S_OH_DISTATTENDPATTERN_SNAP_S (ver 16.7.0)
This table is a standalone table and stores snapshot data for [S_OH_DISTATTENDPATTERN_S].
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 16.7.0 | Number(11,0) | Primary Key. |
| S_OH_DistAttendPattern_SID | 16.7.0 | Number(11,0) | Foreign key that relates the standalone table back to the S_OH_DISTATTENDPATTERN_S table. |
| SnapShotRunID | 16.7.0 | Number(11,0) | A unique ID assigned to an individual snapshot to distinguish snapshots, when multiple snapshots are completed. |
| Attendance_Pattern | 16.7.0 | VarChar2(4) | Locally defined code to describe the pattern of a attendance for a student or group of students, as of the snapshot. |
| C_YWkDayFr | 16.7.0 | Number(1,0) | Flag identifying every Friday as a scheduled day not in session for a group of students, as of the snapshot. |
| C_YWkDayMn | 16.7.0 | Number(1,0) | Flag identifying every Monday as a scheduled day not in session for a group of students, as of the snapshot. |
| C_YWkEndSa | 16.7.0 | Number(1,0) | Flag identifying every Saturday as a scheduled day in session for a group of students, as of the snapshot. |
| C_YWkEndSu | 16.7.0 | Number(1,0) | Flag identifying every Sunday as a scheduled day in session for a group of students, as of the snapshot. |
| C_YWkDayTh | 16.7.0 | Number(1,0) | Flag identifying every Thursday as a scheduled day not in session for a group of students, as of the snapshot. |
| C_YWkDayTu | 16.7.0 | Number(1,0) | Flag identifying every Tuesday as a scheduled day not in session for a group of students, as of the snapshot. |
| C_YWkDayWd | 16.7.0 | Number(1,0) | Flag identifying every Wednesday as a scheduled day not in session for a group of students, as of the snapshot. |
| Description | 16.7.0 | VarChar2(200) | Describes the locally defined Attendance Pattern Code, as of the snapshot. |
| Exclude_Pot | 16.7.0 | Number(1,0) | Flag identifying an attendance pattern to be excluded from the percent of time section of the attendance calculation, as of the snapshot. |
| FiscalYear | 16.7.0 | Number(11,0) | Fiscal year to which data are applicable. |