# DW_TA_JOB_APP_EVENT_F

This is a derived fact based on DW_TA_JOB_APP_HISTORY_EVENT_F with all dimension references

## Details

Module: Recruiting

## Key Columns

JOB_APP_EVENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
JOB_APP_EVENT_ID | NUMBER | 38 | 0 | True | Requisistion Event Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Primary Key |  |
JOB_APP_EVENT_DATE | TIMESTAMP |  |  |  | Event creation Date in Timestamp |  |
JOB_APPLICATION_ID | NUMBER | 38 | 0 |  | The identifier of the Requisition. | DW_TA_JOB_APPLICATION_D | JOB_APPLICATION_ID
JOB_APP_EVENT_TYPE_ID | NUMBER | 38 | 0 |  | The identifier of the event type. | DW_TA_HISTORY_EVENT_TYPE_D | EVENT_TYPE_ID
JOB_APP_PHASE_ID | NUMBER | 38 | 0 |  | The identifier of the phase at the time of the event. | DW_TA_PHASE_D | PHASE_ID
JOB_APP_STATE_ID | NUMBER | 38 | 0 |  | The identifier of the state at the time of the event. | DW_TA_STATE_D | STATE_ID
JOB_APP_ROUTING_STEP_ID | NUMBER | 38 | 0 |  | The identifier of the routing step that triggered the event. | DW_TA_ROUTING_STEPS_D | ROUTING_STEP_ID
JOB_APP_REASON_ID | NUMBER | 38 | 0 |  | The identifier of the reason at the time of the event. | DW_TA_REASON_D | REASON_ID
JOB_APP_ACTION_ID | NUMBER | 38 | 0 |  | The identifier of the action at the time of the event. | DW_TA_ACTION_D | ACTION_ID
JOB_APP_EVENT_PERSON_ID | NUMBER | 38 | 0 |  | The identifier of the event person at the time of the event. | DW_PERSON_D | PERSON_ID
JOB_APP_PROCESS_ID | NUMBER | 38 | 0 |  | process identifier | DW_TA_PROCESS_D | PROCESS_ID
JOB_APP_FLOW_VERSION_ID | NUMBER | 38 | 0 |  | application flow version id | DW_TA_APPLICATION_FLOW_VERSION_D | APPL_FLOW_VERSION_ID
JOB_APP_PROFILE_ID | NUMBER | 38 | 0 |  | profile identifier #1 | DW_CERTIFICATION_D | PROFILE_ID
JOB_APP_REQUISITION_ID | NUMBER | 38 | 0 |  | requisition identifier | DW_TA_JOB_REQUISITION_D | REQUISITION_ID
JOB_APP_PERSON_ID | NUMBER | 38 | 0 |  | person identifier | DW_PERSON_D | PERSON_ID
JOB_APP_SRC_DIMENSION_ID | NUMBER | 38 | 0 |  | Source dimension identifier | DW_TA_SOURCE_TRACKING_D | DIMENSION_ID
JOB_APP_SRC_TRACKING_ID | NUMBER | 38 | 0 |  | Source tracking identifier | DW_TA_SOURCE_TRACKING_D | SOURCE_TRACKING_ID
JOB_APP_SYSTEM_PERSON_TYPE | VARCHAR2 | 32 |  |  | system person type.Values are from the table DW_TA_JOB_APPLICATION_D/DW_HCM_CODE_VALUES_LKP_TL | DW_TA_JOB_APPLICATION_D | SYSTEM_PERSON_TYPE
JOB_APP_CANDIDATE_JOB_APPL_DATE | DATE |  |  |  | submission date | DW_TA_JOB_APPLICATION_D | CANDIDATE_JOB_APPL_DATE
REQ_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business Unit Identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
REQ_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Stores the organization identifier | DW_INTERNAL_ORG_D | ORGANIZATION_ID
REQ_DEPARTMENT_ID | NUMBER | 38 | 0 |  | Department Identifier | DW_DEPARTMENT_D | DEPARTMENT_ID
REQ_LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier | DW_WORKER_LOCATION_D | LOCATION_ID
REQ_GEOGRAPHY_NODE_ID | NUMBER | 38 | 0 |  | Geography Node Identifier | DW_TA_GEO_HIERARICHAL_NODES_D | GEOGRAPHY_NODE_ID
REQ_PROFILE_ID | NUMBER | 38 | 0 |  | Profile Identifier | DW_WORK_REQUIREMENT_D | PROFILE_ID
REQ_JOB_ID | NUMBER | 38 | 0 |  | Job Identifier | DW_JOB_D | JOB_ID
REQ_JOB_FAMILY_ID | NUMBER | 38 | 0 |  | Job Family Identifier | DW_JOB_FAMILY_D | JOB_FAMILY_ID
REQ_JOB_FUNCTION_CODE | VARCHAR2 | 32 |  |  | Stores the job function as a lookup code | DW_JOB_FUNCTION_D_TL | JOB_FUNCTION_CODE
REQ_GRADE_ID | NUMBER | 38 | 0 |  | Grade Identifier | DW_PAY_GRADE_D | GRADE_ID
REQ_POSITION_ID | NUMBER | 38 | 0 |  | Position Identifier | DW_POSITION_D | POSITION_ID
REQ_LEGAL_EMPLOYER_ID | NUMBER | 38 | 0 |  | Legal Employer Identifier | DW_LEGAL_EMPLOYER_D | LEGAL_EMPLOYER_ID
REQ_HIRING_MANAGER_ID | NUMBER | 38 | 0 |  | Hiring Manager Identifier | DW_PERSON_D | PERSON_ID
REQ_MANAGER_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Manager Assignment Identifier |  |
REQ_RECRUITER_ID | NUMBER | 38 | 0 |  | Recruiter Identifier | DW_PERSON_D | PERSON_ID
REQ_RECRUITER_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Recruiter Assignment Identifier |  |
JOB_APP_PHASE_SEQUENCE_NUMBER | NUMBER | 38 | 0 |  | Phase Sequence Number |  |
JOB_APP_STATE_SEQUENCE_NUMBER | NUMBER | 38 | 0 |  | State Sequence Number |  |
JOB_APP_EVENT_COUNT | NUMBER | 38 | 0 |  | Requisition Event Count |  |
JOB_APP_PHASE_COUNT | NUMBER | 38 | 0 |  | Requisition Phase Count |  |
JOB_APP_STATE_COUNT | NUMBER | 38 | 0 |  | Requisition state Count |  |
JOB_APP_EVENT_CALENDAR_DATE | DATE |  |  |  | Event creation Date in date format |  |
JOB_APP_STEP_DURATION | NUMBER | 38 | 0 |  | Duration of Step |  |
CREATION_DATE | TIMESTAMP |  |  |  | Source Creation Date of the Job Application Event |  |
JOB_REQ_CREATION_DATE | DATE |  |  |  | Source Requisition Creation Date. Holds the date when the actual requisition was first created |  |

## Notes

#1 This column is also used to join the tables DW_DEGREE_D,DW_PREVIOUS_EMPLOYMENT_D,DW_WORK_REQUIREMENT_D based on the columns PROFILE_ID,PROFILE_ID,PROFILE_ID.

Copyright © 2019, 2025, Oracle and/or its affiliates.