CST_PUBORGTRACK_AZ (ver 15.5.1)
This table stores organizational track data downloaded from AzEDS. Districts and schools configure organizational tracks at the state level. Downloaded track data is published with student enrollment data. If a track is not defined for a school, then the district organization and track number will be used when publishing student enrollment data.
Column Name | Version | Data Type | Description |
---|---|---|---|
ID | 16.3.0 | Number(10,0) | The internal ID for the CST_PUBORGTRACK_AZ record to which the record is associated. Required. (Default – Next value in CST_PUBORGTRACK_AZ_SQ sequence). |
EDUORGID | 15.5.1 | Varchar2(19) | The education organization ID for this organization track. |
SCHOOLYEAR | 15.5.1 | Number(4,0) | The school year for this organization track. |
TRACKNUMBER | 15.5.1 | Number(10,0) | The track number for this organization track in the range 1 to 4. |
TRACKNAME | 15.5.1 | Varchar2(100) | The track name for this organization track. |
BEGINDATE | 15.5.1 | Date | The begin date for this organization track. |
ENDDATE | 15.5.1 | Date | The end date for this organization track. |
TOTALINSTRUCTIONALDAYS | 15.5.1 | Number(3,0) | The total instructional days for this organization track. |
EXTERNALREFID | 15.5.1 | Varchar2(32) | The external reference (transaction) ID received from AzEDS for this organization track. |
VERSION | 15.5.1 | Varchar2(32) | The external version for this organization track. |