Table Detail Report

COLLECTION_INFO_QUAL_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Collection Information Qualifiers History
Definition: Contains the history of collection requirements.
Table Type: ACTIVITY





Column Detail - COLLECTION_INFO_QUAL_HIST


Column Name Type Null? Definition
CATALOG_CD DOUBLE N Uniquely identifies the order catalog item associated with the collection requirements.
COLLECTION_INFO_QUAL_HIST_ID DOUBLE N Uniquely identifies a row of history from the collection_info_qualifiers table.
COLL_CLASS_CD DOUBLE N Uniquely identifies the collection class associated with the collection requirements.
COLL_INFO_SEQ DOUBLE N The sequence value from the collection requirements from which this history row was created.
MIN_VOL_AMT DOUBLE N The numeric value which, along with the specimen container's Units, defines the smallest amount of specimen needed for the collection.
SPECIMEN_TYPE_CD DOUBLE N Uniquely identifies the specimen type associated with the collection requirements.
SPEC_CNTNR_CD DOUBLE N Uniquely identifiers the specimen container associated with the collection requirements.
SPEC_HNDL_CD DOUBLE N Uniquely identifies the special handling instructions associated with the collection requirements.
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 - COLLECTION_INFO_QUAL_HIST


Child Column in COLLECTION_INFO_QUAL_HIST(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD COLLECTION_INFO_QUALIFIERS CATALOG_CD
COLL_INFO_SEQ COLLECTION_INFO_QUALIFIERS SEQUENCE
SPECIMEN_TYPE_CD COLLECTION_INFO_QUALIFIERS SPECIMEN_TYPE_CD




Parent Column in COLLECTION_INFO_QUAL_HIST (PK) Child Table Name Child Column Name
Children: COLLECTION_INFO_QUAL_HIST_ID ALT_COLLECTION_INFO_HIST COLL_INFO_HIST_ID


COLLECTION_LIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Collection List
Definition: Each collection list or specimen transfer list generated by the system will be represented by a row in this table.
Table Type: ACTIVITY





Column Detail - COLLECTION_LIST


Column Name Type Null? Definition
AUTO_BUILD_CONT_CNT DOUBLE N The number of containers automatically aded to this list.
AUTO_BUILD_STATUS_FLAG DOUBLE N Contains the status of the auto build. 0 - Not an auto build transfer list, 1 - In Process, 2 - Closed
COLLECTION_LIST_DT_TM DATETIME Y For collection lists, collection list date and time is the date and time of the collection list run. For transfer lists, collection list date and time is when the transfer list is created.
COLLECTION_LIST_ID DOUBLE N Unique system identifier for a collection list or transfer list.
COLLECTION_LIST_NBR DOUBLE Y User viewable sequential list number. Collection list numbers are incremented separately for collection lists and transfer lists. Reset to 1 every day.
COLLECTION_ROUTE_CD DOUBLE N Collection route for which the collection list was generated. Not applicable for Transfer Lists.
FROM_LOCATION_CD DOUBLE N Used for Transfer Lists to denote the list's starting location. Not applicable to Collection Lists.
LIST_TYPE_FLAG DOUBLE Y Flag to indicate if a list is a Collection List or a Transfer List.
TO_LOCATION_CD DOUBLE N Used for Transfer Lists to denote the list's ending location. Not applicable to Collection Lists.
TRANSFER_ID DOUBLE N The transfer identifier is the person who transferred the list. Not currently used.
TRANSFER_LIST_AUTO_BUILD_ID DOUBLE N Uniquely identifies the automatic transfer list configuration used to create this transfer list.
TRANSFER_LIST_STATUS_FLAG DOUBLE N Contains the status of the transfer list. 0 - Not a transfer list or use container status; 1 - Not Transferred; 2 - Transferred
TRANSFER_TEMP_CD DOUBLE N The transfer temperature for this collection list.
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.



Relationship Detail - COLLECTION_LIST


Child Column in COLLECTION_LIST(FK) Parent Table Name Parent Column Name
Parents: TRANSFER_LIST_AUTO_BUILD_ID TRANSFER_LIST_AUTO_BUILD TRANSFER_LIST_AUTO_BUILD_ID




Parent Column in COLLECTION_LIST (PK) Child Table Name Child Column Name
Children: COLLECTION_LIST_ID CONTAINER COLLECTION_LIST_ID
CONTAINER TRANSFER_LIST_ID
CONTAINER_EVENT COLLECTION_LIST_ID
CONTAINER_EVENT TRANSFER_LIST_ID
PROP_ORDER COLLECTION_LIST_ID


COLLECTION_LIST_CONTAINER



Column Section Top of Page


Table-level Detail

Description: Collection List Container
Definition: The cross reference table between collection/transfer lists and containers. This table will tell you all of the containers on a collection lists or a specimen transfer list.
Table Type: ACTIVITY





Column Detail - COLLECTION_LIST_CONTAINER


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y The accession number identifies a specimen. The accession number contains the current year, Julian date and a sequential number.
ACCESSION_CONTAINER_NBR DOUBLE Y Accession numbers may have multiple containers. These containers are sequenced by the accession container number.
COLLECTION_LIST_ID DOUBLE N Unique system identifier of a collection list or transfer list.
CONTAINER_ID DOUBLE N Unique system identifier of a container.
LINE_NBR DOUBLE Y Each accession in each collection list will have its own line number.
RESPONSIBLE_PARTY_ID DOUBLE N System identifier for the person who is responsible for the list. Not currently used.
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.


COLLECTION_PRIORITY



Column Section Top of Page


Table-level Detail

Description: Collection Priority
Definition: Stores all collection priorities (codeset 2054) and their attributes.
Table Type: REFERENCE





Column Detail - COLLECTION_PRIORITY


Column Name Type Null? Definition
ADDON_IND DOUBLE N If the indicator is on for this collection priority makes an add-on order which will not generate a nurse task.
AFTER_LAST_IND DOUBLE Y An indicator that orders with this collection priority should print immediately when they are requested before midnight and after the cut-off time for the last collection schedule time. The collection schedule time is based on the patient location, the order's specimen type, the collection priority, and nurse-collect status.
BEFORE_FIRST_IND DOUBLE Y An indicator that orders with this collection priority should print immediately when they are requested after midnight and before the cut-off time for the first collection schedule time. The collection schedule time is based on the patient location, the order's specimen type, the collection priority, and nurse-collect status.
COLLECTION_PRIORITY_CD DOUBLE N The internal number assigned by the system to the Collection Priority.
COL_LIST_IND DOUBLE Y Not currently in use.
DEFAULT_REPORT_PRIORITY_CD DOUBLE N Used by Powerchart orders to define the default reporting priority for orders placed with the given collection priority.
DEFAULT_START_DT_TM VARCHAR(20) Y Used by Powerchart orders as a default for the collection date/time for orders.
GROUP_WITH_OTHER_FLAG DOUBLE Y A flag indicating how orders with this collection priority should be grouped or netted with orders having different collection priorities.
IMMEDIATE_PRINT_IND DOUBLE Y An indicator that orders with this collection priority should always print labels immediately.
LABEL_SEQUENCE DOUBLE Y This field is used by label netting when several orders are netted to the same container. In this case, the netting procedure will look at the label sequence and the order with lower sequence will have priority.
LOOK_AHEAD_MINUTES DOUBLE Y Defines the window of time to look ahead to net orders.
LOOK_BACK_MINUTES DOUBLE Y Defines the window of time to look back to net orders.
TIME_STUDY_IND DOUBLE Y An indicator that this priority is a Time Study type of priority and future collection times will be specified at the time orders are requested.
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.


COLL_TEMPLATE_PREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: COLL TEMPLATE PREF
Definition: Used to store preferences for collection templates.
Table Type: REFERENCE





Column Detail - COLL_TEMPLATE_PREF


Column Name Type Null? Definition
COLL_TEMPLATE_CD DOUBLE N Contains the code value for the Collection Template.
MODE_FLAG DOUBLE N Stores which mode this preference is applied to. 1 - by location 2 - by list 3 - by accession 4 - by patient
PREFERENCE DOUBLE N This field stores what preference it is. PREF_DATE_FLAG = 10 PREF_LOOK_AHEAD_HOURS = 20 PREF_LOOK_BACK_HOURS = 30 PREF_CUTOFF_HOURS = 40 PREF_NURSE_COLLECT_FLAG = 50 PREF_CUTOFF_HOURS_TYPE_FLAG = 60 PREF_SHOW_NONE_COLL_PRIO = 70
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.
VALUE DOUBLE Y The value of the given preference



Relationship Detail - COLL_TEMPLATE_PREF


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