Table Detail Report

MIC_EVENT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Event Detail
Definition: This table contains a record for each task and event that occurs for the orderable procedure. Eachtime a task is added, modified or deleted a record is written to this table. Results that are corrected have the original results posted to this table.
Table Type: ACTIVITY





Column Detail - MIC_EVENT_DETAIL


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
CHARTABLE_IND DOUBLE Y This field indicates whether the task should be displayed on patient reports or be displayed in inquiry applications. Valid values include: 0 = Non-chartable 1 = Chartable
DETAIL_BIOCHEM_CD DOUBLE N This field identifies the code value associated with the detail biochemical. Detail biochemicals are defined on code set 1005.
DETAIL_SUS_CD DOUBLE N This field identifies the code value for the detail susceptibility procedure. Detail susceptibility procedures are defined on code set 1004.
EVENT_DETAIL_SEQ DOUBLE N This field identifies a unique value for each event detail record added to this table for a particular task_log_id and event_log seq combination.
EVENT_LOG_SEQ DOUBLE N This field identifies a unique value for each event record added to this table for a particular task_log_id.
GROUP_BIOCHEM_CD DOUBLE N This field identifies the code value associated with the group biochemical. Group biochemicals are defined on code set 1002.
MEDIA_CD DOUBLE N This field contains the code value of the specific type of media identified for this procedure. Media types are defined on code set 2051 Specimen Containers.
PANEL_CD DOUBLE N This field identifies the code value for the antibiotic panel. Antibiotic panels are defined on code set 1010.
PANEL_MED_CD DOUBLE N This field identifies the code value for the antibiotic. Antibiotic are defined on code set 1011.
POSITIVE_IND DOUBLE Y This field indicates whether or not the procedure is considered positive. Microbiology procedures are considered positive when a preliminary or final report is issued that includes a positive response or organism. Valid values include: 0 = Not positive 1 = Positive
PREV_EVENT_DETAIL_SEQ DOUBLE N Contains the event detail sequence number associated with the previous result that caused a delta checking failure on the current result.
PREV_EVENT_LOG_SEQ DOUBLE N Contains the event log sequence number associated with the previous result that caused a delta checking failure on the current result.
PREV_TASK_LOG_ID DOUBLE N Contains the task log identifier number associated with the previous result that caused a delta checking failure on the current result.
QUANTITATION_CD DOUBLE N This field identifies the code value of the quantity associated with the media and organism. Organism quantity codes are defined on code set 1022 Quantitations.
REPORT_IND DOUBLE Y This field indicates whether or not the quantity for the associated organism should be linked to the report. Only one quantity may be linked per organism.
RESULT_CD DOUBLE N This field identifies the code value of the biochemical or susceptibility result. Coded biochemical results are defined on code set 1027. Coded susceptibility results are defined on code sets 64 and 1025.
RESULT_NUMERIC DOUBLE Y This field identifies the susceptibility result if the detail susceptibility procedure is defined as 'numeric'. If the detail susceptibility procedure is not numeric this field will be set to '1'.
RESULT_STATUS_CD DOUBLE N This field identifies the status of the result. Result statuses are defined on code set 1901.
RESULT_TEXT VARCHAR(200) Y This field identifies the result text for tasks such as free-text biochemicals, and free text comments.
RESULT_UNIT_CD DOUBLE N This field identifies the code value for the units of measure associated with the numeric susceptibility result. Units of measure are defined on code set 54.
TASK_LOG_ID DOUBLE N This field identifies the unique value assigned to the task from the mic_task_log table thus associating the event log record with the appropriate 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_EVENT_DETAIL


Child Column in MIC_EVENT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: DETAIL_SUS_CD MIC_DETAIL_TASK TASK_COMPONENT_CD
PREV_EVENT_DETAIL_SEQ MIC_EVENT_DETAIL EVENT_DETAIL_SEQ
PREV_EVENT_LOG_SEQ MIC_EVENT_DETAIL EVENT_LOG_SEQ
PREV_TASK_LOG_ID MIC_EVENT_DETAIL TASK_LOG_ID
EVENT_LOG_SEQ MIC_EVENT_LOG EVENT_LOG_SEQ
TASK_LOG_ID MIC_EVENT_LOG TASK_LOG_ID
TASK_LOG_ID MIC_TASK_LOG TASK_LOG_ID




Parent Column in MIC_EVENT_DETAIL (PK) Child Table Name Child Column Name
Children: EVENT_DETAIL_SEQ MIC_EVENT_DETAIL PREV_EVENT_DETAIL_SEQ
EVENT_LOG_SEQ MIC_EVENT_DETAIL PREV_EVENT_LOG_SEQ
TASK_LOG_ID MIC_EVENT_DETAIL PREV_TASK_LOG_ID
EVENT_DETAIL_SEQ MIC_EVENT_FOOTNOTE EVENT_DETAIL_SEQ
EVENT_LOG_SEQ MIC_EVENT_FOOTNOTE EVENT_LOG_SEQ
TASK_LOG_ID MIC_EVENT_FOOTNOTE TASK_LOG_ID


MIC_EVENT_FOOTNOTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Event table for footnotes.
Definition: This table contains a record for susceptibility footnote that occurs for the orderable procedure. Each time a susceptibility footnote is added, modified or deleted a record is written to this table. Results that are corrected have the original results p
Table Type: ACTIVITY





Column Detail - MIC_EVENT_FOOTNOTE


Column Name Type Null? Definition
CHARTABLE_IND DOUBLE N This field indicates whether or not the susceptibility footnote is to be included on the patient reports and displayed in inquiry applications. Valid values include:0 = Not Chartable1 = Chartable
EKM_IND DOUBLE N This field indicates whether or not the event footnote has been generated from an expert knowledge module. Valid values include:0 = Not expert knowledge module generated1 = Expert knowledge module generated
EVENT_DETAIL_SEQ DOUBLE N This field identifies a unique value for each event detail record added to mic_event_detail table for a particular task_log_id and event_log seq combination.
EVENT_LOG_SEQ DOUBLE N This field identifies a unique value for each event record added to mic_event_log table for a particular task_log_id.
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 task from the mic_task_log table thus associating the event log record with the appropriate 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_EVENT_FOOTNOTE


Child Column in MIC_EVENT_FOOTNOTE(FK) Parent Table Name Parent Column Name
Parents: EVENT_DETAIL_SEQ MIC_EVENT_DETAIL EVENT_DETAIL_SEQ
EVENT_LOG_SEQ MIC_EVENT_DETAIL EVENT_LOG_SEQ
TASK_LOG_ID MIC_EVENT_DETAIL TASK_LOG_ID


MIC_EVENT_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Event Log
Definition: This table contains a record for each task and event that occurs for the orderable procedure. Eachtime a task is added, modified or deleted a record is written to this table.
Table Type: ACTIVITY





Column Detail - MIC_EVENT_LOG


Column Name Type Null? Definition
ABNORMAL_IND DOUBLE Y Indicates whether the event in the row is abnormal.
CHARTABLE_IND DOUBLE Y Indicates whether the event in the row should be printed on a patient chart.
EVENT_DT_TM DATETIME Y This field identifies the date and time the event log record was written.
EVENT_LOG_FLAG DOUBLE N Flag for the mic_event_log table that specifies special characteristics of the given row.
EVENT_LOG_SEQ DOUBLE N This field identifies a unique value for each event record added to this table for a particular task_log_id.
EVENT_STATUS_CD DOUBLE N This field identifies the status of the task at the time the event log record was written. Result statuses are defined on code set 1901.
EVENT_TECH_ID DOUBLE N This field identifies the ID of the person working with the task when the event log record is written. The event_tech_id corresponds to the person_id on the prsnl table, which identifies the user.
EXTERNAL_DEVICE_IND DOUBLE Y Indicates whether the task has been issued by an external device or issued from millennium applications. Valid values include: 0=Millennium Applications, 1=External Device.
LONG_TEXT_ID DOUBLE N This field identifies the long_text_id associated with the report task as it existed at a given event date and time. The report text is stored on the long_text table in formatted form for retrieval and display on management reports and inquiries.
ORGANISM_CD DOUBLE N The Organism code is the code set value that identifies the organism associated with the event in the row.
ORGANISM_SEQ DOUBLE N This field identifies a sequence number for each organism code_value entered. For example, if there are two gpc organisms identified for this procedure the first gpc organism would have an organism seq of 01 the second would have 02.
POSITIVE_IND DOUBLE Y Indicates whether the catalog code is considered positive.
SERVICE_RESOURCE_CD DOUBLE N The code value of the service resource code associated with the event.
TASK_LOG_ID DOUBLE N This field identifies the unique value assigned to the task from the mic_task_log table thus associating the event log record with the appropriate task.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - MIC_EVENT_LOG


Child Column in MIC_EVENT_LOG(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORGANISM_CD MIC_ORGANISM_DATA ORGANISM_ID
TASK_LOG_ID MIC_TASK_LOG TASK_LOG_ID
SERVICE_RESOURCE_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in MIC_EVENT_LOG (PK) Child Table Name Child Column Name
Children: EVENT_LOG_SEQ MIC_EVENT_DETAIL EVENT_LOG_SEQ
TASK_LOG_ID MIC_EVENT_DETAIL TASK_LOG_ID


MIC_EXT_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology External Data
Definition: External staging table for MIC concept, to temporarily hold untrusted data that has come from and external source (e.g. FHIR)
Table Type: ACTIVITY





Column Detail - MIC_EXT_DATA


Column Name Type Null? Definition
ACTION_PRSNL_DT_TM DATETIME Y The date and time of the action.
ACTION_PRSNL_ID DOUBLE Y The personnel who performed the action.;
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE Y Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE Y The person who caused the active_status_cd to be set or change.
CLIENT_IDENT VARCHAR(80) Y The client identifier that represents the client who wrote the data to the system.
CORRELATION_IDENT VARCHAR(80) Y Uppercase, hyphenated GUID that identifies the transaction that updated this row.
DATA_STATUS_CD DOUBLE Y The level of authenticity of the row data.
EFFECTIVE_DT_TM DATETIME Y The clinicaly significant date time of this lab result.
ENCNTR_ID DOUBLE Y The encounter related to the external data.
EVENT_ID DOUBLE Y The id of the clinical event associated to this lab result.
ISSUE_DT_TM DATETIME Y The date and time this external data was added to the staging tables.
LOGICAL_DOMAIN_ID DOUBLE Y The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MIC_EXT_BLOB LONGBLOB Y The dta that has come from an external interface.
MIC_EXT_DATA_ID DOUBLE N A system generated number to uniquely identify a row on the MIC_EXT_DATA table.
PARENT_EXT_DATA_ID DOUBLE Y This unique identifier is used to indicate the parent external data that groups this external data row is related to.
PERSON_ID DOUBLE Y Ther person related to the external data.
REQUESTED_ACTION_CD DOUBLE Y Actoin requested for the data.
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - MIC_EXT_DATA


Child Column in MIC_EXT_DATA(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
PARENT_EXT_DATA_ID MIC_EXT_DATA MIC_EXT_DATA_ID
PERSON_ID PERSON PERSON_ID
ACTION_PRSNL_ID PRSNL PERSON_ID
ACTIVE_STATUS_PRSNL_ID PRSNL PERSON_ID




Parent Column in MIC_EXT_DATA (PK) Child Table Name Child Column Name
Children: MIC_EXT_DATA_ID LAB_EXT_IDENTIFIER MIC_EXT_DATA_ID
MIC_EXT_DATA PARENT_EXT_DATA_ID


MIC_FOOTNOTE_FORMAT



Column Section Top of Page


Table-level Detail

Description: Microbiology Footnote Format
Definition: This reference table contains a record for each detail that defines a footnote format.
Table Type: REFERENCE





Column Detail - MIC_FOOTNOTE_FORMAT


Column Name Type Null? Definition
CODED_RESPONSE_CD DOUBLE N This field contains the internal identification code of the coded response, if any, associated withthe format detail on the line number specified.
DATA_ELEMENT_CD DOUBLE N This field contains the internal identification code of the data element to be printed in the footnote detail on the line number specified.
DATE_FORMAT_CD DOUBLE N This field contains the internal identification code of the date format associated with the format detail if a date element is selected in the DATA_ELEMENT_CD field.
FORMAT_CD DOUBLE N This field contains the internal identification code assigned to display format of the correlation message.
LINE_NUMBER DOUBLE N This field identifies the line number within the footnote format to which the format information included on this record applies.
LITERAL VARCHAR(255) Y This field contains the literal display value associated with the data element, if any, specified to print in the footnote format detail.
MAX_SIZE DOUBLE Y This field contains the printable size (number of characters) for the associated data element IF the data element includes a free text comment.
REQUIRED_IND DOUBLE N This field contains a value indicating that the footnote format detail is required or not required to be completed by the user.
SEPARATOR DOUBLE Y This field identifies the number of spaces between the LITERAL and DATA_ELEMENT defined in the format detail.
SEPARATOR2 DOUBLE Y This field identifies the number of spaces in front of the LITERAL defined in the format detail.
SEQUENCE DOUBLE N This field contains a sequence value that, when combined with the FORMAT_CD make the unique table key value. It also determines the order in which the details are displayed in 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.