Lease Entity Scrub — gr_unitleases

Generated 2026-05-15 05:02. Crosby: 81 rows, 123 fields with data. Willis: 140 rows, 101 fields with data.

Total distinct fields across both tenants: 131.

38Keep — canonical

20Keep — sparse but valid

6Harmonize — Crosby missing

1Harmonize — Willis missing

8Crosby-specific

3Willis-specific

28Drop — zombie (both)

22Drop — Crosby zombie

5Drop — Willis zombie

Keep — canonical (38)

Field	Type	Crosby fill	Willis fill	Crosby sample	Willis sample	Rationale
`_createdby_value`	str	100% (81)	100% (140)	a5c56abc-7303-f111-8406-000d3a30548a \| aaf41dcb-4ef6-f011-8406-002248044b02 \| aaf41dcb-4ef6-f011-8406-002248044b02	7c8c3d7e-0eae-f011-bbd3-000d3a367f25 \| 7c8c3d7e-0eae-f011-bbd3-000d3a367f25 \| 7c8c3d7e-0eae-f011-bbd3-000d3a367f25	Both tenants use this field heavily
`_modifiedby_value`	str	100% (81)	100% (140)	a1d4cd14-d8cf-f011-8544-0022480b642f \| 64711bdb-d2ca-f011-8543-000d3a34ed11 \| 64711bdb-d2ca-f011-8543-000d3a34ed11	7c8c3d7e-0eae-f011-bbd3-000d3a367f25 \| 3d25cfd7-7671-f011-b4cb-000d3a58dc13 \| 7c8c3d7e-0eae-f011-bbd3-000d3a367f25	Both tenants use this field heavily
`_ownerid_value`	str	100% (81)	100% (140)	a5c56abc-7303-f111-8406-000d3a30548a \| aaf41dcb-4ef6-f011-8406-002248044b02 \| aaf41dcb-4ef6-f011-8406-002248044b02	7c8c3d7e-0eae-f011-bbd3-000d3a367f25 \| 7c8c3d7e-0eae-f011-bbd3-000d3a367f25 \| 7c8c3d7e-0eae-f011-bbd3-000d3a367f25	Both tenants use this field heavily
`_owningbusinessunit_value`	str	100% (81)	100% (140)	83f322d5-d2ca-f011-8543-000d3a34ed11 \| 83f322d5-d2ca-f011-8543-000d3a34ed11 \| 83f322d5-d2ca-f011-8543-000d3a34ed11	baab5c02-5170-f011-b4cb-6045bd0342f1 \| baab5c02-5170-f011-b4cb-6045bd0342f1 \| baab5c02-5170-f011-b4cb-6045bd0342f1	Both tenants use this field heavily
`_owninguser_value`	str	100% (81)	100% (140)	a5c56abc-7303-f111-8406-000d3a30548a \| aaf41dcb-4ef6-f011-8406-002248044b02 \| aaf41dcb-4ef6-f011-8406-002248044b02	7c8c3d7e-0eae-f011-bbd3-000d3a367f25 \| 7c8c3d7e-0eae-f011-bbd3-000d3a367f25 \| 7c8c3d7e-0eae-f011-bbd3-000d3a367f25	Both tenants use this field heavily
`_transactioncurrencyid_value`	str	100% (81)	100% (140)	3b105f61-8bcb-f011-8543-000d3a34ed11 \| 3b105f61-8bcb-f011-8543-000d3a34ed11 \| 3b105f61-8bcb-f011-8543-000d3a34ed11	f751339e-d870-f011-b4cb-6045bd0342f1 \| f751339e-d870-f011-b4cb-6045bd0342f1 \| f751339e-d870-f011-b4cb-6045bd0342f1	Both tenants use this field heavily
`createdon`	str	100% (81)	100% (140)	2026-02-27T18:01:06Z \| 2026-02-24T17:46:08Z \| 2026-03-09T15:32:13Z	2026-01-12T22:35:09Z \| 2026-04-30T23:34:30Z \| 2026-02-11T15:54:25Z	Both tenants use this field heavily
`exchangerate`	float	100% (81)	100% (140)	1.0 \| 1.0 \| 1.0	1.0 \| 1.0 \| 1.0	Both tenants use this field heavily
`gr_leasestatus`	int	100% (81)	100% (140)	122830000 \| 122830001 \| 122830000	1 \| 2 \| 1	Both tenants use this field heavily
`gr_name`	str	100% (81)	100% (140)	WL-Unit-1029 \| WL-Unit-1023 \| WL-Unit-1045	WL-Unit-1050 \| WL-Unit-1130 \| WL-Unit-1065	Both tenants use this field heavily
`gr_unitleaseid`	str	100% (81)	100% (140)	f7f2e1f1-8665-41a7-9da2-01bb6b018f47 \| 72522978-1c1a-4c3d-8464-02dd7bb9ddd2 \| ebe46147-1a28-49c6-9701-0428cfda2a12	26eee3d2-15c5-4ac1-aa51-00bd8f6289a5 \| 5e095d92-30a0-4a82-a3d4-02c167abe985 \| 58fba53b-13f1-4609-83d0-04752f432ca6	Both tenants use this field heavily
`modifiedon`	str	100% (81)	100% (140)	2026-05-08T19:53:37Z \| 2026-05-14T19:40:36Z \| 2026-05-12T14:53:21Z	2026-05-13T21:34:44Z \| 2026-05-04T16:18:18Z \| 2026-05-13T21:22:19Z	Both tenants use this field heavily
`processid`	str	100% (81)	100% (140)	00000000-0000-0000-0000-000000000000 \| 00000000-0000-0000-0000-000000000000 \| 00000000-0000-0000-0000-000000000000	00000000-0000-0000-0000-000000000000 \| 00000000-0000-0000-0000-000000000000 \| 00000000-0000-0000-0000-000000000000	Both tenants use this field heavily
`statecode`	int	100% (81)	100% (140)	0 \| 0 \| 0	0 \| 0 \| 0	Both tenants use this field heavily
`statuscode`	int	100% (81)	100% (140)	1 \| 1 \| 1	1 \| 1 \| 1	Both tenants use this field heavily
`versionnumber`	int	100% (81)	100% (140)	27072063 \| 28228085 \| 27182148	45698792 \| 43961599 \| 45698315	Both tenants use this field heavily
`gr_adult`	int	99% (80)	100% (140)	1 \| 1 \| 2	1 \| 1 \| 1	Both tenants use this field heavily
`gr_children`	int	99% (80)	100% (140)	1 \| 1 \| 1	1 \| 1 \| 1	Both tenants use this field heavily
`gr_emailaddress`	str	99% (80)	100% (140)	Gregory.Rubio.Sr@gmail.com \| kallynwilkins92@crosbyisd.org \| shalexisware@gmail.com	jakebrigman42@outlook.com \| seanharris552@yahoo.com \| Makenziej663@gmail.com	Both tenants use this field heavily
`gr_firstname`	str	99% (80)	100% (140)	Gregory \| Kallyn \| Shalexis	Jacob \| Sean \| McKenzie	Both tenants use this field heavily
`gr_lastname`	str	99% (80)	100% (140)	Rubio \| Wilkins \| Ware	Brigman \| Harris \| Jordan	Both tenants use this field heavily
`gr_paymentfrequency`	int	99% (80)	99% (139)	1 \| 1 \| 1	1 \| 1 \| 1	Both tenants use this field heavily
`gr_securitydeposit`	int	98% (79)	100% (140)	0 \| 1 \| 1	1 \| 0 \| 1	Both tenants use this field heavily
`gr_contactnumber`	str	95% (77)	100% (140)	2549132362 \| 9794129015 \| 3462735708	6626226145 \| (303) 815-7519 \| 9792181409	Both tenants use this field heavily
`gr_firstresponders`	int	98% (79)	96% (135)	1 \| 0 \| 1	1 \| 1 \| 0	Both tenants use this field heavily
`gr_unitstatus`	int	100% (81)	93% (130)	122830000 \| 122830001 \| 122830000	122830000 \| 122830001 \| 122830000	Both tenants use this field heavily
`timezoneruleversionnumber`	int	99% (80)	94% (131)	0 \| 0 \| 0	4 \| 0 \| 0	Both tenants use this field heavily
`_gr_unitnumber_value`	str	98% (79)	91% (127)	45812f86-75b3-f011-bbd2-00224826183b \| 95b91933-6eb3-f011-bbd3-00224826e2cb \| e33718eb-75b3-f011-bbd3-00224826e691	afcbead2-77b3-f011-bbd3-00224826e2cb \| 7ea67ec2-77b3-f011-bbd3-00224826e2cb \| 77939c31-77b3-f011-bbd3-00224826e691	Both tenants use this field heavily
`gr_discountperiod`	int	99% (80)	89% (124)	1 \| 0 \| 1	1 \| 1 \| 0	Both tenants use this field heavily
`_gr_meternumber_value`	str	100% (81)	86% (120)	bdc9a0ca-f9fd-f011-8406-00224804bc21 \| a3c9a0ca-f9fd-f011-8406-00224804bc21 \| cbc9a0ca-f9fd-f011-8406-00224804bc21	26f4df71-87d7-f011-8406-7ced8d3c72c7 \| ff43136e-87d7-f011-8406-7ced8d6fe124 \| 2f3dd34c-87d7-f011-8406-7ced8d7106a2	Both tenants use this field heavily
`gr_moveindate`	str	96% (78)	87% (122)	2026-02-27T06:00:00Z \| 2026-06-12T05:00:00Z \| 2026-03-17T05:00:00Z	2026-01-12T00:00:00Z \| 2026-02-09T00:00:00Z \| 2026-02-26T00:00:00Z	Both tenants use this field heavily
`gr_unitcolor`	int	75% (61)	99% (139)	122830004 \| 122830000 \| 122830002	122830002 \| 122830002 \| 122830001	Both tenants use this field heavily
`gr_pets`	int	81% (66)	86% (120)	0 \| 1 \| 1	0 \| 0 \| 0	Both tenants use this field heavily
`gr_esapets`	int	83% (67)	84% (118)	0 \| 0 \| 0	0 \| 0 \| 0	Both tenants use this field heavily
`gr_fobs`	int	83% (67)	82% (115)	1 \| 0 \| 1	0 \| 0 \| 0	Both tenants use this field heavily
`gr_furniture`	str	63% (51)	99% (139)	122830000,122830001,122830002 \| 122830000 \| 122830002	122830001,122830002 \| 122830001,122830002 \| 122830001,122830002	Both tenants use this field heavily
`gr_securitydepositamount`	float	99% (80)	59% (83)	0.0 \| 500.0 \| 500.0	500.0 \| 500.0 \| 500.0	Both tenants use this field heavily
`gr_securitydepositamount_base`	float	99% (80)	59% (83)	0.0 \| 500.0 \| 500.0	500.0 \| 500.0 \| 500.0	Both tenants use this field heavily

Keep — sparse but valid (20)

Field	Type	Crosby fill	Willis fill	Crosby sample	Willis sample	Rationale
`gr_discountqualifiedgroup`	int	44% (36)	80% (112)	122830006 \| 122830005 \| 122830006	122830005 \| 122830005 \| 122830005	Both populated but sparsely (C=44%, W=80%)
`gr_totaldeposits`	float	64% (52)	46% (65)	0.0 \| 0.0 \| 0.0	500.0 \| 500.0 \| 500.0	Both populated but sparsely (C=64%, W=46%)
`gr_totaldeposits_base`	float	64% (52)	46% (65)	0.0 \| 0.0 \| 0.0	500.0 \| 500.0 \| 500.0	Both populated but sparsely (C=64%, W=46%)
`gr_petdeposit`	int	52% (42)	45% (63)	0 \| 0 \| 1	0 \| 0 \| 0	Both populated but sparsely (C=52%, W=45%)
`gr_pet`	int	52% (42)	34% (48)	1 \| 1 \| 3	1 \| 1 \| 1	Both populated but sparsely (C=52%, W=34%)
`gr_scheduledmovein`	str	44% (36)	23% (32)	2026-06-12T00:00:00Z \| 2026-04-03T05:00:00Z \| 2026-04-29T00:00:00Z	2026-05-15T00:00:00Z \| 2026-06-30T00:00:00Z \| 2026-05-15T00:00:00Z	Both populated but sparsely (C=44%, W=23%)
`_gr_coapplicant_value`	str	23% (19)	24% (34)	de36c213-e81b-f111-88b1-000d3a30548a \| 42fa1f46-8219-f111-8341-000d3a341b5f \| d097c961-7128-f111-88b3-002248046b8b	52bbef93-3fd5-f011-8543-6045bd009039 \| 87b794ea-3f13-f111-8341-7ced8d3c7e87 \| 6f0f31ae-98ce-f011-8543-000d3a5aad29	Both populated but sparsely (C=23%, W=24%)
`gr_emailaddress1`	str	23% (19)	24% (34)	acreshomelilkam@gmail.com \| anthonytconnell.88@gmail.com \| frankdelrio12@gmail.com	deric821@gmail.com \| laurenfry1983@gmail.com \| johngwd77@gmail.com	Both populated but sparsely (C=23%, W=24%)
`gr_firstname1`	str	23% (19)	24% (34)	Kameron \| Anthony \| Frank	Deric \| Larry \| Jonathan	Both populated but sparsely (C=23%, W=24%)
`gr_lastname1`	str	23% (19)	24% (34)	Meeks \| Connell \| Del Rio	Tinkham \| Fry \| Mcferrin	Both populated but sparsely (C=23%, W=24%)
`gr_discountenddate`	str	32% (26)	14% (19)	2026-07-17T00:00:00Z \| 2026-05-22T00:00:00Z \| 2026-06-02T00:00:00Z	2026-06-19T00:00:00Z \| 2026-05-23T00:00:00Z \| 2026-05-25T00:00:00Z	Both populated but sparsely (C=32%, W=14%)
`gr_discountstartdate`	str	32% (26)	14% (19)	2026-06-12T05:00:00Z \| 2026-04-18T00:00:00Z \| 2026-04-29T00:00:00Z	2026-05-15T00:00:00Z \| 2026-04-18T00:00:00Z \| 2026-04-20T00:00:00Z	Both populated but sparsely (C=32%, W=14%)
`gr_initialdiscount`	int	32% (26)	14% (19)	1 \| 1 \| 1	1 \| 1 \| 1	Both populated but sparsely (C=32%, W=14%)
`gr_contactnumber1`	str	21% (17)	24% (34)	2812471286 \| 4075085567 \| 7135846966	7137029581 \| 7138636794 \| 9364072966	Both populated but sparsely (C=21%, W=24%)
`gr_moveoutdate`	str	10% (8)	20% (28)	2026-03-31T05:00:00Z \| 2026-04-24T05:00:00Z \| 2026-05-14T00:00:00Z	2026-02-06T06:00:00Z \| 2026-03-01T00:00:00Z \| 2026-02-16T00:00:00Z	Both populated but sparsely (C=10%, W=20%)
`gr_middlename1`	str	22% (18)	4% (6)	Marcquette \| Thomas \| Rico	John \| Rose \| Dawne	Both populated but sparsely (C=22%, W=4%)
`gr_paythroughdate`	str	9% (7)	18% (25)	2026-04-09T00:00:00Z \| 2026-05-02T00:00:00Z \| 2026-05-16T00:00:00Z	2026-02-06T00:00:00Z \| 2026-03-01T00:00:00Z \| 2026-02-16T00:00:00Z	Both populated but sparsely (C=9%, W=18%)
`gr_noticedate`	str	9% (7)	16% (22)	2026-03-23T00:00:00Z \| 2026-04-17T00:00:00Z \| 2026-05-14T00:00:00Z	2026-02-04T00:00:00Z \| 2026-03-01T00:00:00Z \| 2026-02-09T00:00:00Z	Both populated but sparsely (C=9%, W=16%)
`gr_electricdeposit`	—	0% (0)	12% (17)		1 \| 1 \| 1	Both populated but sparsely (C=0%, W=12%)
`gr_moveoutreason`	—	0% (0)	9% (13)		5 \| 1 \| 1	Both populated but sparsely (C=0%, W=9%)

Harmonize — Crosby missing (6)

Field	Type	Crosby fill	Willis fill	Willis sample	Rationale
`gr_petdepositamount`	—	0% (0)	86% (120)	0.0 \| 0.0 \| 0.0	Willis uses (86%); Crosby doesn't (0%)
`gr_petdepositamount_base`	—	0% (0)	86% (120)	0.0 \| 0.0 \| 0.0	Willis uses (86%); Crosby doesn't (0%)
`gr_fobdepositamount`	—	0% (0)	82% (115)	0.0 \| 0.0 \| 0.0	Willis uses (82%); Crosby doesn't (0%)
`gr_fobdepositamount_base`	—	0% (0)	82% (115)	0.0 \| 0.0 \| 0.0	Willis uses (82%); Crosby doesn't (0%)
`gr_country`	—	0% (0)	70% (98)	184 \| 184 \| 184	Willis uses (70%); Crosby doesn't (0%)
`_gr_application_value`	—	0% (0)	69% (97)	cc3d4f19-f8e8-f011-ad8e-7ced8d3c99ac \| d4507864-11ef-f011-92b9-00224806e4fc \| 02f92440-f909-f111-83da-00224808526f	Willis uses (69%); Crosby doesn't (0%)

Harmonize — Willis missing (1)

Field	Type	Crosby fill	Willis fill	Crosby sample	Willis sample	Rationale
`gr_middlename`	str	85% (69)	9% (12)	Eric \| Taylor \| Ashanti yolonda	Kay \| Kathleen \| Corina	Crosby uses (85%); Willis doesn't (9%)

Crosby-specific (8)

Field	Type	Crosby fill	Willis fill	Crosby sample	Rationale
`_gr_applicant_value`	str	99% (80)	not in entity	36bab7d4-9112-f111-8341-000d3a30548a \| 567e8248-0b11-f111-8341-000d3a30579a \| 354c14d7-e81b-f111-88b1-000d3a328f1d	Crosby-only, in use (99%)
`gr_fobdeposit`	float	64% (52)	not in entity	0.0 \| 0.0 \| 0.0	Crosby-only, in use (64%)
`gr_fobdeposit_base`	float	64% (52)	not in entity	0.0 \| 0.0 \| 0.0	Crosby-only, in use (64%)
`gr_petdeposit1`	float	64% (52)	not in entity	0.0 \| 0.0 \| 0.0	Crosby-only, in use (64%)
`gr_petdeposit1_base`	float	64% (52)	not in entity	0.0 \| 0.0 \| 0.0	Crosby-only, in use (64%)
`gr_securitydeposit1`	float	64% (52)	not in entity	0.0 \| 0.0 \| 0.0	Crosby-only, in use (64%)
`gr_securitydeposit1_base`	float	64% (52)	not in entity	0.0 \| 0.0 \| 0.0	Crosby-only, in use (64%)
`gr_paidinvoice`	int	11% (9)	not in entity	3 \| 15 \| 5	Crosby-only, in use (11%)

Willis-specific (3)

Field	Type	Crosby fill	Willis fill	Willis sample	Rationale
`_gr_contact_value`	str	not in entity	100% (140)	dd6b76d9-5cea-f011-8406-7ced8d3b5eae \| f91547b3-4e43-f111-bec7-000d3a371d6d \| 9af04be4-cdf0-f011-8406-7ced8d6fe5f0	Willis-only, in use (100%)
`gr_unitlease`	str	not in entity	100% (140)	WL-Unit-1050 \| WL-Unit-1130 \| WL-Unit-1065	Willis-only, in use (100%)
`gr_moveoutcheck`	bool	not in entity	54% (75)	False \| False \| False	Willis-only, in use (54%)

Drop — zombie (both) (28)

Field	Type	Crosby fill	Willis fill	Crosby sample	Willis sample	Rationale
`gr_address`	—	0% (0)	2% (3)		201 Ridgewood Dr. \| 17386 West FM 1097 \| 10800 S. Lake Mist LN.	Field exists on both but neither populates it (<5%)
`gr_city`	—	0% (0)	2% (3)		Magnolia \| Montgomery \| Willis	Field exists on both but neither populates it (<5%)
`gr_state`	—	0% (0)	2% (3)		43 \| 43 \| 43	Field exists on both but neither populates it (<5%)
`gr_zipcode`	—	0% (0)	2% (3)		77355 \| 77356 \| 77318	Field exists on both but neither populates it (<5%)
`gr_moveoutreason1`	int	1% (1)	1% (1)	1	1	Field exists on both but neither populates it (<5%)
`gr_address1`	—	0% (0)	1% (1)		#105	Field exists on both but neither populates it (<5%)
`_createdonbehalfby_value`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`_gr_intrestedunit_value`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`_modifiedonbehalfby_value`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`_owningteam_value`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_backgroundcheck`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_backgroundcheck1`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_coapplicant1`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_credit`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_credit_base`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_frequency`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_invoiceddate`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_plaidid`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_plaidid1`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_plaidincome`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_plaidincome1`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_status`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_stay`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_totalpets`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`gr_waitlistedposition`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`importsequencenumber`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`overriddencreatedon`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)
`utcconversiontimezonecode`	—	0% (0)	0% (0)			Field exists on both but neither populates it (<5%)

Drop — Crosby zombie (22)

Field	Type	Crosby fill	Willis fill	Rationale
`_gr_case_value`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_activeinvoice`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_availablesecuritydeposit`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_availablesecuritydeposit_base`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_fobdepositdeducted`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_fobdepositdeducted_base`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_fobdepositrefunded`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_fobdepositrefunded_base`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_petdepositdeducted`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_petdepositdeducted_base`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_petdepositrefunded`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_petdepositrefunded_base`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_securitydepositdeducted`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_securitydepositdeducted_base`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_securitydepositrefunded`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_securitydepositrefunded_base`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_totalavailabledeposit`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_totalavailabledeposit_base`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_totaldepositrefunded`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_totaldepositrefunded_base`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_totaldepositsdeducted`	—	0% (0)	not in entity	Crosby-only and unused (0%)
`gr_totaldepositsdeducted_base`	—	0% (0)	not in entity	Crosby-only and unused (0%)

Drop — Willis zombie (5)

Field	Type	Crosby fill	Willis fill	Rationale
`_gr_applicationnumber_value`	—	not in entity	0% (0)	Willis-only and unused (0%)
`_gr_assettag_value`	—	not in entity	0% (0)	Willis-only and unused (0%)
`_gr_cases_value`	—	not in entity	0% (0)	Willis-only and unused (0%)
`_gr_workorder_value`	—	not in entity	0% (0)	Willis-only and unused (0%)
`gr_petdepositc`	—	not in entity	0% (0)	Willis-only and unused (0%)