DW_TA_INSIGHTS_SALARY_EF (Preview)

This table requires activation of Talent Acquisition Connected Insights functional area. This is a derived fact with salary details of Accepted Job Offers

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. Unique Source Record Identifier    
CALENDAR_DATE DATE       Calendar Date DW_DAY_D CALENDAR_DATE
OFFER_ID NUMBER 38 0   Offer Identifier DW_TA_OFFER_D OFFER_ID
JOB_APP_PROFILE_ID NUMBER 38 0   profile identifier 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
REQ_BUSINESS_UNIT_ID NUMBER 38 0   Business Unit Indentifier 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 Identifier DW_DEPARTMENT_D DEPARTMENT_ID
REQ_LOCATION_ID NUMBER 38 0   Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
REQ_GEOGRAPHY_NODE_ID NUMBER 38 0   Stores the corresponding geography node ID DW_TA_GEO_HIERARICHAL_NODES_D GEOGRAPHY_NODE_ID
REQ_PROFILE_ID NUMBER 38 0   Stores the corresponding job profile ID DW_WORK_REQUIREMENT_D PROFILE_ID
REQ_JOB_ID NUMBER 38 0   Job Identifier DW_JOB_D JOB_ID
REQ_JOB_FAMILY_ID NUMBER 38 0   Job Family Identifier 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 DW_PAY_GRADE_D GRADE_ID
REQ_POSITION_ID NUMBER 38 0   Position Identifier DW_POSITION_D POSITION_ID
REQ_LEGAL_EMPLOYER_ID NUMBER 38 0   legal employer identifier DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
REQ_HIRING_MANAGER_ID NUMBER 38 0   Hiring Manager Identifier DW_PERSON_D PERSON_ID
REQ_MANAGER_ASSIGNMENT_ID NUMBER 38 0   Stores the Assignment Identifier of the hiring manager assignment for this Requisition    
REQ_RECRUITER_ID NUMBER 38 0   Recruiter identifier DW_PERSON_D PERSON_ID
REQ_RECRUITER_ASSIGNMENT_ID NUMBER 38 0   Stores the Assignment Identifier of the recruiters assignment for this Requisition    
OFFER_ACCEPTED_DATE TIMESTAMP       Stores last offer accepted date    
ASSIGNMENT_OFFER_ID NUMBER 38 0   Assignment Offer Identifier    
OBJECT_STATUS VARCHAR2 32     Stores the status of the object.    
CURRENCY_CODE VARCHAR2 16     Currency of salary amount    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global Currency Code    
GLOBAL_CURRENCY_EXCH_RATE NUMBER       Global Currency Conversion Exchange Rate    
ANNUALIZED_FULLTIME_SAL_AMOUNT NUMBER       Annualized Salary Amount when the person FTE=1    
ANNUALIZED_FULLTIME_SAL_GLOBAL_CRNCY NUMBER       Annualized Salary Amount in the Global Currency Code when the person FTE=1    

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