DW_PRFL_TYPES_D

It stores information about profile type.

Details

Module: Profile Management

Key Columns

BUSINESS_GROUP_ID, PROFILE_TYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROFILE_TYPE_ID NUMBER 38 0 True Profile Type identifier    
BUSINESS_GROUP_ID NUMBER 38 0 True Business Group Identifier    
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier with PROFILE_TYPE_ID, BUSINESS_GROUP_ID    
DATE_FROM DATE       Date From    
DATE_TO DATE       Date To    
PROFILE_TYPE_CODE VARCHAR2 32     This is the Profile Type Code.    
PROFILE_STATUS_CODE VARCHAR2 32     This is the Profile Status Code.    
PROFILE_USAGE_CODE VARCHAR2 32     This is the Profile Usage Code.    

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