# DW_TA_INSIGHTS_WRKFRC_GRADE_SALARY_A (Preview)

This table requires activation of Talent Acquisition Connected Insights functional area. Table stores current date average annualized salary by grade, legal employer

## Details

Module: Recruiting

## Key Columns

GRADE_ID, CURRENCY_CODE, LEGAL_EMPLOYER_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
GRADE_ID | NUMBER | 38 | 0 | True | Grade Identifier |  |
LEGAL_EMPLOYER_ID | NUMBER | 38 | 0 | True | Legal Employer Identifier | DW_LEGAL_EMPLOYER_D | LEGAL_EMPLOYER_ID
CURRENCY_CODE | VARCHAR2 | 16 |  | True | Currency Code |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier |  |
LEMP_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Default Currency Code of Legal Employer |  |
LEGISLATION_CODE | VARCHAR2 | 256 |  |  | Legislation Code | DW_LEGISLATION_D_TL | LEGISLATION_CODE
CALENDAR_DATE | DATE |  |  |  | Current Calendar Date |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Global Currency Code |  |
GLOBAL_CURRENCY_EXCH_RATE | NUMBER |  |  |  | Global Currency Conversion Exchange Rate |  |
AVG_ANNUALIZED_SAL_AMOUNT | NUMBER |  |  |  | Average Annualized Salary Amount |  |
AVG_ANNUALIZED_SAL_GLOBAL_CRNCY | NUMBER |  |  |  | Average Annualized Salary Amount in the Global Currency |  |
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.