The CENSUS program will create a common census file per ING requirements.

Field Definitions

Columns are listed below in the same order they appear in the CENSUS.CSV file.

ColumnScreenCriteria
SSNEmployee
First NameEmployee
Middle NameEmployee
Last NameEmployee
Street 1Employee
Street 2Employee
CityEmployee
StateEmployee
Zip CodeEmployee
GenderEmployee

M = Male

F = Female

Birth DateEmployee
Plan StatusEmployeeIf there's a termination date, then "X"


If there's NO termination date, then "A"
Plan Status SubEmployeeBlank for ALL employees
Plan Status DateEmployeeIf there's a termination date, then termination date


If there's NO termination date, then hire date
Employee StatusEmployeeIf there's a termination date, then "T"


If there's NO termination date, then "H"
Employee Status SubEmployeeIf there's NO termination date and (No Rehired Date or the User Date 2 is not checked) it is "O"


If there's NO termination date and there is a Rehired date and 'Use User Defined Date 2 For Rehired Date?' field is checked, it is an "R"


If there's a termination date, then "Blank"
Employee Status DateEmployeeIf there's a termination date, then termination date


If there's NO termination date, then hire date
Hire DateEmployee
Plan Entry DateEmployeeHire Date
Rehire DateEmployeeInput parm="Y" Date employee rehired within the district (if district uses 'Payroll Date 2"
Contribution Status
"Y" For All Employees
SalaryFederal YTD Total Gross field
Vested Status
"Y" For All Employees
Years ExperienceCalculatedCurrent Date - Hire Date

Example of CENSUS.CSV