Versions Compared

Old Version 13

changes.mady.by.user Aaron Sakievich (Unlicensed)

Saved on

compared with

New Version 14

changes.mady.by.user Aaron Sakievich (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

Table of Contents

Related pages:

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel = "report_definition" and title !~ " Vendor Report Field Definitions"

Cost and Invoice Reports

Expand
titleCost 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

Expand
titleLinguist 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.

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.

Source

String

The document’s source locale.

Target

String

The target locale.

Target UUID

String (UUID)

The UUID of the target.

Billable Hours

Int

The number of hours manually inputed when the phase was marked complete.

Total Time Spent

String

The aggregate time spent for the phase across all linguists who worked on it.

Total Segments

Int

The number of translateable segments in the phase.

Total Words

Int

The total source word count included in translatable segments.

Repetitions Word Count

Int

The total repetitions calculated from the initial leverage.

Exact 100 Word Count

Int

The total Exact 100 matches calculated from the initial leverage.

Syntax 100 Word Count

Int

The total Syntax 100 matches calculated from the initial leverage.

99-95% TM Word Count

Int

The total 99-95% calculated from the initial leverage.

94-85% TM Word Count

Int

The total 94-85% calculated from the initial leverage.

84-75% TM Word Count

Int

The total 84-75% calculated from the initial leverage.

74-50% TM Word Count

Int

The total 74-50% calculated from the initial leverage.

49-0% TM Word Count

Int

The total 49-0% calculated from the initial leverage.

Final Invoiced

Boolean

Whether or not this phase has been included in a final invoice report.

Invoice Report ID

String

If the phase was invoiced, the ID of the report it was included in.

Phase Type

String

The phase type (TRANSLATION, REVIEW, CUSTOM).

Phase Name

String

The name of the phase.

Phase UUID

String (UUID)

The UUID of the phase.

Phase Start Date

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

The date the phase was ready for translation.

Phase Completed Date

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

The date the phase was marked complete.

Phase Duration

String (HH:MM:SS)

The time between the start date and completion date.

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.