DW_PERSON_PERFORMANCE_F

This table contains profile items that make up a Profile with Performance rating level.

Details

Module: Global Human Resources

Key Columns

PROFILE_ITEM_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROFILE_ITEM_ID NUMBER 38 0 True Primary Key sequence for Salary in Fusion Source.    
SOURCE_RECORD_ID VARCHAR2 64     Unique Source Record Identifier with profile item id This column contains SALARY_ID.    
PERSON_ID NUMBER 38 0   Persons ID DW_PERSON_D PERSON_ID
RATING_LEVEL_ID NUMBER 38 0   The rating value. The values depend on the rating model selected DW_RATING_LEVEL_D RATING_LEVEL_ID
DATE_FROM DATE       Date From    
DATE_TO DATE       Date To    
DW_DATE_FROM DATE       Warehouse Effective From Date for the Performance. 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 Performance. This is equal to EFFECTIVE_END_DATE    
DW_INITIAL_RECORD_IND NUMBER 38 0   This indicates whether the record is the first event for performance to be brought into the warehouse based on initial extract date set by user.