This page was last edited on June 23, 2022, at 00:01.
Comments or questions about this documentation? Contact us for support!
In the Column List:
Introduced: 8.5.005.20. Supported in certain Genesys Engage cloud deployments only.
Modified: 8.5.116.45 (size of the SESSION_ID column increased); 8.5.010.16 (UPDATE_AUDIT_KEY added); 8.5.010 (in Microsoft SQL Server, data type for SESSION_ID modified in multi-language databases)
In partitioned databases, this table is partitioned.
This table captures transcriptions of voice messages left by survey respondents.
Column | Data Type | P | M | F | DV |
---|---|---|---|---|---|
SESSION_ID | VARCHAR2(128 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 |
Modified: 8.5.116.45 (size of the column increased); 8.5.010 (in Microsoft SQL Server, data type modified in multi-language databases)
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.
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.
The transcription of a voice message left by a survey respondent.
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.
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.
CODE | U | C | Description |
---|---|---|---|
I_SDR_SRV_TRANSCRIPT_FACT_SDT | Improves access time, based on the Start Date Time key. |
Field | Sort | Comment |
---|---|---|
START_DATE_TIME_KEY | Ascending |
No subject area information available.