| Line 3: | Line 3: | ||
The following tables summarize Genesys Info Mart schema changes between 8.5 releases. | The following tables summarize Genesys Info Mart schema changes between 8.5 releases. | ||
| − | + | * Table introduced = 63 | |
| + | * Column introduced = 70 | ||
| + | * Column modified__full = 25 | ||
| + | * Column modified -- itemized = 29 | ||
| + | Ideally, total number of entries should be 63+70+29 = 162 | ||
| − | {{# | + | ===Column modified -- itemized=== |
| − | + | {{#cargo_query: | |
| − | {{#switch:{{PONYDOCSSTATUS}}|unreleased="Documentation: | + | tables=PDMColumn,PDMColumn__modified |
| − | + | |join on=PDMColumn._ID=PDMColumn__modified._rowID | |
| − | + | |fields=PDMColumn._pageName=Table,PDMColumn.colName=Column,PDMColumn__modified._value=Column modified | |
| − | + | |where=(PDMColumn._pageName LIKE {{#switch:{{PONYDOCSSTATUS}}|unreleased="Documentation:GIM:Library:%%:8.5DRAFT"|preview|released|#default="Documentation:GIM:Library:%%:8.5PDMSource"}}) AND (PDMColumn.modified__full IS NOT NULL) | |
| − | + | |format=dynamic table | |
| − | | | + | |rows per page=100 |
| − | |||
| − | | | ||
}} | }} | ||
| + | ===Column modified__full=== | ||
{{#cargo_query: | {{#cargo_query: | ||
| − | tables= | + | tables=PDMColumn |
| − | |fields= | + | |fields=PDMColumn._pageName=Table,PDMColumn.colName=Column,PDMColumn.modified__full=Column modified |
| − | |where= | + | |where=(PDMColumn._pageName LIKE {{#switch:{{PONYDOCSSTATUS}}|unreleased="Documentation:GIM:Library:%%:8.5DRAFT"|preview|released|#default="Documentation:GIM:Library:%%:8.5PDMSource"}}) AND (PDMColumn.modified__full IS NOT NULL) |
|format=dynamic table | |format=dynamic table | ||
| − | |rows per page = | + | |rows per page=100 |
}} | }} | ||
Revision as of 18:42, July 4, 2018
Summary of Info Mart Schema Changes
The following tables summarize Genesys Info Mart schema changes between 8.5 releases.
- Table introduced = 63
- Column introduced = 70
- Column modified__full = 25
- Column modified -- itemized = 29
Ideally, total number of entries should be 63+70+29 = 162
Column modified -- itemized
| Table | Column | Column modified |
|---|---|---|
| Table | Column | Column modified |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | CALLBACK_OFFER_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | CALLBACK_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | CHANNEL | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | CONNECT_ORDER | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | CALL_DIRECTION | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | DIAL_DIALOG_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | FINAL_DIAL_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | OFFER_TIMING | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource | FINAL_TARGET | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | DS_AUDIT_KEY | 8.5.008 (data type increased from 10 to 19 digits) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | FIRST_OUT_IXN_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | LAST_CALLBACK_OFFERED_TS | 8.5.008 (default value added) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | LAST_OUT_IXN_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | ORIGINATION_IXN_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | ORS_SESSION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-COBROWSE FACT:8.5PDMSource | PAGE_QUERY | 8.5.012.15 (No longer a mandatory field) |
| Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource | PROPAGATION_RULE | 8.5.001 (IRF_INITIAL value is added). |
| Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource | PROPAGATION_RULE | 8.5.006 (IRF_ROUTE value is added) |
| Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource | MEDIA_SERVER_IXN_GUID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource | MESSAGE | 8.5.009.20 (default value no longer defined) |
| Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource | START_DATE_TIME_KEY | 8.5.011 (added to the composite primary key in nonpartitioned databases) |
| Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource | MODEL | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource | MODEL_ID | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource | PREDICTOR | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource | PREDICTOR_ID | 8.5.010 (in Microsoft SQL Server,data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | CUSTOMER_FOUND | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | GPM_MODE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | GPM_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | GPM_STATUS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | GPM_USE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource | BUSINESS_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource | CUSTOMER_SEGMENT | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource | SERVICE_SUBTYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource | SERVICE_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource | STATUS | 8.5.001 (error code 26 added) |
| Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource | SUBJECT | 8.5.007 (data type extended from 255 to 1024 characters) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | ANCHOR_FLAGS_KEY | 8.5.004 (scope extended) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | CONS_INIT_TALK_COUNT | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | CONS_RCV_RING_COUNT | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | CONS_RCV_RING_DURATION | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | CONS_RCV_TALK_COUNT | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | CONS_RCV_TALK_DURATION | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | LAST_INTERACTION_RESOURCE | 8.5.003 and 8.5.004 (behavior changed) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | QUEUE_DURATION | 8.1.2, 8.1.3, 8.1.4 (behavior changed) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | ROUTING_POINT_DURATION | 8.1.2, 8.1.3, 8.1.4 (behavior changed) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource | INTERACTION_SUBTYPE | 8.5.001 (InternalConferenceInvite subtype added) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource | INTERACTION_SUBTYPE | 8.5.005 (OutboundCallback subtype added) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource | INTERACTION_SUBTYPE_CODE | 8.5.001 (INTERNALCONFERENCEINVITE subtype added) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource | INTERACTION_SUBTYPE_CODE | 8.5.005 (OUTBOUNDCALLBACK subtype added) |
| Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource | CUSTOM_DATA_1 through CUSTOM_DATA_16 | 8.5.005.09 (data types for the CUSTOM_DATA_13 through CUSTOM_DATA_16 columns in the make_gim_UDE_template.sql script, which used to provide examples of date/time and numeric data types and default values, were changed to character data types). |
| Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource | CUSTOM_DATA_1 through CUSTOM_DATA_16 | 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters, as defined now in the user-data template script, make_gim_UDE_template*.sql) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | SURVEY_IAGENTSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | SURVEY_ICALLSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | SURVEY_ICOMPANYSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | SURVEY_IPRODUCTSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | SURVEY_IQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | SURVEY_IQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | SURVEY_IQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | SURVEY_IQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | SURVEY_SQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | SURVEY_SQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | SURVEY_SQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | SURVEY_SQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | SURVEY_SQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | SURVEY_SQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | SURVEY_SQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | SURVEY_IQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | SURVEY_IQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | SURVEY_SQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | SURVEY_SQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | SURVEY_SQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource | SURVEY_IQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource | SURVEY_IQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource | SURVEY_IQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource | SURVEY_IQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource | SURVEY_COMPLETE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource | SURVEY_IRECOMMENDSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource | SURVEY_RECORDING | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-RESOURCE:8.5PDMSource | RESOURCE_SUBTYPE | 8.5.003.17 (new value, Person, added for the Agent resource type) |
| Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5PDMSource | SESSION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR ACTIVITY:8.5PDMSource | NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource | APPLICATION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource | APPLICATION_TITLE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource | APPLICATION_VERSION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource | DISPOSITION_CATEGORY | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource | DISPOSITION_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource | FINAL_DISPOSITION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource | CALL_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource | MEDIA_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CUST ATRIBUTES:8.5PDMSource | ATRIBUTE_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR ENTRY POINT:8.5PDMSource | DNIS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXIT POINT:8.5PDMSource | APPLICATION_EXIT_POINT | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5PDMSource | URL | 8.5.008.29 (behavior changed) |
| Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5PDMSource | URL | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5PDMSource | SUCCESS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource | METHOD | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource | REQUEST_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource | REQUEST_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource | SERVICE_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource | SERVICE_RESPONSE_DESC | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
Column modified__full
| Table | Column | Column modified |
|---|---|---|
| Table | Column | Column modified |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | CALLBACK_OFFER_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | CALLBACK_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | CHANNEL | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | CONNECT_ORDER | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | CALL_DIRECTION | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | DIAL_DIALOG_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | FINAL_DIAL_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | OFFER_TIMING | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource | FINAL_TARGET | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | DS_AUDIT_KEY | 8.5.008 (data type increased from 10 to 19 digits) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | FIRST_OUT_IXN_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | LAST_CALLBACK_OFFERED_TS | 8.5.008 (default value added) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | LAST_OUT_IXN_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | ORIGINATION_IXN_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | ORS_SESSION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-COBROWSE FACT:8.5PDMSource | PAGE_QUERY | 8.5.012.15 (No longer a mandatory field) |
| Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource | PROPAGATION_RULE | 8.5.006 (IRF_ROUTE value is added) • 8.5.001 (IRF_INITIAL value is added). |
| Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource | MEDIA_SERVER_IXN_GUID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource | MESSAGE | 8.5.009.20 (default value no longer defined) |
| Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource | START_DATE_TIME_KEY | 8.5.011 (added to the composite primary key in nonpartitioned databases) |
| Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource | MODEL | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource | MODEL_ID | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource | PREDICTOR | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource | PREDICTOR_ID | 8.5.010 (in Microsoft SQL Server,data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | CUSTOMER_FOUND | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | GPM_MODE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | GPM_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | GPM_STATUS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | GPM_USE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource | BUSINESS_RESULT | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource | CUSTOMER_SEGMENT | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource | SERVICE_SUBTYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource | SERVICE_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource | STATUS | 8.5.001 (error code 26 added) |
| Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource | SUBJECT | 8.5.007 (data type extended from 255 to 1024 characters) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | ANCHOR_FLAGS_KEY | 8.5.004 (scope extended) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | CONS_INIT_TALK_COUNT | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | CONS_RCV_RING_COUNT | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | CONS_RCV_RING_DURATION | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | CONS_RCV_TALK_COUNT | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | CONS_RCV_TALK_DURATION | 8.5.001 (scope expanded to include chat consultations) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | LAST_INTERACTION_RESOURCE | 8.5.003 and 8.5.004 (behavior changed) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | QUEUE_DURATION | 8.1.2, 8.1.3, 8.1.4 (behavior changed) |
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | ROUTING_POINT_DURATION | 8.1.2, 8.1.3, 8.1.4 (behavior changed) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource | INTERACTION_SUBTYPE | 8.5.005 (OutboundCallback subtype added) • 8.5.001 (InternalConferenceInvite subtype added) |
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource | INTERACTION_SUBTYPE_CODE | 8.5.005 (OUTBOUNDCALLBACK subtype added) • 8.5.001 (INTERNALCONFERENCEINVITE subtype added) |
| Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource | CUSTOM_DATA_1 through CUSTOM_DATA_16 | 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters, as defined now in the user-data template script, make_gim_UDE_template*.sql) • 8.5.005.09 (data types for the CUSTOM_DATA_13 through CUSTOM_DATA_16 columns in the make_gim_UDE_template.sql script, which used to provide examples of date/time and numeric data types and default values, were changed to character data types). |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | SURVEY_IAGENTSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | SURVEY_ICALLSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | SURVEY_ICOMPANYSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | SURVEY_IPRODUCTSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | SURVEY_IQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | SURVEY_IQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | SURVEY_IQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | SURVEY_IQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | SURVEY_SQ1 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | SURVEY_SQ2 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | SURVEY_SQ3 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | SURVEY_SQ4 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | SURVEY_SQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | SURVEY_SQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | SURVEY_SQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | SURVEY_IQ5 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | SURVEY_IQ6 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | SURVEY_SQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | SURVEY_SQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | SURVEY_SQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource | SURVEY_IQ10 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource | SURVEY_IQ7 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource | SURVEY_IQ8 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource | SURVEY_IQ9 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource | SURVEY_COMPLETE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource | SURVEY_IRECOMMENDSCORE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource | SURVEY_RECORDING | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-RESOURCE:8.5PDMSource | RESOURCE_SUBTYPE | 8.5.003.17 (new value, Person, added for the Agent resource type) |
| Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5PDMSource | SESSION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-SDR ACTIVITY:8.5PDMSource | NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource | APPLICATION_ID | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource | APPLICATION_TITLE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource | APPLICATION_VERSION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource | DISPOSITION_CATEGORY | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource | DISPOSITION_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource | FINAL_DISPOSITION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource | CALL_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource | MEDIA_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CUST ATRIBUTES:8.5PDMSource | ATRIBUTE_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR ENTRY POINT:8.5PDMSource | DNIS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXIT POINT:8.5PDMSource | APPLICATION_EXIT_POINT | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5PDMSource | URL | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) • 8.5.008.29 (behavior changed) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5PDMSource | SUCCESS | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource | METHOD | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource | REQUEST_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource | REQUEST_TYPE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource | SERVICE_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource | SERVICE_RESPONSE_DESC | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5PDMSource | COUNTRY_CODE | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5PDMSource | COUNTRY_NAME | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5PDMSource | REGION | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR GEO LOCATION:8.5PDMSource | TIMEZONE | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Documentation:GIM:Library:Table-SDR INPUT OUTCOME:8.5PDMSource | SELECTED_OPTION | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
Modified
| Table | Table Introduced | Column Introduced | Column Modified |
|---|---|---|---|
| Table | Table Introduced | Column Introduced | Column Modified |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | |
| Documentation:GIM:Library:Table-CALLBACK DIM 1:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | |
| Documentation:GIM:Library:Table-CALLBACK DIM 2:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | |
| Documentation:GIM:Library:Table-CALLBACK DIM 3:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.008 (data type increased from 10 to 19 digits) | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.008 (default value added) | |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.009.20 | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.009.20 | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.009.20 | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-CALLBACK FACT:8.5PDMSource | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | 8.5.009.20 | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) |
| Documentation:GIM:Library:Table-COBROWSE FACT:8.5PDMSource | 8.5.011.14 | 8.5.012.15 (No longer a mandatory field) | |
| Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource | 8.5.006 (IRF_ROUTE value is added) • 8.5.001 (IRF_INITIAL value is added). | ||
| Documentation:GIM:Library:Table-CTL UD TO UDE MAPPING:8.5PDMSource | 8.5.006 (IRF_ROUTE value is added) • 8.5.001 (IRF_INITIAL value is added). | ||
| Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource | 8.5.009 | 8.5.009.20 (default value no longer defined) | |
| Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource | 8.5.009 | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | |
| Documentation:GIM:Library:Table-GPM FACT:8.5PDMSource | 8.5.009 | 8.5.011 (added to the composite primary key in nonpartitioned databases) | |
| Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource | 8.5.009 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-GPM MODEL:8.5PDMSource | 8.5.009 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource | 8.5.009 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-GPM PREDICTOR:8.5PDMSource | 8.5.009 | 8.5.010 (in Microsoft SQL Server,data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | 8.5.009 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | 8.5.009 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | 8.5.009 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | 8.5.009 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-GPM RESULT:8.5PDMSource | 8.5.009 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | ||
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | ||
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | ||
| Documentation:GIM:Library:Table-INTERACTION DESCRIPTOR:8.5PDMSource | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | ||
| Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource | 8.5.001 (error code 26 added) | ||
| Documentation:GIM:Library:Table-INTERACTION FACT:8.5PDMSource | 8.5.007 (data type extended from 255 to 1024 characters) | ||
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | 8.1.2, 8.1.3, 8.1.4 (behavior changed) | ||
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | 8.1.2, 8.1.3, 8.1.4 (behavior changed) | ||
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | 8.5.001 (scope expanded to include chat consultations) | ||
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | 8.5.001 (scope expanded to include chat consultations) | ||
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | 8.5.001 (scope expanded to include chat consultations) | ||
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | 8.5.001 (scope expanded to include chat consultations) | ||
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | 8.5.001 (scope expanded to include chat consultations) | ||
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | 8.5.003 and 8.5.004 (behavior changed) | ||
| Documentation:GIM:Library:Table-INTERACTION RESOURCE FACT:8.5PDMSource | 8.5.004 (scope extended) | ||
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource | 8.5.005 (OutboundCallback subtype added) • 8.5.001 (InternalConferenceInvite subtype added) | ||
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource | 8.5.005 (OutboundCallback subtype added) • 8.5.001 (InternalConferenceInvite subtype added) | ||
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource | 8.5.005 (OUTBOUNDCALLBACK subtype added) • 8.5.001 (INTERNALCONFERENCEINVITE subtype added) | ||
| Documentation:GIM:Library:Table-INTERACTION TYPE:8.5PDMSource | 8.5.005 (OUTBOUNDCALLBACK subtype added) • 8.5.001 (INTERNALCONFERENCEINVITE subtype added) | ||
| Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource | 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters, as defined now in the user-data template script, make_gim_UDE_template*.sql) • 8.5.005.09 (data types for the CUSTOM_DATA_13 through CUSTOM_DATA_16 columns in the make_gim_UDE_template.sql script, which used to provide examples of date/time and numeric data types and default values, were changed to character data types). | ||
| Documentation:GIM:Library:Table-IRF USER DATA CUST 1:8.5PDMSource | 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters, as defined now in the user-data template script, make_gim_UDE_template*.sql) • 8.5.005.09 (data types for the CUSTOM_DATA_13 through CUSTOM_DATA_16 columns in the make_gim_UDE_template.sql script, which used to provide examples of date/time and numeric data types and default values, were changed to character data types). | ||
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 1:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 2:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 3:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 4:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 5:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-POST CALL SURVEY DIM 6:8.5PDMSource | 8.5.003. Supported in certain deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-RESOURCE:8.5PDMSource | 8.5.003.17 (new value, Person, added for the Agent resource type) | ||
| Documentation:GIM:Library:Table-SDR ACTIVITIES FACT:8.5PDMSource | 8.5.007. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases) | |
| Documentation:GIM:Library:Table-SDR ACTIVITY:8.5PDMSource | 8.5.007. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-SDR APPLICATION:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-SDR CALL DISPOSITION:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.007 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-SDR CALL TYPE:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.008 | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) |
| Documentation:GIM:Library:Table-SDR CUST ATRIBUTES:8.5PDMSource | 8.5.005. Supported in certain Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-SDR ENTRY POINT:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-SDR EXIT POINT:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) • 8.5.008.29 (behavior changed) | |
| Documentation:GIM:Library:Table-SDR EXT HTTP REST:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) • 8.5.008.29 (behavior changed) | |
| Documentation:GIM:Library:Table-SDR EXT REQUEST OUTCOME:8.5PDMSource | 8.5.004.09. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-SDR EXT REQUEST:8.5PDMSource | 8.5.001. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single-language databases) | |
| Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource | 8.5.004. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) | |
| Documentation:GIM:Library:Table-SDR EXT SERVICE OUTCOME:8.5PDMSource | 8.5.004. Supported in Genesys Engage cloud deployments only. | 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases) |
| Table | Column | Change occurred in |
|---|---|---|
| Table | Column | Change occurred in |
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | ||
| ANCHOR_FLAGS | CUSTOMER_LEFT_FIRST | 8.5.004 |
| ANCHOR_FLAGS | CUSTOMER_LEFT_FIRST | 8.5.004 |
| ATTEMPT_DISPOSITION | ||
| ATTEMPT_DISPOSITION | ||
| ATTEMPT_DISPOSITION | ||
| ATTEMPT_DISPOSITION | ||
| ATTEMPT_DISPOSITION | ||
| ATTEMPT_DISPOSITION | ||
| ATTEMPT_DISPOSITION | ||
| ATTEMPT_DISPOSITION | ||
| BGS_BOT_DIM | 8.5.011 | |
| BGS_BOT_DIM | 8.5.011 | |
| BGS_BOT_DIM | 8.5.011 | |
| BGS_BOT_DIM | 8.5.011 | |
| BGS_BOT_NAME_DIM | 8.5.011 | |
| BGS_BOT_NAME_DIM | 8.5.011 | |
| BGS_BOT_NAME_DIM | 8.5.011 | |
| BGS_SESSION_DIM | 8.5.011 | |
| BGS_SESSION_DIM | 8.5.011 | |
| BGS_SESSION_DIM | 8.5.011 | |
| BGS_SESSION_DIM | 8.5.011 | |
| BGS_SESSION_DIM | 8.5.011 | |
| BGS_SESSION_DIM | 8.5.011 | |
| BGS_SESSION_DIM | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| BGS_SESSION_FACT | 8.5.011 | |
| CALLBACK_DIAL_RESULTS | 8.5.009.20 | |
| CALLBACK_DIAL_RESULTS | 8.5.009.20 | |
| CALLBACK_DIAL_RESULTS | 8.5.009.20 | |
| CALLBACK_DIAL_RESULTS | 8.5.009.20 | |
| CALLBACK_DIAL_RESULTS | 8.5.009.20 | |
| CALLBACK_DIAL_RESULTS | 8.5.009.20 | |
| CALLBACK_DIAL_RESULTS | 8.5.009.20 | |
| CALLBACK_DIM_1 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_1 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_1 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_1 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_1 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_1 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_2 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_2 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_2 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_2 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_2 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_2 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_3 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_3 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_3 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_3 | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_DIM_4 | 8.5.009.20 | |
| CALLBACK_DIM_4 | 8.5.009.20 | |
| CALLBACK_DIM_4 | 8.5.009.20 | |
| CALLBACK_DIM_4 | 8.5.009.20 | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. | |
| CALLBACK_FACT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| Table | Column | Change occurred in |
|---|---|---|
| Table | Column | Change occurred in |
| ANCHOR_FLAGS | ANCHOR_FLAGS_KEY | |
| ANCHOR_FLAGS | ANCHOR_FLAGS_KEY | |
| ANCHOR_FLAGS | CREATE_AUDIT_KEY | |
| ANCHOR_FLAGS | CREATE_AUDIT_KEY | |
| ANCHOR_FLAGS | CUSTOMER_LEFT_FIRST | 8.5.004 |
| ANCHOR_FLAGS | CUSTOMER_LEFT_FIRST | 8.5.004 |
| ANCHOR_FLAGS | FIRST_ENGAGE_FOR_AGENT_IXN | |
| ANCHOR_FLAGS | FIRST_ENGAGE_FOR_AGENT_IXN | |
| ANCHOR_FLAGS | FIRST_ENGAGE_FOR_AGENT_THRD | |
| ANCHOR_FLAGS | FIRST_ENGAGE_FOR_AGENT_THRD | |
| ANCHOR_FLAGS | FIRST_ENGAGE_THRD | |
| ANCHOR_FLAGS | FIRST_ENGAGE_THRD | |
| ANCHOR_FLAGS | FIRST_REPLY_FOR_AGENT_IXN | |
| ANCHOR_FLAGS | FIRST_REPLY_FOR_AGENT_IXN | |
| ANCHOR_FLAGS | FIRST_REPLY_FOR_AGENT_THRD | |
| ANCHOR_FLAGS | FIRST_REPLY_FOR_AGENT_THRD | |
| ANCHOR_FLAGS | UPDATE_AUDIT_KEY | |
| ANCHOR_FLAGS | UPDATE_AUDIT_KEY | |
| ATTEMPT_DISPOSITION | ATTEMPT_DISPOSITION_KEY | |
| ATTEMPT_DISPOSITION | CAUSE | |
| ATTEMPT_DISPOSITION | CAUSE_CODE | |
| ATTEMPT_DISPOSITION | CAUSE_ID | |
| ATTEMPT_DISPOSITION | CREATE_AUDIT_KEY | |
| ATTEMPT_DISPOSITION | DESCRIPTOR | |
| ATTEMPT_DISPOSITION | DESCRIPTOR_CODE | |
| ATTEMPT_DISPOSITION | UPDATE_AUDIT_KEY | |
| BGS_BOT_DIM | BOT_CATEGORY | 8.5.011 |
| BGS_BOT_DIM | BOT_FUNCTION | 8.5.011 |
| BGS_BOT_DIM | CREATE_AUDIT_KEY | 8.5.011 |
| BGS_BOT_DIM | ID | 8.5.011 |
| BGS_BOT_NAME_DIM | BOT_NAME | 8.5.011 |
| BGS_BOT_NAME_DIM | CREATE_AUDIT_KEY | 8.5.011 |
| BGS_BOT_NAME_DIM | ID | 8.5.011 |
| BGS_SESSION_DIM | CREATE_AUDIT_KEY | 8.5.011 |
| BGS_SESSION_DIM | ENDED_ABNORMALLY | 8.5.011 |
| BGS_SESSION_DIM | ENDED_BY | 8.5.011 |
| BGS_SESSION_DIM | END_REASON | 8.5.011 |
| BGS_SESSION_DIM | END_RESULT | 8.5.011 |
| BGS_SESSION_DIM | ID | 8.5.011 |
| BGS_SESSION_DIM | REJECTED_TO_START | 8.5.011 |
| BGS_SESSION_FACT | BGS_BOT_DIM_KEY | 8.5.011 |
| BGS_SESSION_FACT | BGS_BOT_NAME_DIM_KEY | 8.5.011 |
| BGS_SESSION_FACT | BGS_SESSION_DIM_KEY | 8.5.011 |
| BGS_SESSION_FACT | CBS_ID | 8.5.011 |
| BGS_SESSION_FACT | CREATE_AUDIT_KEY | 8.5.011 |
| BGS_SESSION_FACT | DURATION | 8.5.011 |
| BGS_SESSION_FACT | END_DATE_TIME_KEY | 8.5.011 |
| BGS_SESSION_FACT | END_TS | 8.5.011 |
| BGS_SESSION_FACT | INTERACTION_SDT_KEY | 8.5.011 |
| BGS_SESSION_FACT | MEDIA_SERVER_IXN_GUID | 8.5.011 |
| BGS_SESSION_FACT | MEDIA_TYPE_KEY | 8.5.011 |
| BGS_SESSION_FACT | MESSAGES_RECEIVED | 8.5.011 |
| BGS_SESSION_FACT | MESSAGES_SENT | 8.5.011 |
| BGS_SESSION_FACT | START_DATE_TIME_KEY | 8.5.011 |
| BGS_SESSION_FACT | START_TS | 8.5.011 |
| BGS_SESSION_FACT | TENANT_KEY | 8.5.011 |
| BGS_SESSION_FACT | UPDATE_AUDIT_KEY | 8.5.011 |
| CALLBACK_DIAL_RESULTS | CREATE_AUDIT_KEY | 8.5.009.20 |
| CALLBACK_DIAL_RESULTS | DIAL_1_RESULT | 8.5.009.20 |
| CALLBACK_DIAL_RESULTS | DIAL_2_RESULT | 8.5.009.20 |
| CALLBACK_DIAL_RESULTS | DIAL_3_RESULT | 8.5.009.20 |
| CALLBACK_DIAL_RESULTS | DIAL_4_RESULT | 8.5.009.20 |
| CALLBACK_DIAL_RESULTS | DIAL_5_RESULT | 8.5.009.20 |
| CALLBACK_DIAL_RESULTS | ID | 8.5.009.20 |
| CALLBACK_DIM_1 | CALLBACK_OFFER_TYPE | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_1 | CALLBACK_TYPE | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_1 | CHANNEL | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_1 | CONNECT_ORDER | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_1 | CREATE_AUDIT_KEY | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_1 | ID | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_2 | CALL_DIRECTION | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_2 | CREATE_AUDIT_KEY | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_2 | DIAL_DIALOG_RESULT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_2 | FINAL_DIAL_RESULT | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_2 | ID | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_2 | OFFER_TIMING | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_3 | CREATE_AUDIT_KEY | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_3 | DISPOSITION | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_3 | FINAL_TARGET | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_3 | ID | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_DIM_4 | ABANDONED_DURING_CB_OFFER | 8.5.009.20 |
| CALLBACK_DIM_4 | CREATE_AUDIT_KEY | 8.5.009.20 |
| CALLBACK_DIM_4 | DIAL_IGNORING_AVAILABILITY | 8.5.009.20 |
| CALLBACK_DIM_4 | ID | 8.5.009.20 |
| CALLBACK_FACT | ABANDONED_WAITING | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ABANDONED_WAITING | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ABANDONED_WAITING | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ABANDONED_WAITING | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ABANDONED_WAITING | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ADDED_TS | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ADDED_TS | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ADDED_TS | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ADDED_TS | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | ADDED_TS | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | AGENT_ADDED_TO_IXN | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | AGENT_ADDED_TO_IXN | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | AGENT_ADDED_TO_IXN | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | AGENT_ADDED_TO_IXN | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | AGENT_ADDED_TO_IXN | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
| CALLBACK_FACT | CALLBACK_ACCEPTED | 8.1.402. Supported for on-premises deployments starting with release 8.5.005. |
Query that used to work but doesn't since I changed PDMTable.modified to a list:
Error: operator for the virtual field 'PDMTable.modified' must be 'HOLDS', 'HOLDS NOT', 'HOLDS LIKE' or 'HOLDS NOT LIKE'.
Comments or questions about this documentation? Contact us for support!