tblLVST_Transcripts

Table Description:

Stores all of the transcriptions for an interaction.

Table structure:

Primary Keys:

InteractionID
cTranscriptType
Version

Foreign keys relationships:

Column Descriptions and Constraints:

InteractionID

Description:Foreign key to tblLVST_CallInteractions. The interaction this transcript is written for. Part of the primary key set.
Constraint Name:N/A
Constraint Description:N/A

Transcript

Description:The transcript itself. This can be empty, although that is rare; usually even when the speaker doesn't say anything, there will be noise. The field is searchable, but any searches on are full text searches, and therefore expensive.
Constraint Name:N/A
Constraint Description:N/A

cTranscriptType

Description:Foreign key to tblLVST_Transcripts_cTranscriptType. Part of the primary key set. Indicates the kind of transcription. Currently, transcripts are either word-for-word ('RAW'), or the semantic result ('SEMANTIC').
Constraint Name:TranscriptTypeMustExist
Constraint Description:N/A

Gender

Description:Usually, this is the *perceived* sex of the speaker, based on the transcriber's intuition from listening to the audio. It's better if this can be exactly correct, although automated methods are good, too (for example, based on pitch detection).
Constraint Name:N/A
Constraint Description:N/A

Notes

Description:Notes on the transcription. Searchable, but not indexed, so effectively any search is a full text search of every notes entry.
Constraint Name:N/A
Constraint Description:N/A

DateEntered

Description:The date this transcription was written. Note that nearly *any* change to the transcription will generate a new entry, including changing the notes, any of the flags, or the transcription itself.
Constraint Name:N/A
Constraint Description:N/A

AsideF

Description:Marks this transcript as containing speech from the speaker, but not directed at the speech appliction, i.e., the speaker turns their head from the handset, and speaks to someone in the room. Typically, this utterance has to be rejected from usage in training new acoustic models, because the aside speech is really just noise. 1 is true, 0 false.
Constraint Name:N/A
Constraint Description:N/A

CheckF

Description:Marks this transcript as requiring further review by someone else (usually the transcription manager). LumenVox uses this in cases where a situation arises that isn't in the transcription protocol. 1 is true, 0 false.
Constraint Name:N/A
Constraint Description:N/A

ChoppedF

Description:Marks this transcript as containing a chopped word, i.e., the end pointing/speech detector started/ended recording inside a word. Typically, this utterance has to be rejected from usage in training new acoustic models, because there won't be a pronunciation for the chopped word in the dictionary, and because there are odd transient effects in the audio. 1 is true, 0 false.
Constraint Name:N/A
Constraint Description:N/A

PartialF

Description:Marks this transcript as containing a partial word, i.e., the user said a word which wasn't completed. Typically, this utterance has to be rejected from usage in training new acoustic models, because there won't be a pronunciation for the partial word in the dictionary. 1 is true, 0 false.
Constraint Name:N/A
Constraint Description:N/A

stTranscriber

Description:Foreign key to tblLVST_StringTable. Identifies the transcriber for this version of this transcript.
Constraint Name:N/A
Constraint Description:N/A

Version

Description:Identifies the transcript version of this transcript. Bigger version numbers are later versions.
Constraint Name:N/A
Constraint Description:N/A
 

Table Constraints:

Constraint Name:notexists
Constraint Description:Each interaction can have multiple transcriptions of the same type, but they must be marked as different versions.
Columns related:InteractionID, cTranscriptType, Version