S_ID_USR_CONTRACTS_C (ver 15.7.3)
This is a child extension of the Users table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
usersdcid | 15.7.3 | Number(10,0) | Foreign key to the users table. |
| BaseSalary | 15.7.3 | Number(11,0) | For Certified staff, the base salary on the Contract rounded to the nearest dollar. |
| ContractDays | 15.7.3 | Number(11,0) | For certified staff, the annual number of days based on a five day work week contracted in the contract. |
| ContractEndDate | 15.7.3 | Date | The effective end date of the contract. |
| ContractFTE | 15.7.3 | Number(25,10) | The full-time equivalent for the contract. |
| ContractHours | 15.7.3 | Number(11,0) | For certified staff, the total annual hours contracted in the contract for the year. |
| ContractNumber | 15.7.3 | Number(11,0) | The professional practice level of performance from the evaluation. |
| ContractStartDate | 15.7.3 | Date | The effective start date of the contract. |
| ContractType | 15.7.3 | Varchar2(10) | The student achievement level of performance from the evaluation. |
| fundSource1 | 15.7.3 | Varchar2(10) | The code for how the employee is funded - source 1. |
fundSource2 | 15.7.3 | Varchar2(10) | The code for how the employee is funded - source 2. |
| fundSource3 | 15.7.3 | Varchar2(10) | The code for how the employee is funded - source 3. |
| fundSource4 | 15.7.3 | Varchar2(10) | The code for how the employee is funded - source 4. |
| percentSource1 | 15.7.3 | Number(25,10) | The percentage of funding from source 1. |
| percentSource2 | 15.7.3 | Number(25,10) | The percentage of funding from source 2. |
| percentSource3 | 15.7.3 | Number(25,10) | The percentage of funding from source 3. |
| percentSource4 | 15.7.3 | Number(25,10) | The percentage of funding from source 4. |