# 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

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