CST_PUBCODESETMISC (ver 15.5.1)
This table is a standalone table and stores miscellaneous code sets/types for the ODS. Note: Each entry must have a unique CST_PUBPROFILEID and DISPLAYNAME. 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_PUBCODESETMISC record to which the record is associated. Required. (Default – Next value in CST_PUBCODESETMISC_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. |
DISPLAYNAME | 15.5.1 | VARCHAR2(100) | The display name of the misc code set/type. Required. |
DESCRIPTION | 15.5.1 | VARCHAR2(500) | The external description of the code set/type. Required. |
LOCALCODEQUERY | 15.5.1 | VARCHAR2(4000) | An internal query used to get a list of local codes for a given code set/type. |
EXTERNALCODEQUERY | 15.5.1 | VARCHAR2(4000) | An internal query used to get a list of the external codes for a given code set/type. |
USAGEDESCRIPTION | 15.5.1 | VARCHAR2(200) | A description on the usage of the code queries. |