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.