IRC_AIMATCHING_QUEUE
This table is used for processing candidate,requisition and submissions entities to AI.
Details
-
Schema: FUSION
-
Object owner: IRC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
IRC_AIMATCHING_QUEUE_PK |
QUEUE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| QUEUE_ID | NUMBER | 18 | Yes | Primary key of this table generated by sequence | |
| AFFECTED_ENTITY_ID | NUMBER | 18 | Yes | Primary key of entities Submissions,Requisition and Candidates inserted in this table | |
| REFERENCE_COUNT | NUMBER | 1 | Yes | Value of this column shows that row is already being picked up by a thead for indexing , so that no other threads pick up the row again for indexing. | |
| ENTITY_TYPE_CODE | VARCHAR2 | 32 | Yes | This value shows the type of entity to be indexed - Submission,candidate or Requision | |
| ENT_LAST_MODIFIED_DATE | TIMESTAMP | Last_modified_date for entity inserted for processing | |||
| INDEXING_CODE | VARCHAR2 | 8 | Yes | This code tells whether the entity is to be processed in full indexing or incremental indexing | |
| PROCESSOR_ID | NUMBER | 18 | Thread Id of the thread which is going to index this particualr entity row | ||
| RETRY_COUNT | NUMBER | 3 | Keeps record of the failed entity in the queue for retrying failed entities. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IRC_AIMATCHING_QUEUE_N1 | Non Unique | Default | ENTITY_TYPE_CODE, AFFECTED_ENTITY_ID |
| IRC_AIMATCHING_QUEUE_N2 | Non Unique | Default | PROCESSOR_ID, RETRY_COUNT |
| IRC_AIMATCHING_QUEUE_N3 | Non Unique | Default | REFERENCE_COUNT, INDEXING_CODE, RETRY_COUNT |
| IRC_AIMATCHING_QUEUE_N4 | Non Unique | Default | REFERENCE_COUNT, INDEXING_CODE, PROCESSOR_ID, ENTITY_TYPE_CODE |
| IRC_AIMATCHING_QUEUE_U1 | Unique | Default | QUEUE_ID |