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. |