Table Detail Report

MIC_SUS_DELTA_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Susceptibility Delta Checking Result
Definition: This reference table contains the alpha result values for susceptibility results delta checking.
Table Type: REFERENCE





Column Detail - MIC_SUS_DELTA_RESULT


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N This field contains the code_value of the antibiotic used to define susceptibility delta checking value criteria.
RESULT_CD DOUBLE N The code_value of the alpha results and interpreted results used to define the susceptibility delta checking value.
SUS_DELTA_VALUE_ID DOUBLE N This field contains a foreign key value used to join susceptibility delta checking value information.
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.
VALUE_NBR DOUBLE N This field indicates the delta checking value assigned to the particular result.



Relationship Detail - MIC_SUS_DELTA_RESULT


Child Column in MIC_SUS_DELTA_RESULT(FK) Parent Table Name Parent Column Name
Parents: SUS_DELTA_VALUE_ID MIC_SUS_DELTA_VALUE SUS_DELTA_VALUE_ID


MIC_SUS_DELTA_VALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Susceptibility Delta Checking Value
Definition: This reference table contains criteria information for susceptibility results delta checking values.
Table Type: REFERENCE





Column Detail - MIC_SUS_DELTA_VALUE


Column Name Type Null? Definition
ORGANISM_CD DOUBLE N The code_value of the organism used to define susceptibility delta checking value criteria.
SERVICE_RESOURCE_CD DOUBLE N This field contains the code_value of the service resource used to define susceptibility delta checking value criteria.
SOURCE_CD DOUBLE N The code_value of the source used to define susceptibility delta checking value criteria.
SUS_DELTA_VALUE_ID DOUBLE N This field contains a unique value that identifies the susceptibility delta checking value criteria.
SUS_DETAIL_CD DOUBLE N The code_value of the source used to define susceptibility delta checking value criteria.
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_SUS_DELTA_VALUE




Parent Column in MIC_SUS_DELTA_VALUE (PK) Child Table Name Child Column Name
Children: SUS_DELTA_VALUE_ID MIC_SUS_DELTA_NUMERIC_RESULT SUS_DELTA_VALUE_ID
MIC_SUS_DELTA_RESULT SUS_DELTA_VALUE_ID


MIC_SUS_DELTA_XREF



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Susceptibility Delta Checking Parameter Cross Reference
Definition: Contains delta check information between susceptibility details based on susceptibility delta checking criteria.
Table Type: REFERENCE





Column Detail - MIC_SUS_DELTA_XREF


Column Name Type Null? Definition
ANTIBIOTIC_CD DOUBLE N Code_value of the antibiotic used to define susceptibility delta checking parameter criteria.
SUS_DELTA_PARAM_ID DOUBLE N Unique value that identifies susceptibility delta checking parameter criteria.
SUS_DETAIL1_CD DOUBLE N Code_value of the first susceptibility detail to be cross referenced.
SUS_DETAIL2_CD DOUBLE N Code_value of the second susceptibility detail to be cross referenced.
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_SUS_DELTA_XREF


Child Column in MIC_SUS_DELTA_XREF(FK) Parent Table Name Parent Column Name
Parents: ANTIBIOTIC_CD MIC_SUS_DELTA_PARAMETER ANTIBIOTIC_CD
SUS_DELTA_PARAM_ID MIC_SUS_DELTA_PARAMETER SUS_DELTA_PARAM_ID


MIC_SUS_FIRST_LEVEL_INTERP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Susceptibility First Level Interpretations
Definition: This table takes the combination of organism/source/antibiotic/susceptibility detail procedure and creates a unique identifier which is used to define the susceptibility interpretations.
Table Type: REFERENCE





Column Detail - MIC_SUS_FIRST_LEVEL_INTERP


Column Name Type Null? Definition
INTERP_ID DOUBLE N This field identifies a unique value for each set of susceptibility interpretations defined for a organism/source/antibiotic/susceptibility detail combination.
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)
ORGANISM_GROUPING_CD DOUBLE N This field identifies the code_value of the organism for which susceptibility interpretations are defined. Organisms are defined on code set 1021, Organisms.
SOURCE_GROUPING_CD DOUBLE N This field identifies the code_value of the source used to define valid susceptibility interpretations. All three levels of source hierarchy (source, section, category) can be used to define interpretations.
SUS_DETAIL_CD DOUBLE N This field identifies the code value of the susceptibility detail procedure for which susceptibility interpretations are defined. Susceptibility detail procedures are defined on code set 1004.
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_SUS_FIRST_LEVEL_INTERP


Child Column in MIC_SUS_FIRST_LEVEL_INTERP(FK) Parent Table Name Parent Column Name
Parents: MEDICATION_CD MIC_DETAIL_TASK TASK_COMPONENT_CD
SUS_DETAIL_CD MIC_DETAIL_TASK TASK_COMPONENT_CD
ORGANISM_GROUPING_CD MIC_ORGANISM_DATA ORGANISM_ID




Parent Column in MIC_SUS_FIRST_LEVEL_INTERP (PK) Child Table Name Child Column Name
Children: INTERP_ID MIC_INTERP INTERP_ID


MIC_SUS_MED_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Microbiology Medication Results
Definition: This table contains the susceptibility testing activity for microbiology.
Table Type: ACTIVITY





Column Detail - MIC_SUS_MED_RESULT


Column Name Type Null? Definition
ABNORMAL_IND DOUBLE Y This field identifies whether or not the susceptibility result has been defined as an abnormal susceptibility response. Valid values include: 0 = Normal response 1 = Abnormal response
CHARTABLE_IND DOUBLE Y This field indicates whether the susceptibility result should be displayed on patient reports or bedisplayed in inquiry applications. Valid values include: 0 = Non-chartable 1 = Chartable
COMMENT_SEQ DOUBLE Y This field is not used at this time.
COST CHAR(18) Y This field is not used at this time.
DETAIL_SUS_SEQ DOUBLE N The field identifies a value that uniquely identifies each susceptibility detail procedure associated with the susceptibility task. The sequence number is also used to determine the order the susceptibility detail procedures should be displayed in the result entry application and other associated applications.
DOSAGE DOUBLE Y This field is not used at this time.
LOT_INFORMATION_ID DOUBLE N This field contains the unique identifier of the biochemical lot used to result the task.
MEDICATION_DILUTION_CD DOUBLE N This field is not used at this time.
PANEL_MEDICATION_CD DOUBLE N This field identifies the code value for the antibiotic panel associated with the susceptibility task. Antibiotic panels are defined on code set 1010.
PENDING_IND DOUBLE Y This field identifies which antibiotic results are considered pending in the database. All pendingantibiotic results must be verified before the antibiotic panel will be considered complete. Valid values include: 0 = Not pending 1 = Pending
PREV_EVENT_DETAIL_SEQ DOUBLE N Event detail susceptibility of the previous result that caused a delta checking failure on the current result. From the mic_event_detail_table.
PREV_EVENT_LOG_SEQ DOUBLE N Event log susceptibility of the previous result that caused a delta checking failure on the current result. From the mic_event_detail_table.
PREV_TASK_LOG_ID DOUBLE N Task log id of the previous result that caused a delta checking failure on the current result. From the mic_event_detail_table.
REQUEUE_IND DOUBLE Y Currently used to signify that the antibiotic has a footnote.
RESULT_CD DOUBLE N This field identifies the code value for the susceptibility result. Susceptibility results are defined on code set 1025 Alpha susceptibility results and 64 Susceptibility Interpretation Results. '. If the detail susceptibility procedure is numeric this field will be set to '-1'.
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_SCHEDULE_ID DOUBLE N This field contains the unique identifier of the related MIC_QC_RESULT_SCHEDULE row.
RESULT_SEQ DOUBLE N The field identifies a value that uniquely identifies each susceptibility result for each susceptibility detail procedure. For example if there are 10 antibiotics in a panel and each antibiotic getsa dilution and interpretation result then there will be 20 result sequences, one for each result.
RESULT_UNITS_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.
ROUTE_CD DOUBLE N This field is not used at this time.
STATUS_CD DOUBLE N This field identifies the status of the susceptibility result. Result statuses are defined on codeset 1901.
TASK_LOG_ID DOUBLE N This field identifies the unique value assigned to the susceptibility method task from the mic_task_log table thus associating the susceptibility detail procedures with the appropriate susceptibility method 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.
UPDT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.



Relationship Detail - MIC_SUS_MED_RESULT


Child Column in MIC_SUS_MED_RESULT(FK) Parent Table Name Parent Column Name
Parents: PANEL_MEDICATION_CD MIC_DETAIL_TASK TASK_COMPONENT_CD
DETAIL_SUS_SEQ MIC_SUS_ORDER_DETAIL DETAIL_SUS_SEQ
TASK_LOG_ID MIC_SUS_ORDER_DETAIL TASK_LOG_ID
LOT_INFORMATION_ID PCS_LOT_INFORMATION LOT_INFORMATION_ID