GroupCensusMember

Name	Label	Type	Description
Id	Group Census Member ID	ID
OwnerId	Owner ID	LOOKUP
IsDeleted	Deleted	CHECKBOX
Name	Name	TEXT(255)
CreatedDate	Created Date	DATETIME
CreatedById	Created By ID	LOOKUP
LastModifiedDate	Last Modified Date	DATETIME
LastModifiedById	Last Modified By ID	LOOKUP
SystemModstamp	System Modstamp	DATETIME
LastViewedDate	Last Viewed Date	DATETIME
LastReferencedDate	Last Referenced Date	DATETIME
GroupCensusId	Group Census ID	MASTER-DETAIL
AccountId	Account ID	LOOKUP
ContactId	Contact ID	LOOKUP
PrimaryGroupCensusMemberId	Group Census Member ID	LOOKUP
GroupClassId	Group Class ID	LOOKUP
Birthdate	Birthdate	DATE
Street	Street	TEXT AREA(255)
City	City	TEXT(40)
State	State	TEXT(80)
PostalCode	Postal Code	TEXT(20)
Country	Country	TEXT(80)
StateCode	State Code	PICKLIST
CountryCode	Country Code	PICKLIST
Latitude	Latitude	NUMBER(3,15)
Longitude	Longitude	NUMBER(3,15)
GeocodeAccuracy	Geocode Accuracy	PICKLIST
Address	Address	AUTO NUMBER
FirstName	First Name	TEXT(50)
Lastname	Last Name	TEXT(50)
Email	Email	EMAIL
JoinDate	Join Date	DATE
IsOptOutAllPlans	Is Opt-out All Plans	CHECKBOX
IsPortalUser	Is Portal User	CHECKBOX
SourceSystemIdentifier	Source System Identifier	TEXT(255)
AnnualEligibleSalary	Annual Eligible Salary	CURRENCY(16,2)
PrimaryMemberSource	Primary Member Source	TEXT(255)
PhoneNumber	Phone Number	PHONE
FullTimeEquivalent	Full Time Equivalent	NUMBER(1,1)
DependentCount	Dependent Count	AUTO NUMBER
Gender	Gender	PICKLIST
MemberType	Member Type	PICKLIST
OptOutPlanTypes	Opt-out Plan Types	PICKLIST (MULTI-SELECT)
PrimaryMemberCategory	Primary Member Category	PICKLIST
RelationshipToPrimaryMember	Relationship to Primary Member	PICKLIST
SmokerStatus	Smoker Status	PICKLIST
Status	Status	PICKLIST
MemberKey	Member Key	TEXT(50)
PolicyStartDate	Policy Start Date	DATE

Name	Id
Label	Group Census Member ID
Type	ID
Required	Yes

Name	OwnerId
Label	Owner ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	IsDeleted
Label	Deleted
Type	CHECKBOX
Required	Yes
Default value	false

Name	Name
Label	Name
Type	TEXT(255)
Required	Yes

Name	CreatedDate
Label	Created Date
Type	DATETIME
Required	Yes

Name	CreatedById
Label	Created By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	LastModifiedDate
Label	Last Modified Date
Type	DATETIME
Required	Yes

Name	LastModifiedById
Label	Last Modified By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	SystemModstamp
Label	System Modstamp
Type	DATETIME
Required	Yes

Name	LastViewedDate
Label	Last Viewed Date
Type	DATETIME

Name	LastReferencedDate
Label	Last Referenced Date
Type	DATETIME

Name	GroupCensusId
Label	Group Census ID
Type	MASTER-DETAIL
Foreign key	Yes
Required	Yes

Name	AccountId
Label	Account ID
Type	LOOKUP
Foreign key	Yes

Name	ContactId
Label	Contact ID
Type	LOOKUP
Foreign key	Yes

Name	PrimaryGroupCensusMemberId
Label	Group Census Member ID
Type	LOOKUP
Foreign key	Yes

Name	GroupClassId
Label	Group Class ID
Type	LOOKUP
Foreign key	Yes

Name	Birthdate
Label	Birthdate
Type	DATE

Name	Street
Label	Street
Type	TEXT AREA(255)

Name	City
Label	City
Type	TEXT(40)

Name	State
Label	State
Type	TEXT(80)

Name	PostalCode
Label	Postal Code
Type	TEXT(20)

Name	Country
Label	Country
Type	TEXT(80)

Name	StateCode
Label	State Code
Type	PICKLIST
Picklist values	AC AG AG 05 02 AL AL AK AB AL AP AM AN AN AP 34 23 AO AR AZ AR AR AP AS AT ACT AV BA BC BS BA BT 11 BL BN BG BI BR BO BZ BS BR BC CA CA CL CM CB CI CW CE CT CZ CN CE CH CT CS 12 CH CH 50 CE CO CL CO CO CT CO CS CR KR CN DN DD DE DL DC DF DL D DG 38 EN ES DF FM FE FI FL FG FC FR 35 18 40 07 G 62 GE GA 21 GA GO GO GR GT 44 45 GR 52 GJ 10 46 HR HI 13 23 41 HG HP 34 01 91 42 43 28 08 ID IL IM IN IA IS 17 03 JA JK JH 32 36 22 37 46 14 KS KA KY KL KY KE KK 39 43 26 AQ LD LS SP LT LE LC LM 21 LK LI LO LD LA LH LU 92 MC MP MH ME MN MB MN MA MD MS MA MT MT MS MO MH VS ML ME ME MI MI 24 MI MG MN MS MO 04 45 MZ MO MN MT MB MO NL 20 42 NA 29 NA NE 15 NV NB NL NH NJ NM NSW NY 15 64 NC ND NT NT NO NS NL NU NU OA OR OY OG OH 44 33 47 OK OT ON OR OR 27 PD PA PA PB PR PR PV PA PE PG PU PE PC PI PI PT PN PZ PO PE PY PB PB 63 QC QLD QE QR RG RJ RA RC RE RI RI RN RJ RN RS RM RO RR RN RO 41 11 SA SL SC SP SK SS SV SE 61 37 31 14 25 32 22 51 SI SK SI SO SO SO SA SC SD SR TB 71 TM TN TA TAS TG TN TE TR TX 12 TA TL TO 09 36 13 31 16 TP TN TV TS TR TO UD UT UT UP VA VE VE VB VC VT VR VV VI VIC VA VT 30 WA WD WB WA WH WV WX WW WI WY 65 54 06 35 19 YU YT 53 ZA 33

Name	CountryCode
Label	Country Code
Type	PICKLIST
Picklist values	AF AX AL DZ AD AO AI AQ AG AR AM AW AU AT AZ BS BH BD BB BY BE BZ BJ BM BT BO BQ BA BW BV BR IO BN BG BF BI KH CM CA CV KY CF TD CL CN CX CC CO KM CG CD CK CR CI HR CW CY CZ DK DJ DM DO EC EG SV GQ ER EE SZ ET FK FO FJ FI FR GF PF TF GA GM GE DE GH GI GR GL GD GP GT GG GN GW GY HT HM VA HN HU IS IN ID IQ IE IM IL IT JM JP JE JO KZ KE KI KR XK KW KG LA LV LB LS LR LY LI LT LU MO MG MW MY MV ML MT MQ MR MU YT MX MD MC MN ME MS MA MZ MM NA NR NP NL NC NZ NI NE NG NU NF MK NO OM PK PS PA PG PY PE PH PN PL PT QA RE RO RU RW BL SH KN LC MF PM VC WS SM ST SA SN RS SC SL SG SX SK SI SB SO ZA GS SS ES LK SR SJ SE CH TW TJ TZ TH TL TG TK TO TT TN TR TM TC TV UG UA AE GB US UY UZ VU VE VN VG WF EH YE ZM ZW

Name	Latitude
Label	Latitude
Type	NUMBER(3,15)

Name	Longitude
Label	Longitude
Type	NUMBER(3,15)

Name	GeocodeAccuracy
Label	Geocode Accuracy
Type	PICKLIST
Picklist values	Address NearAddress Block Street ExtendedZip Zip Neighborhood City County State Unknown

Name	Address
Label	Address
Type	AUTO NUMBER

Name	FirstName
Label	First Name
Type	TEXT(50)
Required	Yes

Name	Lastname
Label	Last Name
Type	TEXT(50)
Required	Yes

Name	Email
Label	Email
Type	EMAIL

Name	JoinDate
Label	Join Date
Type	DATE

Name	IsOptOutAllPlans
Label	Is Opt-out All Plans
Type	CHECKBOX
Required	Yes
Default value	false

Name	IsPortalUser
Label	Is Portal User
Type	CHECKBOX
Required	Yes
Default value	false

Name	SourceSystemIdentifier
Label	Source System Identifier
Type	TEXT(255)

Name	AnnualEligibleSalary
Label	Annual Eligible Salary
Type	CURRENCY(16,2)

Name	PrimaryMemberSource
Label	Primary Member Source
Type	TEXT(255)

Name	PhoneNumber
Label	Phone Number
Type	PHONE

Name	FullTimeEquivalent
Label	Full Time Equivalent
Type	NUMBER(1,1)

Name	DependentCount
Label	Dependent Count
Type	AUTO NUMBER

Name	Gender
Label	Gender
Type	PICKLIST
Picklist values	Male Female Transgender Not Listed

Name	MemberType
Label	Member Type
Type	PICKLIST
Picklist values	Full Time Part Time Cobra Declined

Name	OptOutPlanTypes
Label	Opt-out Plan Types
Type	PICKLIST (MULTI-SELECT)
Picklist values	Medical Dental Vision Medical Savings Account Life Retirement

Name	PrimaryMemberCategory
Label	Primary Member Category
Type	PICKLIST
Picklist values	Employee Only Employee + Spouse Employee + Family Employee + Child Employee + Children

Name	RelationshipToPrimaryMember
Label	Relationship to Primary Member
Type	PICKLIST
Picklist values	Self Spouse Child Other Parent Parent-in-law

Name	SmokerStatus
Label	Smoker Status
Type	PICKLIST
Picklist values	Tobacco Non-Tobacco

Name	Status
Label	Status
Type	PICKLIST
Picklist values	Completed Incomplete Not Determined

Name	MemberKey
Label	Member Key
Type	TEXT(50)

Name	PolicyStartDate
Label	Policy Start Date
Type	DATE

Name	Parent object	Child object	Parent object field	Child object field
ForecastContext	GroupCensusMember	AdvAcctForecastSetUse	Id	ForecastContextId
ContentContext	GroupCensusMember	AssessmentTaskContentDocument	Id	ContentContextId
FirstPublishLocation	GroupCensusMember	ContentVersion	Id	FirstPublishLocationId
ReferenceObject	GroupCensusMember	DocumentEnvelope	Id	ReferenceObjectId
RelatedTo	GroupCensusMember	EmailMessage	Id	RelatedToId
What	GroupCensusMember	Event	Id	WhatId
RelatedRecord	GroupCensusMember	FlowOrchestrationWorkItem	Id	RelatedRecordId
ReferenceObject	GroupCensusMember	GeneratedDocument	Id	ReferenceObjectId
Context	GroupCensusMember	GenericVisitTaskContext	Id	ContextId
PrimaryGroupCensusMember	GroupCensusMember	GroupCensusMember	Id	PrimaryGroupCensusMemberId
GroupCensusMember	GroupCensusMember	GroupCensusMemberPlan	Id	GroupCensusMemberId
What	GroupCensusMember	Task	Id	WhatId
Relation	GroupCensusMember	TaskRelation	Id	RelationId

Name	Parent object	Child object	Parent object field	Child object field
Owner	User	GroupCensusMember	Id	OwnerId
CreatedBy	User	GroupCensusMember	Id	CreatedById
LastModifiedBy	User	GroupCensusMember	Id	LastModifiedById
GroupCensus	GroupCensus	GroupCensusMember	Id	GroupCensusId
Account	Account	GroupCensusMember	Id	AccountId
Contact	Contact	GroupCensusMember	Id	ContactId
PrimaryGroupCensusMember	GroupCensusMember	GroupCensusMember	Id	PrimaryGroupCensusMemberId
GroupClass	GroupClass	GroupCensusMember	Id	GroupClassId

Label	Value