Skip to main content
Skip table of contents

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.1CHAR(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.1VARCHAR2(30)The internal function used to process the code sets/types.

DESCRIPTION

15.5.1VARCHAR2(500)The external description of the code set/type. Required.

NAMESPACE

15.5.1VARCHAR2(300)The external namespace for the code set/type.

USAGEQUERY

15.5.1VARCHAR2(4000)An internal query used to get a list of local codes for a given code set/type.

BASECODETAGNAME

15.5.1VARCHAR2(100)An external tag name for a base code for a given code set/type.

 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.