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. |
VALIDATIONGROUP | 15.6.4 | VARCHAR2(30) | The validation group for the entity type. |