ALIQUOT_INFO_QUALIFIERS



Column Section Top of Page


Table-level Detail

Description: Aliquot information qualifiers
Definition: This table will hold the collection requirements for aliquots.
Table Type: REFERENCE





Column Detail - ALIQUOT_INFO_QUALIFIERS


Column Name Type Null? Definition
ALIQUOT_SEQ DOUBLE N Indicates the position of each of the requirements.
CATALOG_CD DOUBLE N Reference number for the order catalog item associated with the requirements.
COLL_CLASS_CD DOUBLE N Reference number for the collection class associated with these requirements.
COLL_INFO_SEQ DOUBLE N The sequence with which the collection requirements and aliquot requirements are associated.
MIN_VOL DOUBLE Y Defines the smallest amount of specimen needed for these requirements.
MIN_VOL_UNITS CHAR(15) Y The units associated with the Minimum Volume numeric value.
NET_IND DOUBLE Y Determines if each orderable will go into a unique aliquot container.
SPECIMEN_TYPE_CD DOUBLE N Reference number for the specimen type associated with these requirements.
SPEC_CNTNR_CD DOUBLE N Reference number for the specimen container associated with the requirements.
SPEC_HNDL_CD DOUBLE N Reference number for the special handling associated with these requirements.
STORAGE_TEMP_CD DOUBLE N Reference number for the storage temperature associated with the requirements.
UNITS_CD DOUBLE N Not used at this time.
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.


ALT_COLLECTION_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alternate Collections Information
Definition: Defines alternate collection requirements for a prticular collection requirement on an orderable.
Table Type: REFERENCE





Column Detail - ALT_COLLECTION_INFO


Column Name Type Null? Definition
ALT_COLLECTION_INFO_ID DOUBLE N Uniquely identifies alternate collection requirements information.
CATALOG_CD DOUBLE N The internal number assigned by the system to the order catalog item associated with the collection requirements.
COLL_CLASS_CD DOUBLE N The internal number assigned by the system to the Collection Class associated with the alternate container.
COLL_INFO_SEQ DOUBLE N The sequence with which the collection requirements are associated.
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 alternate collection requirements.
SPECIMEN_TYPE_CD DOUBLE N The internal number assigned by the system to the Specimen Type associated with the collection requirements.
SPEC_CNTNR_CD DOUBLE N The internal number assigned by the system to the Specimen Container associated with the collection requirements.
SPEC_HNDL_CD DOUBLE N The internal number assigned by the system to the Special Handling instructions associated with the alternate container.
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 - ALT_COLLECTION_INFO


Child Column in ALT_COLLECTION_INFO(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


ALT_COLLECTION_INFO_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Alternate Collection Information History
Definition: History of alternate collection requirements for a particular collection requirement on an orderable.
Table Type: ACTIVITY





Column Detail - ALT_COLLECTION_INFO_HIST


Column Name Type Null? Definition
ALT_COLLECTION_INFO_HIST_ID DOUBLE N Uniquely identifies historical alternate container information.
CATALOG_CD DOUBLE N Uniquely identifies the order catalog item associated with the collection requirements.
COLL_CLASS_CD DOUBLE N Uniquely identifies the collection class associated with the alternate container. If this value is null then the collection class of the parent collection requirement should be used.
COLL_INFO_HIST_ID DOUBLE N Uniquely identifies the related Collection History Information
MIN_VOL_AMT DOUBLE N The numeric value which, along with the specim container's Units, defines the smallest amount of specimen needed for the alternate.
SPECIMEN_TYPE_CD DOUBLE N Uniquely identifies the specimen type associated with the collection requirements.
SPEC_CNTNR_CD DOUBLE N Uniquely identifies the specimen container associated with the alternate container.
SPEC_HNDL_CD DOUBLE N Uniquely identifies the special handling instructions associated with the alternate container. If this value is NULL then the special handling instructions of the parent collection requirement should be 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.



Relationship Detail - ALT_COLLECTION_INFO_HIST


Child Column in ALT_COLLECTION_INFO_HIST(FK) Parent Table Name Parent Column Name
Parents: COLL_INFO_HIST_ID COLLECTION_INFO_QUAL_HIST COLLECTION_INFO_QUAL_HIST_ID


COLLECTION_CLASS



Column Section Top of Page


Table-level Detail

Description: Collection Class
Definition: Stores all collection classes (codeset 231) and their attributes.
Table Type: REFERENCE





Column Detail - COLLECTION_CLASS


Column Name Type Null? Definition
COLL_CLASS_CD DOUBLE N The internal number assigned by the system to the Collection Class.
CONTAINER_ID_PRINT CHAR(1) Y Determines whether or not and how container id's should be printed on labels.
DEF_STORAGE_MINUTES DOUBLE Y The default storage retention time in minutes that will be assigned to containers having this Collection Class code. The storage minutes are used to calculate the discard time for a container at the time it is placed in storage.
MAX_ACCESSION_SIZE DOUBLE Y The maximum number of characters to be included in the accession number bar code.
MAX_CLASS_VOLUME DOUBLE Y The numeric value which, along with the Maximum Collection Class Volume Units, represents the largest amount of specimen to be collected for netted orders having this Collection Class.
MAX_CLASS_VOL_UNITS CHAR(15) Y The units associated with the numeric value defined as the Maximum Collection Class Volume.
MAX_CLASS_VOL_UNITS_CD DOUBLE N The internal number assigned by the system to the Maximum Collection Class Volume Units.
SEQUENCE DOUBLE N Sequence field is used to indicate the print sequence of order label. The sequence will be used for label netting purpose. Collection class is not required to have sequence number, and 0 is the default value is sequence number is not assigned.
SMG_BARCODE_ADJUST DOUBLE N Determines left or right barcode adjustment on the label.
SMG_FORMAT CHAR(1) Y Determines left or right justification of the barcode on the label.
STORAGE_TEMP_CD DOUBLE N The default storage temperature for containers assigned to this collection class.
SYMBOLOGY CHAR(1) Y Determines what barcode symbology to use on the label.
TRANSFER_TEMP_CD DOUBLE N The default transfer temperature for containers assigned to this collection class.
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_INFO_QUALIFIERS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Collection Info Qualifiers
Definition: This is where all of the collection requirements are stored.
Table Type: REFERENCE





Column Detail - COLLECTION_INFO_QUALIFIERS


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.
AGE_FROM_MINUTES DOUBLE Y The beginning patient age in minutes for the age range associated with the collection requirements.
AGE_TO_MINUTES DOUBLE Y The ending patient age in minutes at which the collection requirements will no longer be applied. The collection requirements are applicable for patients whose ages are greater than or equal to the Age From Minutes, and less than the Age To Minutes.
ALIQUOT_IND DOUBLE Y An indicator that aliquot container requirements are associated with the collection requirements.
ALIQUOT_ROUTE_SEQUENCE DOUBLE Y Not currently used.
ALIQUOT_SEQ DOUBLE N This field will contain the sequence value of the parent container's collection requirements when aliquot container requirements exist. It is used to read all associate aliquot requirements on the aliquot_info_qualifers table directly for a given coll_info_seq value. If no aliquots exist, the field will contain a value of 0.0.
CATALOG_CD DOUBLE N The internal number assigned by the system to the order catalog item associated with the collection requirements.
COLLECTION_PRIORITY_CD DOUBLE N Provides the ability to flex collection requirements by priority.
COLL_CLASS_CD DOUBLE N The internal number assigned by the system to the Collection Class associated with the collection requirements.
MIN_VOL DOUBLE Y The numeric value which, along with the Minimum Volume Units, defines the smallest amount of specimen needed for the collection requirements.
MIN_VOL_UNITS CHAR(15) Y The units associated with the Minimum Volume numeric value.
OPTIONAL_IND DOUBLE Y An indicator that the collection requirements are acceptable for the order catalog item, but are not the preferred requirements. Not in use at this time.
REQUIRED_IND DOUBLE Y Not currently used.
SEQUENCE DOUBLE N The numeric value assigned by the system to indicate the sequence or position of each row of collection requirements.
SERVICE_RESOURCE_CD DOUBLE N The internal number assigned by the system to the Service Resource associated with the collection requirements.
SPECIES_CD DOUBLE N The internal number assigned by the system to the Species associated with the collection requirements. Not currently used.
SPECIMEN_TYPE_CD DOUBLE N The internal number assigned by the system to the Specimen Type associated with the collection requirements.
SPEC_CNTNR_CD DOUBLE N The internal number assigned by the system to the Specimen Container associated with the collection requirements.
SPEC_HNDL_CD DOUBLE N The internal number assigned by the system to the Special Handling Comments associated with the collection requirements.
UNITS_CD DOUBLE N Not in use at this time.
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_QUALIFIERS




Parent Column in COLLECTION_INFO_QUALIFIERS (PK) Child Table Name Child Column Name
Children: CATALOG_CD ALT_COLLECTION_INFO CATALOG_CD
SEQUENCE ALT_COLLECTION_INFO COLL_INFO_SEQ
SPECIMEN_TYPE_CD ALT_COLLECTION_INFO SPECIMEN_TYPE_CD
CATALOG_CD COLLECTION_INFO_QUAL_HIST CATALOG_CD
SEQUENCE COLLECTION_INFO_QUAL_HIST COLL_INFO_SEQ
SPECIMEN_TYPE_CD COLLECTION_INFO_QUAL_HIST SPECIMEN_TYPE_CD
CATALOG_CD LAB_HANDLING CATALOG_CD
SEQUENCE LAB_HANDLING COLL_INFO_SEQ
SPECIMEN_TYPE_CD LAB_HANDLING SPECIMEN_TYPE_CD