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_OutDisCal |
unique_ID |
S_PA_Calendar_S |
unique_ID |
|
PA_OutDisCal |
schoolID |
S_PA_Calendar_S |
schoolID |
|
PA_OutDisCal |
foreignKey |
S_PA_Calendar_S |
foreignKey |
|
PA_OutDisCal |
foreignKey_alpha |
S_PA_Calendar_S |
foreignKey_alpha |
|
PA_OutDisCal |
cal_name |
S_PA_Calendar_S |
Calendar_Id |
|
PA_OutDisCal |
act80_group |
S_PA_Calendar_S |
Act80_Group |
|
PA_OutDisCal |
cal_desc |
S_PA_Calendar_S |
Calendar_Description |
|
PA_OutDisCal |
rot_pat_cd |
S_PA_Calendar_S |
Rotation_Pattern_Code |
|
PA_OutDisCal |
yearid |
S_PA_Calendar_S |
School_Year_Id |
|
PA_OutDisCal |
cal_prog_cd |
S_PA_Calendar_S |
Calendar_Program_Code |
|
PA_OutDisCal |
cal_start_dt |
S_PA_Calendar_S |
Calendar_Start_Date |
|
PA_OutDisCal |
cal_exit_dt |
S_PA_Calendar_S |
Calendar_End_Date |
|
PA_OutDisCal |
inst_start_dt |
S_PA_Calendar_S |
Instruction_Start_Date |
|
PA_OutDisCal |
inst_end_dt |
S_PA_Calendar_S |
Instruction_End_Date |
|
PA_OutDisCal |
grad_cere_dt |
S_PA_Calendar_S |
Graduation_Ceremony_Date |
|
PA_OutDisCal |
num_schd_days |
S_PA_Calendar_S |
Num_Of_Scheduled_School_Days |
|
PA_OutDisCal |
inst_min_in_day |
S_PA_Calendar_S |
Instruct_Min_In_Standard_Day |
|
PA_OutDisCal |
in_sess_strike |
S_PA_Calendar_S |
Days_In_Session_Lost_Strike |
|
PA_OutDisCal |
in_sess_act80 |
S_PA_Calendar_S |
Days_In_Session_Lost_Act80 |
|
PA_OutDisCal |
in_sess_other |
S_PA_Calendar_S |
Days_In_Session_Lost_Other |
|
PA_OutDisCal |
tot_makeup |
S_PA_Calendar_S |
Total_Makeup_Days |
|
PA_OutDisCal |
tot_instr_short |
S_PA_Calendar_S |
Total_Instruct_Minutes_Lost |
|
PA_OutDisCal |
sort_by |
S_PA_Calendar_S |
sort_by |
|
PA_OutDisCal |
sort_by2 |
S_PA_Calendar_S |
sort_by2 |