Back to Recent Schemas

Schema Information

https://benovate.box.com/shared/static/tihqpoe80walijro39qiyspsvl9h8ahn.json

Download schema

Fields

Index Column Heading Required Unique Type Value Constraints Title/Description
1 External Id Yes No String Minimum Length: 2
External Id
2 Last Name Yes No String Last Name
3 Middle Initial Yes No String Middle Initial
4 First Name Yes No String First Name
5 SSN Yes No String SSN
6 Employer Group Yes No String Employer Group
7 Plan Yes No String Plan
8 Email Address Yes No String Pattern: [-a-zA-Z0-9_.+][email protected][a-zA-Z0-9](.?[-a-zA-Z0-9]*[a-zA-Z0-9])*
Email Address
9 Gender Yes No String Pattern: (M|F)
Gender
10 DOB Yes No String Pattern: (^([0-2]d|[3][0-1])/([0]d|[1][0-2])/[1-2]d{3}((s([0-1]d|[2][0-3]):[0-5]d(:[0-5]d)?)?)|)$
DOB
Must be in format MM/DD/YYYY
11 Ethnicity Yes No String Ethnicity
12 Address1 Yes No String Address1
13 Address2 Yes No String Address2
14 City Yes No String City
15 State Yes No String Maximum Length: 2
Pattern: [A-Z][A-Z]
State
16 Zip Yes No String Zip
17 Home Phone Yes No String Home Phone
18 Mobile Phone Yes No String Mobile Phone
19 Hired Date Yes No String Pattern: (^([0-2]d|[3][0-1])/([0]d|[1][0-2])/[1-2]d{3}((s([0-1]d|[2][0-3]):[0-5]d(:[0-5]d)?)?)|)$
Hired Date
20 Terminated Date Yes No String Pattern: (^([0-2]d|[3][0-1])/([0]d|[1][0-2])/[1-2]d{3}((s([0-1]d|[2][0-3]):[0-5]d(:[0-5]d)?)?)|)$
Term Date Req if user is Inactive
21 Enrollment Status Yes No String Pattern: (Active|Inactive)
Enrollment Status
Enrollment status can be either Active or Inactive
22 Relationship to Employee Yes No String Pattern: (Spouse|Child|)
Relationship to Employee
Only use for dependents WITH employees ON this census
23 External ID of Employee Yes No String External ID of Employee
External ID of employee must be on this census
24 USHC Username Yes No String USHC Username
25 External Registration Code Yes No String External Registration Code
Download Example CSV File