Table Detail Report

MIC_STAT_PROCESS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Micro Statistical Processing
Definition: This statistical table contains the begin and end ranges that the existing data will need to be archived.
Table Type: ACTIVITY





Column Detail - MIC_STAT_PROCESS


Column Name Type Null? Definition
BEGIN_DT_TM DATETIME N This field indicates the beginning date of the time range. The complete date of the culture will be used to determine if the procedure falls within the date range.
COMPLETE_IND DOUBLE Y This field indicator whether data has been archived for the specified date range.
END_DT_TM DATETIME N This field indicates the ending date of the time range. The complete date of the culture will be used to determine if the procedure falls within the date range.
PROCESS_ID DOUBLE N This field contains a unique value that identifies all the procedures falls into the defined time range. This value is used to join to mic_stat_archive and mic_stat_duplicate tables.
PROCESS_TECH_ID DOUBLE N This field indicates the tech that archived the data.
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_PROCESS


Child Column in MIC_STAT_PROCESS(FK) Parent Table Name Parent Column Name
Parents: PROCESS_TECH_ID PRSNL PERSON_ID




Parent Column in MIC_STAT_PROCESS (PK) Child Table Name Child Column Name
Children: PROCESS_ID MIC_STAT_ARCHIVE PROCESS_ID
MIC_STAT_DUPLICATE PROCESS_ID


MIC_STAT_PURGE_PREF



Column Section Top of Page


Table-level Detail

Description: Micro Statistical Purge Preference
Definition: This statistical reference table contains the purge preference information defined by service resource, procedure and source criteria.
Table Type: REFERENCE





Column Detail - MIC_STAT_PURGE_PREF


Column Name Type Null? Definition
CATALOG_CD DOUBLE N This field contains the code_value of the procedure used to define purge preference.
NEGATIVE_MONTHS DOUBLE N This field indicates the number of months, based on complete date, the negative procedures will be stored on the archive tables before they are purged.
POSITIVE_MONTHS DOUBLE N This field indicates the number of months, based on complete date, the positive procedures will be stored on the archive tables before they are purged. The minimum month is 1.
SERVICE_RESOURCE_CD DOUBLE N This field contains the code_value of the service resource used to define purge preference.
SOURCE_CD DOUBLE N This field contains the code_value of the source used to define purge preference.
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_STAT_REPORT_DC_PARAM



Column Section Top of Page


Table-level Detail

Description: Micro Statistical Duplicate Checking Parameter
Definition: This statistical reference table contains the reports and susceptibility organisms duplicate checking information defined by service resource and source criteria.
Table Type: REFERENCE





Column Detail - MIC_STAT_REPORT_DC_PARAM


Column Name Type Null? Definition
ACROSS_ENCOUNTER_IND DOUBLE Y This field indicates if duplicate checking should be across encounters or not. 0 = duplicate checking should not be across encounters. 1 = duplicate checking should be across encounters.
ACROSS_SOURCE_IND DOUBLE Y This field indicates if duplicate checking should be across sources or not. 0 = duplicate checking should not be across sources. 1 = duplicate checking should be across sources.
LOOKBACK_HOURS DOUBLE Y This field indicates the number of hours to look back for duplicates based on the collected date and time of the procedure.
SERVICE_RESOURCE_CD DOUBLE N This field contains the code_value of the service resource used to define reports and organisms duplicate checking preference.
SOURCE_CD DOUBLE N This field contains the code_value of the source used to define reports and organisms duplicate checking preference.
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_STAT_REPORT_RESPONSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Statistical Report Response
Definition: This summary table is comprised of records extracted from the MIC_REPORT_RESPONSE table. This information is utilized by the Microbiology Statistical Reporting package.
Table Type: ACTIVITY





Column Detail - MIC_STAT_REPORT_RESPONSE


Column Name Type Null? Definition
ABNORMAL_IND DOUBLE Y This field identifies whether or not the response has been defined as an abnormal report response. Valid values include: 0 = Normal response 1 = Abnormal response
DUP_RESPONSE_IND DOUBLE Y This field indicates whether the response is considered to be a duplicate. The setting of the field is based on report duplicate checking rules.
GROUP_RESPONSE_ID DOUBLE N This field contains the internal identification code of the group response entered for the report task. This could be used to join to the MIC_GROUP_RESPONSE table.
ORG_TASK_LOG_ID DOUBLE N This field is used to correlate multiple responses to one TASK_LOG_ID on the MIC_STAT_TASK table.
POSITIVE_IND DOUBLE Y This field identifies whether or not the response has been defined as a positive report response. Valid values include: 0 = negative response 1 = positive response
RESPONSE_CD DOUBLE N This field contains the internal identification code of the coded response entered for the report task. This could contain code set 1021, 1022...
RESPONSE_CLASS_FLAG DOUBLE N This field identifies the type of response used in issuing the report.
RESPONSE_TEXT VARCHAR(500) Y This field contains free text response information associated with the report task.
SEQUENCE DOUBLE N The field contains a value that uniquely identifies each report response. This value will allow multiples of the same report response to be uniquely identified.
STATISTICS_FLAG DOUBLE Y This field identifies how a report response will be counted in statistical reporting.
TASK_LOG_ID DOUBLE N This field contains the internal identification code assigned to the report task from the MIC_STAT_TASK table thus associating the report result with the appropriate report task.
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_REPORT_RESPONSE


Child Column in MIC_STAT_REPORT_RESPONSE(FK) Parent Table Name Parent Column Name
Parents: GROUP_RESPONSE_ID MIC_GROUP_RESPONSE GROUP_RESPONSE_ID
ORG_TASK_LOG_ID MIC_STAT_TASK TASK_LOG_ID
TASK_LOG_ID MIC_STAT_TASK TASK_LOG_ID


MIC_STAT_SUSCEPTIBILITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Statistical Susceptibility
Definition: This summary table is comprised of records extracted from the MIC_SUS_ORDER_DETAIL and MIC_SUS_MED_RESULT tables. This information is utilized by the Microbiology Statistical Reporting package.
Table Type: ACTIVITY





Column Detail - MIC_STAT_SUSCEPTIBILITY


Column Name Type Null? Definition
ABNORMAL_IND DOUBLE Y This field identifies whether or not the susceptibility result has been defined as an abnormal susceptibility response. Valid values include: 0 = Normal response 1 = Abnormal response
ALPHA_RESULT_CD DOUBLE N This field contains the internal identification code for the alpha susceptibility result value.
ANTIBIOTIC_CD DOUBLE N This field contains the internal identification code for the antibiotic being tested.
ANTIBIOTIC_DISPLAY_ORDER DOUBLE N This field identifies the order in which the antibiotics will be displayed.
CHARTABLE_IND DOUBLE Y This field indicates whether the susceptibility result should be displayed on patient reports or be displayed in inquiry applications. Valid values include: 0 = Non-chartable 1 = Chartable
DELTA_CHECKING_IND DOUBLE Y Indicates whether or not a delta checking failure occurred for the result.
DETAIL_CD DOUBLE N This field contains the internal identification code for the detail susceptibility procedure.
DETAIL_DISPLAY_ORDER DOUBLE N This field identifies the order in which the detail susceptibility procedures will be displayed.
DETAIL_TYPE_FLAG DOUBLE Y This field identifies the type of detail susceptibility procedure.
DUP_ANTIBIOTIC_IND DOUBLE Y This field indicates whether the antibiotic is considered to be a duplicate. The setting of the field is based on susceptibility duplicate checking rules.
INTERP_RESULT_CD DOUBLE N This field contains the internal identification code for the interpretation susceptibility result value.
PANEL_CD DOUBLE N This field contains the internal identification code for the susceptibility panel.
PANEL_DISPLAY_ORDER DOUBLE N This field identifies the order in which the susceptibility panels will be displayed.
RESULT_DT_NBR DOUBLE N The date number when the susceptibility result was last updated. Used to gather date information from the OMF_DATE table.
RESULT_DT_TM DATETIME Y This field contains the date and time at which the susceptibility result was last updated.
RESULT_GROUP_CD DOUBLE N This field contains the internal identification code for the susceptibility result grouping to which this result is associated.
RESULT_MIN_NBR DOUBLE N The minute number when the susceptibility result was last updated. Used to get time information from the OMF_TIME table.
RESULT_NUMERIC DOUBLE N This field identifies the susceptibility result when the detail susceptibility procedure is defined as 'numeric'.
RESULT_PRSNL_ID DOUBLE N This field contains the internal identification code for the person whom last updated the susceptibility result. This could be used to join to the PRSNL table.
RESULT_UNITS_CD DOUBLE N This field contains the internal identification code for the units of measure associated with the numeric susceptibility result.
STATUS_CD DOUBLE N This field contains the internal identification code for the status of the susceptibility result.
TASK_LOG_ID DOUBLE N This field contains the internal identification code assigned to the susceptibility task from the MIC_STAT_TASK table thus associating the susceptibility result with the appropriate susceptibility task.
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_SUSCEPTIBILITY


Child Column in MIC_STAT_SUSCEPTIBILITY(FK) Parent Table Name Parent Column Name
Parents: TASK_LOG_ID MIC_STAT_TASK TASK_LOG_ID
RESULT_PRSNL_ID PRSNL PERSON_ID