# DW_TA_INSIGHTS_ACTIVE_JOB_REQ_CRNT_F (Preview)

This table requires activation of Talent Acquisition Connected Insights functional area. This fact provides information about Active Job Requisitions as of the current calendar date (excluding those Requisitions that are filled, cancelled, or deleted)

## Details

Module: Recruiting

## Key Columns

REQUISITION_ID, CALENDAR_DATE

## 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 |  |
CAN_BE_SUSPENDED_FLAG | VARCHAR2 | 32 |  |  | Indicates whether the Requisition Can Be Suspended |  |
REQ_COUNT | NUMBER | 38 | 0 |  | Metric defaulted to 1 |  |
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.