Requests
Table Overview
Name | $raw Filters | Description |
---|---|---|
request_schema | archived$ column is not True | Lists all Request schemas |
request_assignee | Lists which users requests are assigned to | |
request_fulfillment | Lists request execution status | |
request_sample | Lists all samples assigned to requests |
request_schema
request_schema
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 |
schema_type | Schema type selected for schema of object | Text | entity, assay_result, assay_run, request, location, box, container, plate, batch | See Schema table for more information |
name | Name of object in Benchling | Character Varying | Transfection Entry, QC Results, Therapeutic Cell Line, etc | |
parent_schema_id | Unique identifier for schema which object is derived from | Foreign key for schema.id | ts_XDQ0OW6s |
request_assignee
request_assignee
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 project or registry that the object's permissions comes from | Foreign key for project.id or registry ID | src_hh9ffHqV | If an object isn't in a project, the permissions will be derived from the Registry |
request_id | Unique identifier for the request | Foreign key for request.id | req_qPtu1MSo | |
user_id | Unique identifier for user | Foreign key for user.id | ent_yXrL3BjX | See User Table for more information |
team_id | Unique identifier for the assignee's team | Foreign key for team.id | team_oh5xGqrm |
request_fulfillment
request_fulfillment
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 project or registry that the object's permissions comes from | Foreign key for project.id or Registry ID | src_hh9ffHqV | If an object isn't in a project, the permissions will be derived from the Registry |
created_at | Created date for object | Timestamp without timezone | 2019-12-06T23:24:44.885478 | |
request_id | Unique identifier for the request | Foreign key for request.id | req_qPtu1MSo | |
sample_group_id | ID of the schemas designated for the request | Foreign key for schema.id | ts_gUQdTwR7 | IDs can be for containers, entities, or batches |
request_task_id | Unique identifier for a task within a request | Foreign key for task.id | reqtsk_2nzie5Io | |
entry_id | Unique identifier for Entry | Foreign key for entry.id | etr_GtcscEZq | See Entry Table for more information |
workflow_id | Unique identifier for workflow containing object | Foreign key for workflow.id | wfw_DMcZhu4A | |
status | Status for a request(requestor) | IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED | IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED |
request_sample
request_sample
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 project or registry that the object's permissions comes from | Foreign key for project.id or registry ID | src_hh9ffHqV | If an object isn't in a project, the permissions will be derived from the Registry |
request_id | Unique identifier for the request | Foreign key for request.id | req_qPtu1MSo | |
sample_group_id | ID of the schemas designated for the request | Foreign key for schema.id | ts_gUQdTwR7 | ID's can be for containers, entities, or batches |
batch_id | Unique identifier for batch object | Foreign key for batch.id | bat_Gs8PtV0K | What batch is in the container |
entity_id | Unique identifier for entity object | Foreign key for registry_entity.id | bfi_cooUBrYb | |
container_id | Unique ID for container object | Foreign key for container.id | con_gQMDFBm4 | |
field_name | Display name for field on schema | Text | "Date Sequenced" | |
row_index | Row position where container is located | Integer | 5, 7, 12, etc | Container specific-must be in box |
EXAMPLE task
Table Row | Definition | Value Type | Example values (if applicable) | Notes |
---|---|---|---|---|
id | Unique Benchling-prescribed ID for each line item in table | Character Varying | reqtsk_eBVIOEho | Primary key for a table |
source_id | The project or registry that the object's permissions comes from | Foreign key for project.id or Registry ID | src_hh9ffHqV | If an object isn't in a project, the permissions will be derived from the Registry |
request_id | Unique identifier for the request | Foreign key for request.id | req_qPtu1MSo |
EXAMPLE request
Table Row | Definition | Value Type | Example values (if applicable) | Notes |
---|---|---|---|---|
id | Unique Benchling-prescribed ID for each line item in table | Character Varying | req_qPtu1MSo | Primary key for a table |
source_id | The project or registry that the object's permissions comes from | Foreign key for project.id or registry ID | src_hh9ffHqV | If an object isn't in a project, the permissions will be derived from the Registry |
schema | Unique Schema name for object | Text | "Fermentation Results" | |
created_at$ | Date created for object | Timestamp without timezone | 2019-12-06T23:24:44.885478 | |
status$ | Status for a request fulfillment | IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED | IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED | |
display_id$ | Display name for object in Benchling | Prefix-unique number | request1, request2 | |
url$ | URL for each object in Benchling | Browser URL | https://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit | |
scheduled_on$ | Date which the request is to be scheduled for | Datetime | 1/8/20 |
Updated 3 days ago