General informations
Fields (33)
| Name | Label | Type | Description |
|---|---|---|---|
| Id | Group Census 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 | |
| AccountId | Account ID | LOOKUP | |
| ExternalIdentifier | External Identifier | TEXT(50) | |
| LeadId | Lead ID | LOOKUP | |
| SourceSystemType | Source System Type | PICKLIST | |
| Status | Status | PICKLIST | |
| Type | Type | PICKLIST | |
| UsageType | Usage Type | PICKLIST | |
| MemberOptOutCount | Member Opt Out Count | AUTO NUMBER | |
| MbrWithoutDependentCount | Member Without Dependent Count | AUTO NUMBER | |
| MemberWithOneChildCount | Member With One Child Count | AUTO NUMBER | |
| MbrWithMoreThan1ChldCount | Member With More Than One Child Count | AUTO NUMBER | |
| MbrWithMoreThan2ChldCount | Member With More Than Two Children Count | AUTO NUMBER | |
| MemberWithDependentCount | Member With Dependent Count | AUTO NUMBER | |
| MemberWithSpouseCount | Member With Spouse Count | AUTO NUMBER | |
| TotalMemberPlusDependent | Total Members Plus Dependents | AUTO NUMBER | |
| TotalDependents | Total Dependents | AUTO NUMBER | |
| TotalMembers | Total Members | AUTO NUMBER | |
| FullTimeMemberCount | Full Time Member Count | AUTO NUMBER | |
| PartTimeMemberCount | Part Time Member Count | AUTO NUMBER | |
| EffectiveEndDate | Effective End Date | DATETIME | |
| EffectiveStartDate | Effective Start Date | DATETIME | |
| SourceSystemName | Source System Name | TEXT(50) |
Fields Details (33)
| Name | Id |
| Label | Group Census 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 | AccountId |
| Label | Account ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Name | ExternalIdentifier |
| Label | External Identifier |
| Type | TEXT(50) |
| Name | LeadId |
| Label | Lead ID |
| Type | LOOKUP |
| Foreign key | Yes |
| Name | SourceSystemType |
| Label | Source System Type |
| Type | PICKLIST |
| Picklist values | External User |
| Name | Status |
| Label | Status |
| Type | PICKLIST |
| Required | Yes |
| Picklist values | Draft Active Inactive |
| Name | Type |
| Label | Type |
| Type | PICKLIST |
| Picklist values | System Quote Enrollment Lead |
| Name | UsageType |
| Label | Usage Type |
| Type | PICKLIST |
| Picklist values | Insurance |
| Name | MemberOptOutCount |
| Label | Member Opt Out Count |
| Type | AUTO NUMBER |
| Name | MbrWithoutDependentCount |
| Label | Member Without Dependent Count |
| Type | AUTO NUMBER |
| Name | MemberWithOneChildCount |
| Label | Member With One Child Count |
| Type | AUTO NUMBER |
| Name | MbrWithMoreThan1ChldCount |
| Label | Member With More Than One Child Count |
| Type | AUTO NUMBER |
| Name | MbrWithMoreThan2ChldCount |
| Label | Member With More Than Two Children Count |
| Type | AUTO NUMBER |
| Name | MemberWithDependentCount |
| Label | Member With Dependent Count |
| Type | AUTO NUMBER |
| Name | MemberWithSpouseCount |
| Label | Member With Spouse Count |
| Type | AUTO NUMBER |
| Name | TotalMemberPlusDependent |
| Label | Total Members Plus Dependents |
| Type | AUTO NUMBER |
| Name | TotalDependents |
| Label | Total Dependents |
| Type | AUTO NUMBER |
| Name | TotalMembers |
| Label | Total Members |
| Type | AUTO NUMBER |
| Name | FullTimeMemberCount |
| Label | Full Time Member Count |
| Type | AUTO NUMBER |
| Name | PartTimeMemberCount |
| Label | Part Time Member Count |
| Type | AUTO NUMBER |
| Name | EffectiveEndDate |
| Label | Effective End Date |
| Type | DATETIME |
| Name | EffectiveStartDate |
| Label | Effective Start Date |
| Type | DATETIME |
| Name | SourceSystemName |
| Label | Source System Name |
| Type | TEXT(50) |
Parents relationships(13)
Children relationships(5)
| Name | Parent object | Child object | Parent object field | Child object field |
|---|---|---|---|---|
| Owner | User | GroupCensus |
|
|
| CreatedBy | User | GroupCensus |
|
|
| LastModifiedBy | User | GroupCensus |
|
|
| Account | Account | GroupCensus |
|
|
| Lead | Lead | GroupCensus |
|
|
Object User-defined metadata (0)
| Label | Value |
|---|