Table Detail Report
MIC_MEDIA_LOT_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Media Lot Relation |
Definition: | This table stores the relationship between a media observation and the associated media lot(s) used for the observation. |
Table Type: | ACTIVITY |
Column Detail - MIC_MEDIA_LOT_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
LOT_INFORMATION_ID | DOUBLE | N | This field contains the unique identifier of the related PCS_LOT_INFORMATION row. |
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_LOT_RELTN_ID | DOUBLE | N | This field contains the unique identifier of the media/lot relationship. |
MEDIA_SEQ | DOUBLE | N | This field contains the media_seq associated with the related MIC_ORGANISM_OBSERVATION row. |
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. |
RESULT_SCHEDULE_ID | DOUBLE | N | This field contains the unique identifier of the related MIC_QC_RESULT_SCHEDULE row. |
TASK_LOG_ID | DOUBLE | N | This field contains the task_log_id associated with the related MIC_ORGANISM_OBSERVATION row. |
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_LOT_RELTN
Child Column in MIC_MEDIA_LOT_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MEDIA_SEQ | MIC_ORGANISM_OBSERVATION | MEDIA_SEQ |
TASK_LOG_ID | MIC_ORGANISM_OBSERVATION | TASK_LOG_ID | |
ORDER_ID | ORDERS | ORDER_ID | |
LOT_INFORMATION_ID | PCS_LOT_INFORMATION | LOT_INFORMATION_ID |
MIC_MEDICATION_RANGE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Medication Range |
Definition: | This table associates the abnormal susceptibility results with the procedure/source/organism/susceptibility type and service resource combination defined on the mic_abn_sus_result table. |
Table Type: | REFERENCE |
Column Detail - MIC_MEDICATION_RANGE
Column Name | Type | Null? | Definition |
---|---|---|---|
ABN_SUS_ID | DOUBLE | N | This field identifies a unique value for each set of abnormal susceptibility results defined for a procedure/source/organism/susceptibility type and service resource combination. |
DEFAULT_RESULT_CD | DOUBLE | N | This field identifies the code_value of the susceptibility alpha or interpretation result for which abnormals susceptibility results are defined.. Susceptibility interpretation results are defined on code set 64, Susceptibility Interp Results and alpha susceptibility results are defined on code set 1025, Alpha Susceptibility Results. |
HIGH_VALUE | DOUBLE | Y | This field identifies the highest numeric susceptibility result for the abnormal susceptibility result 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. |
LOW_VALUE | DOUBLE | N | This field identifies the lowest numeric susceptibility result for the abnormal susceptibility result range defined. This field displays the results according to the numeric sensi detail procedure'snbr_digits and nbr_decimals from the mic_detail_task table. This field is only valid for numeric sensi detail procedures, task_type_flag = 6. |
MEDICATION_CD | DOUBLE | N | This field identifies the code_value of the antibiotic for which susceptibility interpretations are defined.. Antibiotics are defined on code set 1011 Antibiotics(Medications) |
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_MEDICATION_RANGE
Child Column in MIC_MEDICATION_RANGE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ABN_SUS_ID | MIC_ABN_SUS_RESULT | ABN_SUS_ID |
MEDICATION_CD | MIC_DETAIL_TASK | TASK_COMPONENT_CD |
MIC_MEDS_ACTIVITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Current Medication |
Definition: | This table contains information regarding the current medications added to an order during the microbiology log in conversation. |
Table Type: | ACTIVITY |
Column Detail - MIC_MEDS_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. |
MEDICATION_CD | DOUBLE | N | This field identifies the code value for the antibiotic associated with the order. Antibiotics are defined on code set 1011. |
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. |
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_MEDS_ACTIVITY
Child Column in MIC_MEDS_ACTIVITY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MEDICATION_CD | MIC_DETAIL_TASK | TASK_COMPONENT_CD |
ORDER_ID | MIC_ORDER_LAB | ORDER_ID | |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
MIC_MED_TRADE_NAME
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Medication Trade Name |
Definition: | This table contains the generic trade name, route and dosage information defined for each antibiotic. |
Table Type: | REFERENCE |
Column Detail - MIC_MED_TRADE_NAME
Column Name | Type | Null? | Definition |
---|---|---|---|
CHART_IND | DOUBLE | Y | This field indicates whether the trade name should be included in inquiry applications and on patient reports. Valid values include: 0 = Do not chart 1 = Chart |
COST_PER_DOSE | VARCHAR(10) | Y | This field identifies the cost per dose of the antibiotic for the defined trade name. |
DOSAGE | VARCHAR(30) | Y | This field identifies the standard dosage of the antibiotic for the defined trade name. |
PRIMARY_IND | DOUBLE | Y | This field indicates whether the trade name is the primary trade name. Charting will able to be defined such that either all trade names print on patient reports or only the primary trade name. Valid values include: 0 = Not the primary trade name 1 = Primary trade name |
TASK_COMPONENT_CD | DOUBLE | N | This field identifies the code_value of the antibiotic to which the trade name is associated. Antibiotics are defined on code set 1011 Antibiotics(Medications) |
TRADE_NAME | VARCHAR(50) | Y | This field identifies the generic trade name associated with the antibiotic. |
TRADE_NAME_SEQ | DOUBLE | N | This field contains a unique value for each trade name associated with an antibiotic. The first trade name would be assigned sequence 1, and the second trade name would be assigned sequence 2, etc. |
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_MED_TRADE_NAME
Child Column in MIC_MED_TRADE_NAME(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_COMPONENT_CD | MIC_DETAIL_TASK | TASK_COMPONENT_CD |
MIC_ORDER_LAB
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Microbiology Orders |
Definition: | This table contains the order level activity information for ordered microbiology procedures. Thistable is filled out initially during the order conversation and is updated again when the procedureis received into its performing service resource. |
Table Type: | ACTIVITY |
Column Detail - MIC_ORDER_LAB
Column Name | Type | Null? | Definition |
---|---|---|---|
ARCHIVE_DT_TM | DATETIME | Y | This field is not used at this time. |
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. |
COMPLETE_DT_TM | DATETIME | Y | This field identifies the date and time the procedure was completed. |
CULTURE_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. |
DOWNLOAD_IND | DOUBLE | Y | This field relates to the blood culture instrument interfaces. Once all of the media associated with a procedure has been successfully downloaded to the instrument this field will be set to 1 indicating that it has downloaded. If not set to 1, user can re-download the procedure again. Valid values include: 1 = downloaded 0 = not downloaded |
EVENT_FLAG | DOUBLE | Y | Obsolete. This field is not used at this time. |
INTERP_TEXT_ID | DOUBLE | N | Identifies the long_text_id value from the long_text table that associates the interpretive data text with this orderable procedure. |
NOSOCOMIAL_IND | DOUBLE | Y | Nosocomial refers to an infection that a patient gets while in the hospital. Customization can be done to the number of hours between patient admission and specimen collection that would qualify a culture as a nosocomial infection. So this column indicates when a positive culture is deemed to be an infection that developed while the patient was in the hospital. |
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. |
ORDER_LOCK_DT_TM | DATETIME | Y | This field identifies the date and time the record was locked. When the user exits the microbiology application accessing the accession this field will be set to null. |
ORDER_LOCK_ID | DOUBLE | N | This field identifies the id of the person that currently has this order_id locked. The order_lock_id corresponds to the person_id on the prsnl table, which identifies the user. When the user exits the microbiology application accessing the accession this field will be set to null. |
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 |
PRELIMINARY_POSITIVE_IND | DOUBLE | Y | This field is not used at this time. |
PURGE_DT_TM | DATETIME | Y | This field is not used at this time. |
REPORT_IND | DOUBLE | Y | This field indicates whether or not a report has been issued for the procedure. This indicator is used by the microbiology inquiry application to quickly identify if a procedure has a report issued.Valid values include: 0 = No report issued 1 = Report has been issued. |
RESTORED_DT_TM | DATETIME | Y | This field is not used at this time. |
SERVICE_RESOURCE_CD | DOUBLE | N | Identifies the service_resource code_value (code set 221 service resource) for the orderable procedure. This is the service resource code where the procedure is currently located and where interpretive data text will be extracted from for this procedure. This field is only filled out if there is interpretive data associated with the orderable procedure. |
STATUS_CD | DOUBLE | N | This field identifies the current status of the orderable procedure. The status code_value is fromcode set 1031 & 1905 Micro Status. |
SUSCEPTIBILITY_IND | DOUBLE | Y | This field indicates whether or not a susceptibility has been ordered for the procedure. This indicator is used by the microbiology inquiry application to quickly identify if a procedure has a susceptibility ordered. Valid values include: 0 = No susceptibilities ordered 1 = Susceptibilities ordered |
SUS_INSTR_ID_NBR | CHAR(18) | Y | This field is not used at this time. |
TASK_ASSAY_CD | DOUBLE | N | Identifies the task_assay_cd from the discrete_task_assay code set(14003) for the orderable procedure. This field is only filled out if there is interpretive data associated with the orderable procedure. |
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_ORDER_LAB
Child Column in MIC_ORDER_LAB(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
INTERP_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
ORDER_ID | ORDERS | ORDER_ID | |
CATALOG_CD | ORDER_CATALOG | CATALOG_CD | |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
Parent Column in MIC_ORDER_LAB (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ORDER_ID | MIC_ACT_ANG_SUM_RPT | ORDER_ID |
MIC_ANG_AUTOMATED | ORDER_ID | ||
MIC_MEDIA_ACTIVITY | ORDER_ID | ||
MIC_MEDS_ACTIVITY | ORDER_ID | ||
MIC_PATHOGEN | ORDER_ID | ||
MIC_REQUIRED_TASK | ORDER_ID |