Appendix C — Differences Ongoing/Closed Projects

Here you can see the differences in Field Type between closed and ongoing projects:

Module	Field name	Field Type Closed	Field Type Ongoing
action	TypeOfToxicityStudy	Recommended	Mandatory
action	RoleStudyLead	Optional	Recommended
assay_sheet	CellTypeOntologyID	Recommended	Mandatory
assay_sheet	CellProvider	Recommended	Mandatory
assay_sheet	CellLlineDesignationRRID	Optional	Recommended
assay_sheet	SerumCatalogueNumber	Optional	Recommended
assay_sheet	SerumSource	Optional	Recommended
assay_sheet	SerumLotNumber	Optional	Recommended
assay_sheet	PlateManufacturer	Optional	Recommended
assay_sheet	PlateProductNumber	Optional	Recommended
control_neg	NegativeControlCASRegistryName	Recommended	Mandatory
control_neg	NegativeControlCASRegistryNumber	Recommended	Mandatory
control_neg	NegativeControlSMILES	Optional	Recommended
control_neg	NegativeControlInChI	Optional	Recommended
control_neg	NegativeControlInChIKey	Optional	Recommended
control_neg	NegativeControlProductNumber	Optional	Recommended
control_neg	NegativeControlPortfolioBrand	Optional	Recommended
control_neg	NegativeControlBatchNumber	Optional	Recommended
control_neg	NegativeControlPurity	Optional	Recommended
control_pos	PositiveControlSMILES	Optional	Recommended
control_pos	PositiveControlInChI	Optional	Recommended
control_pos	PositiveControlInChIKey	Optional	Recommended
control_pos	PositiveControlProductNumber	Optional	Recommended
control_pos	PositiveControlPortfolioBrand	Optional	Recommended
control_pos	PositiveControlBatchNumber	Optional	Recommended
control_pos	PositiveControlPurity	Optional	Recommended
investigation	RepositoryWeblink	Conditionally required	Recommended
investigation	Publication	Mandatory	Recommended
investigation	PublicationLink	Mandatory	Recommended
test_substance	InChI	Optional	Recommended
test_substance	InChIKey	Optional	Recommended
test_substance	ProductNumber	Optional	Mandatory
test_substance	BatchNumber	Optional	Mandatory
test_substance	StorageTemperature	Optional	Mandatory
test_substance	SolventProductNumber	Optional	Recommended
test_substance	SolventBatchNumber	Optional	Recommended
test_substance	SolventPurity	Optional	Recommended
test_substance	StockAliquotStorageConditions	Optional	Mandatory

Differences in Mandatory fields between closed and ongoing projects:

# Count per Module number of times Field Type Closed is Mandatory and Field Type Ongoing is Mandatory
data |>
  group_by(Module) |>
  summarise(
    `Mandatory Closed` = sum(`Field Type Closed` == "Mandatory"),
    `Mandatory Ongoing` = sum(`Field Type Ongoing` == "Mandatory")
  ) |>
  gt() |>
    tab_options(
      # table.width = pct(100), # give 100% width to table
      quarto.disable_processing = TRUE # prevent quarto from messing with gt table formatting
    ) |>
    opt_stylize(style = 1) |> # Striped look
    cols_align(
      align = "left",
      columns = everything()
    )

Module	Mandatory Closed	Mandatory Ongoing
action	21	22
assay_sheet	24	26
assay_summary_result	16	16
control_neg	3	5
control_pos	3	3
investigation	14	12
test_substance	8	12