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_TRANSCRIPT_FACT

Description

Introduced: 8.5.005.20. Supported in certain Genesys Cloud deployments only.
Modified: 8.5.010.16 (UPDATE_AUDIT_KEY added)

In partitioned databases, this table is partitioned.


This table captures transcriptions of voice messages left by survey respondents.

Column List

Legend

Column Data Type P M F DV

SESSION_ID

VARCHAR2(50 CHAR) X X

START_DATE_TIME_KEY

NUMBER(10) X X X

TRANSCRIPTION_TS_MS

NUMBER(19) X

TRANSCRIPTION

VARCHAR2(4000 CHAR)

CREATE_AUDIT_KEY

NUMBER(19) X X

UPDATE_AUDIT_KEY

NUMBER(19) X

SESSION_ID

The ID as assigned to the session by Orchestration Server. You can use the SESSION_ID to link the SDR_SURVEY_TRANSCRIPT_FACT record with an SDR_SESSION_FACT.

START_DATE_TIME_KEY

Identifies the start of a 15-minute interval in which the fact began. Use this value as a key to join the fact tables to any configured DATE_TIME dimension.

TRANSCRIPTION_TS_MS

The time stamp when the transcription was produced.

TRANSCRIPTION

The transcription of a voice message left by a survey respondent.

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.

UPDATE_AUDIT_KEY

Introduced: Release 8.5.010.16
The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify recently modified data.


Index List

CODE U C Description

I_SDR_SRV_TRANSCRIPT_FACT_SDT

Improves access time, based on the Start Date Time key.

Index I_SDR_SRV_TRANSCRIPT_FACT_SDT

Field Sort Comment
START_DATE_TIME_KEY Ascending

No subject area information available.

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 28 July 2017, at 10:55.