S_PA_Calendar_S (ver 17.6.0)
This table is a standalone table and stores additional calendar information for PA.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| Unique_ID | 17.6.0 | Number(11,0) | Migrated From [PA_OutDisCal]unique_ID. |
| SchoolID | 17.6.0 | Number(11,0) | Migrated From [PA_OutDisCal]schoolID. |
| ForeignKey | 17.6.0 | Number(11,0) | Migrated From [PA_OutDisCal]foreignKey. |
| ForeignKey_Alpha | 17.6.0 | Varchar2(31) | Migrated From [PA_OutDisCal]foreignKey_alpha.. |
| Calendar_Id | 17.6.0 | Varchar2(12) | Migrated From [PA_OutDisCal]cal_name. |
| Act80_Group | 17.6.0 | Varchar2(12) | Migrated From [PA_OutDisCal]act80_group. |
| Calendar_Description | 17.6.0 | Varchar2(100) | Migrated From [PA_OutDisCal]cal_desc. |
| Rotation_Pattern_Code | 17.6.0 | Varchar2(1) | Migrated From [PA_OutDisCal]rot_pat_cd |
| School_Year_Id | 17.6.0 | Number(11,0) | Migrated From [PA_OutDisCal]yearid.. |
| Calendar_Program_Code | 17.6.0 | Varchar2(8) | Migrated From [PA_OutDisCal]cal_prog_cd. |
| Calendar_Start_Date | 17.6.0 | Date | Migrated From [PA_OutDisCal]cal_start_dt. |
| Calendar_End_Date | 17.6.0 | Date | Migrated From [PA_OutDisCal]cal_exit_dt. |
| Instruction_Start_Date | 17.6.0 | Date | Migrated From [PA_OutDisCal]inst_start_dt. |
| Instruction_End_Date | 17.6.0 | Date | Migrated From [PA_OutDisCal]inst_end_dt. |
| Graduation_Ceremony_Date | 17.6.0 | Date | Migrated From [PA_OutDisCal]grad_cere_dt. |
| Num_Of_Scheduled_School_Days | 17.6.0 | Number(11,0) | Migrated From [PA_OutDisCal]num_schd_days. |
| Instruct_Min_In_Standard_Day | 17.6.0 | Number(11,0) | Migrated From [PA_OutDisCal]inst_min_in_day. |
| Days_In_Session_Lost_Strike | 17.6.0 | Number(11,0) | Migrated From [PA_OutDisCal]in_sess_strike. |
| Days_In_Session_Lost_Act80 | 17.6.0 | Number(11,0) | Migrated From [PA_OutDisCal]in_sess_act80. |
| Days_In_Session_Lost_Other | 17.6.0 | Number(11,0) | Migrated From [PA_OutDisCal]in_sess_other. |
| Total_Makeup_Days | 17.6.0 | Number(11,0) | Migrated From [PA_OutDisCal]tot_makeup. |
| Total_Instruct_Minutes_Lost | 17.6.0 | Number(11,0) | Migrated From [PA_OutDisCal]tot_instr_short. |
| Sort_By | 17.6.0 | Varchar2(20) | Migrated From [PA_OutDisCal]sort_by. |
| Sort_By2 | 17.6.0 | Varchar2(20) | Migrated From [PA_OutDisCal]sort_by2. |
| Sub_District | 18.5.0 | Number(11,0) | System generated ID for the sub_district. |