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 |