IRC_AIMATCHING_ENTY_TRK
This table is to track the injested candidate along with status of passed for successfully injested candidate and status of failed for non injested candidate while incremental injestion is being ran.
Details
-
Schema: FUSION
-
Object owner: IRC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
IRC_AIMATCHING_ENTY_TRK_PK |
TRACKING_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TRACKING_ID | NUMBER | 18 | Yes | Primary key of the table auto generated by sequence. | |
AFFECTED_ENTITY_ID | NUMBER | 18 | Yes | This column stores the id of the entity (like candidate, requisition). | |
ENTITY_TYPE | VARCHAR2 | 32 | Yes | This column will store the different entity type for which the ingestion tracking is happening (like CANDIDATE, REQUISITION). | |
ESS_REQUEST_ID | NUMBER | 18 | This column stores the request id of the ESS job. | ||
STATUS | VARCHAR2 | 10 | This column will store the status of injestion (FAILED/PASSED). | ||
ERROR_MESSAGE | VARCHAR2 | 1000 | This column will store the error message of the entity which failed to injest. | ||
INGESTION_COUNT | NUMBER | 3 | Count to track number of times entity is ingested | ||
INGESTION_TIME | TIMESTAMP | This column indicates the time stamp of last successful ingestion | |||
FILE_NAME | VARCHAR2 | 32 | The name of thde json file posted. | ||
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_ENTY_TRK_PK | Unique | Default | TRACKING_ID |
IRC_AIMATCHING_ENTY_TRK_U1 | Unique | Default | ENTITY_TYPE, AFFECTED_ENTITY_ID |