RPRT Table of Contents Page

GIMRef title: Genesys Info Mart Historical Database Reference

• AboutThisPDM title: About This Database Reference
  
• AboutDataExport title: About Data Export Capability
  
• GIMOverview title: Genesys Info Mart Database
  
  • InfoMartDBSchema title: Genesys Info Mart Database Schema
    
  • TenantViews title: Genesys Info Mart Tenant User Schema and Tenant Views
    
• GIM850NewPDM title: New in the Info Mart Database
  
• InfoMartSchemaChanges title: Summary of Info Mart Schema Changes
  

• SubjectAreas title: Subject Areas
  
  • SubjArea-Facts title: Facts Subject Area
    
  • SubjArea-Calling_List_Metric title: Calling_List_Metric Subject Area
    
  • SubjArea-Calling_List_To_Campaign title: Calling_List_To_Campaign Subject Area
    
  • SubjArea-Campaign_Group_Session title: Campaign_Group_Session Subject Area
    
  • SubjArea-Campaign_Group_State title: Campaign_Group_State Subject Area
    
  • SubjArea-Campaign_Group_To_Campaign title: Campaign_Group_To_Campaign Subject Area
    
  • SubjArea-Contact_Attempt title: Contact_Attempt Subject Area
    
  • SubjArea-Interaction title: Interaction Subject Area
    
  • SubjArea-Interaction_Resource title: Interaction_Resource Subject Area
    
  • SubjArea-Interaction_Resource_State title: Interaction_Resource_State Subject Area
    
  • SubjArea-Mediation_Segment title: Mediation_Segment Subject Area
    
  • SubjArea-Place_Group title: Place_Group Subject Area
    
  • SubjArea-Resource_Group title: Resource_Group Subject Area
    
  • SubjArea-Resource_Skill title: Resource_Skill Subject Area
    
  • SubjArea-Summary_Resource_Session title: Summary_Resource_Session Subject Area
    
  • SubjArea-Summary_Resource_State title: Summary_Resource_State Subject Area
    
  • SubjArea-Summary_Resource_State_Reason title: Summary_Resource_State_Reason Subject Area
    

• InfoMartTables title: Info Mart Tables
  
  • Table-ANCHOR_FLAGS title: Table ANCHOR_FLAGS
    
  • Table-ATTEMPT_DISPOSITION title: Table ATTEMPT_DISPOSITION
    
  • Table-BGS_BOT_DIM title: Table BGS_BOT_DIM
    
  • Table-BGS_BOT_NAME_DIM title: Table BGS_BOT_NAME_DIM
    
  • Table-BGS_SESSION_DIM title: Table BGS_SESSION_DIM
    
  • Table-BGS_SESSION_FACT title: Table BGS_SESSION_FACT
    
  • Table-CALL_RESULT title: Table CALL_RESULT
    
  • Table-CALL_TYPE title: Table CALL_TYPE
    
  • Table-CALLBACK_DIAL_RESULTS title: Table CALLBACK_DIAL_RESULTS
    
  • Table-CALLBACK_DIM_1 title: Table CALLBACK_DIM_1
    
  • Table-CALLBACK_DIM_2 title: Table CALLBACK_DIM_2
    
  • Table-CALLBACK_DIM_3 title: Table CALLBACK_DIM_3
    
  • Table-CALLBACK_DIM_4 title: Table CALLBACK_DIM_4
    
  • Table-CALLBACK_FACT title: Table CALLBACK_FACT
    
  • Table-CALLING_LIST_METRIC_FACT title: Table CALLING_LIST_METRIC_FACT
    
  • Table-CAMPAIGN_GROUP_SESSION_FACT title: Table CAMPAIGN_GROUP_SESSION_FACT
    
  • Table-CAMPAIGN_GROUP_STATE title: Table CAMPAIGN_GROUP_STATE
    
  • Table-CAMPAIGN_GROUP_STATE_FACT title: Table CAMPAIGN_GROUP_STATE_FACT
    
  • Table-CDR_DIM1 title: Table CDR_DIM1
    
  • Table-CDR_FACT title: Table CDR_FACT
    
  • Table-CHAT_SESSION_DIM title: Table CHAT_SESSION_DIM
    
  • Table-CHAT_SESSION_FACT title: Table CHAT_SESSION_FACT
    
  • Table-COBROWSE_END_REASON title: Table COBROWSE_END_REASON
    
  • Table-COBROWSE_FACT title: Table COBROWSE_FACT
    
  • Table-COBROWSE_MODE title: Table COBROWSE_MODE
    
  • Table-COBROWSE_PAGE title: Table COBROWSE_PAGE
    
  • Table-COBROWSE_USER_AGENT title: Table COBROWSE_USER_AGENT
    
  • Table-CONTACT_ATTEMPT_FACT title: Table CONTACT_ATTEMPT_FACT
    
  • Table-CONTACT_INFO_TYPE title: Table CONTACT_INFO_TYPE
    
  • Table-DATE_TIME title: Table DATE_TIME
    
  • Table-DIALING_MODE title: Table DIALING_MODE
    
  • Table-GPM_FACT title: Table GPM_FACT
    
  • Table-GPM_MODEL title: Table GPM_MODEL
    
  • Table-GPM_PREDICTOR title: Table GPM_PREDICTOR
    
  • Table-GPM_RESULT title: Table GPM_RESULT
    
  • Table-GROUP_ANNEX title: Table GROUP_ANNEX
    
  • Table-INTERACTION_DESCRIPTOR title: Table INTERACTION_DESCRIPTOR
    
  • Table-INTERACTION_FACT title: Table INTERACTION_FACT
    
  • Table-INTERACTION_RESOURCE_FACT title: Table INTERACTION_RESOURCE_FACT
    
  • Table-INTERACTION_RESOURCE_STATE title: Table INTERACTION_RESOURCE_STATE
    
  • Table-INTERACTION_TYPE title: Table INTERACTION_TYPE
    
  • Table-IRF_USER_DATA_CUST_1 title: Table IRF_USER_DATA_CUST_1
    
  • Table-IRF_USER_DATA_GEN_1 title: Table IRF_USER_DATA_GEN_1
    
  • Table-IRF_USER_DATA_KEYS title: Table IRF_USER_DATA_KEYS
    
  • Table-IXN_RESOURCE_STATE_FACT title: Table IXN_RESOURCE_STATE_FACT
    
  • Table-LDR_CAMPAIGN title: Table LDR_CAMPAIGN
    
  • Table-LDR_DEVICE title: Table LDR_DEVICE
    
  • Table-LDR_FACT title: Table LDR_FACT
    
  • Table-LDR_GROUP title: Table LDR_GROUP
    
  • Table-LDR_LIST title: Table LDR_LIST
    
  • Table-LDR_POSTAL_CODE title: Table LDR_POSTAL_CODE
    
  • Table-LDR_RECORD title: Table LDR_RECORD
    
  • Table-MEDIA_TYPE title: Table MEDIA_TYPE
    
  • Table-MEDIATION_SEGMENT_FACT title: Table MEDIATION_SEGMENT_FACT
    
  • Table-POST_CALL_SURVEY_DIM_1 title: Table POST_CALL_SURVEY_DIM_1
    
  • Table-POST_CALL_SURVEY_DIM_2 title: Table POST_CALL_SURVEY_DIM_2
    
  • Table-POST_CALL_SURVEY_DIM_3 title: Table POST_CALL_SURVEY_DIM_3
    
  • Table-POST_CALL_SURVEY_DIM_4 title: Table POST_CALL_SURVEY_DIM_4
    
  • Table-POST_CALL_SURVEY_DIM_5 title: Table POST_CALL_SURVEY_DIM_5
    
  • Table-POST_CALL_SURVEY_DIM_6 title: Table POST_CALL_SURVEY_DIM_6
    
  • Table-RECORD_FIELD_GROUP_1 title: Table RECORD_FIELD_GROUP_1
    
  • Table-RECORD_FIELD_GROUP_2 title: Table RECORD_FIELD_GROUP_2
    
  • Table-RECORD_STATUS title: Table RECORD_STATUS
    
  • Table-RECORD_TYPE title: Table RECORD_TYPE
    
  • Table-REQUESTED_SKILL title: Table REQUESTED_SKILL
    
  • Table-REQUESTED_SKILL_COMBINATION title: Table REQUESTED_SKILL_COMBINATION
    
  • Table-RESOURCE title: Table RESOURCE_
    
  • Table-RESOURCE_ANNEX title: Table RESOURCE_ANNEX
    
  • Table-RESOURCE_GROUP_COMBINATION title: Table RESOURCE_GROUP_COMBINATION
    
  • Table-RESOURCE_STATE title: Table RESOURCE_STATE
    
  • Table-RESOURCE_STATE_REASON title: Table RESOURCE_STATE_REASON
    
  • Table-ROUTING_TARGET title: Table ROUTING_TARGET
    
  • Table-SDR_ACTIVITIES_FACT title: Table SDR_ACTIVITIES_FACT
    
  • Table-SDR_ACTIVITY title: Table SDR_ACTIVITY
    
  • Table-SDR_APPLICATION title: Table SDR_APPLICATION
    
  • Table-SDR_CALL_DISPOSITION title: Table SDR_CALL_DISPOSITION
    
  • Table-SDR_CALL_TYPE title: Table SDR_CALL_TYPE
    
  • Table-SDR_CUST_ATRIBUTES_FACT title: Table SDR_CUST_ATRIBUTES_FACT
    
  • Table-SDR_CUST_ATRIBUTES title: Table SDR_CUST_ATRIBUTES
    
  • Table-SDR_ENTRY_POINT title: Table SDR_ENTRY_POINT
    
  • Table-SDR_EXIT_POINT title: Table SDR_EXIT_POINT
    
  • Table-SDR_EXT_HTTP_REST title: Table SDR_EXT_HTTP_REST
    
  • Table-SDR_EXT_REQUEST title: Table SDR_EXT_REQUEST
    
  • Table-SDR_EXT_REQUEST_FACT title: Table SDR_EXT_REQUEST_FACT
    
  • Table-SDR_EXT_REQUEST_OUTCOME title: Table SDR_EXT_REQUEST_OUTCOME
    
  • Table-SDR_EXT_SERVICE_OUTCOME title: Table SDR_EXT_SERVICE_OUTCOME
    
  • Table-SDR_GEO_LOCATION title: Table SDR_GEO_LOCATION
    
  • Table-SDR_INPUT title: Table SDR_INPUT
    
  • Table-SDR_INPUT_OUTCOME title: Table SDR_INPUT_OUTCOME
    
  • Table-SDR_LANGUAGE title: Table SDR_LANGUAGE
    
  • Table-SDR_MESSAGE title: Table SDR_MESSAGE
    
  • Table-SDR_MILESTONE title: Table SDR_MILESTONE
    
  • Table-SDR_SESSION_FACT title: Table SDR_SESSION_FACT
    
  • Table-SDR_SURVEY_ANSWERS title: Table SDR_SURVEY_ANSWERS
    
  • Table-SDR_SURVEY_FACT title: Table SDR_SURVEY_FACT
    
  • Table-SDR_SURVEY_I1 title: Table SDR_SURVEY_I1
    
  • Table-SDR_SURVEY_I2 title: Table SDR_SURVEY_I2
    
  • Table-SDR_SURVEY_QUESTIONS title: Table SDR_SURVEY_QUESTIONS
    
  • Table-SDR_SURVEY_QUESTIONS_I1 title: Table SDR_SURVEY_QUESTIONS_I1
    
  • Table-SDR_SURVEY_QUESTIONS_I2 title: Table SDR_SURVEY_QUESTIONS_I2
    
  • Table-SDR_SURVEY_QUESTIONS_S1 title: Table SDR_SURVEY_QUESTIONS_S1
    
  • Table-SDR_SURVEY_QUESTIONS_S2 title: Table SDR_SURVEY_QUESTIONS_S2
    
  • Table-SDR_SURVEY_S1 title: Table SDR_SURVEY_S1
    
  • Table-SDR_SURVEY_S2 title: Table SDR_SURVEY_S2
    
  • Table-SDR_SURVEY_STATUS title: Table SDR_SURVEY_STATUS
    
  • Table-SDR_SURVEY_SCORES title: Table SDR_SURVEY_SCORES
    
  • Table-SDR_SURVEY_TRANSCRIPT_FACT title: Table SDR_SURVEY_TRANSCRIPT_FACT
    
  • Table-SDR_USER_INPUT title: Table SDR_USER_INPUT
    
  • Table-SDR_USER_INPUTS_FACT title: Table SDR_USER_INPUTS_FACT
    
  • Table-SDR_USER_MILESTONE_FACT title: Table SDR_USER_MILESTONE_FACT
    
  • Table-SM_MEDIA_NEUTRAL_STATE_FACT title: Table SM_MEDIA_NEUTRAL_STATE_FACT
    
  • Table-SM_RES_SESSION_FACT title: Table SM_RES_SESSION_FACT
    
  • Table-SM_RES_STATE_FACT title: Table SM_RES_STATE_FACT
    
  • Table-SM_RES_STATE_REASON_FACT title: Table SM_RES_STATE_REASON_FACT
    
  • Table-STRATEGY title: Table STRATEGY
    
  • Table-TECHNICAL_DESCRIPTOR title: Table TECHNICAL_DESCRIPTOR
    
  • Table-TIME_ZONE title: Table TIME_ZONE
    
  • Table-USER_DATA_CUST_DIM_1 title: Table USER_DATA_CUST_DIM_1
    
  • Table-WORKBIN title: Table WORKBIN
    

• InfoMartViews title: Genesys Info Mart Views
  
  • View-CALLING_LIST title: View CALLING_LIST
    
  • View-CALLING_LIST_TO_CAMP_FACT title: View CALLING_LIST_TO_CAMP_FACT
    
  • View-CAMPAIGN title: View CAMPAIGN
    
  • View-GROUP title: View GROUP_
    
  • View-GROUP_TO_CAMPAIGN_FACT title: View GROUP_TO_CAMPAIGN_FACT
    
  • View-PLACE title: View PLACE
    
  • View-PLACE_GROUP_FACT title: View PLACE_GROUP_FACT
    
  • View-RESOURCE_GROUP_FACT title: View RESOURCE_GROUP_FACT
    
  • View-RESOURCE_SKILL_FACT title: View RESOURCE_SKILL_FACT
    
  • View-SKILL title: View SKILL
    
  • View-TENANT title: View TENANT
    

• InfoMartReferences title: Reference List
  

• InfoMartIndexes title: Info Mart Indexes
  

• InfoMartPartitioning title: Info Mart Partitioning
  

• InfoMartAdminTablesViews title: Info Mart Service and Staging Tables and Administrative Views
  
  • Table-CTL_AUDIT_LOG title: Table CTL_AUDIT_LOG
    
  • Table-CTL_ETL_HISTORY title: Table CTL_ETL_HISTORY
    
  • Table-CTL_EXTRACT_HISTORY title: Table CTL_EXTRACT_HISTORY
    
  • Table-CTL_GDPR_HISTORY title: Table CTL_GDPR_HISTORY
    
  • Table-CTL_PURGE_HISTORY title: Table CTL_PURGE_HISTORY
    
  • Table-CTL_TRANSFORM_HISTORY title: Table CTL_TRANSFORM_HISTORY
    
  • Table-CTL_UD_TO_UDE_MAPPING title: Table CTL_UD_TO_UDE_MAPPING
    
  • Table-CTL_UDE_KEYS_TO_DIM_MAPPING title: Table-CTL_UDE_KEYS_TO_DIM_MAPPING
    
  • View-ADMIN_AUDIT_LOG title: View ADMIN_AUDIT_LOG
    
  • View-ADMIN_ETL_JOB_HISTORY title: View-ADMIN_ETL_JOB_HISTORY
    
  • View-ADMIN_ETL_JOB_STATUS title: View ADMIN_ETL_JOB_STATUS
    
  • View-ADMIN_ETL_STEP_HISTORY title: View ADMIN_ETL_STEP_HISTORY
    
  • View-ADMIN_EXTRACT_HISTORY title: View-ADMIN_EXTRACT_HISTORY
    
  • View-CTL_ETL_HWM title: View CTL_ETL_HWM
    
  • Table-STG_IDB_FK_VIOLATION title: Table STG_IDB_FK_VIOLATION
    
  • Table-STG_TRANSFORM_DISCARDS title: Table STG_TRANSFORM_DISCARDS
    

• InfoMartGIDBTables title: Info Mart GIDB Tables
  
  • Table-GIDB_GCX_LOGIN_INFO title: Table GIDB_GCX_LOGIN_INFO
    
  • Table-GIDB_GC_CALLING_LIST title: Table GIDB_GC_CALLING_LIST
    
  • Table-GIDB_GC_CAMPAIGN title: Table GIDB_GC_CAMPAIGN
    
  • Table-GIDB_GC_FOLDER title: Table GIDB_GC_FOLDER
    
  • Table-GIDB_GC_GROUP title: Table GIDB_GC_GROUP
    
  • Table-GIDB_GC_LOGIN title: Table GIDB_GC_LOGIN
    
  • Table-GIDB_GC_PLACE title: Table GIDB_GC_PLACE
    
  • Table-GIDB_GC_SKILL title: Table GIDB_GC_SKILL
    
  • Table-GIDB_GC_TENANT title: Table GIDB_GC_TENANT
    
  • GDict title: G_DICTIONARY Values
    

• GIMConcepts title: Explaining Genesys Info Mart Data
  
  • GIMPopData title: Populating Genesys Info Mart Data
    
    • GIMPopIRF title: Populating Interaction Resource Data
      
    • GIMPopIxn title: Populating Interaction Data
      
    • GIMPopMSF title: Populating Mediation Segments
      
    • GIMPopCAF title: Populating Outbound Contact Campaign Activity
      
    • GIMPopAgent title: Populating Agent Activity Data
      
  • GIMTechDescr title: Technical Descriptors
    
  • GIMTechDescComb title: Technical Descriptor Combinations
    
  • GIMDateTime title: Representing Dates and Times of Day
    
  • GIMVoxIxnFlow does not exist. Click to create GIMVoxIxnFlow in Julie
    
  • GIMMMIxnFlow does not exist. Click to create GIMMMIxnFlow in Julie