Active reporting tables

Archive tables are useful for reporting on historical information, but they are not so good for finding out what is going on in WorldServer right now. For that purpose, there are views on WorldServer’s internal active schema. Unlike the internal active schema itself, these views are documented and supported, and the reports built on them continue to work across multiple WorldServer versions.

Active views do not show historical information. Information about completed projects and tasks will be available in these tables for a short time (by default, 15 days, but you can configure this), before being cleaned out for performance reasons. Use the active views to build reports on current activity and the archive tables for historical records.

activeProjectGroups

Information about active and recently completed WorldServer project groups:
ColumnTypeDescription
projectGroupIdintegerThe internal ID of the project group.
namestringThe name of the project group.
descriptionstringThe description of the project group (optional).
workgroupIdintegerThe internal ID of the workgroup with which the project group is associated.
workgroupNamestringThe name of the workgroup with which the project group is associated.
creationDatedateThe date when the project group was created.
dueDatedateThe 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.
completionDatedateThe date when the project group was completed. Not set if the project group is still active.
creatorIdintegerThe internal ID of the user who created the project group.
creatorNamestringThe name of the user who created the project group.
typeintegerIgnored.

activeProjects

Information about active and recently completed WorldServer projects:
ColumnTypeDescription
projectIdintegerThe internal ID of the project. Primary key.
namestringThe name of the project.
descriptionstringThe description of the project (optional).
localeIdintegerThe internal ID of the target locale of the project.
localeNamestringThe name of the target locale of the project.
workgroupIdintegerThe internal ID of the workgroup with which the project is associated.
workgroupNamestringThe name of the workgroup with which the project is associated.
creationDatedateThe date when the project was created.
dueDatedateThe date when the project is due (optional).
completionDatedateThe date when the project was completed. Not set if the project is still active.
creatorIdintegerThe internal ID of the user who created the project.
creatorNamestringThe user name of the user who created the project.
typeintegerIgnored.
lastTaskNumintegerThe task number given to the last task in the project. This is ordinarily the same as the number of tasks in the project.
projectGroupIdintegerA foreign key into the archiveProjectGroups table, identifying the project group that this project is a part of.
activeTasksintegerThe number of active tasks in the project.
completedTasksintegerThe number of completed tasks in the project.
canceledTasksintegerThe number of canceled tasks in the project.
totalTasksintegerThe total number of tasks in the project, regardless of their status.
adjustmentdoubleA manual adjustment to the project cost (optional).
vendorNotesstringVendor notes related to the cost adjustment (optional).
customerNotesstringCustomer notes related to the cost adjustment (optional).

activeCostModels

Information about the translation costs associated with active and recently completed WorldServer projects:
ColumnTypeDescription
costModelIdintegerThe internal ID of the cost model.
projectIdintegerA reference into the activeProjects view, identifying the project that the cost model applies to.
nameintegerThe name of the cost model.
sourceLocaleIdintegerThe internal ID of the source locale to which the cost model applies.
sourceLocalestringThe name of the source locale to which the cost model applies.
targetLocaleIdintegerThe internal ID of the target locale to which the cost model applies.
targetLocalestringThe name of the target locale to which the cost model applies.
currencystringThe three-letter currency code for the currency that the prices in this cost model are listed in (for example, USD).
icePricedoubleThe price of translating each ICE match word.
repetitionPricedoubleThe price of translating each repetition word.
perfectPricedoubleThe price of translating each word with a perfect (100%) TM match.
vendorIdintegerThe internal ID of the vendor associated with the cost model (optional).
vendorNamestringThe name of the vendor associated with the cost model (optional).
vendorDescriptionstringThe description of the vendor associated with the cost model (optional).
vendorContactNamestringThe contact name for the vendor associated with the cost model (optional).
vendorContactPhonestringThe contact phone number for the vendor associated with the cost model (optional).
vendorContactEmailstringThe contact email address for the vendor associated with the cost model (optional).
vendorOtherContactstringOther contact details for the vendor associated with the cost model (optional).
vendorAddressstringThe street address of the vendor associated with the cost model (optional).
vendorNotesstringNotes for the vendor associated with the cost model (optional).
scopingConfigNamestringThe name of the scoping configuration associated with the cost model.
scopingConfigDescriptionstringThe description of the scoping configuration associated with the cost model.
defaultScopingConfigurationbooleanIndicates whether the scoping configuration associated with the cost model is the default one.

activeCostModelFuzzyPrices

Information about prices for words with fuzzy translation memory matches in cost models associated with active and recently completed projects. This view has several rows for each cost model, giving the price for each scoping range (for example, 0-60%, 60-70%, and so on) for each pair of source and target locales:
ColumnTypeDescription
costModelIdintegerA reference into the activeCostModels view, indicating the cost model to which the pricing applies.
sourceLocalestringThe name of the source locale to which the pricing applies.
sourceLocaleIdintegerThe internal ID of the source locale to which the pricing applies.
targetLocalestringThe name of the target locale to which the pricing applies.
targetLocaleIdintegerThe internal ID of the target locale to which the pricing applies.
scopingRangeMinintegerThe lower bound on the scoping range to which the pricing applies.
scopingRangeMaxintegerThe upper bound on the scoping range to which the pricing applies.
costPerWorddoubleThe price for each word in the associated scoping range for the associated source and target locales.

activeCostModelLineItems

Information about special charges or discounts on active and recently completed projects, as calculated by cost model rules:
ColumnTypeDescription
lineItemIdintegerThe internal ID of the line item.
costModelIdintegerA reference into the activeCostModels view, indicating the cost model to which the line item applies.
namestringThe name of the line item.
descriptionstringThe description of the line item.
projectIdintegerA reference into the activeProjects view, indicating the project to which the line item applies.

activeTasks

Information about tasks in active and recently completed WorldServer projects:
ColumnTypeDescription
taskIdintegerThe internal ID of the task.
projectIdintegerA reference into the activeProjects view, indicating the project to which the task belongs.
workflowIdintegerThe internal ID of the workflow that the task is flowing through.
workflowNamestringThe name of the workflow that the task is flowing through.
stepCountintegerThe ordinal step number of the currently active task step.
parentIdintegerIf the 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.
parentStepCountintegerIf the task is part of a sub-workflow, this is the step number of the currently active task step in the parent workflow. Otherwise, 0.
statusintegerIndicates the last event that occurred with this task. One of the following values:
  • 1: Editing/translation is in progress for this task.
  • 2: The task was started.
  • 3: The task was marked for revisiting.
  • 4: The task was completed.
  • 5: The task was exported for offline translation.
  • 6: An offline translation was imported.
taskNumInProjectintegerThe ordinal number of the task in the associated project.
creationDatedateThe date when the task was created.
dueDatedateThe date when the task is due (optional).
expectedDurationintegerThe number of hours the task is expected to take to complete (optional).
completionDatedateThe date when the task was completed.
completionStatusintegerIndicates the status of the task. One the following values:
  • 0: Not started
  • 1: In progress, successful so far
  • 2: In progress, with failures
  • 3: Completed successfully
  • 4: Failed
  • 5: Canceled
currentTaskStepIdintegerA foreign key into the activeTaskSteps table indicating which task step is currently active.
priorityintegerThe priority of the task.
includeInCostbooleanWhether or not the cost of the task should be included in the total cost of the project.
sourceAssetstringThe AIS Path of the source asset.
targetAssetstringThe AIS Path of the target asset.
typeintegerIgnored.
totalWordCountintegerThe total number of words processed by this task. Not set if the task never caused an asset to be segmented.
mtWordCountintegerThe number of words processed by the task with an MT match.
iceWordCountintegerThe number of words processed by the task with a TM ICE match. Not set if the task never caused an asset to be segmented.
perfectWordCountintegerThe number of words processed by the task with a 100% TM match. Not set if the task never caused an asset to be segmented.
repetitionWordCountintegerThe number of words processed by the task with a TM repetition. Not set if the task never caused an asset to be segmented.
creatorNamestringThe user name of the user who created the task.
scopingConfigNamestringThe name of the associated scoping configuration.
scopingConfigDescriptionstringThe description of the scoping configuration associated with the cost model.
defaultScopingConfigurationstringIndicates whether the scoping configuration associated with the cost model is the default one.
translatedSegmentsintegerThe number of segments processed so far.
totalSegmentsintegerThe total number of segments to be processed.

activeTaskFuzzyWordCounts

Information about the counts for words with fuzzy translation memory matches in tasks associated with active and recently completed projects. This view has several rows for each task, giving the word count for each scoping range:
ColumnTypeDescription
taskIdintegerA reference into the activeTasks view, indicating the task to which the word count applies.
scopingRangeMinintegerThe lower bound on the scoping range to which the word count applies.
scopingRangeMaxintegerThe upper bound on the scoping range to which the word count applies.
wordCountintegerThe number of words processed by this task.

activeTaskSteps

Information about each step encountered so far during the processing of tasks in active and recently completed projects:
ColumnTypeDescription
taskStepIdintegerThe internal ID of the task step.
taskIdintegerA reference into the activeTasks view, indicating the task to which the task step belongs.
workflowStepIdintegerThe internal ID of the workflow step that the task step corresponds to.
claimaintIdintegerThe internal ID of the user who has claimed the task step.
claimantNamestringThe user name of the user who has claimed the task step.
statusintegerOne of the following values:
  • 1: The task step has not yet started.
  • 2: The task step is in progress.
  • 3: The task step has been completed.
  • 4: The task has project scope and is waiting to execute.
  • 5: The task step has project scope and is in progress.
compTransitionIdintegerThe internal ID of the transition taken from this step when it was completed.
transitionNamestringThe name of the transition taken from this step when it was completed.
creationDatedateThe date when the task step was created.
dueDatedateThe date when the task step is due (optional).
expectedDurationintegerThe number of hours the task step is expected to take to complete (optional).
startDatedateThe date when the task step began executing.
completionDatedateThe date when the task step was completed.
vendorIdintegerThe internal ID of the vendor to whom the step is assigned.
vendorNamestringThe name of the vendor to whom the step is assigned.
stepNamestringThe name of the step (for example, Translate).
stepTypestringThe type of the step (Start, Finish, Human, Automatic, Sub-Workflow, Parallel Review, Automatic Error, or Cancel).

activeTaskHistoryEntries

A record of relevant events with time stamps for tasks in active and recently completed projects:
ColumnTypeDescription
taskHistEntryIdintegerThe internal ID of the history entry.
taskIdintegerA reference into the archiveTasks table, indicating the task to which the history entry applies.
theDatedateThe date of an event.
eventTypeintegerThe event that occurred. One of the following values:
  • 1: Task started
  • 2: Task completed
  • 3: Task canceled
  • 4: Task step claimed
  • 5: Task step executed
  • 6: Task step completed
  • 7: Task step un-claimed
  • 8: Sub-task started
  • 9: Sub-task completed
  • 10: Task assignees modified
  • 11: Task assets exported
  • 12: Task assets imported
  • 13: Task branched
  • 14: Sub-task canceled
userIdintegerThe unique ID of the user who performed the event, if relevant.
theCommentstringA user-provided comment for the event (optional).

activeProjectCustomAttributes

Custom attributes and values for active and recently completed WorldServer projects. Attributes with multiple values will have multiple rows in this table for the same attribute and project:
ColumnTypeDescription
projectIdintegerA reference into the activeProjects view, indicating the project whose custom attribute this is.
namestringThe name of the custom attribute.
uiNamestringThe UI display name of the custom attribute.
valuestringThe string value of the attribute.
valueClobstringThe value of the character large object (CLOB) for the attribute.

activeTasksCustomAttributes

Custom attributes and values for tasks in active and recently completed WorldServer projects. Attributes with multiple values will have multiple rows in this table for the same attribute and task:
ColumnTypeDescription
taskIdintegerA reference into the activeTasks view, indicating the task whose custom attribute this is.
namestringThe name of the custom attribute.
uiNamestringThe UI display name of the custom attribute.
valuestringThe string value of the attribute.
valueClobstringThe value of the character large object (CLOB) for the attribute.

activeVendorCustomAttributes

Custom attributes and values for vendors associated with active and recently completed projects. Attributes with multiple values will have multiple rows in this table for the same attribute and vendor:
ColumnTypeDescription
vendorIdintegerA reference matching the vendorId column in the activeCostModels view, indicating the vendor whose custom attribute this is.
projectIdintegerA reference into the activeProjects table, indicating the project the vendor is associated with.
namestringThe name of the custom attribute.
uiNamestringThe UI display name of the custom attribute.
valueClobstringThe value of the CLOB for the attribute.
valuestringThe string value of the attribute.

Active reporting schema diagram

The following diagram shows the relationships between active reporting tables:A diagram that shows the relationships between active reporting tables.