This page was last edited on June 23, 2022, at 03:41.
Comments or questions about this documentation? Contact us for support!
In the Column List:
Introduced: 8.5.005. Supported in certain Genesys Engage cloud deployments only.
Modified: 8.5.010 (in Microsoft SQL Server, data type for the SQ* columns modified in single- and multi-language databases)
In partitioned databases, this table is not partitioned.
This dimension table enables Session Detail Record (SDR) facts to be described based on responses to survey questions SQ6-SQ10. The capital letter (S) preceding the digits in the table name indicates that a string response is expected.
Column | Data Type | P | M | F | DV |
---|---|---|---|---|---|
ID | integer | X | X | ||
SQ6 | varchar(255) | X | NO_VALUE | ||
SQ7 | varchar(255) | X | NO_VALUE | ||
SQ8 | varchar(255) | X | NO_VALUE | ||
SQ9 | varchar(255) | X | NO_VALUE | ||
SQ10 | varchar(255) | X | NO_VALUE | ||
CREATE_AUDIT_KEY | numeric(19) | X | X |
Modified: 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Based on KVP: survey_sQ6
The answer from the caller to string-response question 6.
Modified: 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Based on KVP: survey_sQ7
The answer from the caller to string-response question 7.
Modified: 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Based on KVP: survey_sQ8
The answer from the caller to string-response question 8.
Modified: 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
Based on KVP: survey_sQ9
The answer from the caller to string-response question 9.
Modified: 8.5.010 (in Microsoft SQL Server, data type modified in single- and multi-language databases)
The answer from the caller to string-response question 10.
The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools--that is, applications that need to identify newly added data.
CODE | U | C | Description |
---|---|---|---|
I_SDR_SURVEY_S2 | X | Improves access time, based on the CREATE_AUDIT_KEY value. |
Field | Sort | Comment |
---|---|---|
SQ6 | Ascending | |
SQ7 | Ascending | |
SQ8 | Ascending | |
SQ9 | Ascending | |
SQ10 | Ascending |
No subject area information available.