This table requires activation of Talent Acquisition Connected Insights functional area. Table stores current date average annualized salary by grade, legal employer
Module: Recruiting
CURRENCY_CODE, LEGAL_EMPLOYER_ID, GRADE_ID
| 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.