DW_TA_JOB_APPLICATION_D

Job application dimension

Details

Module: Recruiting

Key Columns

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    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. source record identifier    
APPLICATION_ACTIVE_FLAG VARCHAR2 16     indicates submission is active or not    
SYSTEM_PERSON_TYPE VARCHAR2 32     system person type.Values are from the table DW_HCM_CODE_VALUES_LKP_TL with CODE_TYPE=ORA_IRC_PERSON_TYPE. DW_HCM_CODE_VALUES_LKP_TL CODE
PROCESS_ID NUMBER 38 0   process identifier DW_TA_PROCESS_D PROCESS_ID
APPLICATION_FLOW_VERSION_ID NUMBER 38 0   application flow version id DW_TA_APPLICATION_FLOW_VERSION_D APPL_FLOW_VERSION_ID
SITE_NUMBER VARCHAR2 256     site number DW_TA_CAREER_SITE_D CAREER_SITE_NUMBER
APPLICATION_CONFIRMED_FLAG VARCHAR2 16     submission is confirmed or not    
DISQUALIFIED_FLAG VARCHAR2 16     To track if submission overall was disqualified    
INTERNAL_CANDIDATE_FLAG VARCHAR2 16     to know if submission was internal application    
IS_RESTRICTED_FLAG VARCHAR2 16     Indicates whether the job application is restricted to access based on the user privilage.    
CANDIDATE_JOB_APPL_DATE DATE       submission date    
CAND_JOB_APPL_LAST_MOD_DATE DATE       Stores the last modified date for the Submission    
SUBMISSION_CONFIRMED_DATE DATE       Submission confirmed date    
PROFILE_ID NUMBER 38 0   profile identifier #1 DW_CERTIFICATION_D PROFILE_ID
REQUISITION_ID NUMBER 38 0   requisition identifier DW_TA_JOB_REQUISITION_D REQUISITION_ID
PERSON_ID NUMBER 38 0   person identifier DW_PERSON_D PERSON_ID
CURRENT_PHASE_ID NUMBER 38 0   phase identifier DW_TA_PHASE_D PHASE_ID
CURRENT_STATE_ID NUMBER 38 0   state identifier DW_TA_STATE_D STATE_ID

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