S_NC_PS_ABSENCE (ver 13.6.0)
This table is a stand alone table that stores information about a student's attendance..
Column Name | Version | Data Type | Description |
---|---|---|---|
BELL_SCHEDULE_ID | 13.6.0 | NUMBER(10,0) | The bell schedule ID associated with the absence. |
CALENDARDATE | 13.6.0 | DATE | The date the student was absent. |
EXCUSED | 13.6.0 | NUMBER(,) | Indicates if the attendance was excused. |
H_MIN | 13.6.0 | NUMBER(,) | Indicates the number of minutes for an absence code of H. |
MIN_ABSENCE | 13.6.0 | NUMBER(,) | Indicates the number of minutes absent. |
PERIOD_ABSENCE | 13.6.0 | NUMBER(,) | Indicates the period the student was absent. |
PREF_VALUE | 13.6.0 | NUMBER(,) | |
SCHOOLID | 13.6.0 | NUMBER(10,0) | The school id for the absence. |
STUDENTID | 13.6.0 | NUMBER(10,0) | The student id for the attendance record. |
UNEXCUSED | 13.6.0 | NUMBER(,) | Indicates if the attendance was unexcused. |