CST_PUBDOWNLOADJOB (ver 15.5.1)
This table is a standalone table and stores information related to download jobs from the ODS. 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_ PUBDOWNLOADJOB record to which the record is associated. Required. (Default – Next value in CST_ PUBDOWNLOADJOB_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. |
| CST_SUBDISTRICTSID | 15.9.3 | NUMBER(10,0) | The internal ID for the CST_SUBDISTRICTS record to which the record is associated. Required. (Default - 0) |
CST_PUBLOGID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBLOGID record to which the record is associated. |
SCHOOLYEAR | 15.5.1 | NUMBER(4,0) | The school year for the download resource. Required. |
RESOURCENAME | 15.5.1 | VARCHAR2(100) | The external resource name available on the ODS. Required. |
STATUS | 15.5.1 | CHAR(1) | The status of the download job. Required. (i.e. ‘S’-Successful, ‘F’-Failed, ‘P’-Pending) |
PARAMS | 15.5.1 | VARCHAR2(300) | Parameters that will be added to the end of the download URL to get resources by value or ID. |
DOWNLOADEDDATA | 15.5.1 | XMLType | The XML data downloaded from the ODS. |
| NODEID | 15.9.3 | VARCHAR2(50) | The node ID of the node processing this download job. |