S_MO_USR_X (ver 16.2.0)
This table is an extension of the [USERS] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| UsersDCID | 16.2.0 | Number(10,0) | Foreign Key |
| Careerladder | 16.2.0 | Varchar2(1) | Career Ladder. Migrated from [SchoolStaff.Careerladder] |
| Comments | 16.2.0 | Varchar2(70) | Comments. Migrated from [SchoolStaff.comments] |
| CountyDistCode | 16.2.0 | Varchar2(6) | County District Code - Fiscal Agent. Migrated from [SchoolStaff.countyDistCode] |
| ExtContractDur | 16.2.0 | Number(11,0) | Extended Contract Duration. Migrated from [SchoolStaff.ExtContractDur] |
| ExtContractSalary | 16.2.0 | Number(11,0) | Extended Contract Salary. Migrated from [SchoolStaff.ExtContractSalary] |
| ExtraDutySalary | 16.2.0 | Number(11,0) | Extra Duty Salary. Migrated from [SchoolStaff.ExtraDutySalary] |
| HighestDegree | 16.2.0 | Varchar2(4) | Highest Degree. Migrated from [SchoolStaff.HighestDegree] |
| MinSalaryDaysWorked | 16.2.0 | Number(11,0) | Minimal Salary Days Worked. Migrated from [SchoolStaff.minSalaryDaysWorked] |
| MinSalarySupplement | 16.2.0 | Number(11,0) | Minimum Salary Supplement. Migrated from [SchoolStaff.minSalarySupplement] |
| PubSchYearExpDist | 16.2.0 | Number(11,0) | Public School Years - Experience District. Migrated from [SchoolStaff.PubSchYearExpDist] |
| PubSchYearExpMO | 16.2.0 | Number(11,0) | Public School Years - Experience Missouri. Migrated from [SchoolStaff.PubSchYearExpMO] |
| PubSchYearExpTot | 16.2.0 | Number(11,0) | Public School Years - Experience Total. Migrated from [SchoolStaff.PubSchYearExpTot] |
| RegularTermSalary | 16.2.0 | Number(11,0) | Regular Term Salary. Migrated from [SchoolStaff.regularTermSalary] |
| BaseSalaryGrant | 22.9.2.0 | Number(11) | Indicates the Baseline Salary Grant of the staff |