The CENSUS program will create a common census file per ING requirements.
Field Definitions
...
| Column | Screen | Criteria |
|---|---|---|
| SSN | Employee | |
| First Name | Employee | |
| Middle Name | Employee | |
| Last Name | Employee | |
| Street 1 | Employee | |
| Street 2 | Employee | |
| City | Employee | |
| State | Employee | |
| Zip Code | Employee | |
| Gender | Employee | M = Male F = Female |
| Birth Date | Employee | |
| Plan Status | Employee | If there's a termination date, then "X" |
| If there's NO termination date, then "A" | ||
| Plan Status Sub | Employee | Blank for ALL employees |
| Plan Status Date | Employee | If there's a termination date, then termination date |
| If there's NO termination date, then hire date | ||
| Employee Status | Employee | If there's a termination date, then "T" |
| If there's NO termination date, then "H" | ||
| Employee Status Sub | Employee | If there's a termination date and rehired date and they checked the 'Use User Defined Date 2 For Rehired Date?", then "R" |
| If there's NO termination date, then "O" | ||
| Employee Status Date | Employee | If there's a termination date, then termination date |
| If there's NO termination date, then hire date | ||
| Hire Date | Employee | |
| Plan Entry Date | Employee | Hire Date |
| Rehire Date | Employee | Input parm="Y" Date employee rehired within the district (if district uses 'Payroll Date 2" |
| Contribution Status | "Y" For All Employees | |
| Salary | ||
| Vested Status | "Y" For All Employees | |
| Years Experience | Calculated | Current Date - Hire Date |
...