Field Set: State PA Virtual PA_OutDisCal 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_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 |