Table Detail Report

MIC_SEQUENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Sequence
Definition: This reference table contains a single record for every sequence included in the PathNet Microbiology system. It is a key table for most reports (reports retrieve information based upon a defined sequence).
Table Type: REFERENCE





Column Detail - MIC_SEQUENCE


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.
DESCRIPTION VARCHAR(60) Y This field stores the description associated with the sequence.
DISPLAY VARCHAR(40) Y This field stores the display associated with the sequence.
SEQUENCE_ID DOUBLE N This field contains the internal identification code that uniquely identifies the sequence (and itsassociated parameters). This value is used to join to other tables, such as the mic_seq_sort table.
SEQ_TYPE_FLAG DOUBLE N This field is used to store the type of sequence (Management or Statistical).
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 - MIC_SEQUENCE




Parent Column in MIC_SEQUENCE (PK) Child Table Name Child Column Name
Children: SEQUENCE_ID MIC_SEQ_FILTER SEQUENCE_ID
MIC_SEQ_PRINTER SEQUENCE_ID
MIC_SEQ_REPORT_R SEQUENCE_ID
MIC_SEQ_SERVICE_RESOURCE SEQUENCE_ID
MIC_SEQ_SORT SEQUENCE_ID


MIC_SEQ_CHILD_FILTER



Column Section Top of Page


Table-level Detail

Description: Microbiology Sequence Child Filter
Definition: This reference table contains filter value(s) and defaults for a specified 'child' filter on a sequence.
Table Type: REFERENCE





Column Detail - MIC_SEQ_CHILD_FILTER


Column Name Type Null? Definition
FILTER_BEGIN_STRING VARCHAR(100) Y This field is used to store the beginning string value for the default filter row.
FILTER_CD DOUBLE N This field contains the foreign key value used to join to the mic_seq_filter table. The field contains the internal identification code assigned to the filter stored on code_set 25212.
FILTER_END_STRING VARCHAR(100) Y This field is used to store the ending string value for the default filter row.
FILTER_FLAG DOUBLE Y This field is used to store a small numeric value for the default filter row.
FILTER_ID DOUBLE N This field contains the internal identification for this reference table.
FILTER_NBR DOUBLE Y This field is used to store a large numeric value for the default filter row.
PARENT_ENTITY_ID DOUBLE N This field is used to store a code value or identification for the default filter row. The parent_entity_name will determine which table the value came from.
PARENT_ENTITY_NAME VARCHAR(32) N This field is used to store the name of the table that places a value in the parent_entity_id field.
PARENT_FILTER_ID DOUBLE N This field is used to store an identification for the 'parent' filter row. The parent_entity_name will determine which table the value came from.
PARENT_FILTER_NAME VARCHAR(32) N This field is used to store the name of the 'parent filter' table. Currently, this column is only valued with 'MIC_SEQ_FILTER_DEFAULT'.
PARENT_SEQ DOUBLE N This field is used in conjunction with the PARENT_FILTER_NAME and PARENT_FILTER_ID columns to identify the 'parent' filter row. When the PARENT_FILTER_NAME is valued with MIC_SEQ_FILTER_DEFAULT this field maps to the SEQUENCE column on the MIC_SEQ_FILTER_DEFAULT table.
SEQUENCE_ID DOUBLE N This field contains the foreign key value used to join to sequence information stored on the mic_seq_filter and mic_sequence reference table.
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.


MIC_SEQ_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Sequence Filter
Definition: This reference table contains the filters associated with a sequence.
Table Type: REFERENCE





Column Detail - MIC_SEQ_FILTER


Column Name Type Null? Definition
FILTER_CD DOUBLE N If a filter was entered for the sequence, this field contains the internal identification code assigned to the filter. Filters are stored on code_set 25212.
SEQUENCE_ID DOUBLE N This field contains the foreign key value used to join to sequence information stored on the mic_sequence reference table.
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 - MIC_SEQ_FILTER


Child Column in MIC_SEQ_FILTER(FK) Parent Table Name Parent Column Name
Parents: SEQUENCE_ID MIC_SEQUENCE SEQUENCE_ID




Parent Column in MIC_SEQ_FILTER (PK) Child Table Name Child Column Name
Children: FILTER_CD MIC_SEQ_FILTER_DEFAULT FILTER_CD
SEQUENCE_ID MIC_SEQ_FILTER_DEFAULT SEQUENCE_ID


MIC_SEQ_FILTER_DEFAULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Sequence Filter Default
Definition: This reference table contains the default filter value(s) for a specified filter on a sequence.
Table Type: REFERENCE





Column Detail - MIC_SEQ_FILTER_DEFAULT


Column Name Type Null? Definition
FILTER_BEGIN_STRING VARCHAR(100) Y This field is used to store the beginning string value for the default filter row.
FILTER_CD DOUBLE N This field contains the foreign key value used to join to the mic_seq_filter table. The field contains the internal identification code assigned to the filter stored on code_set 25212.
FILTER_END_STRING VARCHAR(100) Y This field is used to store the ending string value for the default filter row.
FILTER_FLAG DOUBLE Y This field is used to store a small numeric value for the default filter row.
FILTER_NBR DOUBLE Y This field is used to store a large numeric value for the default filter row.
PARENT_ENTITY_ID DOUBLE N This field is used to store a code value or identification for the default filter row. The parent_entity_name will determine which table the value came from.
PARENT_ENTITY_NAME VARCHAR(32) Y This field is used to store the name of the table that places a value in the parent_entity_id field.
SEQUENCE DOUBLE N This field, in conjunction with the value included in the sequence_id and filter_cd field, uniquely identifies a row on this table.
SEQUENCE_ID DOUBLE N This field contains the foreign key value used to join to sequence information stored on the mic_seq_filter and mic_sequence reference table.
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 - MIC_SEQ_FILTER_DEFAULT


Child Column in MIC_SEQ_FILTER_DEFAULT(FK) Parent Table Name Parent Column Name
Parents: FILTER_CD MIC_SEQ_FILTER FILTER_CD
SEQUENCE_ID MIC_SEQ_FILTER SEQUENCE_ID


MIC_SEQ_PRINTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Sequence Printer
Definition: This reference table contains the printers associated with a sequence.
Table Type: REFERENCE





Column Detail - MIC_SEQ_PRINTER


Column Name Type Null? Definition
NBR_OF_COPIES DOUBLE Y This field contains the 'number of copies' value specified by the user when the sequence was executed.
OUTPUT_DEST_ID DOUBLE N This field contains the internal identification code of the output destination (related to a printer and a print queue) used to print the output produced after executing the sequence.
SEQUENCE_ID DOUBLE N This field contains the foreign key value used to join to sequence information stored on the mic_sequence reference table.
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 - MIC_SEQ_PRINTER


Child Column in MIC_SEQ_PRINTER(FK) Parent Table Name Parent Column Name
Parents: SEQUENCE_ID MIC_SEQUENCE SEQUENCE_ID
OUTPUT_DEST_ID OUTPUT_DEST OUTPUT_DEST_CD