This table requires activation of Salary Basis functional area. Holds person salary and assoicated metrics
Module: Compensation
SALARY_ID
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.