CST_PUBATTEND_JTEDDATE_AZ (ver 15.5.1)
Operational table used for calculating student attendance data for JTED sections by date. Used for AzEDS reporting. Note: Data is not permanently stored in this table.
Column Name | Version | Data Type | Description |
---|---|---|---|
SCHOOLID | 15.5.1 | Number(10,0) | The school ID related to this JTED attendance event. |
STUDENTID | 15.5.1 | Number(10,0) | The student ID related to this JTED attendance event. |
SECTIONID | 15.5.1 | Integer | The section ID related to this JTED attendance event. |
DATE_VALUE | 15.5.1 | Date | The date value for this JTED attendance event. |
BELL_SCHEDULE_ID | 15.5.1 | Number | The bell schedule ID related to this JTED attendance event. |
SECTION_RANK | 15.5.1 | Number | The section rank for this JTED attendance event. |
JTED_STU | 15.5.1 | Varchar2(4000) | Student data related to this JTED attendance event. |
DATELEFT | 15.5.1 | Date | The date left for this JTED attendance event. |
DATEENROLLED | 15.5.1 | Date | The date enrolled for this JTED attendance event. |
YEAR_ID | 15.5.1 | Number(10,0) | The year ID for this JTED attendance event. |
PERIOD_NUMBER | 15.5.1 | Number(10,0) | The period number for this JTED attendance event. |
CYCLE_DAY_LETTER | 15.5.1 | Varchar2(2) | The cycle day letter for this JTED attendance event. |
CC_ID | 15.5.1 | Number(10,0) | The CC ID for this JTED attendance event. |
IS_JTED | 15.5.1 | Char(1) | Indicates if section is marked as JTED. |
GRADE_LEVEL | 16.3.0 | Number(10,0) | The grave level of the student related to this JTED attendance event. |
JTED_ORGID | 16.3.0 | Varchar2(19) | The organization ID related to this JTED attendance event. |