tblLVST_TranscriptScores
Table Description:
Aggregate scored results from the aligned transcripts and a particular scoring protocol run. Each score
type sums all of the alignments of that type for a given transcription
Table structure:
| Column Name |
Data Type |
Data Length |
Default Value |
See Also |
| ScoringProtocolID |
INTEGER |
N/A |
N/A |
N/A |
| cScoreType |
INTEGER |
N/A |
N/A |
tblLVST_TranscriptScores _cScoreType |
| TypeCount |
INTEGER |
N/A |
0 |
N/A |
| TotalConf |
FLOAT |
N/A |
0 |
N/A |
| TotalSquaredConf |
FLOAT |
N/A |
0 |
N/A |
| MinConf |
FLOAT |
N/A |
4294967295 |
N/A |
| MaxConf |
FLOAT |
N/A |
0 |
N/A |
| InVocabulary |
INTEGER |
N/A |
-1 |
N/A |
| OutOfVocabulary |
INTEGER |
N/A |
-1 |
N/A |
Primary Keys:
ScoreID
| Foreign Key |
Reference Table |
Reference Key |
| ScoringProtocolID |
tblLVST_ScoringProtocol |
ScoringProtocolID |
| cScoreType |
tblLVST_TranscriptScores_cScoreType |
ConstantValue |
Column Descriptions and Constraints:
| Column |
Description |
Constraint Name |
Constraint Description |
| ScoringProtocolID |
The scoring protocol used to derive these scores. |
N/A |
N/A |
| cScoreType |
Foreign key to tblLVST_TranscriptScores_cScoreType. The type of the token alignment score. This
field maps to the ConstantValue defined by ConstantNames ("INSERTION", "DELETION",
"SUBSTITUTION", "OOV_INSERTION", "NOISE_INSERTION", "MATCH",
"OOV_MATCH", "NOISE_MATCH") in tblLVST_TranscriptSCores_cScoreType.
|
"INSERTION", "DELETION", "SUBSTITUTION", "OOV_INSERTION",
"NOISE_INSERTION", "MATCH", "OOV_MATCH", "NOISE_MATCH"
|
Foreign key to tblLVST_TranscriptScores _cScoreType. |
| TypeCount |
The total summed confidence of each type of score in the alignment. Useful, among other things,
for calculating average confidence.
|
N/A |
N/A |
| TotalSquaredConf |
The total squared confidence of each type of score in the alignment. Useful, among other things,
for calculating variance and stdev.
|
N/A |
N/A |
| MinConf |
The lowest confidence score in the alignment. This is ULONG_MAX, as defined by MS Visual Studio 6. |
N/A |
N/A |
| MaxConf |
The highest confidence score in the alignment. |
N/A |
N/A |
| InVocabulary |
The count of in-vocabulary items in the alignment. |
N/A |
N/A |
| OutOfVocabulary |
The count of out-of-vocabulary items in the alignment. |
N/A |
N/A |
Table Constraints:
| Constraint Name |
Constraint Description |
Columns Related |
| N/A |
N/A |
N/A |