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