Job Application Snapshot Fact
Module: Recruiting
CALENDAR_DATE, JOB_APPLICATION_ID
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 | This column is for Oracle Internal use only. 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 |
#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.