Table Detail Report

COLL_TEMPLATE_PREF_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: COLL TEMPLATE PREF R
Definition: Stores the relationship preference for Collection Templates.
Table Type: REFERENCE





Column Detail - COLL_TEMPLATE_PREF_R


Column Name Type Null? Definition
CHILD_RELATION_CD DOUBLE N The child relation code for the parent.
COLL_TEMPLATE_CD DOUBLE N The collection template code value.
MODE_FLAG DOUBLE N The mode for this relationship preference. 1 - By location 2 - By list 3 - By Accession 4 - By Patient
PARENT_RELATION_CD DOUBLE N The parent code value for this relationship.
RELATION DOUBLE N The relationship type of this preference.
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 - COLL_TEMPLATE_PREF_R


Child Column in COLL_TEMPLATE_PREF_R(FK) Parent Table Name Parent Column Name
Parents: COLL_TEMPLATE_CD CODE_VALUE CODE_VALUE


CONTAINER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Container
Definition: Each and every specimen container tracked by the PathNet Specimen Collections module will be represented by a row in this table.
Table Type: ACTIVITY





Column Detail - CONTAINER


Column Name Type Null? Definition
ADDITIONAL_LABELS DOUBLE Y The number of extra labels which will be printed for orders with these collection requirements. The additional labels will not be assigned to a container.
AUTO_PRINT_ALIQUOT_IND DOUBLE Y Indicates whether aliquot labels have automatically printed once the specimen container reaches the login location. A value of 0 means the aliquot labels have not printed. A value of 1 means the aliquot labels have printed.
COLLECTION_LIST_ID DOUBLE N Unique system identifier of a collection list.
COLLECTION_METHOD_CD DOUBLE N The procedure for collecting a specimen.
COLLECTION_TASK_ELIG_FLAG DOUBLE N This field indicates whether the container is elibible for a nurse collection task. 0 - Not Eligible; 1 - Eligible
COLL_CLASS_CD DOUBLE N The internal number assigned by the system to the Collection Class associated with the collection requirements.
COLL_COMMENT_ID DOUBLE N The identifier in the long text table of the collection comment for the container if one exists.
CONTAINER_ID DOUBLE N Unique system identifier for a container.
CURRENT_LOCATION_CD DOUBLE N The container's current location.
DISCARD_DT_TM DATETIME Y The date and time the container was discarded.
DISCARD_REASON_CD DOUBLE N The reason why the container was disposed.
DRAWN_DT_TM DATETIME Y The date and time when the specimen was collected.
DRAWN_ID DOUBLE N The system identifier of the person who collected the specimen.
FIXATIVE_CD DOUBLE N Not currently used.
INSTR_LOGIN_IND DOUBLE Y This field is to indicate whether a container is initially logged in by Auto Login. instr_login_ind = 0 means the container initially is not logged in by instrument. instr_login_ind = 1 means the container is initially logged in by an instrument.
LABEL_DT_TM DATETIME Y The date and time printed on the label.
ON_ROBOTICS_LINE_FLAG DOUBLE N When a container is placed on the robotics line, this flag is set to 1.
ORIGINAL_STORAGE_DT_TM DATETIME Y The date and time the container is placed in storage.
PARENT_CONTAINER_ID DOUBLE N This unique system identifier is used to indicate which container the aliquot came from.
RECEIVED_DT_TM DATETIME Y The date and time when the container was logged in.
RECEIVED_ID DOUBLE N The system identifier for the user who logged in the container.
REMAINING_VOLUME DOUBLE Y The remaining volume in the container.
SPECIMEN_ID DOUBLE N Unique system identifier for the specimen in the container.
SPECIMEN_TYPE_CD DOUBLE N The type of specimen in the container.
SPEC_CNTNR_CD DOUBLE N The type of container the specimen is in.
SPEC_HNDL_CD DOUBLE N Any special handling for the container.
STORAGE_RACK_CELL_ID DOUBLE N The storage location of the given container. Used by storage tracking.
STORAGE_STATUS_CD DOUBLE N Obsolete, No longer being used. Identifies the current status of each container as it relates to Storage Tracking. Identifies whether the Container has never been placed in storage, is currently in storage, is checked out from storage, or has been discarded.
SUGGESTED_DISCARD_DT_TM DATETIME Y Obsolete, No longer being used. The suggested date and time when the container should be discarded.
TASK_LOG_ID DOUBLE N Allows microbiology to uniquely an organizm.
TRANSFER_LIST_ID DOUBLE N The unique system identifier for a transfer list.
UNITS_CD DOUBLE N The units the container is measured in.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VOLUME DOUBLE Y The total volume of the container.
VOLUME_UNIT CHAR(15) Y The volume units of the container. No longer used.



Relationship Detail - CONTAINER


Child Column in CONTAINER(FK) Parent Table Name Parent Column Name
Parents: COLLECTION_LIST_ID COLLECTION_LIST COLLECTION_LIST_ID
TRANSFER_LIST_ID COLLECTION_LIST COLLECTION_LIST_ID
PARENT_CONTAINER_ID CONTAINER CONTAINER_ID
COLL_COMMENT_ID LONG_TEXT LONG_TEXT_ID
TASK_LOG_ID MIC_TASK_LOG TASK_LOG_ID
DRAWN_ID PRSNL PERSON_ID
RECEIVED_ID PRSNL PERSON_ID
SPEC_CNTNR_CD SPECIMEN_CONTAINER SPEC_CNTNR_CD
STORAGE_RACK_CELL_ID STORAGE_ITEM_CELL STORAGE_ITEM_CELL_ID
SPECIMEN_ID V500_SPECIMEN SPECIMEN_ID




Parent Column in CONTAINER (PK) Child Table Name Child Column Name
Children: CONTAINER_ID CONTAINER PARENT_CONTAINER_ID
CONTAINER_EVENT PARENT_CONTAINER_ID
CONTAINER_LAB_HANDLING CONTAINER_ID
FOREIGN_CONTAINER CONTAINER_ID
FOREIGN_CONTAINER_EXCPTN CONTAINER_ID
HANDHELD_DETAIL CONTAINER_ID
ORDER_CONTAINER_R DEST_CONTAINER_ID
PERSON_ABORH_RESULT CONTAINER_ID
SPECIMEN_USAGE CREATED_CONTAINER_ID
SPECIMEN_USAGE PARENT_CONTAINER_ID
TASK_ACTIVITY CONTAINER_ID


CONTAINER_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Container Event.
Definition: Events that happen to a container are recorded here to support container tracking.
Table Type: ACTIVITY





Column Detail - CONTAINER_EVENT


Column Name Type Null? Definition
ADDITIONAL_LABELS DOUBLE Y The number of extra labels which will be printed for orders with these collection requirements. The additional labels will not be assigned to a container. Not currently used.
COLLECTION_LIST_ID DOUBLE N Unique system identifier of a collection list.
COLLECTION_METHOD_CD DOUBLE N The procedure for collecting a specimen.
COLLECTION_TASK_ELIG_FLAG DOUBLE N This field contains whether the container is eligible for a nurse collection task. 0 - Not Eligible; 1 - Eligible
COLL_CLASS_CD DOUBLE N The internal number assigned by the system to the Collection Class associated with the collection requirements.
COLL_COMMENT_ID DOUBLE N The identifier of the collection comment in the long_text table.
CONTAINER_ID DOUBLE N Unique system identifier for a container.
CONVERSATION_ID DOUBLE N A system generated number that uniquely identifies the group of orders that caused the container event.
CURRENT_LOCATION_CD DOUBLE N The container's current location.
DISCARD_DT_TM DATETIME Y The date/time that the container was discarded.
DISCARD_REASON_CD DOUBLE N The reason why the container was disposed.
DRAWN_DT_TM DATETIME Y The date and time when the specimen was collected.
DRAWN_ID DOUBLE N The system identifier of the person who collected the specimen.
EVENT_DT_TM DATETIME Y The Date and Time the event occurred
EVENT_SEQUENCE DOUBLE N Sequential number to indicate the order events on a container.
EVENT_TYPE_CD DOUBLE N The type of event which occurred on the container.
FIXATIVE_CD DOUBLE N Not currently used.
FROM_SERVICE_RESOURCE_CD DOUBLE Y Unique generated number that identifies a specific prior service resource where the container was located.
LABEL_DT_TM DATETIME Y The date and time printed on the label.
LABEL_PRINTER_NAME VARCHAR(100) Y This is used to save the label printer which was used to print the labels in container event table. The label printer details will be displayed in container inquiry application when it is called from scs_get_container_accession script.
ORIGINAL_STORAGE_DT_TM DATETIME Y The date/time that the container was placed in storage originally,
PARENT_CONTAINER_ID DOUBLE N This unique system identifier is used to indicate which container the aliquot came from.
PROCESSING_FLAG DOUBLE N Identifies the type of processing that should occur as a result of the container event. 0 - No Processing Needed; 1 - Container Tracking Event; 2 - Nurse Collection Task
REASON_MISSED_CD DOUBLE N The reason a container was missed.
REASON_MISSED_DT_TM DATETIME Y The date/time a container was marked as missed.
REASON_MISSED_ID DOUBLE N The ID of the person who marked the container as missed.
RECEIVED_DT_TM DATETIME Y The date and time when the container was logged in.
RECEIVED_ID DOUBLE N The system identifier for the user who logged in the container.
REMAINING_VOLUME DOUBLE Y Obsolete - No longer in use. Replaced by Remaining_Volume_NBR
REMAINING_VOLUME_NBR DOUBLE N The remaining volume in the container.
SERVICE_RESOURCE_CD DOUBLE Y Unique generated number that identifies a specific service resource associated with the container.
SPECIMEN_ID DOUBLE N Unique system identifier for the specimen in the container.
SPECIMEN_TYPE_CD DOUBLE N The type of specimen in the container.
SPEC_CNTNTR_CD DOUBLE N The type of container the specimen is in.
SPEC_HNDL_CD DOUBLE N Any special handling for the container.
STORAGE_LOCATION_TXT VARCHAR(100) Y The storage location of the container when the event occurs
STORAGE_RACK_CELL_ID DOUBLE N The storage location of the container
SUB_EVENT_TYPE_CD DOUBLE N Provides context for the source of the container event.
SUGGESTED_DISCARD_DT_TM DATETIME Y Obsolete, No longer being used. The suggested discard date/time of the container for storage tracking.
TASK_LOG_ID DOUBLE N Used by Microbiology to uniquely identify an organism,
TRANSFER_LIST_ID DOUBLE N The unique system identifier for a transfer list.
UNITS_CD DOUBLE N The units the container is measured in.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VOLUME DOUBLE Y Obsolete - No longer in use. Replaced by Volume_NBR
VOLUME_NBR DOUBLE N The total volume of the container.
VOLUME_UNITS CHAR(15) Y The volume units of the container. No longer used.



Relationship Detail - CONTAINER_EVENT


Child Column in CONTAINER_EVENT(FK) Parent Table Name Parent Column Name
Parents: COLLECTION_LIST_ID COLLECTION_LIST COLLECTION_LIST_ID
TRANSFER_LIST_ID COLLECTION_LIST COLLECTION_LIST_ID
PARENT_CONTAINER_ID CONTAINER CONTAINER_ID
COLL_COMMENT_ID LONG_TEXT LONG_TEXT_ID
TASK_LOG_ID MIC_TASK_LOG TASK_LOG_ID
FROM_SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
STORAGE_RACK_CELL_ID STORAGE_ITEM_CELL STORAGE_ITEM_CELL_ID
SPECIMEN_ID V500_SPECIMEN SPECIMEN_ID




Parent Column in CONTAINER_EVENT (PK) Child Table Name Child Column Name
Children: CONTAINER_ID CONTAINER_EVENT_DETAILS CONTAINER_ID
EVENT_SEQUENCE CONTAINER_EVENT_DETAILS EVENT_SEQUENCE


CONTAINER_EVENT_ASSAY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Container Event Task Assay
Definition: Stores a task assay associated with a specific order for a container event.
Table Type: ACTIVITY





Column Detail - CONTAINER_EVENT_ASSAY


Column Name Type Null? Definition
CONTAINER_EVENT_ASSAY_ID DOUBLE N A system generated number that uniquely defines a row on the CONTAINER_EVENT_ASSAY table.
CONTAINER_ID DOUBLE Y Unique generated number that identifies a specific specimen container.
EVENT_SEQUENCE DOUBLE Y Sequential number to indicate the order of events on a container.
ORDER_ID DOUBLE Y Unique generated number that identifies a specific order.
TASK_ASSAY_CD DOUBLE Y Unique generated number that identifies a specific discrete task assay.
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - CONTAINER_EVENT_ASSAY


Child Column in CONTAINER_EVENT_ASSAY(FK) Parent Table Name Parent Column Name
Parents: CONTAINER_ID CONTAINER_EVENT_DETAILS CONTAINER_ID
EVENT_SEQUENCE CONTAINER_EVENT_DETAILS EVENT_SEQUENCE
ORDER_ID CONTAINER_EVENT_DETAILS ORDER_ID
TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD


CONTAINER_EVENT_DETAILS



Column Section Relationship Section Top of Page


Table-level Detail

Description: container event details
Definition: Determines what orders a container event applies to.
Table Type: ACTIVITY





Column Detail - CONTAINER_EVENT_DETAILS


Column Name Type Null? Definition
CONTAINER_ID DOUBLE N The ID of the container that the event applies to.
EVENT_SEQUENCE DOUBLE N The unique identifier for the container event.
ORDER_ID DOUBLE N The ID of the order that this container event applies to.
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 - CONTAINER_EVENT_DETAILS


Child Column in CONTAINER_EVENT_DETAILS(FK) Parent Table Name Parent Column Name
Parents: CONTAINER_ID CONTAINER_EVENT CONTAINER_ID
EVENT_SEQUENCE CONTAINER_EVENT EVENT_SEQUENCE
ORDER_ID ORDERS ORDER_ID




Parent Column in CONTAINER_EVENT_DETAILS (PK) Child Table Name Child Column Name
Children: CONTAINER_ID CONTAINER_EVENT_ASSAY CONTAINER_ID
EVENT_SEQUENCE CONTAINER_EVENT_ASSAY EVENT_SEQUENCE
ORDER_ID CONTAINER_EVENT_ASSAY ORDER_ID