- Created by Aaron Sakievich, last modified on Jun 14, 2021
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 6 Current »
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.
Document Sheet
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 where quality evaluation took place |
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 | The adjusted error points based on the source word count and the standard word count |
Quality Score | Double | The quality score of the document's targets |
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 |
---|---|---|
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 |
---|---|---|
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 |
- No labels