CIPSER System

ICIS Models implemented at CIP in CIPSER System

CIP report to 25 February 2008, reported by Edwin Rojas and Reinhard Simon.

To december 2007 the CIP has implemented a mobile solution called CIPSER system for:

Manage seed stocks for curators and breeders
Manage seed locations for curators and breeders
Support different CIP crops: potato, sweetpotato and ARTCs
Support multiple cold chambers, at CIP we have 4 cold chambers for seeds
Simplify the management using barcodes with wireless integrated, mobile devices (PDA) and thermal printers

CIP is at 80% of seed inventory: re-label all seed envelopes with barcodes.

At 80% of seed inventory, the database store:

A very good response time when retrieve one lot with stock and location
A good response time when retrieve a lot container with stocks and locations (~= 100 lots)
A very good response time when store a lot container with stocks and locations (~= 100 lots)

The general lot concept permit a group envelopes, bags, tubers and thinking to apply to in-vitro
Potato, sweetpotato and 10 ARTC crops are supported
Different locations and physical levels are supported
Enable to extend other type of transactions: Store, Remove and Move/Transfer (new)

Added the security module to manage roles by curators and locations
Added the physical levels module to manage the different orders to store the seeds. For examples:
- For potato for curator 1 or 2 on botanic seed: Cold chamber 1 --> Shelf --> Metallic Box --> Lot (aluminum envelopes)
- For potato for curator 3 on botanic seed: Cold chamber 1 --> Shelf --> Metallic Box --> Lot (aluminum envelopes)
- For potato for curator 3 on botanic seed: Cold chamber 1 --> Shelf --> Plastic box with cover (taper) --> Lot (aluminum bags)
- For potato for curator 3 on botanic seed: Cold chamber 1 --> Shelf --> Cardboard Box --> Lot (plastic bags)
- For potato for curator 1 or 2 on vegetative seed: Cold chamber 2 --> Shelf --> Plastic Box --> Lot (group of tubers)
- For potato for breeder 1 on botanic seed: Cold chamber 4 --> Shelf --> Lot (aluminum bags)
- For ARTC for curator 3 on vegetative seed: Ambient chamber 3 --> Wood Box --> Lot (paper bags)
Added lot movement tracking inside chamber and between chambers
Added justification for transaction: Regeneration for Conservation, Correct Errors (daily work),Discard/Loss, Acquisition, Distribution, Inventory Adjustments (annual activity),Other
Added to support two languages (English and other)

With tables LOC_LEVELS and LOC_LEVELS_ORDER is possible to know hierarchy levels names without the necessity to navigate for all locations on table location --> to improve system performance.
With tables LOC_LEVELS and LOC_LEVELS_ORDER is possible to anticipate registration of hierarchy levels and show levels without registering any locations --> to facilities summary reports or before start lot inventory we register hierarchy levels.
With tables LOC_LEVELS and LOC_LEVELS_ORDER is possible to control registration of locations with their associations, for example is not correct for curator 1 to associate directly a lot to a shelf --> to help check data integrity.
With tables LOC_LEVELS and LOC_LEVELS_ORDER is possible to layout different hierarchy levels for one chamber, at CIP one chamber is shared for three curators.
For columns Sub-nat 1,2,3 theses store only the parent id location, at CIPSER the equivalent is the column LOCIDParent