Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

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.

On this page:

Related pages:

Cost and Invoice Reports

 Cost and Invoice Reports - Field Definitions and Details

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.

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

The sum of the base cost and the PM fee.

Linguist Report

 Linguist Report - Field Definitions and Details

Field

Data Type

Description

Client Organization

String

The client organization the work was done for

Client Organization Id

String (UUID)

The ID of the client organization the work was done for

Customer Id

String

The Customer ID stored in the admin application

Project

String

The name of the project

Document ID

Int

Legacy document ID

Document UUID

String (UUID)

Document ID

Document Name

String

The name of the document

Source

String

The document source locale

Target

String

The target locale the source is being translated into

Target UUID

String (UUID)

The ID of the target

Billable Hours

Float

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

Total Time Spent

Float

The time the linguist spent on the phase. Tracked by the timer in the Workbench. 

Total Segments

Int

The total number of segments on the source document. 

Total Words

Int

The total words in the source document

Repetitions Word Count

Int

The number of repetitions calculated by the initial leverage report

Exact 100 Word Count

Int

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

Syntax 100 Word Count

Int

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

99-95% TM Word Count

int

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

94-85% TM Word Count

Int

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

84-75% TM Word Count

Int

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

74-50% TM Word Count

Int

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

49-0% TM Word Count

Int

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

Phase Type

String

The phase type (TRANSLATE, REVIEW, or CUSTOM)

Phase Name

String

The name of the phase assigned by the workflow

Phase UUID

String (UUID)

The ID of the phase

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 Duration

Float

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

Phase Due Date

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

The current phase due date

Phase Invoiceable Date

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

The date the phase was marked invoiceable

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

Phase Assignee

String

The user(s) assigned to the phase

Aliased Phase Assignee

String

The aliases of the user(s) assigned to the phase

Responsible User

String

The user the system determined is actually responsible for work on the phase. 

Aliased Responsible User

String

The aliase of the user who was responsible for work on the phase. 

User UUID

String (UUID)

The UUID of the user who performed the work described in the following columns

User Name

String

The username of the individual who performed the work described in the following columns

Alias

String

The alias of the individual who performed the work described in the following columns

Login Id

String

The login ID of the individual who performed the work described in the following columns

Email

String

The email of the individual who performed the work described in the following columns

Linguist Organization

String

The name of the organization of the individual who performed the work described in the following columns

Linguist Organization UUID

String (UUID)

The organization ID of the individual who performed the work described in the following columns

Linguist Time Spent

Float

The amount of time the linguist spent on the phases he/she worked on. 

Linguist Segments

String

The number of segments the linguist worked on for the phase

Linguist Repetitions

String

The percent of repetitions the linguist worked on. Calculated by taking the total number or repetitions multiplied by the percent of segments they worked on. 

Linguist Exact 100%

String

The percent of exact 100% words the linguist worked on. Calculated by taking the total number or exact 100% words multiplied by the percent of segments they worked on. 

Linguist Syntax 100%

String

The percent of syntax 100% the linguist worked on. Calculated by taking the total number or syntax 100% multiplied by the percent of segments they worked on. 

Linguist 99%-95%

String

The percent of 99-95% words the linguist worked on. Calculated by taking the total number or 99-95% words multiplied by the percent of segments they worked on. 

Linguist 94%-85%

String

The percent of 94-85% words the linguist worked on. Calculated by taking the total number or 94-85% words multiplied by the percent of segments they worked on. 

Linguist 84%-75%

String

The percent of 84-75% words the linguist worked on. Calculated by taking the total number or 84-75% words multiplied by the percent of segments they worked on. 

Linguist 74%-50%

String

The percent of 74-50% words the linguist worked on. Calculated by taking the total number or 74-50% words multiplied by the percent of segments they worked on. 

Linguist 49%-0%

String

The percent of 0-49% words the linguist worked on. Calculated by taking the total number or 0-49% words multiplied by the percent of segments they worked on. 

  • No labels