# DW_TA_JOB_REQ_SNAPSHOT_F

Requisition Snapshot Fact

## Details

Module: Recruiting

## Key Columns

CALENDAR_DATE, REQUISITION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
REQUISITION_ID | NUMBER | 38 | 0 | True | Requisition Identifier | DW_TA_JOB_REQUISITION_D | REQUISITION_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 |  |
REQ_PHASE_ID | NUMBER | 38 | 0 |  | Requisition Phase Identifier | DW_TA_PHASE_D | PHASE_ID
REQ_STATE_ID | NUMBER | 38 | 0 |  | Requisition State Identifier | DW_TA_STATE_D | STATE_ID
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 |  |
REQ_PHASE_SEQUENCE_NUMBER | NUMBER | 38 | 0 |  | Requisition Phase Sequence Number |  |
REQ_STATE_SEQUENCE_NUMBER | NUMBER | 38 | 0 |  | Requisition State Sequence Number |  |
REQ_COUNT | NUMBER | 38 | 0 |  | Metric defaulted to 1 |  |
APPLICATION_COUNT_HR_PHASE | NUMBER | 38 | 0 |  | Count of the No. of Job Applications that are in HR Phase excluding those that have been Rejected or Withdrawn |  |
APPLICATION_COUNT_HR_PHASE_PROCESSED | NUMBER | 38 | 0 |  | Count of the No. of Job Applications that are Hired i.e. in Hr Processed Phase and State |  |
APPLICATION_COUNT_OFFER_PHASE | NUMBER | 38 | 0 |  | Count of the No. of Job Applications that are in Offer Phase excluding those that have been Rejected by Employer or Withdrawn By Candidate or are in To Be Created or Offer Approval Rejected states |  |
CAL_MONTH_ID | NUMBER | 38 | 0 |  | Month identifier in YYYYQMM format. For example, 1979412. |  |
CAL_QUARTER_ID | NUMBER | 38 | 0 |  | Quarter identifier in YYYYQ format. For example, 19794. |  |
CAL_YEAR_ID | NUMBER | 38 | 0 |  | Year identifier in YYYY format. For example, 1979. |  |

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