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 |