Quality Report Field Definitions

Owned by Aaron Sakievich (Unlicensed)
Last updated: Nov 30, 2021
4 min read

Overview

  • Quality reports are downloaded as XLSX files with three sheets.

  • Each sheet corresponds to a different level of hierarchy in the TMS (document, target, and segment).

  • Use the Document ID field found in each sheet to cross-reference information across the sheets.

  • The Feedback sheet has information at the segment level. And there can be multiple feedback on a single segment. Use the Segment ID to roll up information about a single segment.

On this page:

Related pages:

Document Sheet

Field

Datatype

Description

Field

Datatype

Description

Document Name

String

The name of the document

Document ID

UUID

Document ID

Content Type

String

The “Content Type” field in the document metadata.

Project Name

String

The name of the project

Project ID

UUID

The ID of the project

Source Words

Int

The number of source words in the document

Target Words

Int

The number of source words across all targets

Weighted Words

String

The number of weighted words across all targets

Evaluated Phase

String

The phase in the workflow that is being evaluated for quality

Evaluated Vendor

String

The vendor organization(s) assigned to the evaluated phase

LQE Phase

String

The phase with the quality evaluation setting enabled.

If there is more than one phase with the “Allow Quality Feeback on this Phase” setting enabled, the LQE phase will be the last one with the setting.

LQE Vendor

String

The vendor organization(s) assigned to perform the quality evaluation in the LQE Phase

Standard Word Count

Int

The standard word count specified in the quality program, which is used as a baseline for comparing documents of varying sizes

Total Error Points

Double

The total number of error points on the document

Weighted Error Points

String

The weighted error points on the document, after multiplying the error points against the weight defined in the Quality Program

Standardized Error Points

Double

This is calculated by adding all error points across the document’s targets, and dividing the sum of the error points by the number of targets.

Quality Score

Double

This is the overall quality score of the document.

Quality Grade

String

Whether or not the document passed or failed the quality evaluation; based on the pass/fail threshold defined in the Quality Program

Completed Date

Date (YYYY-MM-DD HH24:MI:SS)

The completion date of the document

Target Sheet

Field

Datatype

Description

Field

Datatype

Description

Target Locale

String

The target language locale

Document Name

String

The name of the document

Document ID

UUID

Document ID

Content Type

String

The “Content Type” field in the document metadata.

Project Name

String

The name of the project

Project ID

UUID

The ID of the project

Source Words

Int

The number of source words in the document

Target Words

Int

The number of source words for the target

Weighted Words

String

The number of weighted words across all targets

Standard Word Count

Int

The standard word count specified in the quality program, which is used as a baseline for comparing documents of varying sizes

Total Error Points

Double

The total number of error points on the target

Weighted Error Points

Double

The weighted error points on the Target, after multiplying the error points against the weight defined in the Quality Program

Standardized Error Points

Double

The adjusted error points based on the source word count and the standard word count

Quality Score

Double

The target's quality score

Quality Grade

String

Whether or not the Target passed or failed the quality evaluation; based on the pass/fail threshold defined in the Quality Program

Target Completed Date

Date (YYYY-MM-DD HH24:MI:SS)

The date the target was marked complete

Evaluated Phase

String

The phase in the workflow that is getting evaluated

Evaluated Author

String

The linguist who completed the task. This field is aliased if the user who ran the report is from a different default organization than the one who left the evaluation

Evaluated Vendor

String

The vendor organization assigned to the task

Evaluated Phase Start

Date (YYYY-MM-DD HH24:MI:SS)

The date the phase began

Evaluated Phase Complete

Date (YYYY-MM-DD HH24:MI:SS)

The date the phase was marked complete

Evaluated Phase Duration

Double

The total time in hours between the phase's start and completion dates

Evaluated Phase Time Spent

String (Int)  

The time recorded in the Workbench by the linguist(s) who worked on the evaluated phase

LQE Phase

String

The phase where quality evaluation took place

LQE User

String

The linguist who performed the quality evaluation. This field is aliased if the user who ran the report is from a different default organization than the one who left the evaluation

LQE Vendor

String

The linguist assigned to performing LQE. This field is aliased if the user who ran the report is from a different default organization than the one who left the evaluation

LQE Phase Start

Date (YYYY-MM-DD HH24:MI:SS)

The start date of the phase where quality evaluation took place

LQE Phase Complete

Date (YYYY-MM-DD HH24:MI:SS)

The completion date of the phase where quality evaluation took place

LQE Phase Duration

Double

The time between the start and completion date of the LQE phase

LQE Phase Time Spent

String (Int) 

The time recorded in the Workbench by the linguist(s) who worked on the quality evaluation

Feedback Sheet

Field

Datatype

Description

Field

Datatype

Description

Feedback Type

String

The error type selected

Feedback Category

String

The category the error type belongs to

Severity

String

The severity of the error

Comment

String

The comment the evaluator left with the feedback

Standard Word Count

Int

The standard word count specified by the quality program

Document Name

String

The name of the document

Document ID

UUID

Document ID

Document Source Words

Int

The source word count

Project Name

String

The name of the project

Project ID

UUID

The ID of the project

Segment

Int

The segment number

Segment ID

UUID

The ID of the segment

Segment Words

Int

The number of words in the segment

Total Error Points

Double

The total number of error points on the document

Weighted Error Points

Double

The weighted error points on the document

Standardized Error Points

Double

The adjusted error points based on the number of source word counts. 

Feedback Provided By

String

The user who provided the feedback. This field is aliased if the user who ran the report is from a different default organization than the one who left the evaluation

Feedback Date

Date (YYYY-MM-DD HH24:MI:SS)

The date the feedback was provided

Source Locale

String

The source locale of the segment

Source Text

String

The source text of the segment

Target Locale

String

The locale of the target segment

Evaluated Phase

String

The phase in the workflow that is getting evaluated

Evaluated Translation

String

The translation that received the evaluation

Evaluated Author

String

The linguist who completed the task. This field is aliased if the user who ran the report is from a different default organization than the one who left the evaluation

Evaluated Vendor

String

The vendor organization assigned to the task

Selected Text

String

The text highlighted when feedback was left

LQE Phase

String

The phase where quality evaluation took place

Corrected Translation

String

The edited translation when the quality evaluation was made

Corrected Translation Author

String

The user who made the corrected translation. This field is aliased if the user who ran the report is from a different default organization than the one who left the evaluation

LQE Vendor

String

The linguist assigned to performing LQE. This field is aliased if the user who ran the report is from a different default organization than the one who left the evaluation