Vendor Report Field Definitions

Vendor Report Field Definitions

Overview

  • Data Structure

    • Cost and Invoice Reports – All data in a row is in relation to the phase represented by that row. Meaning, any document information is about the document the phase is in, or any target information is about the target the phase is a part of.

    • Linguist Reports – Data in a row is the unique combination of a phase and linguists. Meaning, if three linguists worked on one phase, there will be three rows for each linguist, about the same phase.

  • Data about phases, documents, targets, and phases are updated whenever the Project app sends information to the Vendor app. This happens when:

    • The target is created

    • The leverage phase completes

    • The quote is generated

    • The phase is marked as invoiceable

  • Only cost information gets changed when:

    • The phase is skipped or cancelled.

    • The vendor assignment is changed.

  • Information is removed from the Vendor application when:

    • The phase is deleted (usually when the target or document is deleted).

    • The document is archived.

Cost and Invoice Reports

Field

Data Type

Description

Field

Data Type

Description

Document ID

Int

Legacy document ID.

Document UUID

String (UUID)

Document ID.

Document Name

String

The name of the document.

Project Name

String

The name of the project.

Project Type

String

Continuous or Scoped

Project Status

String

Scoping, Active, Complete

Project Approved

String

Approved, Denied, or blank if no decision has been made

Author Email

String

Document Metadata.

Author Name

String

Document Metadata.

Business Division

String

Document Metadata.

Business Unit

String

Document Metadata.

Campaign ID

String

Document Metadata.

Campaign Rating

Int

Document Metadata.

Category

String

Document Metadata.

Channel

String

Document Metadata.

Client

String

Document Metadata.

Contact Email

String

Document Metadata.

Contact Name

String

Document Metadata.

Content Description

String

Document Metadata.

Content Type

String

Document Metadata.

Domain

String

Document Metadata.

Ext. Application ID

String

Document Metadata..

Ext. Document ID

String

Document Metadata..

Ext. Style ID

String

Document Metadata..

Job ID

String

Document Metadata..

Purchase Order

String

Document Metadata..

Reference URL

String

Document Metadata..

Region

String

Document Metadata..

Require Review

Boolean

Document Metadata..

Doc Created By

String

The user who uploaded the document.

Doc Created Date

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

The date the document was created.

Target UUID

String (UUID)

The ID of the target.

Source

String

The document source locale.

Target

String

The target locale the source is being translated into.

Workflow

String

The name of the workflow used for translation.

Target Status

String

The status of the target since the last time vendor information was updated.

Target Created Date

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

The date the target was created.

Target Start Date

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

The date the work was started on the target's workflow.

Completed Target Date

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

The date the target was marked complete.

Turnaround Time

String (HH:MM:SS)

The time from the target's creation to when it was marked complete.

Original Target Due Date

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

The first target due date.

Target Due Date

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

The current target due date.

Reason for Negotiated Due Date

String

The reason the document’s due date was changed when the quote is generated

Reason for Missing Due Date

String

The reason the document’s due date was changed when the phase is marked invoiceable.

Total Words

Int  

The total words in the source document.

Quoted Weighted Words

Float

The original weighted words on the target.

Phase UUID

String (UUID)

The ID of the phase.

Phase Name

String

The name of the phase assigned by the workflow.

Phase Type

String

The phase type (TRANSLATE, REVIEW, or CUSTOM).

Phase Start Date

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

The date the phase transitioned to the READY status.

Phase Completed Date

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

The date the phase was marked complete.

Phase Invoiceable Date

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

The date the phase was marked invoiceable.

Phase Duration

String (HH:MM:SS)

The time from the phase's creation to when it was marked complete.

Phase Status

String

The status of the phase since the last time vendor information was updated.

Phase Percent Complete

Int

The progress percentage of the phase. Mostly used to track how much progress was made on the phase before it was cancelled.

Original Phase Due Date

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

The original phase due date.

Phase Due Date

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

The current phase due date.

Reason for Negotiated Due Date

String

The reason the phase due date was changed.

Phase Vendor

String

The vendor organization assigned to the phase.

Hourly Rate

Float

The hourly cost to work on CUSTOM phases. Only populated when the Phase Type is CUSTOM.

Quoted Hours

Int

The estimated cost calculated by the rate chart. This field is an estimate only and has no cost impact.

Billable Hours

Int

The number of hours the vendor is actually charging for the phase. This field impacts cost for CUSTOM phases only. 

Repetitions Word Count

Int

The number of repetitions calculated by the initial leverage report.

Repetitions Rate

Float

The rate charged by the Vendor organization for Repetitions.

Repetitions Cost

Float

The cost of repetitions calculated by multiplying the word count by the rate. 

Context 100 Word Count

Int

The number of context 100 words calculated by the initial leverage report.

Context 100 Rate

Float

The rate charged by the Vendor organization for context 100 words.

Context 100 Cost

Float

The cost of context 100 words calculated by multiplying the word count by the rate. 

Exact 100 Word Count

Int

The number of exact 100 words calculated by the initial leverage report.

Exact 100 Rate

Float

The rate charged by the Vendor organization for exact 100 words.

Exact 100 Cost

Float

The cost of exact 100 words calculated by multiplying the word count by the rate. 

Syntax 100 Word Count

Int

The number of syntax 100 words calculated by the initial leverage report.

Syntax 100 Rate

Float

The rate charged by the Vendor organization for syntax 100 words.

Syntax 100 Cost

Float

The cost of syntax 100 words calculated by multiplying the word count by the rate. 

99-95% TM Word Count

Int

The number of 99-95% words calculated by the initial leverage report.

99-95% TM Rate

Float

The rate charged by the Vendor organization for 99-95% words.

99-95% TM Cost

Float

The cost of 99-95% words calculated by multiplying the word count by the rate. 

94-85% TM Word Count

Int

The number of 94-85% words calculated by the initial leverage report.

94-85% TM Rate

Float

The rate charged by the Vendor organization for 94-85% words.

94-85% TM Cost

Float

The cost of 94-85% words calculated by multiplying the word count by the rate. 

84-75% TM Word Count

Int

The number of 84-75% words calculated by the initial leverage report.

84-75% TM Rate

Float

The rate charged by the Vendor organization for 84-75% words.

84-75% TM Cost

Float

The cost of 84-75% words calculated by multiplying the word count by the rate. 

74-50% TM Word Count

Int

The number of 74-50% words calculated by the initial leverage report.

74-50% TM Rate

Float

The rate charged by the Vendor organization for 74-50% words.

74-50% TM Cost

Float

The cost of 74-50% words calculated by multiplying the word count by the rate. 

49-0% TM Word Count

Int

The number of 49-0% words calculated by the initial leverage report.

49-0% TM Rate

Float

The rate charged by the Vendor organization for 49-0% words.

49-0% TM Cost

Float

The cost of 49-0% words calculated by multiplying the word count by the rate. 

Phase Rate Chart

String

The rate chart used to calculate the costs of this phase.

Base Cost

Float

The total cost of the hourly work OR the word based costs.

PM Fee

Float

The cost of multiplying the project management fee on the rate chart by the base cost.

Total Cost

Float