...
| 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 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 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 | Federal YTD Total Gross field | |
| Vested Status | "Y" For All Employees | |
| Years Experience | Calculated | Current Date - Hire Date |
Example of CENSUS.CSV
