Breadcrumbs

Report S412 - Jobs - Status & Suppliers - Extended

This report is an extended copy of Report S411 - Jobs - Status & Suppliers. It gives you the same oversight of every job in your projects (status history, supplier assignment, declined suppliers and last logins) and adds four columns at the right-hand end: the order the job belongs to, that order's status, the number of files the job covers and its total word count. It produces one row per job and covers both Standard and Codyt projects.

Report content

When creating the report you select a date range and the system selects all projects that were created within this date range. The report produces one row per job and covers both Standard and Codyt projects. Everything to the left of the four new columns is identical to S411, in value and position.

Report option: choose Canceled projects excluded (the default) or Canceled projects included. Cancelled jobs are always excluded.

This report is offered on selected platforms only. If it does not appear in your report list, contact Wordbee. S411 remains available alongside it.

Also read Languages, Dates and Currencies for important information.

A customized copy of S411 does not gain the four new columns, because it keeps its own template. To use them in a customized report, make a fresh copy from S412 and rebuild that template.

Template

The default template is S411's template with four columns appended at the right-hand end: Order ID, Order status, File count and Word count.

Global placeholders

Placeholders can be placed in any location in the Excel file and their properties apply to the whole report.

Placeholder name

Description

<#GeneratedDate>

The date when the report was generated.

<#GeneratedBy>

The name of the user who generated the report.

<#DateRangeFrom>

The start date selected when creating the report.

<#DateRangeTo>

The end date selected when creating the report.

<#IncludeCancelled>

Whether cancelled projects are included in the report. Prints Yes or No.

Data rows and placeholders

Each row of the report corresponds to a single job. The placeholders of the row must be placed within the Excel table range named "___Lines___" (3 leading and trailing underscore characters). Click here for more details on table ranges.

A report prints the raw data in rows. Each row, you can use any of the following placeholders:

Placeholder name

Description

Project

The project the job belongs to.

<#Lines.ProjectReference>

The project reference.

<#Lines.ProjectClient>

The client company name.

<#Lines.ProjectStatus>

The project status title.

<#Lines.ProjectType>

The type of project. Prints either "Standard" or "Codyt".

<#Lines.ProjectCreationDate>

The date when the project was created.

<#Lines.ProjectCreationDateYM>

The project creation date formatted as "year-month", such as 2026-03.

<#Lines.ProjectInProgressDate>

The date when the project entered In progress.

<#Lines.ProjectCompletionDate>

The date when the project was completed.

<#Lines.ProjectManager>

The first and last name of the project manager.

<#Lines.ProjectDeadline>

The project deadline, if any.



Job

The job described by this row.

<#Lines.JobId>

The unique job ID.

<#Lines.JobStatus>

The status title of the job.

<#Lines.JobTaskCode>

The task code, such as TR for translation or PROOF for proofreading.

<#Lines.JobTaskName>

The task name, such as Translation or Revision.

<#Lines.JobSourceLocale>
<#Lines.JobSourceLocaleName>

The source language ISO code and name, respectively.

<#Lines.JobTargetLocale>
<#Lines.JobTargetLocaleName>

The target language ISO code and name, respectively.

<#Lines.JobCreationDate>

The date when the job was created.

<#Lines.JobStartDate>

The date when the job moved to In progress.

<#Lines.JobEndDate>

The date when the job moved to Completed.

<#Lines.JobTotalTimeSpent>

The elapsed time from when the job moved to In progress to when it was Completed, formatted as dd hh:mm so the column can be sorted and filtered in Excel. This is the same elapsed time the job page shows as Work duration, written as a sortable value instead of in words and without seconds. Blank while a job is still in progress or has not started.

<#Lines.JobDeadline>

The job deadline, if any.

<#Lines.JobAllocMode>

The allocation mode of the job: Fixed assignment, Job opening or Crowd.

<#Lines.JobRatingsAvg>

The average supplier rating for the job.

<#Lines.JobRatingsDate>

The date the rating was given.



Assigned supplier

The supplier currently assigned to the job.

<#Lines.JobCompany>

The assigned supplier company, if any.

<#Lines.JobCompanyAssignDate>

The date the company was assigned.

<#Lines.JobPerson>

The assigned supplier contact, if any.

<#Lines.JobPersonAssignDate>

The date the contact was assigned.

<#Lines.JobAssignedSupplierLastLogin>

The last login of the assigned supplier contact.

<#Lines.JobAssignedCompanyLastLogin>

The most recent login across all contacts of the assigned company.



Status history

The first and last time the job was in each status. Codyt jobs leave the Draft, Proposal and Last approved columns blank.

<#Lines.JobDraftInitialDate>
<#Lines.JobDraftLastDate>

First and last time the job was in Draft.

<#Lines.JobProposalInitialDate>
<#Lines.JobProposalLastDate>

First and last time the job was in Proposal.

<#Lines.JobInProgressInitialDate>
<#Lines.JobInProgressLastDate>

First and last time the job was In progress.

<#Lines.JobCompletedInitialDate>
<#Lines.JobCompletedLastDate>

First and last time the job was Completed.

<#Lines.JobLastApprovedDate>

The date the job was last Approved, taken from the status history shown on the job page. Approval is a separate step from completion: a supplier marks the job Completed, then a manager approves the result, so this date is later than the Completed date. If a job was approved more than once, the most recent approval is shown. Blank when the job was never approved, and always blank for Codyt jobs, which have no Approved status. Jobs approved automatically by a workflow step record no approval entry and are also blank.



Suppliers who declined

Suppliers who declined the job.

<#Lines.JobDeclinedSuppliers>

The suppliers who declined the job, each shown as company (and contact) with the decline date, most recent first.



Order and volume

The order the job belongs to and the size of the job. These placeholders exist only in this report.

<#Lines.UserOrderId>

The order ID of the client order the job belongs to, as shown on the order. The report takes the order linked to the job's file if there is one. Otherwise it takes the order of the job's project, but only when that project has exactly one live order. When a job's files point to different orders, a non-cancelled order is preferred, then the most recent. If the job's only order is cancelled, its ID is still shown. Blank when no order can be identified with confidence, for example a job with no order, or a file without an order in a project that has several live orders. For Standard jobs this can show an order where S410 shows none, because S410 looks up orders through the file only.

<#Lines.OrderStatus>

The status of the order shown in Order ID: Request, Proposal, In progress, Work done, Results approved, Closed or Cancelled. This is the order's status, not the job's: a row can read In progress in both columns with different meanings. Blank whenever Order ID is blank.

<#Lines.DocumentCount>

The number of files the job covers. Always 1 for a Codyt job, because a Codyt job covers exactly one file. Blank for a Standard job with no linked file.

<#Lines.WCWords>

The total word count of the job. For a job covering part of a file, the share of that file's count within the job's range. For a job scoped to segments, the job's own stored count, counted once for the job. Blank when the job has no word-count analysis; 0 only when a count of zero was recorded. No pre-translation or fuzzy-match breakdown is included.



Custom fields

You can include any of your job and project custom fields in your report.

<#Lines.JobCF1> ...

<#Lines.JobCF20>

Job custom fields 1 to 20.

<#Lines.ProjectCF1> ...

<#Lines.ProjectCF50>

Project custom fields 1 to 50.

Learn more