Archive reporting tables
Project archiving allows you to generate reports on historical data. Archiving is the process of copying historical data into new database tables, specifically so that you can generate reports and find answers to your questions.
- How many projects were created in each of the last 12 months?
- What was the average time for a translation project?
- Which vendors had the fastest turnaround time?
- How many active projects and tasks were there on each day over the last two months?
In summary, the archive tables provide historical information about work that has been performed in WorldServer. Initial project information is added to these tables when projects are created; task information is added after the successful completion of each task. WorldServer does not remove Information from the archive tables automatically. These tables will store historical information indefinitely, unless end users remove old information from them.
Useful notes
- When a task is canceled, it remains in the
taskstable until garbage collection runs. - When a task is completed, it also remains in the
taskstable for at least 30 days (by default). After 30 days, it can be removed during garbage collection.It does not matter if a task is canceled or completed; it always remains in the
taskstable. The General Cleaner removes it from thetaskstable after a configured number of days. TheTaskDeleteAfterDaysproperty determines the amount of time a task remains in thetaskstable. - Tasks are always archived after they are completed successfully, even if their corresponding projects are not completed. Therefore, a completed task can be both in the
taskstable and in thearchiveTaskstable for a certain period of time, until garbage collection runs. - Archive tables are never included in garbage collection.
Use the
spDeleteArchivestored procedure to clean up archive tables manually.
archiveProjectGroups
| Column | Type | Description |
|---|---|---|
projectGroupId | integer | The internal ID of the project group. Primary key |
name | string | The name of the project group. |
description | string | The description of the project group (optional). |
workgroupId | integer | The internal ID of the workgroup with which the project group is associated. |
workgroupName | string | The name of the workgroup with which the project group is associated. |
creationDate | date | The date when the project group was created. |
dueDate | date | The date when the project group is due. This field is currently set only for projects created through TransPort. Reports should probably not depend on this and should use the due dates of individual projects instead. |
completionDate | date | The date when the project group was completed. Not set if the project group is still active. |
creatorId | integer | The internal ID of the user who created the project group. |
creatorName | string | The name of the user who created the project group. |
type | integer | Ignored. |
sourceLocaleId | integer | The internal ID of the source locale of the project group. |
sourceLocale | string | The name of the source locale of the project group. |
archiveProjects
| Column | Type | Description |
|---|---|---|
projectId | integer | The internal ID of the project. Primary key. |
name | string | The name of the project. |
description | string | The description of the project (optional). |
localeId | integer | The internal ID of the target locale of the project. |
localeName | string | The name of the target locale of the project. |
workgroupId | integer | The internal ID of the workgroup with which the project is associated. |
workgroupName | string | The name of the workgroup with which the project is associated. |
creationDate | date | The date when the project was created. |
dueDate | date | The date when the project is due (optional). |
completionDate | date | The date when the project was completed. Not set if the project is still active. |
creatorId | integer | The internal ID of the user who created the project. |
creatorName | string | The user name of the user who created the project. |
type | integer | Ignored. |
lastTaskNum | integer | The task number given to the last task in the project. This is ordinarily the same as the number of tasks in the project. |
projectGroupId | integer | A foreign key into the archiveProjectGroups table, identifying the project group that this project is a part of. |
activeTasks | integer | The number of active tasks in the project. |
completedTasks | integer | The number of completed tasks in the project. |
canceledTasks | integer | The number of canceled tasks in the project. |
totalTasks | integer | The total number of tasks in the project, regardless of their status. |
rfqId | integer | The internal ID of the quote for this project. |
rfqName | string | The name of the quote for this project. |
clientId | integer | The internal ID of the client for this project. |
clientName | string | The name of the client for this project. |
projectTypeId | integer | The internal ID of the project type for this project. |
projectTypeName | string | The name of the project type for this project. |
cost | double | The total cost for the project, as calculated by applying the associated cost model. Not set until the project is completed. |
adjustment | double | A manual adjustment to the project cost (optional). |
vendorNotes | string | Vendor notes related to the cost adjustment (optional). |
customerNotes | string | Customer notes related to the cost adjustment (optional). |
costModelArchiveId | integer | A foreign key into the archiveCostModels table, indicating the cost model associated with this project. |
reviewModelArchiveId | integer | A foreign key into the reviewModelArchive table, indicating the review model associated with this project. |
archiveCostModels
| Column | Type | Description |
|---|---|---|
costModelArchiveId | integer | The internal ID of the cost model. Primary key. |
name | integer | The name of the cost model. |
icePrice | double | The price of translating each ICE match word. |
repeititionPrice | double | The price of translating each repetition word.
|
perfectPrice | double | The price of translating each word with a perfect (100%) TM match. |
range1Price | double | The price of translating the highest fuzzy match range (for example, 90-100%). |
range1Min | integer | The lower boundary of the highest fuzzy match range (for example, 90). |
range2Price | double | The price of translating the second fuzzy match range (for example, 80-90%). Not set if there are fewer than two fuzzy match ranges in the associated scoping configuration. |
range2Min | integer | The lower boundary of the second fuzzy match range (for example, 80). Not set if there are fewer than two fuzzy match ranges in the associated scoping configuration. |
range3Price | double | The price of translating the third fuzzy match range (for example, 70-80%). Not set if there are fewer than three fuzzy match ranges in the associated scoping configuration. |
range3Min | integer | The lower boundary of the third fuzzy match range (for example, 80). Not set if there are fewer than three fuzzy match ranges in the associated scoping configuration. |
range4Price | double | The price of translating the fourth fuzzy match range (for example, 60-70%). Not set if there are fewer than four fuzzy match ranges in the associated scoping configuration. |
range4Min | integer | The lower boundary of the fourth fuzzy match range (for example, 60). Not set if there are fewer than four fuzzy match ranges in the associated scoping configuration. |
range5Price | double | The price of translating the fifth fuzzy match range (for example, 0-60%). Not set if there are fewer than five fuzzy match ranges in the associated scoping configuration. |
range5Min | integer | The lower boundary of the fifth fuzzy match range (for example, 0). Not set if there are fewer than five fuzzy match ranges in the associated scoping configuration. |
vendorId | integer | The internal ID of the vendor associated with the cost model (optional). |
vendorName | string | The name of the vendor associated with the cost model (optional). |
scopingConfigId | integer | The internal ID of the scoping configuration associated with the cost model. |
scopingConfigName | string | The name of the scoping configuration associated with the cost model. |
currency | string | The three-letter currency code for the currency that the prices in this cost model are listed in (for example, USD). |
archiveLineItems
| Column | Type | Description |
|---|---|---|
lineItemId | integer | The internal ID of the line item. Primary key. |
costModelArchiveId | integer | A foreign key into the archiveCostModels table, indicating the cost model to which the line item applies. |
name | string | The name of the line item. |
description | string | The description of the line item. |
cost | double | The additional charge (or discount, if negative) associated with the line item. |
archiveTasks
| Column | Type | Description |
|---|---|---|
taskId | integer | The internal ID of the task. Primary key. |
projectId | integer | A foreign key into the archiveProjects table, indicating the project to which the task belongs. |
workflowId | integer | The internal ID of the workflow that the task is flowing through. |
workflowName | string | The name of the workflow that the task is flowing through. |
stepCount | integer | The ordinal step number of the currently active task step. |
parentId | integer | If this task is part of a sub-workflow, this is the taskId of the task in the parent workflow that spawned this one. Otherwise, not set. |
parentStepCount | integer | If this task is part of a sub-workflow, this is the step number of the currently active task step in the parent workflow. Otherwise, 0. |
status | integer | Indicates the last event that occurred with this task. One of the following values:
|
taskNumInProject | integer | The ordinal number of the task in the associated project. |
creationDate | date | The date when the task was created. |
dueDate | date | The date when the task is due (optional). |
expectedDuration | integer | The number of hours the task is expected to take to complete (optional). |
completionDate | date | The date when the task was completed. |
currentTaskStepId | integer | A foreign key into the archiveTaskSteps table indicating which task step is currently active. |
priority | integer | The priority of the task. |
includeInCost | boolean | Whether or not the cost of the task should be included in the total cost of the project. |
sourceAsset | string | The AIS Path of the source asset. |
targetAsset | string | The AIS Path of the target asset. |
type | integer | Ignored. |
cost | double | The cost of the task, based on applying the associated cost model. Not set if there was no associated cost model or if the task never caused an asset to be segmented. |
mtWordCount | integer | The number of words processed by the task with an MT match. |
totalWordCount | integer | The total number of words processed by this task. Not set if the task never caused an asset to be segmented. |
iceWordCount | integer | The number of words processed by the task with a TM ICE match. Not set if the task never caused an asset to be segmented. |
perfectWordCount | integer | The number of words processed by the task with a 100% TM match. Not set if the task never caused an asset to be segmented. |
repetitionWordCount | integer | The number of words processed by the task with a TM repetition. Not set if the task never caused an asset to be segmented. |
range1WordCount | integer | The number of words in the highest fuzzy match range (for example, 90-100%). Not set if the task never caused an asset to be segmented. |
range1Min | integer | The lower boundary of the highest fuzzy match range (for example, 90). |
range2WordCount | integer | The number of words in the second fuzzy match range (for example, 80-90%). Not set if the task never caused an asset to be segmented. |
range2Min | integer | The lower boundary of the second fuzzy match range (for example, 80). Not set if there are fewer than two fuzzy match ranges in the associated scoping configuration. |
range3WordCount | integer | The number of words in the third fuzzy match range (for example, 70-80%). Not set if the task never caused an asset to be segmented. |
range3Min | integer | The lower boundary of the third fuzzy match range (for example, 70). Not set if there are fewer than three fuzzy match ranges in the associated scoping configuration. |
range4WordCount | integer | The number of words in the fourth fuzzy match range (for example, 60-70%). Not set if the task never caused an asset to be segmented. |
range4Min | integer | The lower boundary of the fourth fuzzy match range (for example, 60). Not set if there are fewer than four fuzzy match ranges in the associated scoping configuration. |
range5WordCount | integer | The number of words in the fifth fuzzy match range (for example, 0-60%). Not set if the task never caused an asset to be segmented. |
range5Min | integer | The lower boundary of the fifth fuzzy match range (for example, 0). Not set if there are fewer than five fuzzy match ranges in the associated scoping configuration. |
costModelId | integer | A foreign key into the archiveCostModels table. Indicates the cost model associated with the task. This is equivalent to archiveProjects.costModelArchiveId. |
reviewModelId | integer | The internal ID of the review model for this task. |
creatorName | string | The user name of the user who created the task. |
scopingConfigId | integer | The internal ID of the associated scoping configuration. |
scopingConfigName | string | The name of the associated scoping configuration. |
archiveTaskSteps
| Column | Type | Description |
|---|---|---|
taskStepId | integer | The internal ID of the task step. Primary key. |
taskId | integer | A foreign key into the archiveTasks table, indicating the task to which the task step belongs. |
workflowStepId | integer | The internal ID of the workflow step that the task step corresponds to. |
claimaintId | integer | The internal ID of the user who has claimed the task step. |
claimantName | string | The user name of the user who has claimed the task step. |
status | integer | One of the following values:
|
compTransitionId | integer | The internal ID of the transition taken from this step when it was completed. |
transitionName | string | The name of the transition taken from this step when it was completed. |
creationDate | date | The date when the task step was created. |
dueDate | date | The date when the task step is due (optional). |
expectedDuration | integer | The number of hours the task step is expected to take to complete (optional). |
startDate | date | The date when the task step began executing. |
completionDate | date | The date when the task step was completed. |
vendorId | integer | The internal ID of the vendor to whom the step is assigned. |
vendorName | string | The name of the vendor to whom the step is assigned. |
stepName | string | The name of the step (for example, Translate). |
stepType | string | The type of the step (Start, Finish, Human, Automatic, Sub-Workflow, Parallel Review, Automatic Error, or Cancel). |
archiveTaskHistoryEntries
| Column | Type | Description |
|---|---|---|
taskHistEntryId | integer | The internal ID of the history entry. Primary key. |
taskId | integer | A foreign key into the archiveTasks table, indicating the task to which the history entry applies. |
theDate | Date | The date of an event. |
eventType | integer | The event that occurred. One of the following values.
|
userId | integer | The unique ID of the user who performed the event, if relevant. |
theComment | string | A user-provided comment for the event (optional). |
archiveCustomProjectAttributes
| Column | Type | Description |
|---|---|---|
projectId | integer | A foreign key into the archiveProjects table, indicating the Project whose custom attribute this is. |
name | string | The name of the custom attribute. |
uiName | string | The UI display name of the custom attribute. |
valueString | string | The string value of the attribute. |
valueDate | date | The attribute value as a date. Not set for non-date-value attributes. |
valueNumber | integer | The numeric value of the attribute. Not set for non-numeric attributes. |
valueClob | CLOB | The attribute value, for attributes that require large amounts of storage (Large Text Area, Comment, HTML attributes). |
archiveCustomTaskAttributes
| Column | Type | Description |
|---|---|---|
taskId | integer | A foreign key into the archiveTasks table, indicating the task whose custom attribute this is. |
name | string | The name of the custom attribute. |
uiName | string. | The UI display name of the custom attribute |
valueString | string | The string value of the attribute. |
valueDate | date | The attribute value as a date. Not set for non-date-value attributes. |
valueNumber | integer | The numeric value of the attribute. Not set for non-numeric attributes. |
valueClob | CLOB | The attribute value, for attributes that require large amounts of storage (Large Text Area, Comment, HTML attributes). |
archiveCustomCostModelAttributes
| Column | Type | Description |
|---|---|---|
costModelArchiveId | integer | A foreign key into the archiveCostModels table, indicating the cost model whose custom attribute this is. |
name | string | The name of the custom attribute. |
uiName | string | The UI display name of the custom attribute. |
valueString | string | The string value of the attribute. |
valueDate | date | The attribute value as a date. Not set for non-date-value attributes. |
valueNumber | integer | The numeric value of the attribute. Not set for non-numeric attributes. |
valueClob | CLOB | The attribute value, for attributes that require large amounts of storage (Large Text Area, Comment, HTML attributes). |
archiveCustomVendorAttributes
| Column | Type | Description |
|---|---|---|
vendorId | integer | A foreign key matching the vendorId column in the archiveCostModels table, indicating the vendor whose custom attribute this is. |
archiveVendorAttributeId | integer | A unique ID. |
name | string | The name of the custom attribute. |
uiName | string | The UI display name of the custom attribute. |
valueString | string | The string value of the attribute. |
valueDate | date | The attribute value as a date. Not set for non-date-value attributes. |
valueNumber | integer | The numeric value of the attribute. Not set for non-numeric attributes. |
valueClob | CLOB | The attribute value, for attributes that require large amounts of storage (Large Text Area, Comment, HTML attributes). |
periodicWorkStatus
PWS_TASK recurrence, which records periodic snapshots of activity on a schedule:
| Column | Type | Description |
|---|---|---|
time | date | The timestamp when the snapshot was taken. |
activeProjects | integer | The number of projects active when the snapshot was taken. |
activeTasks | integer | The number of tasks active when the snapshot was taken. |
wordsInActiveTasks | integer | The number of words in assets associated with active tasks when the snapshot was taken. |
archiveReviewModels
| Column | Type | Description |
|---|---|---|
reviewModelArchiveId | integer | Primary key. |
reviewModelId | integer | The internal ID of the review model. |
name | string | The name of the review model. |
description | string | The description of the review model. |
archiveReviewModelData
| Column | Type | Description |
|---|---|---|
reviewModelArchiveId | integer | Primary key. |
dataType | integer | The data type of the review model. |
data | string | The data for the review model. |
displayOrder | integer | Order in display. |
archiveTaskReviewErrors
| Column | Type | Description |
|---|---|---|
archivedTaskId | integer | Primary key and foreign key. |
errorSeverity | string | Primary key. Severity of error. |
errorType | string | Primary key. The data for the review model. |
errorCount | integer | Number of errors. |