DW_CMP_ASG_SALARY_DETAIL_D (Preview)

This table requires activation of Salary Basis functional area. Holds person salary and assoicated metrics

Details

Module: Compensation

Key Columns

SALARY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SALARY_ID NUMBER 38 0 True Primary Key for Salary in Fusion Source.    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. Unique Source Record Identifier    
ASSIGNMENT_ID NUMBER 38 0   Assignment identifier    
EFFECTIVE_START_DATE DATE       Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective    
EFFECTIVE_END_DATE DATE       Date Effective Entity: indicates the date at the end of the date range within which the row is effective.    
ELEMENT_TYPE_ID NUMBER 38 0   Element Type identifier    
SALARY_AMOUNT NUMBER       Salary Amount    
ANNUALIZATION_FACTOR NUMBER       Annualized factor    
RATE_ID NUMBER 38 0   Grade Rate id (Salary range) DW_GRADE_RATE_D RATE_ID
RATE_NAME VARCHAR2 256     Grade Rate Name    
RATE_TYPE VARCHAR2 32     Type of Rate ( Salary, Bonus, Overtime, etc)    
RATE_OBJECT_TYPE VARCHAR2 32     Rate object type (Grade , Step, etc)    
RATE_FREQUENCY VARCHAR2 32     Frequency of rate (Monthly, Annualy, etc)    
MINIMUM NUMBER       Minimum Value of salary range (After applying diff profile)    
MID_VALUE NUMBER       Mid point of salary range    
MAXIMUM NUMBER       Maxmum value of salary range    
SALARY_CHANGE_AMT NUMBER       Salary increase amount    
SALARY_CHANGE_PER NUMBER       Salary increase %    
PREV_AMT NUMBER       Previous Salary amount    
PREV_SALARY_BASIS NUMBER       Previous Salary basis ID DW_SALARY_BASIS_D SALARY_BASIS_ID
PREV_CURR_CODE VARCHAR2 999     Previous Currency code    
ANNUALIZED_SALARY NUMBER       Annualized Salary    
ANNUALIZED_FULLTIME_SALARY NUMBER       Annualized Salary when the person FTE = 1    
RANGE_DIFF_FACTOR NUMBER       Salary range differentail Factor (muliplier or grade rate)    
QUARTILE VARCHAR2 999     Quartile    
QUINTILE VARCHAR2 999     Quintile    
COMPARATIO NUMBER       Comparative Ratio    
PERCENTILE NUMBER       Percentile    
ACTION_OCCURRENCE_ID NUMBER 38 0   It defines the action occurrences for an action    
ACTION_ID NUMBER 38 0   Actions Identifier DW_ACTION_D ACTION_ID
ACTION_REASON_ID NUMBER 38 0   Actions reason identifier DW_ACTION_REASON_D ACTION_REASON_ID
NEXT_SAL_REVIEW_DATE DATE       Next Salary Review Date    

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