Revision as of 03:08, March 29, 2017 by Jdruker (talk | contribs)
Jump to: navigation, search

Genesys Info Mart Views

Genesys Info Mart provides the following predefined views for reporting purposes:

ADMIN_AUDIT_LOG
ADMIN_AUDIT_LOG
ADMIN_AUDIT_LOG
ADMIN_ETL_JOB_HISTORY
ADMIN_ETL_JOB_HISTORY
ADMIN_ETL_JOB_HISTORY
ADMIN_ETL_JOB_STATUS
ADMIN_ETL_JOB_STATUS
ADMIN_ETL_JOB_STATUS
ADMIN_ETL_STEP_HISTORY
ADMIN_ETL_STEP_HISTORY
ADMIN_EXTRACT_HISTORY
ADMIN_EXTRACT_HISTORY
ADMIN_EXTRACT_HISTORY
CALLING_LIST Allows facts to be described based on attributes of an outbound campaign calling list.
CALLING_LIST Allows facts to be described based on attributes of an outbound campaign calling list.
CALLING_LIST Allows facts to be described based on attributes of an outbound campaign calling list.
CALLING_LIST Allows facts to be described based on attributes of an outbound campaign calling list.
CALLING_LIST_TO_CAMP_FACT Describes the association of a calling list to an outbound campaign.
CALLING_LIST_TO_CAMP_FACT Describes the association of a calling list to an outbound campaign.
CALLING_LIST_TO_CAMP_FACT Describes the association of a calling list to an outbound campaign.
CALLING_LIST_TO_CAMP_FACT Describes the association of a calling list to an outbound campaign.
CAMPAIGN Allows facts to be described based on attributes of an outbound campaign.
CAMPAIGN Allows facts to be described based on attributes of an outbound campaign.
CAMPAIGN Allows facts to be described based on attributes of an outbound campaign.
CAMPAIGN Allows facts to be described based on attributes of an outbound campaign.
CDR
CDR
CDR
CDR_DATE_TIME
CDR_DATE_TIME
CDR_DATE_TIME
CTL_ETL_HWM
GROUP_ Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups.
GROUP_ Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups.
GROUP_ Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups.
GROUP_ Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups.
GROUP_TO_CAMPAIGN_FACT Describes the association of an agent or place group to an outbound campaign.
GROUP_TO_CAMPAIGN_FACT Describes the association of an agent or place group to an outbound campaign.
GROUP_TO_CAMPAIGN_FACT Describes the association of an agent or place group to an outbound campaign.
GROUP_TO_CAMPAIGN_FACT Describes the association of an agent or place group to an outbound campaign.
PLACE Allows facts to be described by the attributes of a place.
PLACE Allows facts to be described by the attributes of a place.
PLACE Allows facts to be described by the attributes of a place.
PLACE Allows facts to be described by the attributes of a place.
PLACE_GROUP_FACT Describes the membership of places in place groups.
PLACE_GROUP_FACT Describes the membership of places in place groups.
PLACE_GROUP_FACT Describes the membership of places in place groups.
PLACE_GROUP_FACT Describes the membership of places in place groups.
RESOURCE_GROUP_FACT Describes the membership of resources in resource groups.
RESOURCE_GROUP_FACT Describes the membership of resources in resource groups.
RESOURCE_GROUP_FACT Describes the membership of resources in resource groups.
RESOURCE_GROUP_FACT Describes the membership of resources in resource groups.
RESOURCE_SKILL_FACT Describes an agent's skills and proficiency levels.
RESOURCE_SKILL_FACT Describes an agent's skills and proficiency levels.
RESOURCE_SKILL_FACT Describes an agent's skills and proficiency levels.
RESOURCE_SKILL_FACT Describes an agent's skills and proficiency levels.
SKILL Allows facts to be described by the attributes of a skill.
SKILL Allows facts to be described by the attributes of a skill.
SKILL Allows facts to be described by the attributes of a skill.
SKILL Allows facts to be described by the attributes of a skill.
TENANT Allows facts to be described based on attributes of a tenant. The TENANT dimension is used in a multi-tenant deployment to filter facts and dimensions into tenant-specific views--allowing each tenant to see only their own data.
TENANT Allows facts to be described based on attributes of a tenant. The TENANT dimension is used in a multi-tenant deployment to filter facts and dimensions into tenant-specific views--allowing each tenant to see only their own data.
TENANT Allows facts to be described based on attributes of a tenant. The TENANT dimension is used in a multi-tenant deployment to filter facts and dimensions into tenant-specific views--allowing each tenant to see only their own data.
TENANT Allows facts to be described based on attributes of a tenant. The TENANT dimension is used in a multi-tenant deployment to filter facts and dimensions into tenant-specific views--allowing each tenant to see only their own data.
CALLING_LIST Allows facts to be described based on attributes of an outbound campaign calling list.
CAMPAIGN Allows facts to be described based on attributes of an outbound campaign.
CTL_ETL_HWM
GROUP_ Allows facts to be described based on the membership of resources in resource groups or membership of places in place groups.
GROUP_TO_CAMPAIGN_FACT Describes the association of an agent or place group to an outbound campaign.
PLACE Allows facts to be described by the attributes of a place.
SKILL Allows facts to be described by the attributes of a skill.
TENANT Allows facts to be described based on attributes of a tenant. The TENANT dimension is used in a multi-tenant deployment to filter facts and dimensions into tenant-specific views--allowing each tenant to see only their own data.
AG2_AGENT_GRP_HOUR Agent group rollup of interaction handling based on key business attributes, such as customer segment, service type, and service subtype.
AG2_AGENT_GRP_HOUR Agent group rollup of interaction handling based on key business attributes, such as customer segment, service type, and service subtype.
AG2_AGENT_HOUR
AG2_AGENT_HOUR
AG2_AGENT_QUEUE_HOUR
AG2_AGENT_QUEUE_HOUR
AG2_ID_FCR_HOUR Rollup of resource interaction-handling activities for interactions that are assigned a specific business attribute, such as customer segment, business result, service type, and service subtype.
AG2_ID_HOUR
AG2_ID_HOUR
AG2_QUEUE_ABN_HOUR
AG2_QUEUE_ABN_HOUR
AG2_QUEUE_ACC_AGENT_HOUR
AG2_QUEUE_ACC_AGENT_HOUR
AG2_QUEUE_HOUR
AG2_QUEUE_HOUR

In addition to the predefined views described in this document, tenant-specific views can be added to the Genesys Info Mart database schema. For more information, see Genesys Info Mart Tenant Views.

Comments or questions about this documentation? Contact us for support!