CST_PUBCODEVALUE (ver 15.5.1)
This table is a standalone table and stores code values for a given code set/type. 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_PUBCODEVALUE record to which the record is associated. Required. (Default – Next value in CST_PUBCODEVALUE_SQ sequence) |
CST_PUBCODESETID | 15.5.1 | NUMBER(19,0) | The name of the table that had a transaction/change. Required. |
CODEVALUE | 15.5.1 | VARCHAR2(300) | The external code value. |
SHORTDESCRIPTION | 15.5.1 | VARCHAR2(200) | The external short description. |
EFFECTIVEBEGINDATE | 15.5.1 | TIMESTAMP(6) | The external effective begin date. |
EFFECTIVEENDDATE | 15.5.1 | TIMESTAMP(6) | The external effective end date. |
VERSION | 15.5.1 | VARCHAR2(32) | The external version. |
DESCRIPTION | 15.5.0 | VARCHAR2(500) | The external description. |
ALTERNATEID | 15.5.0 | NUMBER(19,0) | The external alternate ID. |
PRIORALTERNATEID | 15.5.1 | NUMBER(19,0) | The external prior alternate ID. |
BASECODEVALUE | 15.5.1 | VARCHAR2(300) | The external base code value. |
EXTERNALREFID | 15.5.1 | VARCHAR2(300) | The external reference ID for code value record. |