> 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.

# [Beta] Procedures

## Definitions

| Term                             | Definition                                                                                                                                                                                                                                                              |
| -------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Procedure                        | A template for the recipe or assay. Lives in a template collection.                                                                                                                                                                                                     |
| Method                           | Unit operation                                                                                                                                                                                                                                                          |
| Parameter                        | Material input, material output, equipment, or parameter. The parameter_type column disambiguates between the four. Data parameters are just referred to as "parameters" in the UI.                                                                                     |
| Parameter Library                | Library of configurable parameters that can be used within a procedure.                                                                                                                                                                                                 |
| Procedure run plan               | Recipe Run Plans (for Process Development Studies) and Assay Run Plans (for Assay-based Studies) are both saved as Procedure run plans in the warehouse. This is essentially a draft procedure run. It becomes a procedure run (Recipe Run or Assay Run) once promoted. |
| Process flowchart config version | The ID of the specific version of the Recipe or Assay that will be used for this planned run (or was used in the case of a promoted run plan)                                                                                                                           |

## Table Overviews

| Name                                                  | \$raw Filters                 | Description                                                                                                                                                                                                                                                            |
| ----------------------------------------------------- | ----------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `bnch$procedure_run$beta`                             | archived\$ column is not True | Lists all executions of a procedure                                                                                                                                                                                                                                    |
| `bnch$procedure_method_execution_instance_assoc$beta` |                               |                                                                                                                                                                                                                                                                        |
| `bnch$procedure_method_execution_instance$beta`       | archived\$ column is not True |                                                                                                                                                                                                                                                                        |
| `bnch$procedure_method_task_transition$beta`          |                               |                                                                                                                                                                                                                                                                        |
| `bnch$procedure_step_execution_instance$beta`         | archived\$ column is not True |                                                                                                                                                                                                                                                                        |
| `bnch$parameter_planned_value$beta`                   |                               | The expected value for a parameter for a particular procedure run                                                                                                                                                                                                      |
| `bnch$parameter_confirmation_value$beta`              |                               | The confirmed value for a parameter for a particular procedure run, filled in by the operator                                                                                                                                                                          |
| `bnch$parameter_measured_value$beta`                  |                               | The measured value of a parameter during the course of executing a procedure                                                                                                                                                                                           |
| `bnch$parameter_value_plate_well$beta`                |                               |                                                                                                                                                                                                                                                                        |
| `bnch$procedure_run_condition$beta`                   |                               |                                                                                                                                                                                                                                                                        |
| `bnch$procedure_run_condition_replicate$beta`         |                               | A single replicate of a condition. The UI doesn't have a singular term for this.                                                                                                                                                                                       |
| `bnch$procedure_method_condition_replicate$beta`      |                               |                                                                                                                                                                                                                                                                        |
| `bnch$library_parameter_definition$alpha`             |                               | Lists all the parameter library definitions                                                                                                                                                                                                                            |
| `bnch$procedure_run_plan$beta`                        |                               | Recipe Run Plans (for Process Development Studies) and Assay Run Plans (for Assay-based Studies) are both saved as Procedure run plans in the warehouse.This is essentially a draft procedure run. It becomes a procedure run (Recipe Run or Assay Run) once promoted. |
| `bnch$procedure_run_plan_condition$beta`              |                               | A single condition in a single Procedure run plan.                                                                                                                                                                                                                     |
| `bnch$run_plan_parameter_planned_value$beta`          |                               | A planned link from a to-be-created unit operation instance to an actual unit operation instance.These planned links become rows in `bnch$procedure_method_execution_instance_assoc$beta` once a procedure run is promoted.                                            |
| `bnch$proc_run_plan_condition_replicate$beta`         |                               | A single replicate within a Procedure run plan condition.                                                                                                                                                                                                              |
| `bnch$proc_run_plan_cond_repl_src_mapping$beta`       |                               | A planned link from a to-be-created unit operation instance to an actual unit operation instance.These planned links become rows in `bnch$procedure_method_execution_instance_assoc$beta` once a procedure run is promoted.                                            |

### `bnch$procedure_run$beta` \[#bnchprocedure_runbeta]

This object lives in a project and has method execution instances that are associated with Workflow tasks that the user will work through. Also referred to as an experiment run in the UI.

| Table Row         | Definition                                                                           | Value Type                                                          | Example values (if applicable)                             | Notes                                     |
| ----------------- | ------------------------------------------------------------------------------------ | ------------------------------------------------------------------- | ---------------------------------------------------------- | ----------------------------------------- |
| id                | Unique Benchling-prescribed ID for each line item in table                           | Character Varying                                                   | pcr_oPQS40h3                                               | Primary key for a table                   |
| creator_id        | Unique identifier for creator of object                                              | Foreign key for [user](/docs/wh-users-teams-projects#principal).id  | ent_yXrL3BjX                                               |                                           |
| source_id         | The id of the project that the object's permissions comes from                       | Foreign key for [project](/docs/wh-users-teams-projects#project).id | src_hh9ffHqV                                               |                                           |
| name              | Name of object in Benchling                                                          | Character Varying                                                   | Transfection Entry, QC Results, Therapeutic Cell Line, etc |                                           |
| description       | Description of object in Benchling                                                   | Character Varying                                                   |                                                            |                                           |
| created_at        | Created date for object                                                              | Timestamp without timezone                                          | 2024-08-20T14:53:15.458544                                 |                                           |
| modified_at       | Most recent modified date for object                                                 | Timestamp without timezone                                          | 2024-08-23T13:34:03.96262                                  |                                           |
| study_id          | Unique identifier for the parent study of the procedure run                          | Foreign key for [study](/docs/wh-studies#study-bnchstudy).id        | stdy_iG0LW1XU                                              |                                           |
| procedure_id      | Unique identifier for the template procedure that the procedure run was created from | Character Varying                                                   | pc_aX3ST2SH                                                |                                           |
| archived\$        | Archival state for object in Benchling                                               | Boolean                                                             | TRUE, FALSE                                                | True indicates the object is archived     |
| archive_purpose\$ | Archival reason for object in Benchling                                              | Text                                                                | null, Made in Error, Retired, Other, etc                   | null indicates the object is not archived |

### `bnch$procedure_method_execution_instance_assoc$beta` \[#bnchprocedure_method_execution_instance_assocbeta]

| Table Row                                     | Definition                                                       | Value Type                                                                                                                | Example values (if applicable) | Notes                   |
| --------------------------------------------- | ---------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------- | ------------------------------ | ----------------------- |
| id                                            | Unique Benchling-prescribed ID for each line item in table       | Character Varying                                                                                                         | pcmeiasn_gRzqEGdo              | Primary key for a table |
| source_id                                     | The id of the project that the object's permissions comes from   | Foreign key for [project](/docs/wh-users-teams-projects#project).id                                                       | src_hh9ffHqV                   |                         |
| created_at                                    | Created date for object                                          | Timestamp without timezone                                                                                                | 2024-08-20T14:53:15.458544     |                         |
| modified_at                                   | Most recent modified date for object                             | Timestamp without timezone                                                                                                | 2024-08-23T13:34:03.96262      |                         |
| source_procedure_method_execution_instance_id | Unique identifier for source procedure method execution instance | Foreign key for [procedure method execution instance](/docs/wh-procedures#bnchprocedure_method_execution_instancebeta).id | pcmei_gLZqJzcl                 |                         |
| target_procedure_method_execution_instance_id | Unique identifier for target procedure method execution instance | Foreign key for [procedure method execution instance](/docs/wh-procedures#bnchprocedure_method_execution_instancebeta).id | pcmei_zsGLtpSo                 |                         |

### `bnch$procedure_method_execution_instance$beta` \[#bnchprocedure_method_execution_instancebeta]

| Table Row         | Definition                                                     | Value Type                                                           | Example values (if applicable)                             | Notes                                     |
| ----------------- | -------------------------------------------------------------- | -------------------------------------------------------------------- | ---------------------------------------------------------- | ----------------------------------------- |
| id                | Unique Benchling-prescribed ID for each line item in table     | Character Varying                                                    | pcmei_Bz5Dlmu5                                             | Primary key for a table                   |
| source_id         | The id of the project that the object's permissions comes from | Foreign key for [project](/docs/wh-users-teams-projects#project).id  | src_hh9ffHqV                                               |                                           |
| 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                                           | 2024-08-20T14:53:15.458544                                 |                                           |
| modified_at       | Most recent modified date for object                           | Timestamp without timezone                                           | 2024-08-23T13:34:03.96262                                  |                                           |
| procedure_run_id  | Unique identifier for parent procedure run                     | Character Varying                                                    | pcr_gLZqJzcl                                               |                                           |
| workflow_task_id  | Unique identifier for associated Workflow task                 | Foreign key for [workflow_task](/docs/wh-workflows#workflow_task).id | wftask_gLZqJzcl                                            |                                           |
| worksheet_id      | Unique identifier for associated worksheet                     | Foreign key for worksheet.id                                         | wks_gLZqJzcl                                               |                                           |
| archived\$        | Archival state for object in Benchling                         | Boolean                                                              | TRUE, FALSE                                                | True indicates the object is archived     |
| archive_purpose\$ | Archival reason for object in Benchling                        | Text                                                                 | null, Made in Error, Retired, Other, etc                   | null indicates the object is not archived |

### `bnch$procedure_method_task_transition$beta` \[#bnchprocedure_method_task_transitionbeta]

| Table Row                    | Definition                                                                                                     | Value Type                                                                                                                | Example values (if applicable)                | Notes                   |
| ---------------------------- | -------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------- | ----------------------- |
| id                           | Unique Benchling-prescribed ID for each line item in table                                                     | Character Varying                                                                                                         | ent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etc | Primary key for a table |
| source_id                    | The id of the project that the object's permissions comes from                                                 | Foreign key for [project](/docs/wh-users-teams-projects#project).id                                                       | src_hh9ffHqV                                  |                         |
| method_execution_instance_id | Unique identifier for the associated method execution instance                                                 | Foreign key for [procedure_method_execution_instance](/docs/wh-procedures#bnchprocedure_method_execution_instancebeta).id | pmei_hh9ffHqV                                 |                         |
| transitioned_at              | Time entered when the associated Workflow task was transitioned to the status specified in status_display_name | Timestamp without timezone                                                                                                | 2019-12-06T23:24:44.885478                    |                         |
| status_display_name          | Status of Workflow task associated with the method                                                             | Character Varying                                                                                                         | In progress, Failed, Skipped                  |                         |
| comment                      | Comment, if any, associated with transitioning (starting, completing, skipping, or failing) the method         | Character Varying                                                                                                         | Delayed                                       |                         |

### `bnch$procedure_step_execution_instance$beta` \[#bnchprocedure_step_execution_instancebeta]

| Table Row         | Definition                                                     | Value Type                                                           | Example values (if applicable)                             | Notes                                     |
| ----------------- | -------------------------------------------------------------- | -------------------------------------------------------------------- | ---------------------------------------------------------- | ----------------------------------------- |
| id                | Unique Benchling-prescribed ID for each line item in table     | Character Varying                                                    | pcsei_bwmh3o3s                                             | Primary key for a table                   |
| source_id         | The id of the project that the object's permissions comes from | Foreign key for [project](/docs/wh-users-teams-projects#project).id  | src_hh9ffHqV                                               |                                           |
| 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                                           | 2024-08-20T14:53:15.458544                                 |                                           |
| modified_at       | Most recent modified date for object                           | Timestamp without timezone                                           | 2024-08-23T13:34:03.96262                                  |                                           |
| position          | Zero-indexed position of the step within a step group          | Integer                                                              | 0, 1                                                       |                                           |
| step_group_type   | Type of the parent step group                                  | Character Varying                                                    | PRE_RUN, RUN                                               |                                           |
| workflow_task_id  | Unique identifier for associated Workflow task                 | Foreign key for [workflow_task](/docs/wh-workflows#workflow_task).id | wftask_gLZqJzcl                                            |                                           |
| archived\$        | Archival state for object in Benchling                         | Boolean                                                              | TRUE, FALSE                                                | True indicates the object is archived     |
| archive_purpose\$ | Archival reason for object in Benchling                        | Text                                                                 | null, Made in Error, Retired, Other, etc                   | null indicates the object is not archived |

### `bnch$parameter_planned_value$beta` \[#bnchparameter_planned_valuebeta]

| Table Row                    | Definition                                                                                                 | Value Type                                                                                                                | Example values (if applicable)                             | Notes                   |
| ---------------------------- | ---------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------- | ----------------------- |
| id                           | Unique Benchling-prescribed ID for each line item in table                                                 | Character Varying                                                                                                         | ppvdp_IBZ9BA8G                                             | Primary key for a table |
| source_id                    | The id of the project that the object's permissions comes from                                             | Foreign key for [project](/docs/wh-users-teams-projects#project).id                                                       | src_hh9ffHqV                                               |                         |
| name                         | Name of object in Benchling                                                                                | Character Varying                                                                                                         | Transfection Entry, QC Results, Therapeutic Cell Line, etc |                         |
| creator_id                   | Unique identifier for creator of object                                                                    | Foreign key for [user](/docs/wh-users-teams-projects#principal).id                                                        | ent_yXrL3BjX                                               |                         |
| created_at                   | Created date for object                                                                                    | Timestamp without timezone                                                                                                | 2024-08-20T14:53:15.458544                                 |                         |
| modified_at                  | Most recent modified date for object                                                                       | Timestamp without timezone                                                                                                | 2024-08-23T13:34:03.96262                                  |                         |
| method_execution_instance_id | Unique identifier for the associated method execution instance                                             | Foreign key for [procedure_method_execution_instance](/docs/wh-procedures#bnchprocedure_method_execution_instancebeta).id | pmei_hh9ffHqV                                              |                         |
| parameter_type               | Parameter type of the parent parameter                                                                     | Character Varying                                                                                                         | EQUIPMENT, MATERIAL_INPUT, MATERIAL_OUTPUT, DATA_PARAMETER |                         |
| parameter_id                 | Unique identifier for the parent parameter                                                                 | Character Varying                                                                                                         | pcparam_cCO8Dvfc                                           |                         |
| value                        | The planned value for the parameter                                                                        | JSON value                                                                                                                | 350, null, bfi_GuPYFZQH, water                             |                         |
| type                         | Data type of the parent parameter version                                                                  | Character Varying                                                                                                         | entity_link, text, float                                   |                         |
| unit_id                      | Unique identifier for the unit associated with the parent parameter version                                | Foreign key for [unit](/docs/wh-results-runs#bnchunit).id                                                                 | null, unit_aWP1Asqp                                        |                         |
| amount                       | The planned amount for a material input. Will always be null for other parameter types.                    | Floating point                                                                                                            | null, 4.2                                                  |                         |
| amount_unit_id               | Unique identifier for the amount unit for a material input. Will always be null for other parameter types. | Foreign key for [unit](/docs/wh-results-runs#bnchunit).id                                                                 | null, unit_aWP1Asqp                                        |                         |
| container_id                 | Unique identifier for the associated container                                                             | Foreign key for [container](/docs/wh-inventory#container).id                                                              | null, con_wQM2Lshs                                         |                         |

### `bnch$parameter_confirmation_value$beta` \[#bnchparameter_confirmation_valuebeta]

| Table Row                    | Definition                                                                                                 | Value Type                                                                                                                | Example values (if applicable)                             | Notes                                        |
| ---------------------------- | ---------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------- | -------------------------------------------- |
| id                           | Unique Benchling-prescribed ID for each line item in table                                                 | Character Varying                                                                                                         | ppvdc_CKErwORT                                             | Primary key for a table                      |
| source_id                    | The id of the project that the object's permissions comes from                                             | Foreign key for [project](/docs/wh-users-teams-projects#project).id                                                       | src_hh9ffHqV                                               |                                              |
| name                         | Name of object in Benchling                                                                                | Character Varying                                                                                                         | Transfection Entry, QC Results, Therapeutic Cell Line, etc |                                              |
| creator_id                   | Unique identifier for creator of object                                                                    | Foreign key for [user](/docs/wh-users-teams-projects#principal).id                                                        | ent_yXrL3BjX                                               |                                              |
| created_at                   | Created date for object                                                                                    | Timestamp without timezone                                                                                                | 2024-08-20T14:53:15.458544                                 |                                              |
| modified_at                  | Most recent modified date for object                                                                       | Timestamp without timezone                                                                                                | 2024-08-23T13:34:03.96262                                  |                                              |
| method_execution_instance_id | Unique identifier for the associated method execution instance                                             | Foreign key for [procedure_method_execution_instance](/docs/wh-procedures#bnchprocedure_method_execution_instancebeta).id | pmei_hh9ffHqV                                              |                                              |
| parameter_type               | Parameter type of the parent parameter                                                                     | Character Varying                                                                                                         | EQUIPMENT, MATERIAL_INPUT, MATERIAL_OUTPUT, DATA_PARAMETER |                                              |
| parameter_id                 | Unique identifier for the parent parameter                                                                 | Character Varying                                                                                                         | pcparam_cCO8Dvfc                                           |                                              |
| value                        | The planned value for the parameter                                                                        | JSON value                                                                                                                | 350, null, bfi_GuPYFZQH, water                             |                                              |
| type                         | Data type of the parent parameter version                                                                  | Character Varying                                                                                                         | entity_link, text, float                                   |                                              |
| unit_id                      | Unique identifier for the unit associated with the parent parameter version                                | Foreign key for [unit](/docs/wh-results-runs#bnchunit).id                                                                 | null, unit_aWP1Asqp                                        |                                              |
| amount                       | The planned amount for a material input. Will always be null for other parameter types.                    | Floating point                                                                                                            | null, 4.2                                                  |                                              |
| amount_unit_id               | Unique identifier for the amount unit for a material input. Will always be null for other parameter types. | Foreign key for [unit](/docs/wh-results-runs#bnchunit).id                                                                 | null, unit_aWP1Asqp                                        |                                              |
| container_id                 | Unique identifier for the associated container                                                             | Foreign key for [container](/docs/wh-inventory#container).id                                                              | null, con_wQM2Lshs                                         |                                              |
| recorded_at                  | The date/time that the parameter was confirmed, or for material inputs, was added                          | Timestamp without time zone                                                                                               | null, 2024-09-06T14:38:29                                  |                                              |
| comment                      | Comment, if any, associated with the parameter confirmation                                                | Character Varying                                                                                                         | Using more salt                                            | Blank comments are stored as an empty string |

### `bnch$parameter_measured_value$beta` \[#bnchparameter_measured_valuebeta]

| Table Row                    | Definition                                                                                                 | Value Type                                                                                                                | Example values (if applicable)                             | Notes                                        |
| ---------------------------- | ---------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------- | -------------------------------------------- |
| id                           | Unique Benchling-prescribed ID for each line item in table                                                 | Character Varying                                                                                                         | ppvda_psx3VtGY                                             | Primary key for a table                      |
| source_id                    | The id of the project that the object's permissions comes from                                             | Foreign key for [project](/docs/wh-users-teams-projects#project).id                                                       | src_hh9ffHqV                                               |                                              |
| name                         | Name of object in Benchling                                                                                | Character Varying                                                                                                         | Transfection Entry, QC Results, Therapeutic Cell Line, etc |                                              |
| creator_id                   | Unique identifier for creator of object                                                                    | Foreign key for [user](/docs/wh-users-teams-projects#principal).id                                                        | ent_yXrL3BjX                                               |                                              |
| created_at                   | Created date for object                                                                                    | Timestamp without timezone                                                                                                | 2024-08-20T14:53:15.458544                                 |                                              |
| modified_at                  | Most recent modified date for object                                                                       | Timestamp without timezone                                                                                                | 2024-08-23T13:34:03.96262                                  |                                              |
| method_execution_instance_id | Unique identifier for the associated method execution instance                                             | Foreign key for [procedure_method_execution_instance](/docs/wh-procedures#bnchprocedure_method_execution_instancebeta).id | pmei_hh9ffHqV                                              |                                              |
| parameter_type               | Parameter type of the parent parameter                                                                     | Character Varying                                                                                                         | EQUIPMENT, MATERIAL_INPUT, MATERIAL_OUTPUT, DATA_PARAMETER |                                              |
| parameter_id                 | Unique identifier for the parent parameter                                                                 | Character Varying                                                                                                         | pcparam_cCO8Dvfc                                           |                                              |
| value                        | The planned value for the parameter                                                                        | JSON value                                                                                                                | 350, null, bfi_GuPYFZQH, water                             |                                              |
| type                         | Data type of the parent parameter version                                                                  | Character Varying                                                                                                         | entity_link, text, float                                   |                                              |
| unit_id                      | Unique identifier for the unit associated with the parent parameter version                                | Foreign key for [unit](/docs/wh-results-runs#bnchunit).id                                                                 | null, unit_aWP1Asqp                                        |                                              |
| amount                       | The planned amount for a material input. Will always be null for other parameter types.                    | Floating point                                                                                                            | null, 4.2                                                  |                                              |
| amount_unit_id               | Unique identifier for the amount unit for a material input. Will always be null for other parameter types. | Foreign key for [unit](/docs/wh-results-runs#bnchunit).id                                                                 | null, unit_aWP1Asqp                                        |                                              |
| container_id                 | Unique identifier for the associated container                                                             | Foreign key for [container](/docs/wh-inventory#container).id                                                              | null, con_wQM2Lshs                                         |                                              |
| recorded_at                  | The date/time that the parameter was confirmed, or for material inputs, was added                          | Timestamp without time zone                                                                                               | null, 2024-09-06T14:38:29                                  |                                              |
| comment                      | Comment, if any, associated with the parameter confirmation                                                | Character Varying                                                                                                         | Using more salt                                            | Blank comments are stored as an empty string |

### `bnch$parameter_value_plate_well$beta` \[#bnchparameter_value_plate_wellbeta]

| Table Row                       | Definition                                                         | Value Type                                                                                                  | Example values (if applicable)                | Notes                   |
| ------------------------------- | ------------------------------------------------------------------ | ----------------------------------------------------------------------------------------------------------- | --------------------------------------------- | ----------------------- |
| id                              | Unique Benchling-prescribed ID for each line item in table         | Character Varying                                                                                           | ent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etc | Primary key for a table |
| source_id                       | The id of the project that the object's permissions comes from     | Foreign key for [project](/docs/wh-users-teams-projects#project).id                                         | src_hh9ffHqV                                  |                         |
| plate_id                        | Unique identifier for the plate                                    | Foreign key for [plate](/docs/wh-inventory#plate).id                                                        | plt_wQM2Lshs                                  |                         |
| parameter_confirmation_value_id | Unique identifier a confirmed parameter value                      | Foreign key for [parameter_confirmation_value](/docs/wh-procedures#bnchparameter_confirmation_valuebeta).id | ppvc_aWP1Asqp                                 |                         |
| parameter_planned_value_id      | Unique identifier a planned parameter value                        | Foreign key for [parameter_planned_value](/docs/wh-procedures#bnchparameter_planned_valuebeta).id           | ppvp_aWP1Asqp                                 |                         |
| well_position                   | Position of the plate well where the parameter value was confirmed | Character Varying                                                                                           | A3                                            |                         |

### `bnch$procedure_run_condition$beta` \[#bnchprocedure_run_conditionbeta]

| Table Row        | Definition                                                     | Value Type                                                                    | Example values (if applicable)                             | Notes                   |
| ---------------- | -------------------------------------------------------------- | ----------------------------------------------------------------------------- | ---------------------------------------------------------- | ----------------------- |
| id               | Unique Benchling-prescribed ID for each line item in table     | Character Varying                                                             | pcrc_V8dmqCiM                                              | Primary key for a table |
| source_id        | The id of the project that the object's permissions comes from | Foreign key for [project](/docs/wh-users-teams-projects#project).id           | src_hh9ffHqV                                               |                         |
| name             | Name of object in Benchling                                    | Character Varying                                                             | Transfection Entry, QC Results, Therapeutic Cell Line, etc |                         |
| description      | Description of the condition                                   | Character Varying                                                             | Control                                                    |                         |
| created_at       | Created date for object                                        | Timestamp without timezone                                                    | 2024-08-20T14:53:15.458544                                 |                         |
| modified_at      | Most recent modified date for object                           | Timestamp without timezone                                                    | 2024-08-23T13:34:03.96262                                  |                         |
| procedure_run_id | Unique identifier for the parent procedure run                 | Foreign key for [procedure_run](/docs/wh-procedures#bnchprocedure_runbeta).id | prc_wa2kjuQaQ                                              |                         |

### `bnch$procedure_run_condition_replicate$beta` \[#bnchprocedure_run_condition_replicatebeta]

| Table Row        | Definition                                                     | Value Type                                                          | Example values (if applicable) | Notes                   |
| ---------------- | -------------------------------------------------------------- | ------------------------------------------------------------------- | ------------------------------ | ----------------------- |
| id               | Unique Benchling-prescribed ID for each line item in table     | Character Varying                                                   | prcr_nuBvDwbn                  | Primary key for a table |
| source_id        | The id of the project that the object's permissions comes from | Foreign key for [project](/docs/wh-users-teams-projects#project).id | src_hh9ffHqV                   |                         |
| created_at       | Created date for object                                        | Timestamp without timezone                                          | 2024-08-20T14:53:15.458544     |                         |
| modified_at      | Most recent modified date for object                           | Timestamp without timezone                                          | 2024-08-23T13:34:03.96262      |                         |
| condition_id     | Unique identifier for the parent condition                     | Foreign key for procedure_run_condition.id                          | pcrc_wa2kjuQaQ                 |                         |
| replicate_number | Unique identifier for the replicate within the condition group | Integer                                                             | 1                              |                         |

### `bnch$procedure_method_condition_replicate$beta` \[#bnchprocedure_method_condition_replicatebeta]

| Table Row                            | Definition                                                                                               | Value Type                                                                                                                | Example values (if applicable)                | Notes                   |
| ------------------------------------ | -------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------- | ----------------------- |
| id                                   | Unique Benchling-prescribed ID for each line item in table                                               | Character Varying                                                                                                         | ent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etc | Primary key for a table |
| source_id                            | The id of the project that the object's permissions comes from                                           | Foreign key for [project](/docs/wh-users-teams-projects#project).id                                                       | src_hh9ffHqV                                  |                         |
| procedure_run_condition_replicate_id | Unique identifier for a specific replicate of a condition                                                | Foreign key for [procedure_run_condition_replicate](/docs/wh-procedures#bnchprocedure_run_condition_replicatebeta).id     | prcr_qHF3HNaT                                 |                         |
| method_execution_instance_id         | Unique identifier for the execution instance of a method (unit operation) for a replicate of a condition | Foreign key for [procedure_method_execution_instance](/docs/wh-procedures#bnchprocedure_method_execution_instancebeta).id | pcmei_Bz5Dlmu5                                |                         |

### `bnch$library_parameter_definition$alpha` \[#bnchlibrary_parameter_definitionalpha]

| Table Row    | Definition                                                 | Value Type                                                          | Example values (if applicable) | Notes                   |
| ------------ | ---------------------------------------------------------- | ------------------------------------------------------------------- | ------------------------------ | ----------------------- |
| id           | Unique Benchling-prescribed ID for each line item in table | Character Varying                                                   | pardef_vV99UJsKLd              | Primary key for a table |
| name         | Name of object in Benchling                                | Character Varying                                                   | Temperature                    |                         |
| description  | Description of object in Benchling                         | Character Varying                                                   |                                |                         |
| type         | Data type of the parameter                                 | Character Varying                                                   | float, datetime, text          |                         |
| unit_type_id | Unit type (mass, time, length, concentration etc)          | Foreign key for [unit_type](/docs/wh-results-runs#bnchunit_type).id | qnty_z8erUgSOcF                |                         |

### `bnch$procedure_run_plan$beta` \[#bnchprocedure_run_planbeta]

This is the draft version of a procedure run. Represents either a planned Recipe Run or Assay Run. Once the plan is promoted, procedure_run_id references the resulting procedure_run row.

| Table Row                               | Definition                                                                                                                                    | Value Type                       | Example values (if applicable)                                     | Notes                                                                                                                                               |
| --------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------- | ------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------- |
| id                                      | Unique Benchling-prescribed ID for each line item in table                                                                                    | Character Varying                | prp_aX3ST2SH                                                       | Primary key for a table                                                                                                                             |
| creator_id                              | Unique identifier for creator of object                                                                                                       | Foreign key for user.id          | ent_yXrL3BjX                                                       |                                                                                                                                                     |
| source_id                               | The id of the project that the object's permissions comes from                                                                                | Foreign key for project.id       | src_hh9ffHqV                                                       |                                                                                                                                                     |
| created_at                              | Created date for object                                                                                                                       | Timestamp without timezone       | 2024-08-20T14:53:15.458544                                         |                                                                                                                                                     |
| modified_at                             | Most recent modified date for object                                                                                                          | Timestamp without timezone       | 2024-08-23T13:34:03.96262                                          |                                                                                                                                                     |
| study_id                                | Unique identifier for the parent study of the procedure run plan                                                                              | Foreign key for study.id         | stdy_iG0LW1XU                                                      |                                                                                                                                                     |
| description                             | Description of the procedure run plan.                                                                                                        | Character Varying                |                                                                    | Becomes the description of the procedure run on promotion.                                                                                          |
| data_entry_mode                         | How data is entered across condition replicates during a procedure run                                                                        | Character Varying                | INDIVIDUAL_CONDITION_REPLICATES, ALL_CONDITION_REPLICATES_TOGETHER | INDIVIDUAL_CONDITION_REPLICATES creates one worksheet per condition-replicate; ALL_CONDITION_REPLICATES_TOGETHER creates a single shared worksheet. |
| process_flowchart_config_version_id     | The ID of the specific version of the Recipe or Assay that will be used for this planned run (or was used in the case of a promoted run plan) | Character Varying                | wffccv_gLZqJzcl                                                    |                                                                                                                                                     |
| procedure_run_id                        | Unique identifier for the procedure run started from this plan                                                                                | Foreign key for procedure_run.id | null, pcr_gLZqJzcl                                                 | null until a procedure run has been started from the plan.                                                                                          |
| confirmation_method_by_param_version_id | Mapping from parameter version id to the confirmation method that should be used for that parameter during execution                          | JSONB                            | `{"schver_abc123": "TABLE", "schver_def456": "PLATE_MAP"}`         | Values are TABLE (entered via a structured notebook table) or PLATE_MAP (entered via a plate-map layout, one value per well).                       |

### `bnch$procedure_run_plan_condition$beta` \[#bnchprocedure_run_plan_conditionbeta]

| Table Row                  | Definition                                                                                           | Value Type                                        | Example values (if applicable) | Notes                   |
| -------------------------- | ---------------------------------------------------------------------------------------------------- | ------------------------------------------------- | ------------------------------ | ----------------------- |
| id                         | Unique Benchling-prescribed ID for each line item in table                                           | Character Varying                                 | prpc_V8dmqCiM                  | Primary key for a table |
| source_id                  | The id of the project that the object's permissions comes from                                       | Foreign key for project.id                        | src_hh9ffHqV                   |                         |
| created_at                 | Created date for object                                                                              | Timestamp without timezone                        | 2024-08-20T14:53:15.458544     |                         |
| modified_at                | Most recent modified date for object                                                                 | Timestamp without timezone                        | 2024-08-23T13:34:03.96262      |                         |
| name                       | Name of the condition                                                                                | Character Varying                                 | Control, High pH, C1, V100     |                         |
| procedure_run_plan_id      | Unique identifier for the parent procedure run plan                                                  | Foreign key for `bnch$procedure_run_plan$beta`.id | prp_wa2kjuQaQ                  |                         |
| template_method_version_id | Unique identifier for the template procedure method definition version this value is planned against | Character Varying                                 | pcmdv_gLZqJzcl                 |                         |
| description                | Description of the condition                                                                         | Character Varying                                 | Testing high pH during culture |                         |

### `bnch$run_plan_parameter_planned_value$beta` \[#bnchrun_plan_parameter_planned_valuebeta]

Planned Parameters, Materials, and Equipment values are all stored in this "Parameters" table. The `parameter_type` column tells you which is which.

| Table Row                       | Definition                                                                                                 | Value Type                                                  | Example values (if applicable)                             | Notes                                                                                                                                                  |
| ------------------------------- | ---------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------- | ---------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ |
| id                              | Unique Benchling-prescribed ID for each line item in table                                                 | Character Varying                                           | prpc_V8dmqCiM_0_pcmdv_ABC123_schver_XYZ789_0               | Primary key for a table. Composite key composed of the condition id, template method version id, parameter version id, and a zero-indexed value index. |
| creator_id                      | Unique identifier for creator of object                                                                    | Foreign key for user.id                                     | ent_yXrL3BjX                                               |                                                                                                                                                        |
| source_id                       | The id of the project that the object's permissions comes from                                             | Foreign key for project.id                                  | src_hh9ffHqV                                               |                                                                                                                                                        |
| created_at                      | Created date for object                                                                                    | Timestamp without timezone                                  | 2024-08-20T14:53:15.458544                                 |                                                                                                                                                        |
| modified_at                     | Most recent modified date for object                                                                       | Timestamp without timezone                                  | 2024-08-23T13:34:03.96262                                  |                                                                                                                                                        |
| procedure_run_plan_id           | Unique identifier for the parent procedure run plan                                                        | Foreign key for `bnch$procedure_run_plan$beta`.id           | prp_wa2kjuQaQ                                              |                                                                                                                                                        |
| procedure_run_plan_condition_id | Unique identifier for the parent procedure run plan condition                                              | Foreign key for `bnch$procedure_run_plan_condition$beta`.id | prpc_wa2kjuQaQ                                             |                                                                                                                                                        |
| parameter_version_id            | Unique identifier for the parameter version this value is planned against                                  | Character Varying                                           | schver_gLZqJzcl                                            |                                                                                                                                                        |
| value_index                     | Zero-indexed position of this planned value within the parameter's planned values                          | Integer                                                     | 0, 1                                                       | Supports parameters that have more than one planned value.                                                                                             |
| name                            | Name of the parameter                                                                                      | Character Varying                                           | Temperature, Buffer, Plate Reader                          | For library-backed parameters, sourced from the library; otherwise sourced from the recipe.                                                            |
| parameter_type                  | Parameter type of the parameter                                                                            | Character Varying                                           | EQUIPMENT, MATERIAL_INPUT, MATERIAL_OUTPUT, DATA_PARAMETER | Parameters, Materials, and Equipment are all stored in this "Parameters" table. This column tells you which is which.                                  |
| type                            | Data type of the parent parameter version                                                                  | Character Varying                                           | entity_link, text, float                                   |                                                                                                                                                        |
| parameter_id                    | Unique identifier for the parent parameter                                                                 | Character Varying                                           | pcparam_cCO8Dvfc                                           |                                                                                                                                                        |
| parameter_library_id            | Unique identifier for the backing library parameter definition, if the parameter is library-backed         | Foreign key for library_parameter_definition.id             | null, pardef_vV99UJsKLd                                    | null when the parameter is not library-backed.                                                                                                         |
| value                           | The planned value for the parameter                                                                        | JSON value                                                  | 350, null, bfi_GuPYFZQH, water                             |                                                                                                                                                        |
| unit_id                         | Unique identifier for the unit associated with the parent parameter version                                | Foreign key for unit.id                                     | null, unit_aWP1Asqp                                        |                                                                                                                                                        |
| amount                          | The planned amount for a material input. Will always be null for other parameter types.                    | Floating point                                              | null, 4.2                                                  |                                                                                                                                                        |
| amount_unit_id                  | Unique identifier for the amount unit for a material input. Will always be null for other parameter types. | Foreign key for unit.id                                     | null, unit_aWP1Asqp                                        |                                                                                                                                                        |

### `bnch$proc_run_plan_condition_replicate$beta` \[#bnchproc_run_plan_condition_replicatebeta]

| Table Row                       | Definition                                                     | Value Type                                                  | Example values (if applicable) | Notes                                                                                                |
| ------------------------------- | -------------------------------------------------------------- | ----------------------------------------------------------- | ------------------------------ | ---------------------------------------------------------------------------------------------------- |
| id                              | Unique Benchling-prescribed ID for each line item in table     | Character Varying                                           | prpc_V8dmqCiM_1                | Primary key for a table. Composite key composed of the parent condition id and the replicate number. |
| source_id                       | The id of the project that the object's permissions comes from | Foreign key for project.id                                  | src_hh9ffHqV                   |                                                                                                      |
| procedure_run_plan_condition_id | Unique identifier for the parent procedure run plan condition  | Foreign key for `bnch$procedure_run_plan_condition$beta`.id | prpc_wa2kjuQaQ                 |                                                                                                      |
| replicate_number                | Unique identifier for the replicate within the condition       | Integer                                                     | 1, 2                           |                                                                                                      |

### `bnch$proc_run_plan_cond_repl_src_mapping$beta` \[#bnchproc_run_plan_cond_repl_src_mappingbeta]

Maps to-be-created Unit Operation instances to actual Unit Operation instances in the Study. These planned links become rows in `bnch$procedure_method_execution_instance_assoc$beta` once a procedure run is promoted.

| Table Row                                 | Definition                                                                                                                                    | Value Type                                                       | Example values (if applicable)            | Notes                                                                                                                                                                    |
| ----------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------- | ----------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| id                                        | Unique Benchling-prescribed ID for each line item in table                                                                                    | Character Varying                                                | prpc_V8dmqCiM_1_pcmdv_ABC123_pcmei_XYZ789 | Primary key for a table. Composite key composed of the replicate id, template procedure method definition version id, and source procedure method execution instance id. |
| source_id                                 | The id of the project that the object's permissions comes from                                                                                | Foreign key for project.id                                       | src_hh9ffHqV                              |                                                                                                                                                                          |
| procedure_run_plan_condition_replicate_id | Unique identifier for the parent planned condition replicate                                                                                  | Foreign key for `bnch$proc_run_plan_condition_replicate$beta`.id | prpc_V8dmqCiM_1                           |                                                                                                                                                                          |
| template_pmdv_id                          | Unique identifier for the template procedure method definition version being planned for this replicate                                       | Character Varying                                                | pcmdv_gLZqJzcl                            |                                                                                                                                                                          |
| source_method_execution_instance_id       | Unique identifier for the upstream source procedure method execution instance that will feed this replicate once a procedure run is promoted. | Character Varying                                                | pcmei_gLZqJzcl                            |                                                                                                                                                                          |