S_ID_USR_StaffAssignments_C (ver 17.8.0)
This table is a child table of USERS.
Column Name | Version | Data Type | Description |
unique_id | 17.8.0 | Number(11,0) | Record ID Migrated from [ID_StaffAssignments.unique_ID]. |
schoolID | 17.8.0 | Number(11,0) | School ID Migrated from [ID_StaffAssignments.schoolID]. |
foreignKey | 17.8.0 | Number(11,0) | Reserved for future use. Migrated from [ID_StaffAssignments.foreignKey]. |
foreignKey_alpha | 17.8.0 | Varchar2(31) | Reserved for future use. Migrated from [ID_StaffAssignments.foreignKey_alpha]. |
AssignmentCode | 17.8.0 | Varchar2(6) | Assignment Code Migrated from [ID_StaffAssignments.user_defined_text]. |
PeriodNumber | 17.8.0 | Number(11,0) | Period Number Migrated from [ID_StaffAssignments.user_defined_integer]. |
EffectiveDate | 17.8.0 | Date | Effective Date Migrated from [ID_StaffAssignments.user_defined_date]. |
EndDate | 17.8.0 | Date | End Date Migrated from [ID_StaffAssignments.user_defined_date2]. |
FTE | 17.8.0 | Number(25,10) | Full Time Equivalency Migrated from [ID_StaffAssignments.FTE]. |
ClassLevel | 17.8.0 | Varchar2(3) | Class Level Migrated from [ID_StaffAssignments.ID_ClassLevel]. |
ContractNo | 17.8.0 | Number(11,0) | Contract Number Migrated from [ID_StaffAssignments.ID_ContractNo]. |
CourseStandards | 17.8.0 | Varchar2(3) | Course Standards Migrated from [ID_StaffAssignments.ID_CourseStandards]. |
CRDCFteFactor | 17.8.0 | Number(1,0) | CRDC FTE Factor Migrated from [ID_StaffAssignments.ID_CRDCFteFactor]. |
GradeLevel | 17.8.0 | Varchar2(2) | Grade Level Migrated from [ID_StaffAssignments.ID_GradeLevel]. |
HQDate | 17.8.0 | Date | HQ Date Migrated from [ID_StaffAssignments.ID_HQDate]. |
HQT | 17.8.0 | Varchar2(3) | HQT Migrated from [ID_StaffAssignments.ID_HQT]. |
InstructionalSetting | 17.8.0 | Varchar2(2) | Instructional Setting Migrated from [ID_StaffAssignments.ID_InstructionalSetting]. |
NoncertRate | 17.8.0 | Number(25,10) | Non-Cert Rate Migrated from [ID_StaffAssignments.ID_NoncertRate]. |
NoncertHours | 17.8.0 | Number(25,10) | Non-Cert Hours Migrated from [ID_StaffAssignments.ID_NoncertHours]. |
NoncertWeeks | 17.8.0 | Number(25,10) | Non-Cert Weeks Migrated from [ID_StaffAssignments.ID_NoncertWeeks]. |
QualOverride | 17.8.0 | Varchar2(2) | Qual Override Migrated from [ID_StaffAssignments.ID_QualOverride]. |
TeachingRole | 17.8.0 | Varchar2(3) | Teaching Role Migrated from [ID_StaffAssignments.ID_TeachingRole]. |
TeacherID | 17.8.0 | Number(11,0) | Teacher Id Migrated from [ID_StaffAssignments.teacherId]. |