# DW_PRFL_PROFILE_D

This table contains information about the person and model profiles.

## Details

Module: Profile Management

## Key Columns

PROFILE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PROFILE_ID | NUMBER | 38 | 0 | True | Primary key of Profile |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier with profile id |  |
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business group for Enterprise |  |
PROFILE_TYPE_ID | NUMBER | 38 | 0 |  | This is the target profile type for the profile. | DW_PRFL_TYPES_D | PROFILE_TYPE_ID
PROFILE_CODE | VARCHAR2 | 32 |  |  | This is the code that identifies the profile. |  |
PROFILE_STATUS_CODE | VARCHAR2 | 32 |  |  | This is the status code that identifies if the profile is active or inactive |  |
PROFILE_USAGE_CODE | VARCHAR2 | 32 |  |  | This is the usage code that identifies if it is used for Person profile or Model profile. |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier | DW_PERSON_D | PERSON_ID
PARTY_ID | NUMBER | 38 | 0 |  | Party Identifier | DW_PARTY_D | PARTY_ID
OWNER_PERSON_ID | NUMBER | 38 | 0 |  | Owner Person Identifier | DW_PERSON_D | PERSON_ID
REVIEW_REQD_FLAG | VARCHAR2 | 32 |  |  | Job Profile needs review Yes,No Flag |  |

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