Summary of Info Mart Schema Changes
The following tables summarize Genesys Info Mart schema changes between 8.5 releases.
| Table | Column | Introduced in release |
|---|---|---|
| Table | Column | Introduced in release |
| 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!