Skip to navigation

Legacy Workflows

Reference guide to legacy workflow data in the Benchling warehouse. This page explains the available tables and fields for older workflow models that may still appear in existing reporting pipelines.

Table Overview

Name$raw FiltersDescription
workflowLists all Legacy Workflows
workflow_templateLists all Legacy Workflow Templates
workflow_template_versionLists all versions of Legacy Workflow Templates
stage_runLists all stages for Legacy Workflows

workflow

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tablewfw_DMcZhu4APrimary key for a table
source_idThe project or registry that the object’s permissions comes fromForeign key for project.id or registry IDsrc_hh9ffHqVIf an object isn’t in a project, the permissions will be derived from the Registry
aliasUnique identifier for the workflow, based on prefix and sequential numberPrefix-unique numberWF020
nameName of object in BenchlingCharacter varyingTransfection Entry, QC Results, Therapeutic Cell Line, etc
created_atCreated date for objectTimestamp without time zone2020-06-04T00:11:56.132400
descriptionDescription given to objectText”Fermentation Workflow”
statusStatus for a request(requestor)IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLEDIN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
last_stage_completedName of last stage entry marked as completeText”Transformation”
last_stage_completed_atTimestamp of when status of last stage entry was marked as completeTimestamp without timezone2019-12-06T23:24:44.885478
workflow_template_version_idAPI ID of workflow template used to generate this workflowForeign key for workflow_template_version.idwfwtmplv_0MjnYgSk
urlURL for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit

workflow_template

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tablewfwtmpl_w6d11hNbPrimary key for a table
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc

workflow_template_version

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tablewfwtmplv_0MjnYgSkPrimary key for a table
versionVersion number for templateInteger1, 3, 65, etcAuto-incremental when new workflow version is completed
workflow_template_idUnique ID for workflow TEMPLATEForeign key for workflow_template.idwfwtmpl_w6d11hNb

stage_run

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tablestgr_OvHALbNC
source_idThe project or registry that the object’s permissions comes fromForeign key for project.id or registry IDsrc_hh9ffHqVIf an object isn’t in a project, the permissions will be derived from the Registry
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
stage_nameStage name in BenchlingText”Transfection”
entry_idUnique identifier for EntryForeign key for entry.idetr_GtcscEZq
workflow_idUnique identifier for workflow containing objectForeign key for workflow.idwfw_DMcZhu4A
statusStatus for a request(requestor)IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLEDIN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
exp_condition_valuesValues available for Stage Experimental ConditionsText”Condition”: “2”