Supplies and chemicals
@erojas documents the need for documenting lab supplies (including chemicals):
- Screen house, In the field: fertilizer, pesticides, insecticides, or pollinators, etc. (plots)
- In Vitro: culture media
- Cryo: culture media
- Seed: types of envelopes, containers
Supervisors add new chemicals indicating date of expiration, manufacturer, name of the item, category, unit, temperature storage, status, quantity, location, catalogue, who can use, .... Consider managing minimal stock for each item.
Inside the genebank we have groups one for in Vitro and one for seeds in the headquarters. Other groups are outside the headquarters that manage their chemicals and supplies stock.
This is very similar to the
Inventory table (status, name, quantity, storage location):
xxxTypeCodeThe type of the supplies item
xxxStatusCodeThe current status of the supplies item
siteIdthe site where this supplies item is stored and used
namename of the supplies item
receivedDatedate when the supplies item was received
expirationDatedate when the supplies item expires and must not be used
quantityUnitCodethe unit of quantity
initialQuantitythe initial quantity
quantityOnHand < alertQuantity, defaults to 25% of initial quantity.
storageLocationPart4Location in storage
Cooperatorrecord of the manufacturer or person who mixed the medium
Methoddocumenting how the item was mixed
The treatments uses chemicals and supplies to be produced and their individual stocks are discounted for each technician.
For each item indicate which group will consume it, maybe was purchased by Cryo group and another item purchased for in Vitro group, some items are shared as common use.
Applying supplies and chemicals to any
Inventory is recorded as