Bookshelf v10.1.3.2: Configuring Flags for Oracle BI Applications Consumer

Many of the fact and dimension tables within the Oracle Contact Center Telephony Analytics application use flag fields to provide value-added information pertaining to a contact or contact representative. These flag fields are configurable and include the following:

The possible values for these flag fields in the data warehouse tables are Y or N. The following table shows Configurable Flag Values and Descriptions.

Table 52. Configurable Flag Values and Descriptions
Flag	Flag Value	Description
CONSULT_FLG	Y	Indicates that the contact representative consulted with other contact representative during the course of the call or contact.
	N	Indicates that the contact representative did not consult with other contact representative during the course of the call or contact.
CONFERENCE_ FLG	Y	Indicates that the contact representative conferenced with other contact representatives during the course of the call or contact.
	N	Indicates that the contact representative did not conference with other contact representative during the course of the call or contact.
PERTINENT_ INFO_FLG	Y	Indicates that the pertinent information was available for the contact.
	N	Indicates that the pertinent information was not available for the contact.
CNTCT_MTCH_ FLG	Y	Indicates that the contact was matched with the existing customer data using Customer Entered Digits (CED) such as PIN Numbers, Account Numbers, or Social Security Number.
	N	Indicates that the contact could not be matched with the existing customer data using Customer Entered Digits (CED) such as PIN Numbers, Account Numbers, or Social Security Number.
IVR_FLG	Y	Indicates that the call associated with the call was recorded in the Interactive Voice Response (IVR) system
	N	Indicates that the call associated with the call was not recorded in the Interactive Voice Response (IVR) system