DW_TA_JOB_REQ_SNAPSHOT_F
Requisition Snapshot Fact
Details
Module: Recruiting
Key Columns
REQUISITION_ID, CALENDAR_DATE
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 |