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.
This page is for Developer Documentation.
Table Overview
| Name | $raw Filters | Description |
|---|---|---|
workflow | Lists all Legacy Workflows | |
workflow_template | Lists all Legacy Workflow Templates | |
workflow_template_version | Lists all versions of Legacy Workflow Templates | |
stage_run | Lists all stages for Legacy Workflows |
workflow
| Table Row | Definition | Value Type | Example values (if applicable) | Notes |
|---|---|---|---|---|
| id | Unique Benchling-prescribed ID for each line item in table | Format dependent on table | wfw_DMcZhu4A | Primary key for a table |
| source_id | The project or registry that the object’s permissions comes from | Foreign key for project.id or registry ID | src_hh9ffHqV | If an object isn’t in a project, the permissions will be derived from the Registry |
| alias | Unique identifier for the workflow, based on prefix and sequential number | Prefix-unique number | WF020 | |
| name | Name of object in Benchling | Character varying | Transfection Entry, QC Results, Therapeutic Cell Line, etc | |
| created_at | Created date for object | Timestamp without time zone | 2020-06-04T00:11:56.132400 | |
| description | Description given to object | Text | ”Fermentation Workflow” | |
| status | Status for a request(requestor) | IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED | IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED | |
| last_stage_completed | Name of last stage entry marked as complete | Text | ”Transformation” | |
| last_stage_completed_at | Timestamp of when status of last stage entry was marked as complete | Timestamp without timezone | 2019-12-06T23:24:44.885478 | |
| workflow_template_version_id | API ID of workflow template used to generate this workflow | Foreign key for workflow_template_version.id | wfwtmplv_0MjnYgSk | |
| url | URL for each object in Benchling | Browser URL | https://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit |
workflow_template
| Table Row | Definition | Value Type | Example values (if applicable) | Notes |
|---|---|---|---|---|
| id | Unique Benchling-prescribed ID for each line item in table | Format dependent on table | wfwtmpl_w6d11hNb | Primary key for a table |
| name | Name of object in Benchling | Character Varying | Transfection Entry, QC Results, Therapeutic Cell Line, etc |
workflow_template_version
| Table Row | Definition | Value Type | Example values (if applicable) | Notes |
|---|---|---|---|---|
| id | Unique Benchling-prescribed ID for each line item in table | Format dependent on table | wfwtmplv_0MjnYgSk | Primary key for a table |
| version | Version number for template | Integer | 1, 3, 65, etc | Auto-incremental when new workflow version is completed |
| workflow_template_id | Unique ID for workflow TEMPLATE | Foreign key for workflow_template.id | wfwtmpl_w6d11hNb |
stage_run
| Table Row | Definition | Value Type | Example values (if applicable) | Notes |
|---|---|---|---|---|
| id | Unique Benchling-prescribed ID for each line item in table | Format dependent on table | stgr_OvHALbNC | |
| source_id | The project or registry that the object’s permissions comes from | Foreign key for project.id or registry ID | src_hh9ffHqV | If an object isn’t in a project, the permissions will be derived from the Registry |
| name | Name of object in Benchling | Character Varying | Transfection Entry, QC Results, Therapeutic Cell Line, etc | |
| created_at | Created date for object | Timestamp without timezone | 2019-12-06T23:24:44.885478 | |
| stage_name | Stage name in Benchling | Text | ”Transfection” | |
| entry_id | Unique identifier for Entry | Foreign key for entry.id | etr_GtcscEZq | |
| workflow_id | Unique identifier for workflow containing object | Foreign key for workflow.id | wfw_DMcZhu4A | |
| status | Status for a request(requestor) | IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED | IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED | |
| exp_condition_values | Values available for Stage Experimental Conditions | Text | ”Condition”: “2” |