# 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.

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