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. |