CST_PUBATTEND_ABSDAILY (ver 15.5.1)
Operational table used for calculating student attendance data. Used by Tennessee state reporting. Note: Data is not permanently stored in this table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
EVENT_DATE | 15.5.1 | Date | The event date for this student absence. |
STUDENTID | 15.5.1 | Varchar2(20) | The student ID for this student absence. |
GRADE_LEVEL | 15.5.1 | Varchar2(10) | The grade level for this student absence. |
SCHOOLID | 15.5.1 | Varchar2(20) | The school ID for this student absence. |
SCHOOL_YEAR | 15.5.1 | Varchar2(50) | The school year for this student absence. |
YEAR_ID | 15.5.1 | Varchar2(50) | The year ID for this student absence. |
NUM_ABSENCE | 15.5.1 | Number(10,0) | The number of times the student was absent. |
NUM_EXCUSED | 15.5.1 | Number(10,0) | The number of times the student was excused. |
NUM_UNEXCUSED | 15.5.1 | Number(10,0) | The number of times the student was unexcused. |
NUM_TRANS | 15.5.1 | Number(10,0) | Total transportation absences. |
MIN_ABSENT | 15.5.1 | Number(10,0) | Total minutes absent. |
MIN_EXCUSED_ABSENT | 15.5.1 | Number(10,0) | Total minutes of excused absence. |
MIN_UNEXCUSED_ABSENT | 15.5.1 | Number(10,0) | The minimum times unexcused absent. |
MIN_TRANS_ABSENT | 15.5.1 | Number(10,0) | The minimum times trans absent. |
ATTENDANCE_MODE | 15.5.1 | Varchar2(20) | The attendance mode for this student absence. |
HAS_TRANSPORT | 15.5.1 | Char(1) | Indicates if the student has a transport record. |
POTENTIAL_MINUTES | 15.5.1 | Number(10,0) | The potential minutes for this student absence. |
ABSENT_FIRST | 15.5.1 | Char(1) | Indicates if this is the first absence. |
ABSENT_LAST | 15.5.1 | Char(1) | Indicates if this is the last absence. |
REASON | 15.5.1 | Varchar2(100) | The reason for this student absence. |
ENVIRONMENT_TYPE | 15.5.1 | Varchar2(100) | The environment type for this student absence. |