# 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 |  |
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.