CST_PUBATTEND_ABSSECTION (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 |
|---|---|---|---|
SCHOOLID | 15.5.1 | Varchar2(20) | The school ID for this section attendance. |
STUDENTID | 15.5.1 | Number(10,0) | The student ID for this section attendance. |
DATE_VALUE | 15.5.1 | Date | The date value for this section attendance. |
SECTION | 15.5.1 | Number(10,0) | The section for this section attendance. |
DATE_ENROLLED | 15.5.1 | Date | The date enrolled for this section attendance. |
DATE_LEFT | 15.5.1 | Date | The date left for this section attendance. |
CC_ID | 15.5.1 | Number(10,0) | The CC ID for this section attendance. |
CALENDAR_DAY_ID | 15.5.1 | Number(10,0) | The calendar day ID for this section attendance. |
PERIOD_ID | 15.5.1 | Number(10,0) | The period ID for this section attendance. |
YEAR_ID | 15.5.1 | Number(10,0) | The year ID for this section attendance. |
MINUTES_ATTENDED | 15.5.1 | Number(10,0) | The minutes attended for this section attendance. |
CLASS_START | 15.5.1 | Varchar2(10) | The start time for this section attendance. |
CLASS_END | 15.5.1 | Varchar2(10) | The end time for this section attendance. |
FIRST_LAST | 15.5.1 | Char(1) | Indicates whether absence is first or last. |
STAFFID | 15.5.1 | Varchar2(30) | The staff ID for this section attendance. |