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

Table SDR_SURVEY_STATUS

Description

Introduced: 8.5.005. Supported in certain Genesys Cloud deployments only.
Modified: 8.5.008 (RECORDING column deprecated); 8.5.007 (OFFER column added)

In partitioned databases, this table is not partitioned.


This dimension table enables Session Detail Record (SDR) facts to be described based on survey status--that is, whether a survey was offered, accepted, rejected, recorded, or completed.

Column List

Legend

Column Data Type P M F DV

ID

integer X X

COMPLETE

varchar(10) X NO_VALUE

RECORDING*

*Discontinued in release 8.5.008

varchar(10) X NO_VALUE

OFFER

varchar(20) X NO_VALUE

CREATE_AUDIT_KEY

numeric(19) X X

ID

The primary key of this table.

COMPLETE

Based on KVP: survey_sComplete

Indicates whether a survey was completed. (TRUE = completed)

RECORDING

Discontinued: Release 8.5.008

Based on KVP: survey_sRecording

Deprecated.

OFFER

Introduced: Release 8.5.007
Indicates whether a survey was offered, and whether the offer was accepted or rejected. Possible values are:

  • none – survey was not offered
  • accepted – survey was accepted
  • rejected – survey was rejected

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_STATUS

X Improves access time, based on the CREATE_AUDIT_KEY value.

Index I_SDR_SURVEY_STATUS

Field Sort Comment
COMPLETE Ascending
RECORDING Ascending
OFFER 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 22:41.