Table Detail Report

FOREIGN_CONTAINER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Foreign Container
Definition: Contains description of container information which comes from a foreign system.
Table Type: ACTIVITY





Column Detail - FOREIGN_CONTAINER


Column Name Type Null? Definition
ACCESSION_CONTAINER_NBR DOUBLE N A number uniquely identifying a particular container on an accession.
BARCODE_ACCESSION VARCHAR(20) N The string printed on a label to uniquely identify the specimen. This string is the accession number truncated.
CONTAINER_ID DOUBLE N The number uniquely identifying the container which utilized this information in its creation in the system.
CREATED_DT_TM DATETIME N The date and time that this foreign container information was created.
FOREIGN_CONTAINER_ID DOUBLE N Uniquely identifies container information which comes from a foreign system.
ORDER_ID DOUBLE N Uniquely identifies the related order.
PARENT_CONTAINER_NBR DOUBLE N The number uniquely identifying the parent container on the accession if the container is an aliquot.
SPEC_CNTNR_CD DOUBLE N The specimen container type associated to this 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_NBR DOUBLE N The total volume of the container.
VOLUME_UNITS_CD DOUBLE N The volume units of measure.



Relationship Detail - FOREIGN_CONTAINER


Child Column in FOREIGN_CONTAINER(FK) Parent Table Name Parent Column Name
Parents: CONTAINER_ID CONTAINER CONTAINER_ID
ORDER_ID ORDERS ORDER_ID




Parent Column in FOREIGN_CONTAINER (PK) Child Table Name Child Column Name
Children: FOREIGN_CONTAINER_ID FOREIGN_CONTAINER_EXCPTN FOREIGN_CONTAINER_ID


FOREIGN_CONTAINER_EXCPTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Foreign Container Exceptions
Definition: A log of exceptions which occurred when using foreign containers while netting containers.
Table Type: ACTIVITY





Column Detail - FOREIGN_CONTAINER_EXCPTN


Column Name Type Null? Definition
CONTAINER_ID DOUBLE N Uniquely identifies the container which is associated to this exception or zero if not applicable.
EXCEPTION_DT_TM DATETIME N The date and time at which the exception occurred.
EXCEPTION_TYPE_FLAG DOUBLE N Indicates what type of exception occurred.1 - Foreign container information not matched/used.2 - Collection Requirement not matched to foreign container.3 - Existing container does not match foreign container information.
FOREIGN_CONTAINER_EXCPTN_ID DOUBLE N Uniquely identifies an exception which occurred when using foreign containers while netting containers.
FOREIGN_CONTAINER_ID DOUBLE N Uniquely identifies the foreign container information which is associated to this exception or zero if not applicable.
ORDER_ID DOUBLE N Identifies the order which is associated to this exception.
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 - FOREIGN_CONTAINER_EXCPTN


Child Column in FOREIGN_CONTAINER_EXCPTN(FK) Parent Table Name Parent Column Name
Parents: CONTAINER_ID CONTAINER CONTAINER_ID
FOREIGN_CONTAINER_ID FOREIGN_CONTAINER FOREIGN_CONTAINER_ID
ORDER_ID ORDERS ORDER_ID


HANDHELD_CONTAINER



Column Section Relationship Section Top of Page


Table-level Detail

Description: A single collection (container) uploaded using a handheld device.
Definition: Handheld Container
Table Type: ACTIVITY





Column Detail - HANDHELD_CONTAINER


Column Name Type Null? Definition
ACCESSION CHAR(20) N This field is the accession number of the uploaded container.
ALIAS VARCHAR(200) Y This field is the alias of the patient for purposes of positive patient identification.
COLLECTED_DT_TM DATETIME N This field contains the collection date and time for the uploaded container.
COLLECTED_IND DOUBLE N This field indicates whether the container was collected or missed.
COLLECTED_METHOD VARCHAR(40) Y This field contains the collection method used to collect the uploaded container.
COLLECTION_ID DOUBLE N This field (with the Report_ID field) uniquely identifies this collection/container.
COLL_PRIORITY VARCHAR(40) Y This field contains the collection priority of the first order in the uploaded container.
CONTAINER_NUMBER DOUBLE N This field contains the accession container number for the uploaded container.
ERROR_FLAG DOUBLE N This field identifies possible error values for the uploaded container/collection.
OVERRIDE_IND DOUBLE N This field indicates whether this container was collected after the user used the HIBC override function.
PATIENT_NAME VARCHAR(100) Y This field contains the name of the patient from which this uploaded container was collected.
REASON_MISSED VARCHAR(40) Y This field contains the reason the uploaded container was missed.
REPORT_ID DOUBLE N This field (with the Collection_ID field) uniquely identifies this collection/container.
REQUESTED_DT_TM DATETIME Y This field contains the requested date and time for the first order on an uploaded 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.



Relationship Detail - HANDHELD_CONTAINER


Child Column in HANDHELD_CONTAINER(FK) Parent Table Name Parent Column Name
Parents: REPORT_ID HANDHELD_REPORT REPORT_ID


HANDHELD_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Handheld Detail
Definition: This table will be used to store the detailed information regarding each handheld collection upload event. This table is used for reporting purposes only.
Table Type: ACTIVITY





Column Detail - HANDHELD_DETAIL


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y The accession number for this collection detail.
ALIAS1 VARCHAR(200) Y One of the person aliases entered to identify the patient. If known based on the barcode format, this will be the patients identifier on the patient wristband.
ALIAS2 VARCHAR(200) Y One of the person aliases entered to identify the patient. If known based on the barcode format, this will be the patients identifier on the collection label.
BARCODE_ALIAS1 VARCHAR(200) Y One of the bar-coded values entered to identify the patient. If known based on the barcode format, this will be the patients identifier on the patient wristband.
BARCODE_ALIAS2 VARCHAR(200) Y One of the bar-coded values entered to identify the patient. If known based on the barcode format, this will be the patients identifier on the collection label.
CANCEL_REASON_CD DOUBLE N If a collection is cancelled, this is the reason for the cancel.
COLLECTION_COMMENT VARCHAR(200) Y A comment entered that will be tied to the container.
COLLECTION_DT_TM DATETIME Y The collection date and time gathered by the device.
COLLECTION_METHOD_CD DOUBLE N The method used to collect the specimen. Only populated if changed on the device.
COLLECTION_PRSNL_ID DOUBLE N The personnel id of the user who performed the collection specified.
COLLECTION_STATUS_CD DOUBLE N Indicates the status of the collection.
CONTAINER_ID DOUBLE N The unique identifier for the CONTAINER table. Only populated if the container ID was specified on the device.
CONTAINER_NBR DOUBLE Y The container suffix used to uniquely identify each container for an accession number. Only populated when it was specified on the device.
ENCNTR1_ID DOUBLE N The encounter ID related to the first patient alias given.
ENCNTR2_ID DOUBLE N The encounter ID related to the second patient alias given.
ERROR_CD DOUBLE N Indicates if an error occurred for this collection.
HANDHELD_DETAIL_ID DOUBLE N Unique identifier for each occurrence of detail for a handheld session.
HANDHELD_UPLOAD_ID DOUBLE N The unique identifier for the HANDHELD_UPLOAD table which stores information about each upload event.
MISSED_REASON_CD DOUBLE N If a collection is missed, this is the reason entered.
ORDER_ID DOUBLE N The unique identifier for the ORDERS table. Only populated if the collection status was different for orders in the same container.
OVERRIDE_IND DOUBLE Y Indicates if Positive Patient Identification was overridden.
PERSON1_ID DOUBLE N The person ID related to the first patient alias given.
PERSON2_ID DOUBLE N The person ID related to the second patient alias given.
RECEIVED_DT_TM DATETIME Y The date/time the specimen was marked as received.
RECEIVED_PRSNL_ID DOUBLE N The personnel id of the user who received the specimen specified.
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 - HANDHELD_DETAIL


Child Column in HANDHELD_DETAIL(FK) Parent Table Name Parent Column Name
Parents: CONTAINER_ID CONTAINER CONTAINER_ID
ENCNTR1_ID ENCOUNTER ENCNTR_ID
ENCNTR2_ID ENCOUNTER ENCNTR_ID
HANDHELD_UPLOAD_ID HANDHELD_UPLOAD HANDHELD_UPLOAD_ID
ORDER_ID ORDERS ORDER_ID
PERSON1_ID PERSON PERSON_ID
PERSON2_ID PERSON PERSON_ID
COLLECTION_PRSNL_ID PRSNL PERSON_ID
RECEIVED_PRSNL_ID PRSNL PERSON_ID


HANDHELD_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: A single user's collection information uploaded using a handheld device.
Definition: Handheld Report
Table Type: ACTIVITY





Column Detail - HANDHELD_REPORT


Column Name Type Null? Definition
COLLECTOR_NAME VARCHAR(50) N Name of user who logged on to handheld and performed collections.
ERROR_FLAG DOUBLE N This field identifies possible error values for an uploaded report/user.
HIBC_FLAG DOUBLE N This field indicates the status of HIBC prefixes on the current upload report.
LOGOFF_DT_TM DATETIME N This field contains the date and time the user logged off of the handheld.
LOGON_DT_TM DATETIME N This field contains the date and time the user logged on to the handheld.
PPID_FLAG DOUBLE N This field indicates the number of times the handheld will prompt for patient identification. These prompts are used in conjunction with Positive Patient Identification on the handheld.
RECEIVED_NAME VARCHAR(50) N Name of user who logged on to the Handheld Collector program and uploaded handheld collections.
REPORT_ID DOUBLE N This field uniquely identifies a handheld report in the database.
REPORT_NBR DOUBLE N User viewable sequential report number. Reset to 1 every day.
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.
UPLOAD_DT_TM DATETIME N This field contains the date and time at which this handheld report was uploaded.
UPLOAD_LOC VARCHAR(40) N This field contains the location to which an uploaded container is logged in.



Relationship Detail - HANDHELD_REPORT




Parent Column in HANDHELD_REPORT (PK) Child Table Name Child Column Name
Children: REPORT_ID HANDHELD_CONTAINER REPORT_ID