Table Detail Report
MIC_INTERP_DATA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Interpretations Data |
Definition: | This table associates the susceptibility interpretation results with the organism/source/antibiotic/susceptibility detail combination defined on the mic_sus_first_level_interp table. |
Table Type: | REFERENCE |
Column Detail - MIC_INTERP_DATA
Column Name | Type | Null? | Definition |
---|---|---|---|
HIGH_VALUE | DOUBLE | Y | This field identifies the highest numeric susceptibility result for the interpretation range defined. This field displays the results according to the numeric sensi detail procedure's nbr_digits andnbr_decimals from the mic_detail_task table. This field is only valid for numeric sensi detail procedures, task_type_flag = 6. |
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_RESULT_CD | DOUBLE | N | This field identifies the code_value of the interpretation result for which susceptibility interpretations are defined.. Susceptibility interpretation results are defined on code set 64, Susceptibility Interp Results. |
LOW_VALUE | DOUBLE | N | This field identifies the lowest numeric susceptibility result for the interpretation range defined. This field displays the results according to the numeric sensi detail procedure's nbr_digits and nbr_decimals from the mic_detail_task table. This field is only valid for numeric sensi detail procedures, task_type_flag = 6. |
SUS_RESULT_CD | DOUBLE | N | This field identifies the code_value of the susceptiblity result for which susceptibility interpretations are defined.. Susceptibility alpha results are defined on code set 1025, Alpha SusceptibilityResults. |
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_DATA
Child Column in MIC_INTERP_DATA(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INTERP_RANGE_ID | MIC_INTERP | INTERP_RANGE_ID |
MIC_LONG_TEXT_SUBTYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Long text table for foonotes. |
Definition: | This table contains information regarding characteristics about each susceptibility footnote. Thistable determines if the footnote was generated from an expert knowledge module and whether or not the footnote is chartable. |
Table Type: | ACTIVITY |
Column Detail - MIC_LONG_TEXT_SUBTYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
CHARTABLE_IND | DOUBLE | N | This field indicates whether or not the susceptibility footnote is to be included on patient reports and displayed in inquiry applications. Valid values include: 0 = Not chartable 1= Chartable |
EKM_IND | DOUBLE | N | This field indicates whether or not the susceptibility footnote has been generated from an expert knowledge module. Valid values include: 0 = Not expert knowledge module generated 1= Expert knowledge module generated |
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. |
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_LONG_TEXT_SUBTYPE
Child Column in MIC_LONG_TEXT_SUBTYPE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
MIC_MEDIA
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Inoculation Media |
Definition: | This table contains the instrument interface translations for each piece of media. Media translations are currently used for blood culture instrument interfaces. |
Table Type: | REFERENCE |
Column Detail - MIC_MEDIA
Column Name | Type | Null? | Definition |
---|---|---|---|
INSTR_TRANS | CHAR(15) | Y | This field identifies the description of the media as it exists on the host system(instrument) and identifies how the code will be transmitted to and from the Cerner system. |
MEDIA_CD | DOUBLE | N | This field identifies the code_value of the media for which translations are defined.. Media is defined on code set 2051, Container. |
MEDIA_TYPE_FLAG | DOUBLE | Y | This field indicates whether the piece of media is associated with microbiology or virology procedures. |
REQ_ANG_IND | DOUBLE | N | This column represents whether media unload required for report generation in ANG. |
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_MEDIA
Parent Column in MIC_MEDIA (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MEDIA_CD | MIC_MEDIA_ACTIVITY | MEDIA_CD |
MIC_MEDIA_DEFAULT | MEDIA_CD |
MIC_MEDIA_ACTIVITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Blood Analyzer Media Activity |
Definition: | This table contains media activity information for each orderable procedure. |
Table Type: | ACTIVITY |
Column Detail - MIC_MEDIA_ACTIVITY
Column Name | Type | Null? | Definition |
---|---|---|---|
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. |
FINAL_UNLOAD_DT_TM | DATETIME | Y | This field identifies the date and time the media was unloaded from the blood culture instrument. This date and time is sent to the Cerner system from several of the blood culture instrument interfaces. This date and time is used to know when the Cerner system should send the final ANG report defined to be sent at 9999 hours. |
INITIAL_LOAD_DT_TM | DATETIME | Y | This field identifies the date and time the media was actually loaded onto the blood culture instrument. This date and time is sent to the Cerner system from several of the blood culture instrument interfaces. This date and time is used to calculate the ANG reporting times. |
INSTR_MEDIA_IDENT | VARCHAR(50) | Y | Identification number assigned to media uploaded from automated microbiology instruments. |
INSTR_MEDIA_LOCATION | CHAR(10) | Y | This field identifies the exact location of the media in the instrument. |
INSTR_STATUS | CHAR(20) | Y | This field is not used at this time. |
INSTR_TRANS | CHAR(15) | Y | This field identifies the translation code for the media. This is the code that will be sent to the blood culture instrument interface to represent the type of media. |
LABEL_CNT | DOUBLE | Y | This field identifies the number of media labels to be printed for this type of media. |
LAST_RESULT_DT_TM | DATETIME | Y | This field identifies the date and time the last result was received from the blood culture instrument interface. |
LAST_RESULT_FLAG | DOUBLE | Y | This field indicates the type of transaction sent from the instrument. |
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. |
MEDIA_SEQ | DOUBLE | N | This field contains a unique value that uniquely identifies more than occurrence of the same media code for a given organism. |
ORDER_ID | DOUBLE | N | This field contains the unique value 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. |
POSITIVE_DT_TM | DATETIME | Y | This field identifies the date and time the Cerner system last received a positive transaction on this media. |
POSITIVE_IND | DOUBLE | Y | This field identifies that the Cerner system has received a presumptive positive transaction from the instrument for this type of media. This indicator does not set the orderable procedure to positive. Only positive responses and/or organisms issued as part of a preliminary, final or amended report type can set an orderable procedure to positive. |
START_DT_TM | DATETIME | Y | This field identifies the start date and time of the orderable procedure. This field is updated when the procedure is received into its performing service resource. |
START_ID | DOUBLE | N | This field identifies the ID of the person who started the procedure. The start_id corresponds to the person_id on the prsnl table, which identifies the user. |
SUBCULTURE_IND | DOUBLE | Y | This field is not used at this time. |
TASK_LOG_ID | DOUBLE | N | This field is not used at this time. |
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_MEDIA_ACTIVITY
Child Column in MIC_MEDIA_ACTIVITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MEDIA_CD | MIC_MEDIA | MEDIA_CD |
ORDER_ID | MIC_ORDER_LAB | ORDER_ID | |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
MIC_MEDIA_DEFAULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Default Inoculation Media |
Definition: | This table identifies the default media associated with each procedure/source/body site and serviceresource combination. |
Table Type: | REFERENCE |
Column Detail - MIC_MEDIA_DEFAULT
Column Name | Type | Null? | Definition |
---|---|---|---|
BODY_SITE_CD | DOUBLE | N | This field identifies the code_value of the body site used to define default media. Body sites are defined on code set 1028, Body Sites. |
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. |
MEDIA_CD | DOUBLE | N | This field identifies the code_value of the media for which defaults are defined.. Media is defined on code set 2051, Container. |
MEDIA_LABEL_CNT | DOUBLE | Y | This field identifies the number of media labels that should be printed for this piece of media. |
MEDIA_SEQ | DOUBLE | N | This is the numeric sequence that determines the uniqueness of a row when more than one media is associated with the same service_resource_cd and catalog_cd. |
SERVICE_RESOURCE_CD | DOUBLE | N | This field identifies the code value of the service resource to which default media is defined. Service resources are defined on code set 221. |
SOURCE_CD | DOUBLE | N | This field identifies the code_value of the source used to define default media. All three levels of source hierarchy (source, section, and category) can be used to define interpretations. |
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_MEDIA_DEFAULT
Child Column in MIC_MEDIA_DEFAULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MEDIA_CD | MIC_MEDIA | MEDIA_CD |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD | |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |