DW_TA_JOB_APP_SNAPSHOT_F

Job Application Snapshot Fact

Details

Module: Recruiting

Key Columns

CALENDAR_DATE, JOB_APPLICATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
JOB_APPLICATION_ID NUMBER 38 0 True Job Application Identifier DW_TA_JOB_APPLICATION_D JOB_APPLICATION_ID
CALENDAR_DATE DATE     True Calendar Date DW_DAY_D CALENDAR_DATE
SOURCE_RECORD_ID VARCHAR2 128     Source Record Identifier    
JOB_APP_PHASE_ID NUMBER 38 0   Job Application Phase Identifier DW_TA_PHASE_D PHASE_ID
JOB_APP_STATE_ID NUMBER 38 0   Job Application State Identifier DW_TA_STATE_D STATE_ID
JOB_APP_PHASE_SEQUENCE_NUMBER NUMBER 38 0   Phase Sequence Number    
JOB_APP_STATE_SEQUENCE_NUMBER NUMBER 38 0   State Sequence Number    
JOB_APP_PROCESS_ID NUMBER 38 0   Job Application Process Identifier DW_TA_PROCESS_D PROCESS_ID
JOB_APP_FLOW_VERSION_ID NUMBER 38 0   Job Application Flow Version Identifier DW_TA_APPLICATION_FLOW_VERSION_D APPL_FLOW_VERSION_ID
JOB_APP_PROFILE_ID NUMBER 38 0   Job Application 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_DIMENSION_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
REQ_BUSINESS_UNIT_ID NUMBER 38 0   Business Unit Identifier of the Requisition 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 Id of the Requisition DW_DEPARTMENT_D DEPARTMENT_ID
REQ_LOCATION_ID NUMBER 38 0   Location Identifier of the Requisition DW_WORKER_LOCATION_D LOCATION_ID
REQ_GEOGRAPHY_NODE_ID NUMBER 38 0   Geography Node Identifier of the Requisition DW_TA_GEO_HIERARICHAL_NODES_D GEOGRAPHY_NODE_ID
REQ_PROFILE_ID NUMBER 38 0   Profile Identifier Identifier of the Requisition DW_WORK_REQUIREMENT_D PROFILE_ID
REQ_JOB_ID NUMBER 38 0   Job Identifier Identifier of the Requisition DW_JOB_D JOB_ID
REQ_JOB_FAMILY_ID NUMBER 38 0   Job Family Identifier of the Requisition 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 of the Requisition DW_PAY_GRADE_D GRADE_ID
REQ_POSITION_ID NUMBER 38 0   Position Identifier of the Requisition DW_POSITION_D POSITION_ID
REQ_LEGAL_EMPLOYER_ID NUMBER 38 0   Legal Employer Identifier of the Requisition DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
REQ_HIRING_MANAGER_ID NUMBER 38 0   Hiring Manager Identifier of the Requisition DW_PERSON_D PERSON_ID
REQ_MANAGER_ASSIGNMENT_ID NUMBER 38 0   Manager Assignment Identifier of the Requisition    
REQ_RECRUITER_ID NUMBER 38 0   Recruiter Identifier of the Requisition DW_PERSON_D PERSON_ID
REQ_RECRUITER_ASSIGNMENT_ID NUMBER 38 0   Recruiter Assignment Identifier of the Requisition    
JOB_APP_COUNT NUMBER 38 0   Metric defaulted to 1    

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, 2023, Oracle and/or its affiliates.