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 This column is for Oracle Internal use only. 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.
CREATION_DATE TIMESTAMP creation date