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 |