[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
bnch$procedure_run$betaThis 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.id | ent_yXrL3BjX | |
| source_id | The id of the project that the object's permissions comes from | Foreign key for 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.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
bnch$procedure_method_execution_instance_assoc$beta| 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.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 executon instance .id | pcmei_gLZqJzcl | |
| target_procedure_method_execution_instance_id | Unique identifier for target procedure method execution instance | Foreign key for procedure method executon instance .id | pcmei_zsGLtpSo |
bnch$procedure_method_execution_instance$beta
bnch$procedure_method_execution_instance$beta| 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.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.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
bnch$procedure_method_task_transition$beta| 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.id | src_hh9ffHqV | |
| method_execution_instance_id | Unique identifier for the associated method execution instance | Foreign key for procedure_method_execution_instance.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
bnch$procedure_step_execution_instance$beta| 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.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.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
bnch$parameter_planned_value$beta| 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.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.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.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.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 | |
| container_id | Unique identifier for the associated container | Foreign key for container.id | null, con_wQM2Lshs |
bnch$parameter_confirmation_value$beta
bnch$parameter_confirmation_value$beta| 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.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.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.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.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 | |
| container_id | Unique identifier for the associated container | Foreign key for 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
bnch$parameter_measured_value$beta| 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.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.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.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.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 | |
| container_id | Unique identifier for the associated container | Foreign key for 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
bnch$parameter_value_plate_well$beta| 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.id | src_hh9ffHqV | |
| plate_id | Unique identifier for the plate | Foreign key for plate.id | plt_wQM2Lshs | |
| parameter_confirmation_value_id | Unique identifier a confirmed parameter value | Foreign key for parameter_confirmation_value.id | ppvc_aWP1Asqp | |
| parameter_planned_value_id | Unique identifier a planned parameter value | Foreign key for parameter_planned_value.id | ppvp_aWP1Asqp | |
| well_position | Position of the plate well where the parameter value was confirmed | Character Varying | A3 |
bnch$procedure_run_condition$beta
bnch$procedure_run_condition$beta| 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.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.id | prc_wa2kjuQaQ |
bnch$procedure_run_condition_replicate$beta
bnch$procedure_run_condition_replicate$beta| 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.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
bnch$procedure_method_condition_replicate$beta| 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.id | src_hh9ffHqV | |
| procedure_run_condition_replicate_id | Unique identifier for a specific replicate of a condition | Foreign key for procedure_run_condition_replicate.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.id | pcmei_Bz5Dlmu5 |
bnch$library_parameter_definition$alpha
bnch$library_parameter_definition$alpha| 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.id | qnty_z8erUgSOcF |
bnch$procedure_run_plan$beta
bnch$procedure_run_plan$betaThis is the draft version of a procedure run. Represents either a planned Recipe Run or Assay Run. Once a 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
bnch$procedure_run_plan_condition$beta| 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
bnch$run_plan_parameter_planned_value$beta 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
bnch$proc_run_plan_condition_replicate$beta| 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
bnch$proc_run_plan_cond_repl_src_mapping$beta 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 |
Updated 23 days ago
Did this page help you?