CST_PUBATTABSDAILY_NE (ver 16.3.0)
Operational table used for calculating student attendance data. Used by Nebraska 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 student absence. |
| ATT_CODE | 16.3.0 | VARCHAR2(20) | The attendance code for the student absence. |
STUDENTID | 16.3.0 | VARCHAR2(20) | The student ID for this student absence. |
SCHOOLID | 16.3.0 | VARCHAR2(20) | The school ID for this student absence. |
SCHOOLYEAR | 16.3.0 | VARCHAR2(50) | The school year for this student absence. |
TERM | 16.3.0 | VARCHAR2(10) | The term for this student absence. |
TERMABBREV | 16.3.0 | VARCHAR2(10) | The term abbreviation for this student absence. |
REASON | 16.3.0 | VARCHAR2(100) | The reason for this student absence. |
ENVIRONMENT_TYPE | 16.3.0 | VARCHAR2(100) | The environment type for this student absence. |
| ABSENCE_PERCENT | 16.3.0 | NUMBER(10,2) | The percent for this student absence. |
| FTE_VALUE | 16.3.0 | NUMBER(10,2) | The FTE value for this student absence. |
| NUM_ABSENCE | 16.3.0 | NUMBER(10,0) | The number of times for this student absence. |
MIN_ABSENT | 16.3.0 | NUMBER(10,0) | Total minutes absent. |
NUM_EXC_ABSENCE | 16.3.0 | NUMBER(10,0) | The number of times the student absence was excused. |
MIN_EXC_ABSENT | 16.3.0 | NUMBER(10,0) | Total minutes of excused absence. |
ATTENDANCE_MODE | 16.3.0 | VARCHAR2(20) | The attendance mode for this student absence. |