Store the data to be used for Qualifier framework
Module: Profile Management
QUALIFIER_ID , BUSINESS_GROUP_ID
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 |
Copyright © 2019, 2022, Oracle and/or its affiliates.