S_OH_SCHOOLS_DAP_MAP_SNAP_S (ver 16.7.0)
This table is a standalone table and stores snapshot data from [S_OH_SCHOOLS_DAP_MAP_C] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 16.7.0 | Number(11,0) | Primary Key. |
| SchoolsDCID | 16.7.0 | Number(11,0) | Foreign key that relates the child table back to the SCHOOLS table. |
| SnapShotRunID | 16.7.0 | Number(11,0) | A unique ID assigned to an individual snapshot to distinguish snapshots, when multiple snapshots are completed. |
| S_OH_DistAttendPattern_SID | 16.7.0 | Number(11,0) | Foreign key that relates the child table back to the S_OH_DISTATTENDPATTERN_S table. |
| C_CldrSpec | 16.7.0 | VarChar2(50) | Indicates a building attendance pattern which has been exempt from the minimum total hours/days, as of the snapshot. |
| FiscalYear | 16.7.0 | Number(11,0) | Fiscal year to which data are applicable. |