School District Employee Report

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
Sample file
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
Element Name Starting Position Number of Characters Data Type Comments
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