Table Detail Report
CONTAINER_ACCESSION
Column Section | Top of Page |
Table-level Detail
Description: | Container Accession |
Definition: | The resolution table between containers and accessions. This table will tell you what containers belong to an accession. |
Table Type: | ACTIVITY |
Column Detail - CONTAINER_ACCESSION
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION | VARCHAR(20) | Y | A string that uniquely identifies a specimen. |
ACCESSION_CONTAINER_NBR | DOUBLE | Y | A number uniquely identifying a particular container on an accession. |
ACCESSION_ID | DOUBLE | N | A system generated number that uniquely identifies an accession number. |
BARCODE_ACCESSION | VARCHAR(20) | Y | The string printed on a label to uniquely identify the specimen. This string is the accession number truncated. |
CONTAINER_ALIAS_CD | DOUBLE | N | An alias for the sontainer suffix. |
CONTAINER_ID | DOUBLE | N | A system generated number that uniquely identifies a container. |
OVERRIDE_CONT_ID_PRINT_FLAG | DOUBLE | N | An override value for the container ID print setting normally applied from the collection class. 0 - Use default collection class setting; 1 - Print the Container ID in the barcode and on the label; 2 - Do not print the container ID in the barcode or on the label. |
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. |
DEPT_DUP_CHECK
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Departmental Duplicate Checking |
Definition: | Used to store duplicate checking information that the department would want to store (dup checking across order catalog items) |
Table Type: | REFERENCE |
Column Detail - DEPT_DUP_CHECK
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
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. |
CATALOG_CD | DOUBLE | N | Used to store the code for the catalog item for which duplicate checking is being specified |
DUP_CATALOG_CD | DOUBLE | N | Used to store the code for the catalog item that will cause cancellation of the order catalog item in the catalog_cd field if orders for this item already exist on the system |
DUP_QUANTITY | DOUBLE | Y | Used to store quantity information for duplicate checking. This field is used to allow multiples of duplicate orders to be processed but will cancel duplicates beyond the value in this field. |
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. |
MINUTES_AHEAD | DOUBLE | Y | Used to store the number of minutes ahead to look for other orders scheduled on the system to perform duplicate checking. |
MINUTES_BEHIND | DOUBLE | Y | Used to store the number of minutes behind to look for other orders scheduled on the system to perform duplicate checking. |
MNEMONIC_TYPE_CD | DOUBLE | N | Used to store the mnemonic type for the catalog item for display purposes |
PRIORITY_CD | DOUBLE | N | Used to store the code value for the priority to validate when performing duplicate checking |
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 - DEPT_DUP_CHECK
Child Column in DEPT_DUP_CHECK(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | SERVICE_DIRECTORY | CATALOG_CD |
INSTRUMENT_IMAGE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Instrument Image |
Definition: | Contains scattergram image activity data associated to results. |
Table Type: | ACTIVITY |
Column Detail - INSTRUMENT_IMAGE
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
INSTRUMENT_IMAGE_ID | DOUBLE | N | Uniquely identifies scattergram image activity data associated to results. |
PERFORM_DT_TM | DATETIME | N | Performed data and time of the result associated to the image. |
REPEAT_NBR | DOUBLE | N | Keeps track of the number of times a dta has been resulted. |
RESULT_ID | DOUBLE | N | Relates this image activity data to a specific result. |
RESULT_IMAGE_NAME | VARCHAR(64) | Y | Handle to scattergram image stored in MMF. |
RESULT_IMAGE_VRSN_NBR | DOUBLE | N | Version number needed for retrieving result image from the MMF data archive. |
SERVICE_RESOURCE_CD | DOUBLE | N | The service resource code for instrument. |
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 - INSTRUMENT_IMAGE
Child Column in INSTRUMENT_IMAGE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RESULT_ID | RESULT | RESULT_ID |
LABEL_PRINTER_DEF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Label Printer Defaults |
Definition: | This table stores the default specimen label printers, medial label printers, and label printer filters. When 'immediate print' Lab orders come across an HIS interface, this table tells the system where to print the labels. |
Table Type: | REFERENCE |
Column Detail - LABEL_PRINTER_DEF
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
COLL_PRIORITY_CD | DOUBLE | N | A collection priority which will route labels to a printer if an order is placed with the given collection priority. A zero value indicates the printer is valid for all collection priorities. |
DEFAULT_TYPE_FLAG | DOUBLE | N | Type of printer default. Label routing defaults direct where an order's label should be printed. Label filtering defaults indicate which printers should default in the printer accept for the location. |
KEY_ID | DOUBLE | N | A unique identifier for a row. |
LBL_PRINTER_ID | DOUBLE | N | Label Routing - the system identifier for a label printer any orders meeting the criteria will print to. Label Filtering - the system identifier for a label printer that should be available for the location_cd. |
LBL_QUEUE_NAME | VARCHAR(20) | Y | The queue name for the label printer. |
LOCATION_CD | DOUBLE | N | An facility, ambulatory, login location or nurse unit which will route labels to a printer if an order is placed on a patient is at the given location or logged in at the given location. Filters will show available printers based on this location. A value of zero indicates the printer is valid for all locations. |
NURSE_PRINTER_ID | DOUBLE | N | The system identifier for a label printer that nurse collect orders should print to. |
NURSE_QUEUE_NAME | VARCHAR(20) | Y | The queue name for the label printer. |
SEQUENCE | DOUBLE | N | Field to make default type, location, service resource, collection priority combination unique. This combination is always unique for routing defaults, but not for filter defaults. |
SERVICE_RESOURCE_CD | DOUBLE | N | Aliquot or Media labels determine which label to print to based on service resource. A value of zero indicates the printer is valid for all service resources at that login location. |
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 - LABEL_PRINTER_DEF
Child Column in LABEL_PRINTER_DEF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOCATION_CD | LOCATION | LOCATION_CD |
NETTING
Column Section | Top of Page |
Table-level Detail
Description: | Netting |
Definition: | Short for container/accession/order netting. Processed by the netting server when it is time to net orders. |
Table Type: | ACTIVITY |
Column Detail - NETTING
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION | VARCHAR(20) | Y | An accession number identifies an order or a group of orders. |
ACCESSION_ID | DOUBLE | N | A system-generated number that uniquely identifies an accession number. |
ACTIVITY_TYPE_CD | DOUBLE | N | A code value that uniquely identifies to which "net" (such as PathNet or RadNet) and/or what department (such as General Lab or Microbiology) an order belongs. |
ALIQUOT_PRINTER_ID | DOUBLE | N | A system-generated number that uniquely identifies an aliquot label printer. |
BED_CD | DOUBLE | N | The internal number assigned by the system as a code value for the Bed Code. The nursing unit will determine the location where the label is printed. |
BODY_SITE_CD | DOUBLE | N | The internal number assigned by the system as a code value for the Body Site Code. |
CATALOG_CD | DOUBLE | N | The internal number assigned by the system as a code value for the Catalog Code. |
COLLECTED_IND | DOUBLE | Y | The collection status of an order (0 - not collected, 1 - collected). |
COLLECTION_COMMENT | VARCHAR(200) | Y | The collection comment (label comment) for an order. |
COLLECTION_DT_TM | DATETIME | Y | The collection date and time for an order. |
COLLECTION_ID | DOUBLE | N | A system-generated number that uniquely identifies the collector of an order. |
COLLECTION_LIST_ID | DOUBLE | N | Unique system identifier for a collection list or transfer list. |
COLLECTION_METHOD_CD | DOUBLE | N | The internal number assigned by the system as a code value for the Collection Method Code. |
COLLECTION_PRIORITY_CD | DOUBLE | N | The internal number assigned by the system as a code value for the Collection Priority Code. |
CONTAINER_ID | DOUBLE | N | Unique identifier for the container that was associated with the order. |
CONVERSATION_ID | DOUBLE | N | A system-generated number that uniquely identifies a group orders to be netted. |
LABEL_FILE_PREFIX | VARCHAR(5) | Y | The file prefix used to identify a label file. |
LABEL_PRINTER_ID | DOUBLE | N | A system-generated number that uniquely identifies a label printer. |
MEDIA_PRINTER_ID | DOUBLE | N | A system-generated number that uniquely identifies a media printer. |
NETTING_STATUS | DOUBLE | Y | The status of a netting. Status: 0 - Default. 1 - Active netting row. 4 - Inactive netting row. 5 - Cancelled netting row. 150 - Error In Netting. |
NURSE_UNIT_CD | DOUBLE | N | The internal number assigned by the system as a code value for the Nursing Unit Code. The nursing unit will determine the location where the label is printed. |
ORDER_ID | DOUBLE | N | A system-generated number that uniquely identifies an order. |
ORDER_LOCATION_CD | DOUBLE | N | The internal number assigned by the system as a code value for the Order Location Code. |
PRINT_QUEUE | VARCHAR(250) | Y | The description of the label printer queue. Currently Not Used. |
PROCESSING_FLAG | DOUBLE | Y | A flag indicating the source of a netting row. |
PROP_ID | DOUBLE | N | The identifier of the row in the prop_queue table. |
RECEIVED_DT_TM | DATETIME | Y | The received date and time of the order. |
RECEIVED_ID | DOUBLE | N | A system-generated number that uniquely identifies the collector of an order. |
RECEIVED_LOCATION_CD | DOUBLE | N | The internal number assigned by the system as a code value for the Received Location code. |
REPORT_PRIORITY_CD | DOUBLE | N | The internal number assigned by the system as a code value for the Reporting Priority Code. |
ROOM_CD | DOUBLE | N | The internal number assigned by the system as a code value for the Room Code. The nursing unit will determine the location where the label is printed. |
SPECIMEN_TYPE_CD | DOUBLE | N | The internal number assigned by the system as a code value for the Specimen Type Code. |
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. |