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.