Table Detail Report
MIC_GROUP_RESPONSE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Group Response Criteria |
Definition: | This table contains the information regarding group report responses defined for a microbiology orderable procedure and service resource. |
Table Type: | REFERENCE |
Column Detail - MIC_GROUP_RESPONSE
Column Name | Type | Null? | Definition |
---|---|---|---|
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. |
CARRY_FORWARD_IND | DOUBLE | N | This column represents whether group responses can be carry forwarded in successive reports or not. |
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. |
GROUP_DESCRIPTION | VARCHAR(60) | Y | Description of the group response |
GROUP_DISPLAY | VARCHAR(40) | Y | Display of the group response |
GROUP_RESPONSE_ID | DOUBLE | N | This field identifies a unique value for each group response defined for an orderable procedure/service resource combination. |
GRP_RESPONSE_CD | DOUBLE | N | This field identifies the code value of the group response code associated with the procedure and service resource. |
POSITIVE_IND | DOUBLE | Y | This field indicates whether the group response is to be considered positive or negative at the group response level. Valid value include: 0 = Negative 1 = Positive |
SERVICE_RESOURCE_CD | DOUBLE | N | This field identifies the code value of the service resource to which group responses are defined.Service resources are defined on code set 221. |
SOURCE_CD | DOUBLE | N | This field identifies the code value of the source to which group responses are defined. Sources are defined on code set 2052, 1150 and 1151. |
STATISTICS_IND | DOUBLE | Y | Indicator to determine if the response should be sent to archive for statistical purposes. Marked with a 1 if detail responses should be sent or a 2 on the first detail if the group should be sent |
TASK_ASSAY_CD | DOUBLE | N | This field identifies the code value of the report associated with the group response. Reports are defined on code set 1000, Microbiology Reports. |
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_GROUP_RESPONSE
Child Column in MIC_GROUP_RESPONSE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_ASSAY_CD | MIC_TASK | TASK_ASSAY_CD |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD | |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
Parent Column in MIC_GROUP_RESPONSE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | GROUP_RESPONSE_ID | MIC_GROUP_RESPONSE_MBR | GROUP_RESPONSE_ID |
MIC_REF_ANG_REPORT | GROUP_RESPONSE_ID | ||
MIC_STAT_REPORT_RESPONSE | GROUP_RESPONSE_ID |
MIC_GROUP_RESPONSE_MBR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Group Response Members |
Definition: | This table associates the coded responses with the microbiology group response/procedure and service resource. |
Table Type: | REFERENCE |
Column Detail - MIC_GROUP_RESPONSE_MBR
Column Name | Type | Null? | Definition |
---|---|---|---|
DETAIL_RESPONSE_CD | DOUBLE | N | This field identifies the code_value of the coded response or organism associated with the group response. Fill in the blank coded responses are defined on code set 1022 with a CDF meaning of 'BLANK'. |
GROUP_RESPONSE_ID | DOUBLE | N | This field identifies the unique value for group response from the mic_group_response table. |
NEW_PHRASE_IND | DOUBLE | Y | This field indicates whether the coded response should display on a new line or display on the current line. Valid values include: 0 = Display on current line 1 = Display on a new line |
RESPONSE_SEQ | DOUBLE | N | This field identifies a unique value for each coded response included in the group response. The sequence also determines the order the coded responses were entered into the group response. |
STATISTICS_IND | DOUBLE | Y | Determines whether or not a group or details within a group are sent to the archive model for statistical purposes |
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_GROUP_RESPONSE_MBR
Child Column in MIC_GROUP_RESPONSE_MBR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | GROUP_RESPONSE_ID | MIC_GROUP_RESPONSE | GROUP_RESPONSE_ID |
MIC_IC_ORDERS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Infection Control Candidate Orders |
Definition: | This activity table contains 'order' level information that is used for Infection Control Candidate reporting. This table contains information for General Lab and Microbiology orders only. |
Table Type: | ACTIVITY |
Column Detail - MIC_IC_ORDERS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACCESSION_NBR | VARCHAR(20) | N | This field uniquely identifies an order or a group of orders. |
ACTIVITY_TYPE_CD | DOUBLE | N | This field contains the internal identification code for the 'type' of order. For example, this table contains orders for both General Lab and Microbiology procedures and this field is used to differentiate between the types. |
BODY_SITE_CD | DOUBLE | N | This field contains the internal identification code identifying the body site from which this specimen was drawn. |
CATALOG_CD | DOUBLE | N | This field contains the internal identification code of the orderable procedure. This could be used to join to the ORDER_CATALOG table. |
COMPLETE_DT_TM | DATETIME | Y | This field contains the date and time at which the orderable procedure was completed. |
CULTURE_START_DT_TM | DATETIME | Y | This field identifies the start date and time of the orderable procedure. |
DRAWN_DT_TM | DATETIME | N | This field contains the date and time at which the orderable procedure was collected. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
NOSOCOMIAL_IND | DOUBLE | Y | This field indicates whether an infection was acquired during a hospital stay. Valid values include: 0 = No nosocomial infection 1 = Nosocomial infection |
ORDER_ID | DOUBLE | N | This field contains the internal identification code assigned to each orderable procedure associated with an order. For example: if there are two procedures on the same accession number, then each procedure will have a unique order id. |
ORDER_PROVIDER_ID | DOUBLE | N | This field contains the internal identification code for the ordering provider. This could be used to join to the PRSNL table. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
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 |
PROCEDURE_ORDER_DT_TM | DATETIME | N | This field contains the date and time at which the orderable procedure was ordered. |
RECEIVED_DT_TM | DATETIME | N | This field contains the date and time at which the orderable procedure was received. |
SOURCE_CD | DOUBLE | N | This field contains the internal identification code of the source to which this specimen was drawn. |
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_IC_ORDERS
Child Column in MIC_IC_ORDERS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
ORDER_ID | ORDERS | ORDER_ID | |
PERSON_ID | PERSON | PERSON_ID | |
ORDER_PROVIDER_ID | PRSNL | PERSON_ID |
MIC_INSTR_TRANS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Instrument Translation |
Definition: | This table contains the translation information for all codes transmitted from a susceptibility instrument interface to the Cerner system. This includes organisms, antibiotics, panels, sources, susceptibility results, susceptibility methods, and automate |
Table Type: | REFERENCE |
Column Detail - MIC_INSTR_TRANS
Column Name | Type | Null? | Definition |
---|---|---|---|
MICRO_ALIAS | VARCHAR(20) | N | This field identifies the description of the code as it exists on the host system(instrument) and identifies how the code will be transmitted to and from the Cerner system. |
MICRO_CD | DOUBLE | N | The microbiology code is the code set value of the row. This includes translations for source, procedure, medication, panel, |
MICRO_FLAG | DOUBLE | N | This field identifies the type of translation. |
SERVICE_RESOURCE_CD | DOUBLE | N | This field identifies the code value of the instrument for which translations are defined. |
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_INSTR_TRANS
Child Column in MIC_INSTR_TRANS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
MIC_INTERP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Interpretations |
Definition: | This table takes the combination of interp_id from the mic_sus_first_level_interp and each susceptibility interpretation detail procedure and creates a unique identifier which is used to define the susceptibility interpretation results. |
Table Type: | REFERENCE |
Column Detail - MIC_INTERP
Column Name | Type | Null? | Definition |
---|---|---|---|
INTERP_ID | DOUBLE | N | This field identifies a unique value for each set of susceptibility interpretations defined for an organism/source/antibiotic/susceptibility detail combination. |
INTERP_RANGE_ID | DOUBLE | N | This field identifies a unique value for each combination of interp_id and susceptibility interpretation detail procedure. This allows users to have multiple interpretations for each dilution result. |
INTERP_TEST_CD | DOUBLE | N | This field identifies the code_value of the interpretation susceptibility detail procedure for which susceptibility interpretations are defined. Susceptibility interpretation details are defined on code set 1004 and are identified on the mic_detail_task table with a task_type_flag of 7. |
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_INTERP
Child Column in MIC_INTERP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INTERP_TEST_CD | MIC_DETAIL_TASK | TASK_COMPONENT_CD |
INTERP_ID | MIC_SUS_FIRST_LEVEL_INTERP | INTERP_ID |
Parent Column in MIC_INTERP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | INTERP_RANGE_ID | MIC_INTERP_DATA | INTERP_RANGE_ID |