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

CURRENCY_CODE, LEGAL_EMPLOYER_ID, GRADE_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    

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