Table Detail Report

MIC_REQ_RPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Required Reports
Definition: This table identifies the required and pending reports for each procedure/source and service resource combination.
Table Type: REFERENCE





Column Detail - MIC_REQ_RPT


Column Name Type Null? Definition
CRITERIA_ID DOUBLE N This field identifies a unique value for each set of required and pending reports defined for each procedure/source and service resource combination.
REQUIRED_IND DOUBLE Y This field indicates whether the report is required (mandatory) or pending (suggested) for the procedure. Valid values include: 0 = Pending 1 = Required
TASK_CD DOUBLE N This field identifies the code_value of the report defined as required or pending for this procedure. Reports are defined on code set 1000, Microbiology Reports.
TAT_MINUTES DOUBLE N This field identifies the turnaround time value for the report. This time value is the expected turn around time for the report associated with the procedure.
TAT_UNITS_CD DOUBLE N This field identifies the unit of time associated with the tat_minutes field. Units are defined on code set 340, Age Units.
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_REQ_RPT


Child Column in MIC_REQ_RPT(FK) Parent Table Name Parent Column Name
Parents: CRITERIA_ID MIC_RPT_PARAMS CRITERIA_ID
TASK_CD MIC_TASK TASK_ASSAY_CD


MIC_RESULT_FOOTNOTE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference table for footnotes.
Definition: This table contains information associating the susceptibility footnote text from the long_text table with the antibiotic.
Table Type: ACTIVITY





Column Detail - MIC_RESULT_FOOTNOTE_R


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N This field identifies the code value for the antibiotic. Antibiotics are defined on code set 1011.
LONG_TEXT_ID DOUBLE N This field identifies the long_text_id associated with the footnote text. The footnote text is stored on the long_text table.
TASK_LOG_ID DOUBLE N This field identifies the unique value assigned to the susceptibility task from the mic_task_log table thus associating the susceptibility task with the footnote.
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_RESULT_FOOTNOTE_R


Child Column in MIC_RESULT_FOOTNOTE_R(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ANTIBIOTIC_CD MIC_DETAIL_TASK TASK_COMPONENT_CD


MIC_RPT_LIMIT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Report Limits
Definition: This table associates a limit on the number of times a particular report can be issued for a procedure/report type.
Table Type: REFERENCE





Column Detail - MIC_RPT_LIMIT


Column Name Type Null? Definition
CRITERIA_ID DOUBLE N This field identifies a unique value for each set of required and pending reports defined for each procedure/source and service resource combination.
REPORT_LIMIT DOUBLE Y This field identifies the number of times the report can be issued for a procedure/accession.
TASK_CD DOUBLE N This field identifies the code_value of the report defined as required or pending for this procedure. Reports are defined on code set 1000, Microbiology Reports.
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_RPT_LIMIT


Child Column in MIC_RPT_LIMIT(FK) Parent Table Name Parent Column Name
Parents: CRITERIA_ID MIC_RPT_PARAMS CRITERIA_ID
TASK_CD MIC_TASK TASK_ASSAY_CD


MIC_RPT_PARAMS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Report Parameters
Definition: This table identifies a unique value for each procedure/source and service resource combination forwhich required and pending report parameters are defined.
Table Type: REFERENCE





Column Detail - MIC_RPT_PARAMS


Column Name Type Null? Definition
CATALOG_CD DOUBLE N This field contains the code value assigned to the procedure as defined in the DCPtools.exe application. Ordered procedure code values are stored on code set 200 Order Catalog.
CRITERIA_ID DOUBLE N This field identifies a unique value for each set of required and pending reports defined for each procedure/source and service resource combination.
SERVICE_RESOURCE_CD DOUBLE N This field identifies the code value of the service resource to which report parameters are defined. Service resources are defined on code set 221.
SOURCE_GROUPING_CD DOUBLE N This field identifies the code_value of the source used to define report parameters. All three levels of source hierarchy (source, section, and category) can be used to define interpretations.
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_RPT_PARAMS


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




Parent Column in MIC_RPT_PARAMS (PK) Child Table Name Child Column Name
Children: CRITERIA_ID MIC_REQ_RPT CRITERIA_ID
MIC_RPT_LIMIT CRITERIA_ID


MIC_SCRIPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Scripted Workup
Definition: This reference table contains a single record for every Microbiology 'organism scripted work-up' (Script).
Table Type: REFERENCE





Column Detail - MIC_SCRIPT


Column Name Type Null? Definition
EXCLUDE_TECH_IND DOUBLE Y This indicator field is used to determine whether Microbiology techs defined on the MIC_SCRIPT_TECH table can run the script or not. A value of 1 indicates that techs on the MIC_SCRIPT_TECH table can NOT run the script.
SCRIPT_ID DOUBLE N This field contains the internal identification code that uniquely identifies the 'organism scripted work-up' and its associated parameters. This value is used to join to the MIC_SCRIPT_* tables.
SCRIPT_NAME VARCHAR(40) N This field contains a unique name for a script.
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_SCRIPT




Parent Column in MIC_SCRIPT (PK) Child Table Name Child Column Name
Children: SCRIPT_ID MIC_SCRIPT_CRITERIA SCRIPT_ID
MIC_SCRIPT_NODE SCRIPT_ID
MIC_SCRIPT_TECH SCRIPT_ID