This table contains information about the person and model profiles.
Module: Profile Management
PROFILE_ID
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 | 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 |