S_ON_SSF_Educator_Assign_C ver 17.9.0
This table is a child table of SchoolStaff and stores educator assignments.
Column Name | Version | Data Type | Description |
|---|---|---|---|
unique_ID | 17.9.0 | Number(11,0) | Record ID. Migrated from [ON_Educator_Assign.unique_ID]. |
| SchoolID | 17.9.0 | Number(11,0) | School ID. Migrated from [ON_Educator_Assign.schoolID]. |
| foreignKey | 17.9.0 | Number(11,0) | Reserved for future use. Migrated from [ON_Educator_Assign.foreignKey]. |
| foreignKey_alpha | 17.9.0 | Varchar2(31) | Reserved for future use. Migrated from [ON_Educator_Assign.foreignKey_alpha]. |
| Assignment_Start | 17.9.0 | Date | Assignment Start. Migrated from [ON_Educator_Assign.user_defined_date]. |
| Assignment_End | 17.9.0 | Date | Assignment End. Migrated from [ON_Educator_Assign.user_defined_date2]. |
| AssignmentID | 17.9.0 | Number(11,0) | Assignment ID. Migrated from [ON_Educator_Assign.user_defined_integer]. |
| FTE | 17.9.0 | Number(25,10) | FTE. Migrated from [ON_Educator_Assign.user_defined_numeric]. |
| Position_Type | 17.9.0 | Varchar2(3) | Position Type. Migrated from [ON_Educator_Assign.user_defined_text]. |
| Leave_Type | 17.9.0 | Varchar2(3) | Leave Type. Migrated from [ON_Educator_Assign.user_defined_text2]. |
| Assign_Withdrawal_Type | 17.9.0 | Varchar2(5) | Assign Withdrawal Type. Migrated from [ON_Educator_Assign.ON_Assign_Withdrawal_Type]. |
| Department_Type | 17.9.0 | Varchar2(20) | Department Type. Migrated from [ON_Educator_Assign.ON_Department_Type]. |
| Letter_Permission | 17.9.0 | Varchar2(79) | Letter Permission. Migrated from [ON_Educator_Assign.ON_Letter_Permission]. |
| Teaching_Type | 17.9.0 | Varchar2(3) | Teaching Type. Migrated from [ON_Educator_Assign.ON_Teaching_Type]. |
| Core_Flag | 17.9.0 | Varchar2(1) | Core Flag. Migrated from [ON_Educator_Assign.ON_Core_Flag]. |
| NTIP_Status | 17.9.0 | Varchar2(5) | NTIP Status. Migrated from [ON_Educator_Assign.ON_NTIP_Status]. |
| Class_Assignment_Flag | 17.9.0 | Varchar2(1) | Class Assignment Flag. Migrated from [ON_Educator_Assign.ON_Class_Assignment_Flag]. |
| TLA | 17.9.0 | Varchar2(255) | TLA. Migrated from [ON_Educator_Assign.ON_TLA]. |