S_PA_SCH_FireDrill_C (ver 17.5.0)
This table is a child table of the Schools table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 17.5.0 | Number(10,0) | System generated Primary Key. |
SchoolsDCID | 17.5.0 | Number(10,0) | Foreign Key to the Schools table. |
SchoolYear | 17.5.0 | Number(10,0) | School year of drill. |
Fire_Drill_Month | 17.5.0 | Varchar2(3) | Month of drill. |
Fire_Drill_Indicator_YN | 17.5.0 | Varchar2(1) | Indicates whether the fire drill occurred. |
Fire_Drill_Reason | 17.5.0 | Varchar2(2) | Reason the drill has not held. |
Fire_Drill_Comment | 17.5.0 | Varchar2(250) | Extra comment for.why the drill has not held. |
| Fire_Drill_Date | 17.5.0 | Date | Date on which drill occurred. |
| Fire_Drill_Type | 18.10.0 | Varchar2(2) | The drill type. |
Fire_Drill_Firstday | 18.10.0 | Number(1) | Indicates whether the drill occurred on first day of school. |