Table Detail Report

SPECIMEN_CONTAINER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Specimen Container
Definition: Reference table storing all specimen containers (codeset 2051) used within the Lab and their attributes.
Table Type: REFERENCE





Column Detail - SPECIMEN_CONTAINER


Column Name Type Null? Definition
ALIQUOT_IND DOUBLE Y An indicator that the container is an aliquot type of container, and not a primary type of container.
SPEC_CNTNR_CD DOUBLE N The internal number assigned by the system to the Specimen Container.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VOLUME_UNITS CHAR(15) Y The units associated with the numeric container volume(s).
VOLUME_UNITS_CD DOUBLE N The internal number assigned by the system to the Volume Units.



Relationship Detail - SPECIMEN_CONTAINER




Parent Column in SPECIMEN_CONTAINER (PK) Child Table Name Child Column Name
Children: SPEC_CNTNR_CD CONTAINER SPEC_CNTNR_CD
SPECIMEN_CONTAINER_VOLUME SPEC_CNTNR_CD


SPECIMEN_CONTAINER_VOLUME



Column Section Relationship Section Top of Page


Table-level Detail

Description: Specimen Container Volume
Definition: Reference table storing the various volumes that containers come in. For example, if a red top tube comes in 3 sizes, 3ml, 5ml and 7ml. That would be represented by 1 row in the specimen_container table and 3 rows in the specimen_container_volume table.
Table Type: REFERENCE





Column Detail - SPECIMEN_CONTAINER_VOLUME


Column Name Type Null? Definition
SPEC_CNTNR_CD DOUBLE N The internal number assigned by the system to the Specimen Container associated with the volume.
SPEC_CNTNR_SEQ DOUBLE N The numeric value assigned by the system to indicate the sequence of each container volume.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
VOLUME DOUBLE Y The numeric value of the container volume.



Relationship Detail - SPECIMEN_CONTAINER_VOLUME


Child Column in SPECIMEN_CONTAINER_VOLUME(FK) Parent Table Name Parent Column Name
Parents: SPEC_CNTNR_CD SPECIMEN_CONTAINER SPEC_CNTNR_CD


SPECIMEN_USAGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: specimen usage
Definition: Contains usage event for a given specimen.
Table Type: ACTIVITY





Column Detail - SPECIMEN_USAGE


Column Name Type Null? Definition
CREATED_CONTAINER_ID DOUBLE N Container that was created to store the new specimen in.
ORDER_ID DOUBLE N Uniquely relates this row to a specific order.
PARENT_CONTAINER_ID DOUBLE N Container the parent specimen was located in.
PARENT_SPECIMEN_ID DOUBLE N Parent specimen that was used in the creation of the specimen.
SPECIMEN_ID DOUBLE N Specimen for which this usage event refers to.
SPECIMEN_USAGE_ID DOUBLE N Non-intelligent key to uniquely identify a row.
UNITS_CD DOUBLE N Units of measure for given volume.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
USAGE_DT_TM DATETIME N The date and time this usage event occurred on.
USAGE_PRSNL_ID DOUBLE N The person responsible for this usage event.
VOLUME_USED_QTY DOUBLE N Volume of parent container used to create the new specimen.



Relationship Detail - SPECIMEN_USAGE


Child Column in SPECIMEN_USAGE(FK) Parent Table Name Parent Column Name
Parents: CREATED_CONTAINER_ID CONTAINER CONTAINER_ID
PARENT_CONTAINER_ID CONTAINER CONTAINER_ID
ORDER_ID ORDERS ORDER_ID
USAGE_PRSNL_ID PRSNL PERSON_ID
PARENT_SPECIMEN_ID V500_SPECIMEN SPECIMEN_ID
SPECIMEN_ID V500_SPECIMEN SPECIMEN_ID


STORAGE_CONTENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Storage Content
Definition: Describes the inventory content of a storage item.
Table Type: ACTIVITY





Column Detail - STORAGE_CONTENT


Column Name Type Null? Definition
CONTENT_STATUS_CD DOUBLE N The current status of the storage content within the storage item.
CONTENT_TABLE_ID DOUBLE N This field contains the foreign key identifier to content information stored on the table named by the content table name.
CONTENT_TABLE_NAME VARCHAR(30) N This field contains the table name of content information stored on the table named in the field.
EXPECTED_RETURN_DT_TM DATETIME Y The date and time when the content is expected to be returned to storage.
STORAGE_CONTENT_ID DOUBLE N Uniquely identifies the inventory content of a storage item.
STORAGE_ITEM_CD DOUBLE N Uniquely identifies the storage item related to the storage content.
STORAGE_ITEM_CELL_ID DOUBLE N This field contains the foreign key value to the storage_item_cell table for the last storage item cell containing the storage content.
SUGGESTED_DISCARD_DT_TM DATETIME Y The suggested date and time for the content to be discarded.
TRACKING_LOCATION_CD DOUBLE N The destination to which the content has been tracked.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - STORAGE_CONTENT


Child Column in STORAGE_CONTENT(FK) Parent Table Name Parent Column Name
Parents: STORAGE_ITEM_CD STORAGE_ITEM STORAGE_ITEM_CD
STORAGE_ITEM_CELL_ID STORAGE_ITEM_CELL STORAGE_ITEM_CELL_ID


STORAGE_CONTENT_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Storage Content Event
Definition: Describes te events for inventory content of a storage item.
Table Type: ACTIVITY





Column Detail - STORAGE_CONTENT_EVENT


Column Name Type Null? Definition
ACTION_CD DOUBLE N The action that has been performed on the inventory for the given event.
ACTION_DT_TM DATETIME N Date and time the action occurred
ACTION_PRSNL_ID DOUBLE N Id of the person who performed the action
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
COMMENT_ID DOUBLE N The identifier of the comment recorded with the event that occurred.
CONTENT_STATUS_CD DOUBLE N The status of the storge content within the storage item after the event has occurred.
DESTINATION_CD DOUBLE N The destination for the storage content.
DISPOSAL_REASON_CD DOUBLE N The reason why the storage content was disposed.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
STATION_CD DOUBLE N The station used to perform the event on the inventory.
STORAGE_CONTENT_EVENT_ID DOUBLE N Uniquely identifies and describes the events for inventory content of a storage item.
STORAGE_CONTENT_ID DOUBLE N Uniquely identifies the storage content to which this event applies.
STORAGE_ITEM_CD DOUBLE N This field contains the code of the storage item containing the storage content for this event.
STORAGE_ITEM_CELL_ID DOUBLE N Contains the identifier of the cell of the storage item that contains the storage content for this event.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - STORAGE_CONTENT_EVENT


Child Column in STORAGE_CONTENT_EVENT(FK) Parent Table Name Parent Column Name
Parents: COMMENT_ID LONG_TEXT LONG_TEXT_ID
STORAGE_ITEM_CD STORAGE_ITEM STORAGE_ITEM_CD
STORAGE_ITEM_CELL_ID STORAGE_ITEM_CELL STORAGE_ITEM_CELL_ID