Table Detail Report

MIC_SEQ_REPORT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Sequence Report Relationship
Definition: This reference table contains relationships between Microbiology Sequences and Microbiology Statistical and Management reports. This relationship defines which reports are available for a specific sequence.
Table Type: REFERENCE





Column Detail - MIC_SEQ_REPORT_R


Column Name Type Null? Definition
REPORT_CD DOUBLE N This field contains the internal identification code of a Microbiology Statistical report. This could be used to join to the CODE_VALUE table.
SEQUENCE_ID DOUBLE N This field contains the internal identification code of a Microbiology sequence. This could be used to join to the MIC_SEQUENCE 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_REPORT_R


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


MIC_SEQ_SERVICE_RESOURCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Sequence Service Resource
Definition: This reference table contains the service resources associated with a sequence.
Table Type: REFERENCE





Column Detail - MIC_SEQ_SERVICE_RESOURCE


Column Name Type Null? Definition
SEQUENCE_ID DOUBLE N This field contains the foreign key value used to join to sequence information stored on the mic_sequence reference table.
SERVICE_RESOURCE_CD DOUBLE N This field contains the internal identification code of the service resource to which the sequence is assigned. This could be used to join to the service_resource 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_SERVICE_RESOURCE


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


MIC_SEQ_SORT



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - MIC_SEQ_SORT


Column Name Type Null? Definition
ASCENDING_IND DOUBLE Y This indicator value specifies whether or not the report generated from the sequence should be ordered ascending or descending by the associated sort field.
PAGE_BREAK_IND DOUBLE Y This indicator value specifies whether or not the report generated from the sequence should page break on the associated sort field.
SEQUENCE_ID DOUBLE N This field contains the foreign key value used to join to sequence information stored on the mic_sequence reference table.
SORT_CD DOUBLE N If a sort was entered for the sequence, this field contains the internal identification code assigned to the sort. Sorts are stored on code_set 25213.
SORT_SEQ DOUBLE Y This field contains a numeric value that is used to order sorts used for a sequence. For example, this field would be used to sequence service resource #1 and task date/time #2.
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_SORT


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


MIC_STAIN_CORRELATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Stain Correlation
Definition: This reference table contains a single record for every correlation check for a stain at a service resource that needs to occur.
Table Type: REFERENCE





Column Detail - MIC_STAIN_CORRELATION


Column Name Type Null? Definition
CATALOG_CD DOUBLE N This field contains the internal identification code of the procedure to which the correlation is assigned. This could be used to join to the order_catalog table.
FAILURE_REASON_CD DOUBLE N This field contains the internal identification code assigned to the type of failure the correlation rule is checking.
FORMAT_CD DOUBLE N This field contains the internal identification code assigned to display format of the correlation message.
SERVICE_RESOURCE_CD DOUBLE N This field contains the internal identification code of the service resource to which the sequence is assigned. This could be used to join to the service_resource table.
STAIN_CD DOUBLE N This field contains the internal identification code assigned to the stain associated for this correlation rule. Reports are stored on code_set 1000 and set up as a 'stain' on the mic_task 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_STAIN_CORRELATION


Child Column in MIC_STAIN_CORRELATION(FK) Parent Table Name Parent Column Name
Parents: CATALOG_CD ORDER_CATALOG CATALOG_CD
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD


MIC_STAT_ARCHIVE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Statistical Archive
Definition: This table contains Microbiology orders, which require archiving into the Microbiology statistical data model.
Table Type: ACTIVITY





Column Detail - MIC_STAT_ARCHIVE


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N This field identifies the level of at which level this order needs to be archived.
ORDER_ID DOUBLE N This field contains the unique value assigned to each orderable procedure associated with an order. For example: if there are two procedures on the same accession number, then each procedure will have a unique order id.
PROCESS_ID DOUBLE N This field contains the internal identification code of the process, which triggered the archiving of the order. This field contains a non-zero value only when archiving is triggered from the Statistical Preference tool. This could be used to join to the MIC_STAT_PROCESS 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_STAT_ARCHIVE


Child Column in MIC_STAT_ARCHIVE(FK) Parent Table Name Parent Column Name
Parents: PROCESS_ID MIC_STAT_PROCESS PROCESS_ID
ORDER_ID ORDERS ORDER_ID