Salary holds details of salary proposals for Employee or Contingent worker assignments.
Module: Global Human Resources
SALARY_ID
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. |