Skip to main content
Skip table of contents

CST_PUBENTITYTYPE (ver 15.5.1)

This table is a standalone table and stores entity type information received from the ODS. 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_PUBENTITYTYPE record to which the record is associated. Required. (Default – Next value in CST_PUBENTITYTYPE_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(50)

The external name for the entity type.

STATUS

15.5.1

CHAR(1)

The internal status for the entity type. Required. (‘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 entity type.

LASTSYNC

15.5.1

TIMESTAMP(6)

The internal date and time of when the entity type was last synced with the ODS.

DESCRIPTION

15.5.1

VARCHAR2(200)

The internal description for the entity type. Required.

VALIDATIONGROUP15.6.4VARCHAR2(30)The validation group for the entity type.
JavaScript errors detected

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

If this problem persists, please contact our support.