DW_PRFL_RELATION_D

It stores information about profile relations to job or position.

Details

Module: Profile Management

Key Columns

PROFILE_RELATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROFILE_RELATION_ID NUMBER 38 0 True Profile relation identifier    
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier with PROFILE_TYPE_ID, BUSINESS_GROUP_ID    
BUSINESS_GROUP_ID NUMBER 38 0   Business group    
PROFILE_ID NUMBER 38 0   Profile Identifier    
JOB_OR_POS_ID NUMBER 38 0   Id for job or position. it will also have join with dw_position_d if positionprofile type to position_id. DW_JOB_D JOB_ID
OBJECT_EFF_START_DATE DATE       Effective start date    
OBJECT_EFF_END_DATE DATE       Effective end date