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 |