nssrs_mnt
The nssrs_mnt table stores demographic and salary data.
The following table lists the field names, data types, and descriptions of the nssrs_mnt table.
Field Name | Data Type | Description |
|---|---|---|
empl_no | Integer | Employee number |
location | Char(3) | Location |
rpt_date | Date | Report date |
lname | Char(30) | Last name |
fname | Char(30) | First name |
ssn | Char(11) | Social Security |
sex | Char(1) | Gender |
race | Char(2) | Race 1 |
education | Char(2) | Education |
contract | Char(1)) | Contract |
contract_org | Char(7) | NDE County District Number |
cdays | Char(3) | Contract days |
salary | Decimal(8,2) | Basic salary |
add_comp | Decimal(8,2) | Additional compensation |
benefit | Decimal(8,2) | Salary benefits |
dist_exp | Char(2) | Years of experience in the District |
tot_exp | Char(2) | Total years of experience |
hispan | Char(1) | Hispanic |
race2 | Char(2) | Race 2 |
race3 | Char(2) | Race 3 |
race4 | Char(2) | Race 4 |
race5 | Char(2) | Race 5 |
contract_date | Date | Contract date |
mid_init | Char(1) | Middle Initial |
name_suffix | Char(5) | Suffix |
nde_id | Char(10) | NDE Staff ID |
email_addr | Char(128) | Email address |
primary_subj | Char(2) | Primary subject |