CST_PUBATTEND_DAILY_AZ (ver 15.5.1)
Operational table used for temporarily storing calculated student daily attendance data. Used for AzEDS reporting. Note: Data is not permanently stored in this table.
Column Name | Version | Data Type | Description |
---|---|---|---|
EVENT_DATE | 15.5.1 | Varchar2(20) | The event date for this absence. |
ATT_CAT | 15.5.1 | Varchar2(20) | The attendance category for this absence. |
STUDENTID | 15.5.1 | Varchar2(20) | The student ID for this absence. |
SCHOOLID | 15.5.1 | Varchar2(20) | The school ID for this absence. |
YEAR_ID | 15.5.1 | Varchar2(50) | The year ID for this absence. |
REASON | 15.5.1 | Varchar2(100) | The reason for this absence. |
ENVIRONMENT_TYPE | 15.5.1 | Varchar2(100) | The environment type for this absence. |
ABSENCE_AMOUNT | 15.5.1 | Number(10,2) | The amount for this absence. |
NUM_ABSENCE | 15.5.1 | Number(10,0) | The number of absence. |
NUM_EXCUSED | 15.5.1 | Number(10,0) | The number of excused absence. |
MIN_ABSENT | 15.5.1 | Number(10,0) | The number of absence minutes. |
MIN_EXCUSED_ABSENT | 15.5.1 | Number(10,0) | The number of excused absence minutes. |
STUDENTTYPE | 15.5.1 | Char(2) | The student type for this absence. |
INSTRUCTIONALMINUTES | 15.5.1 | Number(10,0) | The number of instructional minutes for this absence. |