NDE Staff ID Download File
The following table shows the fields, data types, format details, and sample data of the NDE Staff ID download file.
When downloading the NDE Staff ID download file from NDE, specify No to include the column headers and select the Comma Delimited file format.
Field Name | Data Type | Notes/Format Details | Sample Data | |||||
|---|---|---|---|---|---|---|---|---|
SSN | Varchar(9) | Omit dashes. | 555127890 | |||||
LOCAL_STAFF_ID | Varchar(30) | Employee number | (blank) OR Employee number | |||||
LASTNAME | Varchar(30) | Last name | Doe | |||||
FIRSTNAME | Varchar(30) | First name | John | |||||
MIDDLENAME | Varchar(30) | It may be blank or middle initial only. | (blank) OR R OR Roger | |||||
GENDER | Varchar(1) | Valid values:
| M | |||||
BIRTHDATE | Varchar(10) | The format is mm/dd/yyyy. | 8/25/1993 | |||||
NDE_STAFF_ID | Varchar(10) | The ten-digit Staff ID assigned by the NDE. | 1234567890 | |||||