/
Report Downloads

Report Downloads

Overview

With Report Downloads, you can generate reports about various tasks in the TMS. These downloadable reports contain full, unfiltered data that can provide insights that your organization can analyze to make better business decisions. You can tailor the data sets in the report according to a specific date range.

Each report includes an average of the dataset within the selected date range. This is a way to know whether the correct data is harnessed in the report.

To download a report, set a date range in the Date Range box, and then, click the DOWNLOAD option for the applicable dataset.

Documents

Included in the Documents report is the total number of documents that are completed within the selected date range. It also includes the metadata and other information from documents once they reach completion.

Column Name

Data Type

Description

Column Name

Data Type

Description

community_uid

String (UUID)

Community UUID

community_name

String

Community Name

community_id

String

Legacy community ID

project_uid

String (UUID)

Project UUID

project_name

String

Project name

project_due_time

Timestamp

Due date set for the project

project_complete_date

Timestamp

The date the project was marked complete

project_quality_program_id

String (UUID)

The ID of the quality program used for all content in the project

project_created_at

Timestamp

The date the project was created

document_uid

String (UUID)

Document UUID

document_name

String

Document Name

document_locale

String

The locale of the source document

document_language_description

String

The language the language code represents (EX: "English")

document_country_description

String

The country the locale code represents (EX: "United States")

document_note

String

A note left on the document used to provide useful information and instructions

document_requested_document_format

String

The source format code in the Lingotek system

document_duplicate_segment_count

Integer

The number of segments that are repeated in the document.

document_unique_segment_count

Integer

The number of unique segments in the document.

document_requested_importer_version

String

The importer version used to import the source file into the TMS

document_format_tag_count

Integer

The number of format tags found on the source file after the filtering and import process.

document_unique_word_count

Integer

The number of unique words in the source file.

document_translation_units

Integer

The number of segments in the document.

document_start_date

Timestamp

The date the document was 'ready' for translation.

document_character_count

Integer

The number of characters on the source file.

document_upload_date

Timestamp

The date the document was uploaded to the TMS.

document_duplicate_word_count

Integer

The number of duplicated words in the source file.

document_percent_complete

Integer

The percent progress of the document. This will be normally be 100% unless the document was cancelled.

document_source_word_count

Integer

The total word count of the source document.

document_weighted_word_count

Integer

The sum the document's targets' weighted word counts.

document_save_to_vault

String

The vault that created translation memory will be saved to unless otherwise specified at the target level

document_next_document_uuid

String (UUID)

The document version created when this document was updated

document_prev_document_uuid

String (UUID)

The document version this document was updated from

document_parent_document_uuid

String (UUID)

The original document uploaded to the TMS that this and all other document versions were created from.

document_format_code

String

The format code of the source document's file type

document_format_name

String

The description of the document_format_code

document_importer_version_code

String

The code of the importer version

document_author_name

String

Document metadata

document_external_style_id

String

Document metadata

document_creation_user

String

Document metadata

document_channel

String

Document metadata

document_external_document_id

String

Document metadata

document_reference_url

String

Document metadata

document_complete_date

String

The date the document was completed

document_external_application_id

String

Document metadata

document_contact_email

String

Document metadata

document_campaign_rating

Decimal

Document metadata

document_content_type

String

Document metadata

document_author_email

String

Document metadata

document_campaign_id

Integer

Document metadata

document_require_review

Boolean

Document metadata

document_contact_name

String

Document metadata

document_domain_type

String

Document metadata

document_company_id

Integer

Document metadata

document_original_due_date

Timestamp

The due date first set on the document

document_due_date

Timestamp

The current due date set on the document

document_original_due_reason

Integer

The reason the original due date was changed

document_due_reason

Integer

The reason the document's due date was changed to the current due date

document_application_name

String

The name of the application that uploaded the document to the Lingotek TMS

document_business_unit

String

Document metadata

document_content_description

String

Document metadata

document_business_division

String

Document metadata

document_purchase_order

String

Document metadata

document_job_id

String

Document metadata

document_region

String

Document metadata

document_priority_name

String

Document metadata

document_company_name

String

Document metadata

document_company_uid

String (UUID)

Document metadata

document_status

String

The document status when it was completed. The status will be "complete", "late", or "cancelled"

document_status_description

String

The definition of the document_status

document_status_reason

String

The reason for the document's status. Generally supplied when the document is late or cancelled.

document_status_reason_description

String

The user facing version of the document_status_reason

document_cancelled_at

Timestamp

The time the document was cancelled

document_created_at

Timestamp

The time the document was created

document_modified_at

Timestamp

The time the document was updated to a new version

document_quality_actual_error_points

Decimal

The actual number of error points a document has been docked based on the scorecards/severities

document_quality_normalized_error_points

Decimal

This represents the value of how many error points can be allowed before a document has a failing quality score given an expected word count per document.

document_quality_actual_quality_score

Decimal

This is also called the "Quality Score" in the quality reports. This represents the score that must be beaten for a document to pass

document_quality_pass_fail_status

String

This field states whether a document has passed or failed and is based on the error points calculated from scorecards/severities

document_quality_threshold_wc

Integer

This is also called the "Standard Word Count" in the quality report, and is used to normalize the actual error points found from feedback entries. This value represents an expected word count per document and then normalizes based on the documents actual word count.

document_quality_threshold_allowance

Integer

This represents how many error points can be allowed according to the quality program's passing score. If a quality program's passing score is 71, then the threshold allowance is 29 (100 - 71)

document_quality_threshold_type

String

Whether the error threshold should be weighed points (per how many words) or total points

document_quality_threshold_wc

Integer

The document's total word count

document_quality_threshold_allowance_points

Integer

How many "bad" points a quality score has before it's not considered, i. e. 10 points and you're out

document_quality_threshold_allowance_percentage

Decimal

A "bad" percentage a quality score has before it's not considered, i. e. 10% and you're out "thresholdAllowancePoints / thresholdWc) * 100)"

document_quality_minimum_quality_score

Decimal

The most minimum a score can be to be considered, "100 - thresholdAllowancePercentage"

document_quality_created_at

Timestamp

When the quality score was created for a document, a timestamp

document_turnaround_time_hours

Integer

The total time between the time the document was created and marked complete

document_finalized_timestamp

Timestamp

The time the document was finalized, and eligible to be added in the intelligence database. Documents are finalized when they enter a completed status.

document_finalized_date

Date

The calendar date the document was finalized

document_finalized_year

Integer

The calendar year the document was finalized

document_finalized_month

Integer

The calendar month the document was finalized

document_finalized_day

Integer

The day in the calendar year the document was finalized

document_finalized_week_number

Integer

The week of the year the document was finalized

document_finalized_start_of_week_mon

Date

The start of the week if this user's organization considers Monday to be the first day of the week.

document_finalized_start_of_week_sun

Date

The start of the week if this user's organization considers Sunday to be the first day of the week.

document_finalized_start_of_week_sat

Date

The start of the week if this user's organization considers Saturday to be the first day of the week.