Note: All file submissions are considered to be of type "20". The type "08" and type "14" submission types no longer exist. As a result, no transaction code is required.
Note: Values not provided should be set to a space (blank character). Submitting a 0 IS NOT ACCEPTABLE when the value is not available. For example, only certified employees may have a salary submitted for them. For classified employees, the value for salary should be " ", NOT "0000000".
Note: The name field has been separated into different parts, first, middle, and last.
Note: Ethnicity has been replaced by Hispanic/Latino and Race.
Record Length: 126
SDER_WEB_IMPORT, 2013
010201000John QO'Leary 111111111 M0WHBLASAMPI01011993201.5 024 .5 C14131430000 0E
010201000Jesamine Jontehiem 222222222 F1WHAM 122420011011 E03 3 321000 1200 0E
Header: SDER_WEB_IMPORT, FiscalYear
CTDS |
1 |
9 |
Numeric |
Must be a ctds whose owner is the entity submitting the data. |
First Name |
10 |
20 |
Alphanumeric |
|
Middle Initial |
30 |
1 |
Alphanumeric |
|
Last Name |
31 |
20 |
Alphanumeric |
|
Employee ID |
51 |
11 |
Numeric |
Do not include dashes, spaces, or other punctuation. |
Gender |
62 |
1 |
Alphanumeric |
M or F for (M)ale or (F)emale |
Hispanic/Latino |
63 |
1 |
Numeric |
1 for Hispanic/Latino, 0 for non Hispanic/Latino |
Race |
64 |
10 |
Alphanumeric |
WH, BL, AS, AM, PI (WH)ite, (BL)ack or African American, (AS)ian, (AM)erican Indian or Alaskan Native, (PI) Native Hawaiian or other Pacific Islander.
Include all that apply. |
Employment Start Date |
74 |
8 |
Numeric |
Should be in the format of MMDDYYYY. Do not include dashes, spaces, or separators. For example, June 16, 2003 would be written as " 6 62003", "06062003" is also acceptable. |
Position Code 1 |
82 |
3 |
Numeric |
See the Position Codes page for the list of allowable position codes. |
Position 1 M&O FTE |
85 |
4 |
Numeric |
Include the decimal place as needed; for example 1.25. |
Position 1 Other FTE |
89 |
4 |
Numeric |
Include the decimal place as needed; for example 1.25. Not allowed for classified employees. |
Position Code 2 |
93 |
3 |
Numeric |
See the Position Codes page for the list of allowable position codes. |
Position 2 M&O FTE |
96 |
4 |
Numeric |
Include the decimal place as needed; for example 1.25. |
Position 2 Other FTE |
100 |
4 |
Numeric |
Include the decimal place as needed; for example 1.25. Not allowed for classified employees. |
Grade Level |
104 |
1 |
Alphanumeric |
C, E, S representing (C)ombined, (E)lementary, and (S)econdary. Required for certified employees. Discarded for classified employees. |
Education Level |
105 |
2 |
Numeric |
See the Education Level page for a list of allowable codes. Saved for certified employees. Discarded for classified employees. Required for teachers. |
Years of Experience |
107 |
2 |
Numeric |
Saved for certified employees. Discarded for classified employees. Required for teachers. |
Benefits |
109 |
2 |
Numeric |
Saved for certified employees. Discarded for classified employees. Required for teachers. |
Salary |
111 |
7 |
Numeric |
No decimal places. Round to nearest dollar. Saved for certified employees. Discarded for classified employees. Required for teachers. |
CSF Salary |
118 |
7 |
Numeric |
No Longer Used. |
PSP Employee |
125 |
1 |
Numeric |
1 for PSP Employee, 0 for non-PSP employee. 1/0 for Certified employees and non-certified Superintendent. For classified employees it should be 0. |
End of Line |
126 |
1 |
Alphanumeric |
Should always be E |
|