CST_PUBCODESET (ver 15.5.1)
This table is a standalone table and stores code sets/types for the ODS. Note: Each entry must have a unique CST_PUBPROFILEID 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_PUBCODESET record to which the record is associated. Required. (Default – Next value in CST_PUBCODESET_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. |
RESOURCENAME | 15.5.1 | VARCHAR2(100) | The external resource name available on the ODS. Required. |
NAME | 15.5.1 | VARCHAR2(100) | The external name of the code set/type. Required. |
STATUS | 15.5.1 | CHAR(1) | The status of the code set. Required. (i.e. ‘I’–Initial, ‘R’-Requested, ‘D’-Downloaded, ‘P’-Processing, ‘S’-Successful, ‘F’-Failure) (Default – ‘I’-Initial) |
FUNC | 15.5.1 | VARCHAR2(30) | The internal function used to process the code sets/types. |
DESCRIPTION | 15.5.1 | VARCHAR2(500) | The external description of the code set/type. Required. |
NAMESPACE | 15.5.1 | VARCHAR2(300) | The external namespace for the code set/type. |
USAGEQUERY | 15.5.1 | VARCHAR2(4000) | An internal query used to get a list of local codes for a given code set/type. |
BASECODETAGNAME | 15.5.1 | VARCHAR2(100) | An external tag name for a base code for a given code set/type. |