DW_PRFL_QUALIFIERS_D

Store the data to be used for Qualifier framework

Details

Module: Profile Management

Key Columns

BUSINESS_GROUP_ID , QUALIFIER_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 This column is for Oracle Internal use only. 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