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 |