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 |