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