CST_PUBATTEND_DAILY (ver 15.5.1)
Operational table used for temporarily storing calculated student daily attendance data. Used by Tennessee state reporting. Note: Data is not permanently stored in this table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
EVENT_DATE | 16.3.0 | Varchar2(20) | The event date for this absence. |
ATT_CODE | 15.5.1 | Varchar2(20) | The attendance code 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. |
SCHOOLYEAR | 15.5.1 | Varchar2(50) | The school year for this absence. |
TERM | 15.5.1 | Varchar2(50) | The term 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. |
NUM_ABSENCE | 15.5.1 | Number(10,0) | Total absences. |
MIN_ABSENT | 15.5.1 | Number(10,0) | Total minutes absent. |
NUM_EXC_ABSENCE | 15.5.1 | Number(10,0) | Total excused absences. |
MIN_EXC_ABSENT | 15.5.1 | Number(10,0) | Total minutes of excused absence. |
NUM_UNEXC_ABSENCE | 15.5.1 | Number(10,0) | Total unexcused absences. |
MIN_UNEXC_ABSENT | 15.5.1 | Number(10,0) | Total minutes of unexcused absence. |
ATTENDANCE_MODE | 15.5.1 | Varchar2(20) | The attendance mode for this absence. |
HAS_TRANSPORT | 15.5.1 | Char(1) | Indicates if the student separately has a transport record. |
POTENTIAL_MIN | 15.5.1 | Number(10,0) | Potential minutes for this absence. |
ABSENT_FIRST | 15.5.1 | Char(1) | The absent first for this absence. |
ABSENT_LAST | 15.5.1 | Char(1) | The absent last for this absence. |