Field Set: State PA Virtual PA_SAT v1
This field set was included with State Reporting Installer 17.6.0 released on June 29, 2017.
Source Table (Virtual Table) | Source Field | Destination Table (Extended Schema) | Destination Field |
|---|---|---|---|
| PA_SAT | unique_ID | S_PA_SSF_Staff_Assign_C | unique_ID |
| PA_SAT | schoolID | S_PA_SSF_Staff_Assign_C | schoolID |
| PA_SAT | foreignKey | S_PA_SSF_Staff_Assign_C | foreignKey |
| PA_SAT | foreignKey_alpha | S_PA_SSF_Staff_Assign_C | foreignKey_alpha |
| PA_SAT | assign_cd | S_PA_SSF_Staff_Assign_C | Assignment_Code |
| PA_SAT | loc_cd | S_PA_SSF_Staff_Assign_C | Location_Code |
| PA_SAT | sch_yr_dt | S_PA_SSF_Staff_Assign_C | School_Year_Date |
| PA_SAT | assign_dt | S_PA_SSF_Staff_Assign_C | Assignment_Date |
| PA_SAT | comp_dt | S_PA_SSF_Staff_Assign_C | Completion_Date |
| PA_SAT | primary_assignment | S_PA_SSF_Staff_Assign_C | Primary_Assignment_YN |
| PA_SAT | per_time_assign | S_PA_SSF_Staff_Assign_C | Percent_Time_Assign |
| PA_SAT | section_desc | S_PA_SSF_Staff_Assign_C | Assignment_Identifier |
| PA_SAT | assignment_programs_code | S_PA_SSF_Staff_Assign_C | EWS_Assignment_Programs_Code |
| PA_SAT | assignment_title | S_PA_SSF_Staff_Assign_C | EWS_Assignment_Title |
| PA_SAT | sort_by | S_PA_SSF_Staff_Assign_C | sort_by |