Review Processes added to Warehouse

A number of new tables and table columns are being added to the warehouse to support review processes; expand to see more details about what’s been added.

What’s changing?

The Benchling warehouse now supports review process data, with the addition of new tables and table columns. The following tables have been added to support review processes:

• review_process - Table containing review processes
  • id - ID of the review process
  • current_version - Version ID of the current (most up to date) review process version
• project_review_process - Table containing project ↔ review process associations
  • id - ID of row
  • project_id - ID of project
  • review_process_id - ID of review process
• review_process_version - Table containing review process versions
  • id - ID of review process version
  • review_process_id - ID of review process associated with this version
  • created_at - Date row
  • name - Name of review process version
  • lifecycle_type - Type of review process
  • completion_state - Completion status of a review using review process
• review_process_stage - Table containing review process stages
  • id - ID of review process stage
  • name - Name of review process stage
  • action - Text of the action label when completing review process stage
  • review_process_version_id - ID of associated review process version

Additionally, a number of new columns have been added to the following tables:

• entry_auditor
  • review_process_stage_id - ID of review process stage auditor is assigned to
• entry
  • review_process_version_id - ID of review process version used in entry review

When is this happening?

These changes are now live; for more details on the changes or information on accessing the Benchling Warehouse, check out our Warehouse Guides.