Report S721 - File QA Oversight Per Language
This report helps you confirm that quality assurance was carried out on your files. It produces one row per file and target language, showing whether a QA check was run, when, and which jobs and suppliers were involved. It 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 file and target language, and covers both Standard and Codyt projects.
Report option: choose Canceled projects excluded (the default) or Canceled projects included. Cancelled jobs are always excluded.
Also read Languages, Dates and Currencies for important information.
Template
Screenshot of the default template:
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 file and target language. 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 file 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.ProjectManager> | The first and last name of the project manager. |
<#Lines.ProjectDeadline> | The project deadline, if any. |
File | The file and target language described by this row. |
<#Lines.FileId> | The unique file (document) ID. |
<#Lines.FileName> | The file name. |
<#Lines.FilePath> | The full file path. |
<#Lines.FileSourceLocale> | The source language ISO code and name, respectively. |
<#Lines.FileTargetLocale> | The target language ISO code and name, respectively. |
Quality assurance | Whether a QA check was run for this file and target language. |
<#Lines.QAExecuted> | Whether a QA check was run for this file and target language. Prints Yes or No. |
<#Lines.QACheckDate> | The date when the QA check was run. |
Jobs | Aggregated across all jobs covering this file and target language. |
<#Lines.JobCount> | The number of jobs covering this file and target language. |
<#Lines.JobTypes> | The task types involved, as a semicolon-separated list. |
<#Lines.JobStatuses> | The statuses of those jobs, as a semicolon-separated list. |
<#Lines.JobCompanies> | The supplier companies involved, as a semicolon-separated list. |
<#Lines.JobPersons> | The supplier contacts involved, as a semicolon-separated list. |
Custom fields | You can include any of your project custom fields in your report. |
<#Lines.ProjectCF1> ... <#Lines.ProjectCF50> | Project custom fields 1 to 50. |