Obsolete: S_OH_CALENDARGROUP_SNAP_S (ver 16.7.0)
This table is obsolete as of FY18.
This table is a standalone table and stores snapshot data for the [S_OH_CALENDARGROUP_S].
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 16.7.0 | Number(11,0) | Primary Key. |
| SchoolID | 16.7.0 | Number(11,0) | Schools IRN, if the Attribute Name being reported is created at the school level, as of the snapshot. |
| SnapShotRunID | 16.7.0 | Number(11,0) | A unique ID assigned to an individual snapshot to distinguish snapshots, when multiple snapshots are completed. |
| Attendance_Patterns | 16.7.0 | VarChar2(200) | Locally defined attendance patterns impacted by the Attribute Name being reported, as of the snapshot. |
| Attribute_Date | 16.7.0 | Date | Date on which the Attribute Name being reported occurred, as of the snapshot. |
| Attribute_Hours | 16.7.0 | Number(25,10) | Number of hours spent for the Attribute Name being reported, as of the snapshot. |
| Attribute_Name | 16.7.0 | VarChar2(10) | The state defined attribute name. |
| District_IRN | 16.7.0 | VarChar2(6) | District IRN, if the Attribute Name being reported is created at the district level. |
| Exclude | 16.7.0 | Number(1,0) | A flag identifying a school as being excluded from a district wide event, as of the snapshot. |
| FiscalYear | 16.7.0 | Number(11,0) | Fiscal year to which data are applicable. |