Stores Talent Requisition history Event details
Module: Recruiting
EVENT_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
EVENT_ID | NUMBER | 38 | 0 | True | Primary key of the table | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Primary Key | ||||
EVENT_DATE | TIMESTAMP | Event creation Date | |||||
REQUISITION_ID | NUMBER | 38 | 0 | The identifier of the Requisition. | DW_TA_JOB_REQUISITION_D | REQUISITION_ID | |
EVENT_TYPE_ID | NUMBER | 38 | 0 | The identifier of the event type. | DW_TA_HISTORY_EVENT_TYPE_D | EVENT_TYPE_ID | |
PHASE_ID | NUMBER | 38 | 0 | The identifier of the phase at the time of the event. | DW_TA_PHASE_D | PHASE_ID | |
STATE_ID | NUMBER | 38 | 0 | The identifier of the state at the time of the event. | DW_TA_STATE_D | STATE_ID | |
ROUTING_STEP_ID | NUMBER | 38 | 0 | The identifier of the routing step that triggered the event. | DW_TA_ROUTING_STEPS_D | ROUTING_STEP_ID |