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
SALARY_BASIS_ID NUMBER 38 0 Salary Basis Identifier DW_SALARY_BASIS_D SALARY_BASIS_ID
RANGE_DIFF_ID NUMBER 38 0 Salary Range differential Identifier DW_CMP_RANGE_DIFF_D RANGE_DIFF_ID
ZONE_TYPE_ID NUMBER 38 0 Compensation Zone Type Identifier DW_CMP_ZONE_TYPE_D_TL GEOGRAPHY_TYPE_ID
ZONE_ID NUMBER 38 0 Compensation Zone Identifier DW_CMP_ZONE_D_TL GEOGRAPHY_ID