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.