You are here:
Upload Group Census Data
Use a csv file to upload census information such as group members and dependents into a group census.
Required Editions
| Available in: Lightning Experience |
| Available in: Professional, Enterprise, and Unlimited Editions of Digital Insurance with Digital Insurance Product Admin Add On, Digital Insurance Group Benefits AddOn, Digital Insurance Group Enrollment AddOn,Digital Insurance Group Benefits Customer Community AddOn, and Digital Insurance Group Benefits Partner Community AddOn licenses |
| User Permissions Needed | |
|---|---|
| To upload group census data | Digital Insurance Group Census Quote Contract Management, Digital Insurance Group Enrollment, Digital Insurance Group Census Quote Contract Management Partner Community, and Digital Insurance Group Enrollment Partner Community |
Keep these guidelines in mind.
- Don’t include an extra empty line at the end of the CSV file.
- Remove trailing spaces before commas in column headers to improve upload performance.
- Define Association with Primary Member values such as Self, Spouse, Child, Parent, Parent-in-law, or Other.
- Ensure that the primary member (Self) is followed by all their dependents in the file.
- The census upload uses First Name, Last Name, and Association with Primary Member from the CSV file to identify members when updating personal information or adding new members.
- Define your own duplicate detection criteria by setting the Duplicate Detection Fields property when you add the Insurance Group Census Lightning web component. Provide unique values in these fields to avoid matching multiple records to the same member.
- The group class that you assign to the primary member is automatically applied to their dependents even if dependents have a different value in the Group Class field.
- Either assign a group class to all members in the census or leave the field blank for all members.
- You can’t update the group class for an existing member. To change it, delete the member and add them again with the correct value.
- From the App Launcher, find and select Group Census.
-
On the group census details page, click the Census Members
tab.
Depending on your organization’s customization, this tab may have a different label.
- Click Add Member to manually add an individual census member.
- Click Upload Census to upload census data from a CSV file. You can upload a new census or reuse an existing one.
-
If you’re uploading a new census, map fields in the source file to fields in Group Census
Member records.
- The number of fields to map matches the number of columns in the source file.
- Field labels are the same as the column headings in the file.
- Field values in dropdowns are populated from the Group Census Member object.
Note If you select Census Type as Enrollment, use the Contract Group Plan field for each plan column to map the plans from the CSV file.
- Save your changes. Uploaded census members appear in a hierarchical tree view.
- (Optional) If errors occur, download the error file from the Notes & Attachments section to review and correct issues.
- Review the group census group class summary record under the Related tab to view statistics about the group class members for the associated group census.
Did this article solve your issue?
Let us know so we can improve!
