DW_PRFL_QUALIFIERS_D

Store the data to be used for Qualifier framework

Details

Module: Profile Management

Key Columns

QUALIFIER_ID , BUSINESS_GROUP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
QUALIFIER_ID NUMBER 38 0 True Primary Key    
BUSINESS_GROUP_ID NUMBER 38 0 True Business Group Identifier    
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier with QUALIFIER_ID, BUSINESS_GROUP_ID    
QUALIFIER_SET_ID NUMBER 38 0   Qualifier Set Id    
QUALIFIER_CODE VARCHAR2 32     Qualifier Code    
QUALIFIER_SEQ_NUMBER NUMBER       Qualifier Sequence Number    
EMP_VIEW_FLAG VARCHAR2 32     Employee View Flag    
EMP_DEF_FLAG VARCHAR2 32     Employee Default Flag    
MGR_VIEW_FLAG VARCHAR2 32     Manager View Flag    
MGR_DEF_FLAG VARCHAR2 32     Manager Default Flag    
SEARCH_FLAG VARCHAR2 32     Search Flag