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     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.