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`

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`

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`

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`

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 months ago