# DW_CMP_ASG_SALARY_F

Salary holds details of salary proposals for Employee or Contingent worker assignments.

## Details

Module: Global Human Resources

## 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 sequence for Salary in Fusion Source. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier This column contains SALARY_ID. |  |
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Person's Work term assignment ID |  |
SALARY_BASIS_ID | NUMBER | 38 | 0 |  | Salary Basis ID, it is the entity that establishes the period of time for which an employee's salary is quoted, typically either Monthly, Hourly or Annually. | DW_SALARY_BASIS_D | SALARY_BASIS_ID
EFFECTIVE_START_DATE | DATE |  |  |  | Salary Start Date. |  |
EFFECTIVE_END_DATE | DATE |  |  |  | Salary End Date. |  |
SALARY_APPROVED | VARCHAR2 | 32 |  |  | Yes or No flag if the Salary is approved or not |  |
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
SALARY_AMOUNT | NUMBER |  |  |  | Salary Amount entered based on the Salary Basis |  |
CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency of salary amount |  |
DW_DATE_FROM | DATE |  |  |  | Warehouse Effective From Date for the Salary Event. If Initial extract date is greater than EFFECTIVE_FROM_DATE then Initial extract date is used. |  |
DW_DATE_TO | DATE |  |  |  | Warehouse Effective To Date for the Salary Event. This is equal to EFFECTIVE_END_DATE |  |
DW_INITIAL_RECORD_IND | NUMBER | 38 | 0 |  | This indicates whether the record is the first event for the salary to be brought into the warehouse based on initial extract date set by user. |  |

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