The utility accepts data from a comma-delimited text or CSV file (e.g., provided by a third-party business application vendor) and inserts the records into HR tables which allows you to maintain this data in the ASCENDER TSDS application.
The values must be inserted in this order:
| Field | Validation |
| Unique staff ID | Must be ten digits. |
| Staff ID/SSN | Must be nine digits. Required.
First character must be S or 0-8.
First three characters must not be 000.
Middle characters (3rd-4th digit) must not be 00.
Last four characters must not be 0000.
First seven characters must not be the same. |
| Last Name | Required |
| First Name | Required |
| Middle Name | Required |
| Gender | One character (M or F) |
| Legal Generation | One character
1 = Jr
2 = Sr
3 = II
4 = III
5 = IV
6 = V
7 = VI
8 = VII
9 = VIII
A = I
B = IX
C = X |
| DOB | Required; format YYYYMMDD |
| Hispanic Ethnicity | One character (Y or N) |
| Race American | One character (Y or N)
At least one race indicator is required. |
| Race Asian | One character (Y or N) |
| Race Black | One character (Y or N) |
| Race Native Hawaiian Pacific Islander | One character (Y or N) |
| Race White | One character (Y or N) |
| Highest Degree | One character
0 = No Bachelor's
1 = Bachelor's
2 = Master's
3 = Doctorate |
| Prior Teach Experience | Two characters, values 0-99 |
| Original Emp Date | Format YYYYMMDD |
| Term Date | Format YYYYMMDD |
Example:
0133884198,422514579,Bacon,Jason,Donald,M,1,19801023,N,Y,N,N,N,Y,1,10,20150801,20200101
0133884199,422514563,Hannover,Renee,Keen,F,1,19601024,N,Y,N,N,N,Y,1,12,20150801,20200104
0133884189,422514549,Nimitz,Clark,Mason,M,1,19701022,N,Y,N,N,N,Y,1,15,20150801,20200105
0133884179,422514769,Hernandez,Joe,Lee,M,1,19811028,N,Y,N,N,N,Y,1,10,20150801,20200106
