CST_PUBPROGRAM (ver 15.5.1)
This table is a standalone table and stores program information downloaded from the ODS. Note: Each entry must have a unique CST_PUBPROFILEID, EDUORGID, SCHOOLYEAR, and NAME. This table is available for all states/provinces and may or may not be utilized for your state/province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBPROGRAM record to which the record is associated. Required. (Default – Next value in CST_PUBPROGRAM_SQ sequence) |
CST_PUBPROFILEID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBPROFILE record to which the record is associated. Required. |
SCHOOLYEAR | 15.5.1 | NUMBER(4,0) | The external school year for the download resource. Required. |
EDUORGID | 15.5.1 | NUMBER(19,0) | The external education organization ID. Required. |
TYPE | 15.5.1 | VARCHAR2(60) | The external type of program. Required. |
NAME | 15.5.1 | VARCHAR2(60) | The external name of the program. Required. |
PROGRAMID | 15.5.1 | VARCHAR2(60) | The external program ID. |
SPONSORTYPE | 15.5.1 | VARCHAR2(60) | The external sponsor type for the program. |
EXTERNALREFID | 15.5.1 | VARCHAR2(32) | The external reference ID. |
VERSION | 15.5.1 | VARCHAR2(32) | The external version. |