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
This table captures transcriptions of voice messages left by survey respondents.
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.
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 time stamp when the transcription was produced.
The transcription of a voice message left by a survey respondent.
|Improves access time, based on the Start Date Time key.|
No subject area information available.