S_PA_SSF_Staff_Assign_C (ver 17.6.0)
This table is a child table of the SchoolStaff table.
Column Name | Version | Data Type | Description |
---|---|---|---|
Unique_ID | 17.6.0 | Number(11,0) | Migrated From [PA_SAT]unique_ID. |
SchoolID | 17.6.0 | Number(11,0) | Migrated From [PA_SAT]schoolID. |
ForeignKey | 17.6.0 | Number(11,0) | Migrated From [PA_SAT]foreignKey. |
ForeignKey_Alpha | 17.6.0 | Varchar2(31) | Migrated From [PA_SAT]foreignKey_alpha. |
Assignment_Code | 17.6.0 | Varchar2(10) | Migrated From [PA_SAT]assign_cd. |
Location_Code | 17.6.0 | Varchar2(10) | Migrated From [PA_SAT]loc_cd. |
School_Year_Date | 17.6.0 | Date | Migrated From [PA_SAT]sch_yr_dt. |
Assignment_Date | 17.6.0 | Date | Migrated From [PA_SAT]assign_dt.. |
Completion_Date | 17.6.0 | Date | Migrated From [PA_SAT]comp_dt |
Primary_Assignment_YN | 17.6.0 | Varchar2(1) | Migrated From [PA_SAT]primary_assignment.. |
Percent_Time_Assign | 17.6.0 | Number(25,10) | Migrated From [PA_SAT]per_time_assign. |
Assignment_Identifier | 17.6.0 | Varchar2(20) | Migrated From [PA_SAT]section_desc. |
EWS_Assignment_Programs_Code | 17.6.0 | Varchar2(10) | Migrated From [PA_SAT]assignment_programs_code. |
EWS_Assignment_Title | 17.6.0 | Varchar2(50) | Migrated From [PA_SAT]assignment_title. |
Sort_By | 17.6.0 | Varchar2(50) | Migrated From [PA_SAT]sort_by. |