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 |