Leave a comment at the end of this page or email contact@krishagni.com
Storage Position based Audits
Storage Container Positions
Storage Container Position: a record that denotes the position within a storage container (for a specimen or container).
1. Specimen stored in a container
Record ID ‘13040888’ denotes row 2 (‘posOne =2, posOneOrdinal=2’); column 1 (‘posTwo=A,posTwoOrdinal=1’) of container with Identifier ‘165979’.
It holds the specimen with Identifier ‘1545225’ (‘occupyingSpecimen={id=1545225}’).
In turn, the specimen (using Record Type = Specimen) is linked to its location through ‘position’. The position ID matches the Storage Container Position’s Record ID, (‘position={id=1304888}’).
2. Parent-child container position
Record ID ‘130571’ denotes a position within the container with Identifier ‘1018051’, named ‘hi2_Parent’, .
As the container is dimensionless, there are no rows and columns given.
It holds a child container ‘hi2’, with Identifier ‘822206’ (‘occupyingContainer={id=822206, name=hi2}’).
The container hi2 (using Record Type = Storage Container) is linked to its location through ‘position’. The position ID matches the Storage Container Position’s Record ID, (‘position={id=1305271}’).
Examples:
1. Creating a Specimen and assigning its location
Row # | Operation | Record Type | Record ID | Change Log |
|---|---|---|---|---|
1 | Edit | Specimen | 507718 | position={id=176199} |
2 | Add | Storage Container Position | 176199 | blocked=false,container={id=125, name=M6},occupyingSpecimen={id=507718} |
3 | Add | Specimen | 507718 | activityStatus=Active,availabilityStatus=Available,availableQuantity=2.000000,barcode=3779,collectionProtocol={id=10},collectionStatus=Collected,createdOn=Fri Mar 21 01:42:00 GMT 2025,freezeThawCycles=1,initialQuantity=2.000000,label=COV19.WB.2540-Pl-02_4,lineage=Aliquot,parentSpecimen={id=507714},pathologicalStatus={id=78},poolItem=false,specimenClass={id=449},specimenType={id=466},tissueSide={id=108},tissueSite={id=442},visit={id=75407, name=21586} |
Row 3: A Specimen with identifier 507718 is created, with the following details (as mentioned in the Change Log)
Row 2: A Storage Container Position within container M6 is assigned to the specimen in Row 3. This is denoted by the ‘occupyingSpecimen={id=507718}’
Row 1: The position ID (from Row 2) is also assigned to the Specimen. This is denoted by the ‘position={id=176199}’.
2. Adding a position to an existing Specimen
Row # | Operation | Record Type | Record ID | Change Log |
|---|---|---|---|---|
1 | Add | Storage Container Position | 176200 | blocked=false,container={id=125, name=M6},occupyingSpecimen={id=507719} 2 |
2 | Edit | Specimen | 507719 | position={id=176200} |
Row 2: The Position (with Identifier 176200) is assigned to the Specimen 507719 through (position={id=176200})
Row 1: The Specimen in Row 2 is assigned to the Storage Container Position 176200 (through ‘,occupyingSpecimen={id=507719}’)
3. Evicting a specimen from a Container (during Distribution)
Row # | Operation | Record Type | Record ID | Change Log |
|---|---|---|---|---|
1 | Delete | Storage Container Position | 176196 |
|
2 | Edit | Specimen | 507715 | availabilityStatus=Distributed,availableQuantity=0.000000,position=null |
3 | Add | Storage Container Position | 176196 | blocked=false,container={id=125, name=M6},occupyingSpecimen={id=507715} |
4 | Edit | Specimen | 507715 | position={id=176196} |
Row 4: The Position (with Identifier 176196) is assigned to the Specimen 507715 through (position={id=176195})
Row 3: The Specimen in Row 4 is assigned to the Storage Container Position 176195 (through ‘,occupyingSpecimen={id=507715}’)
Row 2: The specimen (in Row 4) is distributed (‘availabilityStatus=Distributed’), setting its
Available Quantity = 0 (‘availableQuantity=0.000000’), and evicting its location (‘position=null’)
Row 1: The Storage Container position (previously occupied by specimen 507715) is now cleared