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
OBJECT_STATUS VARCHAR2 32 object status
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
ADDED_BY_PERSON_ID NUMBER 38 0 added by 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.