Maintenance Notice - PDF Generation
Dynamic PDF generation for web-based content is temporarily unavailable. This maintenance affects dynamic PDF files that are generated from either the HTML-based page or manual that you are viewing. Links that normally allow this functionality have been hidden, and will reappear as soon as the feature is restored.


Note: Access to static files, including PDF files that are not dynamically generated from our web-based content, is unaffected.

Jump to: navigation, search
 
Line 51: Line 51:
 
|internalMetricID=F_DAY, DAY
 
|internalMetricID=F_DAY, DAY
 
|dbTable=FORECAST_DATE_TIME.LABEL_YYYY_MM_DD, DATE_TIME.LABEL_YYYY_MM_DD
 
|dbTable=FORECAST_DATE_TIME.LABEL_YYYY_MM_DD, DATE_TIME.LABEL_YYYY_MM_DD
|usedIn=Abandon Delay Report, Agent Activity, Agent Group Business Attribute Report, Agent Group Interaction Handling Report, Agent Interaction Hierarchy Report,  Agent Interaction State, Agent Omnichannel Activity Report, Agent Outbound Campaign Report, Agent Performance Dashboard, Agent Queue Report, Agent Report, Agent Social Engagement Report, Agent Summarized State, Agent Summary Activity Email Report, Agent Summary Activity Report (Active), Agent Summary Activity Report (Interaction), Agent Task Dashboard, Agent Utilization, Agent Utilization Email Report, Agent Utilization Report, AHT, Application Duration Report, Application Summary Report, Async Chat Dashboard, Blocks Summary Report, Bot Dashboard, Bot Session Overall, Business Metrics Executive Report, Callback Summary Report, Campaign Callbacks Summary Report, Campaign Summary Report, Chat Agent Stats, Chat Engagement Report, Chat Interaction Stats, Chat Termination Report, Co-browse Summary Report, Contact Center Report, Contact List Effectiveness Report, Customer Perspective Report, Interaction Traffic Group Report, Interaction Traffic Report, Interaction Volume Business Attribute Email Report, Interaction Volume Business Attribute Report, Milestone Summary Report, Model Efficiency, Pre-Agent Termination Report, Predictive Routing AB Testing Report, Predictive Routing AB Testing Report (Hour), Predictive Routing Operational Report, Predictive Routing Queue Statistics Report, Queue Outline Report, Queue Report, Queue Summary Report, Session Handled by Bots, Speed of Accept (hours) Report, Speed of Accept (seconds Report, Survey Answer Report, Survey Statistics Report, Task Routing Agent Activity, Task Routing Agent Group Activity, Task Routing Agent Group Summary Activity, Task Volume Report  
+
|usedIn=Abandon Delay Report, Agent Activity, Agent Group Business Attribute Report, Agent Group Interaction Handling Report, Agent Interaction Hierarchy Report,  Agent Interaction State, Agent Omnichannel Activity Report, Agent Outbound Campaign Report, Agent Performance Dashboard, Agent Queue Report, Agent Report, Agent Social Engagement Report, Agent Summarized State, Agent Summary Activity Email Report, Agent Summary Activity Report (Active), Agent Summary Activity Report (Interaction), Agent Task Dashboard, Agent Utilization, Agent Utilization Email Report, Agent Utilization Report, AHT, Application Duration Report, Application Summary Report, Async Chat Dashboard, Blocks Summary Report, Bot Dashboard, Bot Session Overall, Business Metrics Executive Report, Callback Summary Report, Campaign Callbacks Summary Report, Campaign Summary Report, Chat Agent Stats, Chat Engagement Report, Chat Interaction Stats, Chat Termination Report, Co-browse Summary Report, Contact Center Report, Contact List Effectiveness Report, Customer Perspective Report, Interaction Traffic Group Report, Interaction Traffic Report, Interaction Volume Business Attribute Email Report, Interaction Volume Business Attribute Report, Milestone Summary Report, Model Efficiency, Pre-Agent Termination Report, Predictive Routing AB Testing Report, Predictive Routing AB Testing Report (Hour), Predictive Routing Operational Report, Predictive Routing Queue Statistics Report, Queue Outline Report, Queue Report, Queue Summary Report, Sessions Handled by Bots, Speed of Accept (hours) Report, Speed of Accept (seconds) Report, Survey Answer Report, Survey Statistics Report, Task Routing Agent Activity, Task Routing Agent Group Activity, Task Routing Agent Group Summary Activity, Task Volume Report  
 
|project =
 
|project =
 
|notproject =  
 
|notproject =  

Latest revision as of 21:48, November 8, 2019

Time Attributes

The following Attributes are in the Time root folder

attr = Date

anchor = TimeDate
folder = Time

shortDesc = Enables data within the reporting interval to be organized by a particular date. This attribute is used for internal computations.
longDesc = Enables data within the reporting interval to be organized by a particular date. This attribute is used for internal computations.
dbTable = DATE_TIME.CAL_DATE

usedIn =

introduced =

modified =
discontinued =
project =
notproject =

dataType = Date

InternalMetricID = CAL_DATE
form =
lov = none



attr = Date Range

anchor = TimeDateRange
folder = Time

shortDesc = Enables data to be organized by a date range within the reporting interval. This attribute is used for internal computations.
longDesc = Enables data to be organized by a date range within the reporting interval. This attribute is used for internal computations.
dbTable = RELATIVE_RANGE.RANGE_NAME

usedIn = Agent Activity, Agent Interaction State, Agent Omnichannel Activity Report, Agent Summarized State, Agent Summary Activity Email Report, Agent Summary Activity Report (Active), Agent Summary Activity Report (Interaction), Bot Sessions Overall, Chat Agent Stats, Chat Engagement Report, Chat Interaction Report, Chat Message Statistics Report, Chat Session Report, Chat Termination Report, Pre-Agent Termination Report, Sessions Handled by Bots, Task Routing Agent Activity, Task Routing Agent Group Activity, Task Routing Agent Group Summary Activity, Task Routing Agent Summary Activity

introduced =

modified =
discontinued =
project =
notproject =

dataType = Character

InternalMetricID = DATE_RANGE
form =
lov = daterange_lov



attr = Day

anchor = TimeDay
folder = Time

shortDesc = Enables data within the reporting interval to be organized by a particular day within a month and year. Day values are presented in YYYY-MM-DD format.
longDesc = Enables data within the reporting interval to be organized by a particular day within a month and year. Day values are presented in YYYY-MM-DD format.
dbTable = FORECAST_DATE_TIME.LABEL_YYYY_MM_DD, DATE_TIME.LABEL_YYYY_MM_DD

usedIn = Abandon Delay Report, Agent Activity, Agent Group Business Attribute Report, Agent Group Interaction Handling Report, Agent Interaction Hierarchy Report, Agent Interaction State, Agent Omnichannel Activity Report, Agent Outbound Campaign Report, Agent Performance Dashboard, Agent Queue Report, Agent Report, Agent Social Engagement Report, Agent Summarized State, Agent Summary Activity Email Report, Agent Summary Activity Report (Active), Agent Summary Activity Report (Interaction), Agent Task Dashboard, Agent Utilization, Agent Utilization Email Report, Agent Utilization Report, AHT, Application Duration Report, Application Summary Report, Async Chat Dashboard, Blocks Summary Report, Bot Dashboard, Bot Session Overall, Business Metrics Executive Report, Callback Summary Report, Campaign Callbacks Summary Report, Campaign Summary Report, Chat Agent Stats, Chat Engagement Report, Chat Interaction Stats, Chat Termination Report, Co-browse Summary Report, Contact Center Report, Contact List Effectiveness Report, Customer Perspective Report, Interaction Traffic Group Report, Interaction Traffic Report, Interaction Volume Business Attribute Email Report, Interaction Volume Business Attribute Report, Milestone Summary Report, Model Efficiency, Pre-Agent Termination Report, Predictive Routing AB Testing Report, Predictive Routing AB Testing Report (Hour), Predictive Routing Operational Report, Predictive Routing Queue Statistics Report, Queue Outline Report, Queue Report, Queue Summary Report, Sessions Handled by Bots, Speed of Accept (hours) Report, Speed of Accept (seconds) Report, Survey Answer Report, Survey Statistics Report, Task Routing Agent Activity, Task Routing Agent Group Activity, Task Routing Agent Group Summary Activity, Task Volume Report

introduced =

modified =
discontinued =
project =
notproject =

dataType = Character

InternalMetricID = F_DAY, DAY
form =
lov = none



attr = Hour

anchor = TimeHour
folder = Time

shortDesc = Enables data within the reporting interval to be organized by a particular hour within a day. Hour values are presented in YYYY-MM-DD-HH24 format.
longDesc = Enables data within the reporting interval to be organized by a particular hour within a day. Hour values are presented in YYYY-MM-DD-HH24 format.
dbTable = FORECAST_DATE_TIME.LABEL_YYYY_MM_DD_HH24, DATE_TIME.LABEL_YYYY_MM_DD_HH24

usedIn = Agent Conduct Report, Agent Interval Based Report, Agent Not Ready Reason Code Report, Agent Not Ready Report, Agent Wrap Report

introduced =

modified =
discontinued =
project =
notproject =

dataType = Character

InternalMetricID = F_HOUR, HOUR
form =
lov = hour_lov



attr = Month

anchor = TimeMonth
folder = Time

shortDesc = Enables data within the reporting interval to be organized by a particular month within a year. Month values are presented in YYYY-MM format.
longDesc = Enables data within the reporting interval to be organized by a particular month within a year. Month values are presented in YYYY-MM format.
dbTable = FORECAST_DATE_TIME.LABEL_YYYY_MM, DATE_TIME.LABEL_YYYY_MM

usedIn = Agent Group Queue Business Attribute Report

introduced =

modified =
discontinued =
project =
notproject =

dataType = Character

InternalMetricID = F_MONTH, MONTH
form =
lov = none



attr = Month Year Ago

anchor = TimeMonthYearAgo
folder = Time

shortDesc = This attribute is used in the Interaction Volume Summary Report to enable year-by-year comparisons of data that is aggregated by month. This attribute is specifically for the first year of the comparison. Month values are presented in YYYYMM format.
longDesc = This attribute is used in the Interaction Volume Summary Report to enable year-by-year comparisons of data that is aggregated by month. This attribute is specifically for the first year of the comparison. Month values are presented in YYYYMM format.
dbTable = DATE_TIME_YEAR_AGO.LABEL_YYYY_MM

usedIn =

introduced =

modified =
discontinued =
project =
notproject =

dataType = Character

InternalMetricID = MONTH_YEAR_AGO
form =
lov = none



attr = Month Year Next

anchor = TimeMonthYearNext
folder = Time

shortDesc = This attribute is used in the Interaction Volume Summary Report to enable year-by-year comparisons of data that is aggregated by month. This attribute is specifically for the second year of the comparison. Month values are presented in YYYY-MM format.
longDesc = This attribute is used in the Interaction Volume Summary Report to enable year-by-year comparisons of data that is aggregated by month. This attribute is specifically for the second year of the comparison. Month values are presented in YYYY-MM format.
dbTable = DATE_TIME_YEAR_NEXT.LABEL_YYYY_MM

usedIn =

introduced =

modified =
discontinued =
project =
notproject =

dataType = Character

InternalMetricID = MONTH_YEAR_NEXT
form =
lov = none



attr = Quarter

anchor = TimeQuarter
folder = Time

shortDesc = Enables data within the reporting interval to be organized by a particular quarter within a year. Quarter values are presented in YYYY-QQ format.
longDesc = Enables data within the reporting interval to be organized by a particular quarter within a year. Quarter values are presented in YYYY-QQ format.
dbTable = FORECAST_DATE_TIME.LABEL_YYYY_QQ, DATE_TIME.LABEL_YYYY_QQ

usedIn =

introduced =

modified =
discontinued =
project =
notproject =

dataType = Character

InternalMetricID = F_QRTR, QRTR
form =
lov = none



attr = Start Date Time Key

anchor = TimeStartDateTimeKey
folder = Time

shortDesc = Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies.
longDesc = Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies.
dbTable = COBROWSE_FACT_GI2.START_DATE_TIME_KEY ???

usedIn = Agent Login-Logout Details Report, Agent State Details Report, Callback Details Report, Interaction Handling Attempt Report

introduced =

modified =
discontinued =
project =
notproject =

dataType = Number

InternalMetricID = _START_DATE_TIME_KEY ???
form =
lov = none



attr = Start Date Time Key IF

anchor = TimeStartDateTimeKeyIF
folder = Time

shortDesc = Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies. (INTERACTION_FACT)
longDesc = Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies. (INTERACTION_FACT)
dbTable = INTERACTION_FACT_GI2.START_DATE_TIME_KEY ???

usedIn = Interaction Handling Attempt Report

introduced =

modified =
discontinued =
project =
notproject =

dataType = Number

InternalMetricID = IF_START_DATE_TIME_KEY ???
form =
lov = none



attr = Start Date Time Key IRF

anchor = TimeStartDateTimeKeyIRF
folder = Time

shortDesc = Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies. (INTERACTION_RESOURCE_FACT)
longDesc = Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies. (INTERACTION_RESOURCE_FACT)
dbTable = INTERACTION_RESOURCE_FACT_GI2.START_DATE_TIME_KEY

usedIn = Interaction Handling Attempt Report

introduced =

modified =
discontinued =
project =
notproject =

dataType = Number

InternalMetricID = IRF_START_DATE_TIME_KEY
form =
lov = none



attr = Start Date Time Key SSF

anchor = TimeStartDateTimeKeySSF
folder = Time

shortDesc = Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies. (SDR_SESSION_FACT)
longDesc = Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies. (SDR_SESSION_FACT)
dbTable = SDR_SESSION_FACT.START_DATE_TIME_KEY

usedIn = Interaction Handling Attempt Report

introduced =

modified =
discontinued =
project =
notproject =

dataType = Number

InternalMetricID = *_SSF.START_DATE_TIME_KEY ???
form =
lov = none



attr = Start Date Time Key SSuF

anchor = TimeStartDateTimeKeySSuF
folder = Time

shortDesc = Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies. (SDR_SURVEY_FACT)
longDesc = Reserved for internal use to employ a key for a particular date and time from the relevant hierarchies. (SDR_SURVEY_FACT)
dbTable = SDR_SURVEY_FACT.START_DATE_TIME_KEY

usedIn = Interaction Handling Attempt Report

introduced =

modified =
discontinued =
project =
notproject =

dataType = Number

InternalMetricID = *_SSuF.START_DATE_TIME_KEY ???
form =
lov = none



attr = Subhour

anchor = TimeSubhour
folder = Time

shortDesc = Enables data within the reporting interval to be organized by 15- or 30-minute time periods. The periods start either at the beginning of an hour, 15, or 30 minutes into the hour.

This metric depends on the configuration of the materialize-subhour-in-db option in the agg-feature section, and uses either 15- or 30-minute intervals, depending on the configuration of the sub-hour-interval option in the [agg] section. The default value is 30 minutes.

longDesc = Enables data within the reporting interval to be organized by 15- or 30-minute time periods. The periods start either at the beginning of an hour, 15, or 30 minutes into the hour.
dbTable = FORECAST_DATE_TIME.LABEL_YYYY_MM_DD_HH24_30INT, DATE_TIME.LABEL_YYYY_MM_DD_HH24_30INT or FORECAST_DATE_TIME.LABEL_YYYY_MM_DD_HH24_15INT, DATE_TIME.LABEL_YYYY_MM_DD_HH24_15INT

usedIn =

introduced =

modified =
discontinued =
project =
notproject =

dataType = Character

InternalMetricID = F_SUBHR, SUBHR
form =
lov = none



attr = Week

anchor = TimeWeek
folder = Time

shortDesc = Enables data within the reporting interval to be organized by a particular week within a year. Week value are presented in YYYY-WE format.
longDesc = Enables data within the reporting interval to be organized by a particular week within a year. Week values are presented in YYYY-WE format.
dbTable = DATE_TIME.LABEL_YYYY_WE

usedIn = Contact Center Report, Contact Center Dashboard

introduced =

modified =
discontinued =
project =
notproject =

dataType = Character

InternalMetricID = F_WEEK, WEEK
form =
lov = none



attr = Year

anchor = TimeYear
folder = Time

shortDesc = Enables data within the reporting interval to be organized by year, in four-digit format (YYYY).
longDesc = Enables data within the reporting interval to be organized by year, in four-digit format (YYYY).
dbTable = FORECAST_DATE_TIME.LABEL_YYYY, DATE_TIME.LABEL_YYYY

usedIn =

introduced =

modified =
discontinued =
project =
notproject =

dataType = Character

InternalMetricID = F_YEAR, YEAR
form =
lov = none


This page was last edited on November 8, 2019, at 21:48.