Documentation Center

Active Reporting Tables

The 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 reports built on them will continue to work across future WorldServer versions.

The active views do not show historical information. Information about projects and tasks that complete will be available in these tables for a short time (by default, 15 days, but this is configurable), 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 this Project Group.
namestringThe name of this Project Group.
descriptionstringThe description of this Project Group (optional).
workgroupIdintegerThe internal ID of the Workgroup with which this Project Group is associated.
workgroupNamestringThe name of the Workgroup with which this Project Group is associated.
creationDatedateWhen this Project Group was created.
dueDatedateWhen this 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.
completionDatedateWhen this Project Group was completed. Not set if the Project Group is still active.
creatorIdintegerThe internal ID of the user who created this Project Group.
creatorNamestringThe username of the user who created this Project Group.
typeintegerIgnored.

activeProjects

Information about active and recently completed WorldServer Projects.

ColumnTypeDescription
projectIdintegerThe internal ID of this Project. Primary key.
namestringThe name of this Project.
descriptionstringThe description of this Project (optional).
localeIdintegerThe internal ID of the target Locale for this Project.
localeNamestringThe name of the target Locale for this Project.
workgroupIdintegerThe internal ID of the Workgroup with which this Project is associated.
workgroupNamestringThe name of the Workgroup with which this Project is associated.
creationDatedateWhen this Project was created.
dueDatedateWhen this Project is due (optional).
completionDatedateWhen this Project was completed. Not set if the Project is still active.
creatorIdintegerThe internal ID of the user who created this Project.
creatorNamestringThe username of the user who created this 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 part of.
activeTasksintegerThe number of active Tasks in this Project.
completedTasksintegerThe number of completed Tasks in this Project.
canceledTasksintegerThe number of canceled Tasks in this Project.
totalTasksintegerThe total number of Tasks in this Project, regardless of state.
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 this Cost Model.
projectIdintegerA reference into the activeProjects view, identifying the Project that this Cost Model applies to.
nameintegerThe name of this Cost Model.
sourceLocaleIdintegerThe internal ID of the source locale this Cost Model applies to.
sourceLocalestringThe name of the source locale this Cost Model applies to.
targetLocaleIdintegerThe internal ID of the target locale this Cost Model applies to.
targetLocalestringThe name of the target locale this Cost Model applies to
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 matched word.
repititionPricedoubleThe 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 this Cost Model (optional).
vendorNamestringThe name of the vendor associated with this Cost Model (optional).
vendorDescriptionstringThe description of the vendor associated with this Cost Model (optional).
vendorContactNamestringThe contact name for the vendor associated with this Cost Model (optional).
vendorContactPhonestringThe contact phone number for the vendor associated with this Cost Model (optional).
vendorContactEmailstringThe contact email address for the vendor associated with this Cost Model (optional).
vendorOtherContactstringOther contact details for the vendor associated with this Cost Model (optional).
vendorAddressstringThe street address for the vendor associated with this Cost Model (optional).
vendorNotesstringNotes for the vendor associated with this Cost Model (optional).
scopingConfigNamestringThe name of the scoping configuration associated with this Cost Model.
scopingConfigDescriptionstringThe description of the scoping configuration associated with this Cost Model.
defaultScopingConfigurationbooleanIndicates whether the description of the scoping configuration associated with this Cost Model.

activeCostModelFuzzyPrices

Information about prices for words with fuzzy translation memory matches in Cost Models associated with active and recently completed Projects. This views has several rows for each cost model, giving the price for each scoping bucket (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 this pricing applies to.
sourceLocalestringThe name of the source locale this pricing applies to.
sourceLocaleIdintegerThe internal ID of the source locale this pricing applies to.
targetLocalestringThe name of the target locale this pricing applies to.
targetLocaleIdintegerThe internal ID of the target locale this pricing applies to.
scopingRangeMinintegerThe lower bound on the scoping range this pricing applies to.
scopingRangeMaxintegerThe upper bound on the scoping range this pricing applies to
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 this Line Item.
costModelIdintegerA reference into the activeCostModels view, indicating the Cost Model this line item applies to.
namestringThe name of this Line Item.
descriptionstringThe description of this Line Item.
projectIdintegerA reference into the activeProjects view, indicating the Project this line item applies to.

activeTasks

Information about Tasks in active and recently completed WorldServer Projects.

ColumnTypeDescription
taskIdintegerThe internal ID of this Task.
projectIdintegerA reference into the activeProjects view, indicating the Project this Task is part of.
workflowIdintegerThe internal ID of the workflow that this Task is flowing through.
workflowNamestringThe name of the workflow that this Task is flowing through.
stepCountintegerThe ordinal step number of the currently active Task Step.
parentIdintegerIf 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.
parentStepCountintegerIf 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.
statusintegerIndicates the last event of interest that happened with this Task. One of the following values:
  • 1: Editing / translation is in progress for this Task.
  • 2: This 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 this Task in the associated Project.
creationDatedateWhen this Task was created.
dueDatedateWhen this Task is due (optional).
expectedDurationintegerThe number of hours the Task is expected to take to complete (optional).
completionDatedateWhen the Task was completed.
completionStatusintegerIndicates the status of this 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 this Task.
includeInCostbooleanShould this Task’s cost be included in the total cost for 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 this Task with an MT match.
iceWordCountintegerThe number of words processed by this Task with a TM ICE match. Not set if the task never caused an asset to be segmented.
perfectWordCountintegerThe number of words processed by this Task with a 100% TM match. Not set if the task never caused an asset to be segmented.
repetitionWordCountintegerThe number of words processed by this Task with a TM repetition. Not set if the task never caused an asset to be segmented.
creatorNamestringThe username of the user who created this task.
scopingConfigNamestringThe name of the associated scoping configuration.
scopingConfigDescriptionstringThe description of the scoping configuration associated with this Cost Model.
defaultScopingConfigurationstringIndicates whether the description of the scoping configuration associated with this Cost Model.
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 views has several rows for each Task, giving the word count for each scoping bucket.

ColumnTypeDescription
taskIdintegerA reference into the activeTasks view, indicating the Task this word count applies to.
scopingRangeMinintegerThe lower bound on the scoping range this word count applies to.
scopingRangeMaxintegerThe upper bound on the scoping range this word count applies to.
wordCountitegerThe number of words processed by this Task.

activeTaskSteps

Information about each step encountered to far during processing of Tasks in active and recently completed Projects.

ColumnTypeDescription
taskStepIdintegerThe internal ID of this TaskStep.
taskIdintegerA reference into the activeTasks view, indicating the Task this Task Step is part of.
workflowStepIdintegerThe internal ID of the workflow step that this Task Step corresponds to.
claimaintIdintegerThe internal ID of the user who has claimed this Task Step.
claimantNamestringThe username of the user who has claimed this Task Step.
statusinteger
  • 1: This Task Step has not yet started.
  • 2: This Task Step is in progress.
  • 3: This Task Step has been completed.
  • 4: This Task Step has project scope and is waiting to execute.
  • 5: This Task Step has project scope and is in progress.
compTransitionIdintegerThe internal ID of the transition taken from this step when it completed.
transitionNamestringThe name of the transition taken from this step when it completed.
creationDatedateWhen this Task Step was created.
dueDatedateWhen this Task Step is due (optional).
expectedDurationintegerThe number of hours the Task Step is expected to take to complete (optional).
startDatedateWhen the Task Step began executing.
completionDatedateWhen the Task Step was completed.
vendorIdintegerThe internal ID of the Vendor who this step is assigned to.
vendorNamestringThe name of the Vendor who this step is assigned to.
stepNamestringThe name of this step (for example, “Translate”).
stepTypestringThe type of this step (one of Start, Finish, Human, Automatic, Sub-Workflow, Parallel Review, Automatic Error, or Cancel).

activeTaskHistoryEntries

A record of interesting events with timestamps for Tasks in active and recently completed Projects.

ColumnTypeDescription
taskHistEntryIdintegerThe internal ID of this History Entry.
taskIdintegerA reference into the archiveTasks table, indicating the Task this History Entry applies to.
theDateDateThe date of a historical event.
eventTypeintegerThe event that occurred, one of the following possible 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 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 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.
projectId.integerA reference into the activeProjects table, indicating the Project this Vendor is associated with
namestringThe name of the custom attribute.
uiNamestringThe UI display name of the custom attribute.
valueClobstringThe CLOB for the attribute.
valuestringThe string value of the attribute.

Active Reporting Schema Diagram

The following figure shows the relationships between the active reporting tables.

Figure 1. Active Reporting Schema