WordCount Details

Column Name Data Type Description

WordCount_Detail_ID *1

uniqueidentifier

Unique identifier of utterance in QMS.

Recording_ID *3

uniqueidentifier

Unique identifier of media utterance is derived from in QMS.

User_ID *4

uniqueidentifier

Unique identifier of user attached to the media this utterance is derived from in QMS.

Internal_Total

int

Occurances of this utterance in this media attributed to internal sources.

External_Total

int

Occurances of this utterance in this media attributed to external sources.

Word_Text *2

nvarchar-50

Text representation of this utterance.

Language

nvarchar-10

Language code associated with this utterance.

*1

Member is the table’s primary key.

*2

Member has an accompanying, like-named member that serves as a unique identifier. Where the identifier is named member_Id

*3

This member is a foreign key linking a record in the Recording_Details table.

*4

This member is a foreign key linking a record in the User_Details table.