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