tblLVST_ScoringProtocol

Table Description:

Defines the scoring protocol used for scoring the transcription marked by InteractionID. LumenVox currently defines two, both based on a minimum edit algorithm. One uses white space to determine candidate alignments; another uses the actual grammar to tokenize the transcript, and aligns appropriately. Others include grammar evaluation where currently, we run the transcript through the ASR-specific grammar tool (for Nuance this is parse-tool), and evaluate whether it parses or not, and semantic evaulation, where we run the transcript through the ASR-specific semantic tool (for Nuance, this is the nl-tool) to determine whether there is a semantic match or not.

Table structure:

Column Name Data Type Data Length Default Value See Also

ScoringProtocolID

INTEGER

N/A

N/A

N/A

InteractionID

INTEGER

N/A

N/A

N/A

cTranscriptType

INTEGER

N/A

N/A

N/A

Version

INTEGER

N/A

N/A

N/A

stAlgorithmName

INTEGER

N/A

N/A

tblLVST_StringTable

stAlgorithmSource

INTEGER

N/A

N/A

tblLVST_StringTable

stAlgorithmVersion

INTEGER

N/A

N/A

tblLVST_StringTable

stAlgorithmNotes

INTEGER

N/A

N/A

tblLVST_StringTable

cDomainType

INTEGER

N/A

N/A

tblLVST_ScoringProtocol_cDomainType

DateRan

TIMESTAMP

N/A

N/A

N/A

Primary Keys:

ScoringProtocolID

Foreign keys relationships:

Foreign key Reference table Reference key

InteractionID

tblLVST_Transcripts

InteractionID

cTranscriptType

tblLVST_Transcripts

cTranscriptType

Version

tblLVST_Transcripts

Version

 
Foreign key Reference table Reference key

stAlgorithmName

tblLVST_StringTable

StringID

 
Foreign key Reference table Reference key

stAlgorithmSource

tblLVST_StringTable

StringID

 
Foreign key Reference table Reference key

stAlgorithmVersion

tblLVST_StringTable

StringID

 
Foreign key Reference table Reference key

stAlgorithmNotes

tblLVST_StringTable

StringID

 
Foreign key Reference table Reference key

cDomainType

tblLVST_ScoringProtocol_cDomainType

ConstantValue

 

Column Descriptions and Constraints:

ScoringProtocolID

Description:
Autoincrementing primary key
Constraint Name:
N/A
Constraint Description:
N/A

InteractionID

Description:
One of the foriegn key to tblLVST_Transcripts. the interactionID for this scoring protocol
Constraint Name:
N/A
Constraint Description:
N/A

cTranscriptType

Description:
One of the foriegn keys to tblLVST_Transcripts. Indicates the transcript type for the transcript.
Constraint Name:
TranscriptTypeMustExist
Constraint Description:
N/A

Version

Description:
One of the foriegn key to tblLVST_Transcripts. Indicates which version of the transcript is being evaluated.
Constraint Name:
N/A
Constraint Description:
N/A

stAlgorithmName

Description:
Foreign key to tblLVST_StringTable. The name of the scoring algorithm, for example, 'Minimim Edit on Words'.
Constraint Name:
N/A
Constraint Description:
N/A

stAlgorithmSource

Description:
Foreign key to tblLVST_StringTable. The source of the scoring algorithm. For example, 'TunerScoring.dll'.
Constraint Name:
N/A
Constraint Description:
N/A

stAlgorithmVersion

Description:
Foreign key to tblLVST_StringTable. The version of the scoring algorithm.
Constraint Name:
N/A
Constraint Description:
N/A

stAlgorithmNotes

Description:
Foreign key to tblLVST_StringTable. Notes on the scoring involved.
Constraint Name:
N/A
Constraint Description:
N/A

cDomainType

Description:
The scoring domain; i.e., word-error rate, semantic-error rate, or grammar-error rate. See cDomainTypes.
Constraint Name:
"WER", "SER", "GER"
Constraint Description:
Foreign key to tblLVST_ScoringProtocol_cDomainType

DateRan

Description:
The date this transcript was evaulated using this algorithm.
Constraint Name:
N/A
Constraint Description:
N/A
 

Table Constraints:

Constraint Name:N/A
Constraint Description:
N/A
Columns related:
N/A