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 |