# 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 |  |  | This column is for Oracle Internal use only. 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
RELATION_ID | NUMBER | 38 | 0 |  | Relation identifier |  |
OBJECT_EFF_START_DATE | DATE |  |  |  | Effective start date |  |
OBJECT_EFF_END_DATE | DATE |  |  |  | Effective end date |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.