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

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