CST_PUBUNIQUEIDSTAFF (ver 15.5.1)
This table is a standalone table and stores information related to the unique IDs for staff. Note: Each entry must have a unique CST_PUBPROFILEID and PSID. 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_PUBUNIQUEIDSTAFF record to which the record is associated. Required. (Default – Next value in CST_PUBUNIQUEIDSTAFF_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. |
CST_PUBLOGID | 16.3.0 | NUMBER(19,0) | The internal ID for the CST_PUBLOG record to which the record is associated. |
PSID | 15.5.1 | NUMBER(19,0) | The DCID of the USERS table associated with this staff unique ID. Required. |
STATUS | 15.5.1 | CHAR(1) | The status of this unique ID record. Required. (i.e. ‘S’-Success, ‘F’-Failed, ‘N’-Needs human intervention) |
UPDATEFLAG | 15.5.1 | NUMBER(1,0) | A flag used to specify if the unique ID record needs to be updated. Required. (i.e. 0-Updated, 1-Needs to be updated) (Default – 1 Needs to be updated) |
UNIQUEID | 15.5.1 | VARCHAR2(32) | The unique ID assigned by the ODS. |
PRIORUNIQUEID | 15.5.1 | VARCHAR2(32) | The prior unique ID assigned by the ODS. |
EXTERNALREFID | 15.5.1 | VARCHAR2(32) | The external reference ID. |
| NODEID | 15.9.3 | VARCHAR2(50) | The node ID of the node processing this unique ID job. |