Requests

Table Overview

Name$raw FiltersDescription
request_schemaarchived$ column is not TrueLists all Request schemas
request_assigneeLists which users requests are assigned to
request_fulfillmentLists request execution status
request_sampleLists all samples assigned to requests

request_schema

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableCharacter Varyingent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
schema_typeSchema type selected for schema of objectTextentity, assay_result, assay_run, request, location, box, container, plate, batchSee Schema table for more information
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
parent_schema_idUnique identifier for schema which object is derived fromForeign key for schema.idts_XDQ0OW6s

request_assignee

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableCharacter Varyingent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry IDsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
request_idUnique identifier for the requestForeign key for request.idreq_qPtu1MSo
user_idUnique identifier for userForeign key for user.ident_yXrL3BjXSee User Table for more information
team_idUnique identifier for the assignee's teamForeign key for team.idteam_oh5xGqrm

request_fulfillment

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableCharacter Varyingent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or Registry IDsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
request_idUnique identifier for the requestForeign key for request.idreq_qPtu1MSo
sample_group_idID of the schemas designated for the requestForeign key for schema.idts_gUQdTwR7IDs can be for containers, entities, or batches
request_task_idUnique identifier for a task within a requestForeign key for task.idreqtsk_2nzie5Io
entry_idUnique identifier for EntryForeign key for entry.idetr_GtcscEZqSee Entry Table for more information
workflow_idUnique identifier for workflow containing objectForeign key for workflow.idwfw_DMcZhu4A
statusStatus for a request(requestor)IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLEDIN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED

request_sample

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableCharacter Varyingent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry IDsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
request_idUnique identifier for the requestForeign key for request.idreq_qPtu1MSo
sample_group_idID of the schemas designated for the requestForeign key for schema.idts_gUQdTwR7ID's can be for containers, entities, or batches
batch_idUnique identifier for batch objectForeign key for batch.idbat_Gs8PtV0KWhat batch is in the container
entity_idUnique identifier for entity objectForeign key for registry_entity.idbfi_cooUBrYb
container_idUnique ID for container objectForeign key for container.idcon_gQMDFBm4
field_nameDisplay name for field on schemaText"Date Sequenced"
row_indexRow position where container is locatedInteger5, 7, 12, etcContainer specific-must be in box

EXAMPLE task

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableCharacter Varyingreqtsk_eBVIOEhoPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or Registry IDsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
request_idUnique identifier for the requestForeign key for request.idreq_qPtu1MSo

EXAMPLE request

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableCharacter Varyingreq_qPtu1MSoPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry IDsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
schemaUnique Schema name for objectText"Fermentation Results"
created_at$Date created for objectTimestamp without timezone2019-12-06T23:24:44.885478
status$Status for a request fulfillmentIN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLEDIN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
display_id$Display name for object in BenchlingPrefix-unique numberrequest1, request2
url$URL for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit
scheduled_on$Date which the request is to be scheduled forDatetime1/8/20