CST_PUBPUBLISHED (ver 15.5.1)
This table is a standalone table and stores information related to what items have been published and what items are waiting to be published. Note: Each entry must have a unique CST_PUBPROFILEID, CST_PUBENTITYTYPEID, DASHBOARDID, and COMPOSITEKEYS. 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_PUBPUBLISHED record to which the record is associated. Required. (Default – Next value in CST_PUBPUBLISHED_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_PUBENTITYTYPEID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBENTITYTYPE record to which the record is associated. Required. |
CST_PUBPUBLISHMESSAGEID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBPUBLISHMESSAGE record to which the record is associated. |
DASHBOARDID | 15.5.1 | NUMBER(19,0) | The internal ID for the dashboard record to which the record is associated. Required. |
COMPOSITEKEYS | 15.5.1 | VARCHAR2(300) | The internal composite keys for the published items. Required. |
| SUPPORTINGKEYS | 15.5.1 | VARCHAR2(300) | The internal supporting keys for the published items. |
YEARID | 15.5.1 | NUMBER(10,0) | The internal year ID for the published item. Required. |
ORGID | 15.5.1 | VARCHAR2(19) | The internal organization ID. Required. |
VALIDATESTATUS | 15.5.1 | CHAR(1) | The internal validation status. Required. (i.e. ‘V’-Valid, ‘I’-Invalid, ‘R’-Ready, ‘D’-Dependency Invalid, ‘X’-Deleted) (Default – ‘V’ Valid) |
PUBLISHREADY | 15.5.1 | NUMBER(1,0) | Specifies if a record is ready to be published. Required. (0-Not Ready, 1+-Ready |
PUBLISHSTATUS | 15.5.1 | CHAR(1) | Specifies the status for the item to be published. Required. (i.e. ‘S’-Success, ‘E’-Error, ‘P’-A job is waiting/pending to be processed in the cst_pubPublishJob table, ‘F’-Failed for framework problems) (Default – ‘S’ Needs to be published) |
PUBLISHJOBID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBPUBLISHJOB record to which the record is associated. |
LASTPUBLISHDATE | 15.5.1 | TIMESTAMP(6) | The last date and time the item was published. |
EXTERNALREFID | 15.5.1 | VARCHAR2(300) | The external reference ID. |
| STUDENTID | 15.6.4 | NUMBER(19) | The ID from the STUDENTS table. |
| USERSDCID | 15.6.4 | NUMBER(19) | The DCID from the USERS table. |
| DEPENDENCYREASON | 15.8.2 | VARCHAR2(200) | The reason for a dependency. |