Vendor Report Field Definitions
- Aaron Sakievich (Unlicensed)
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 | |
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 | The sum of the base cost and the PM fee. |
Linguist Report
Field | Data Type | Description |
---|
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. |
Project Type | String | |
Project Status | String | Scoping, Active, Complete |
Project Approved | String | Approved, Denied, or blank if no decision has been made |
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. |
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. |