> This page is for Developer Documentation.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.benchling.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.benchling.com/_mcp/server.

# Legacy Workflows

## 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](/docs/wh-users-teams-projects#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](https://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit) |                                                                                    |

### `workflow_template` \[#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` \[#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` \[#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](/docs/wh-users-teams-projects#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"                                           |                                                                                    |