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 |