It stores information about profile relations to job or position.
Module: Profile Management
PROFILE_RELATION_ID
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 |