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