Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)
  • DV = Default value
  • In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.)

Table SDR_SURVEY_S1

Description

Introduced: 8.5.005. Supported in certain Genesys Cloud deployments only.
Modified: 8.5.010 (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 SQ1-SQ5. The capital letter (S) preceding the digits in the table name indicates that a string response is expected.

Column List

Legend

Column Data Type P M F DV

ID

int X X

SQ1

nvarchar(170) X NO_VALUE

SQ2

nvarchar(170) X NO_VALUE

SQ3

nvarchar(170) X NO_VALUE

SQ4

nvarchar(170) X NO_VALUE

SQ5

nvarchar(170) X NO_VALUE

CREATE_AUDIT_KEY

numeric(19) X X

ID

The primary key of this table.

SQ1

Modified: 8.5.010 (data type modified in single- and multi-language databases)
Based on KVP: survey_sQ1

The answer from the caller to string-response question 1.

SQ2

Modified: 8.5.010 (data type modified in single- and multi-language databases)
Based on KVP: survey_sQ2

The answer from the caller to string-response question 2.

SQ3

Modified: 8.5.010 (data type modified in single- and multi-language databases)
Based on KVP: survey_sQ3

The answer from the caller to string-response question 3.

SQ4

Modified: 8.5.010 (data type modified in single- and multi-language databases)
Based on KVP: survey_sQ4

The answer from the caller to string-response question 4.

SQ5

Modified: 8.5.010 (data type modified in single- and multi-language databases)
Based on KVP: survey_sQ5

The answer from the caller to string-response question 5.

CREATE_AUDIT_KEY

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.


Index List

CODE U C Description

I_SDR_SURVEY_S1

X Improves access time, based on the CREATE_AUDIT_KEY value.

Index I_SDR_SURVEY_S1

Field Sort Comment
SQ1 Ascending
SQ2 Ascending
SQ3 Ascending
SQ4 Ascending
SQ5 Ascending

No subject area information available.

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 28 March 2017, at 21:53.