Susceptibility Test Drug Cross Reference_Common Code_FKSusceptibility Test Drug Cross Reference_Generic Drug_FK
| Business Data Model Data Model |
| Description | Susceptibility tests are laboratory tests where organisms are incubated with antimicrobial compounds, like antibiotics, to determine if the compounds prevent the organism from growing. These test results determine which drugs are the most effective to treat the infection. If the organism is resistant to the drug tested, that drug will not stop the growth of the organism. If the organism is susceptible to the drug tested, that drug will be effective in stopping the growth of the organism. Once the drugs are mapped to a LOINC susceptibility drug test code, the LOINC test code must be mapped to a MULTUM drug for alerting purposes. Organism coverage events will query for the organism a patient has grown, and compare the susceptibility test results to the patient's drug profile. |
| Relationship | |
| Susceptibility Test Drug Cross Reference_Common Code_FK |
|
| Susceptibility Test Drug Cross Reference_Generic Drug_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Relationship Details |
Susceptibility Test Drug Cross Reference_Common Code_FK
| Is Identifying Relationship | true |
| Child Table | Susceptibility Test Drug Mapping |
| Child Role Name | is susceptibility test |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Common Code |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Susceptibility Test Drug Cross Reference_Generic Drug_FK
| Is Identifying Relationship | true |
| Child Table | Susceptibility Test Drug Mapping |
| Child Role Name | is susceptibility generic drug |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Generic Drug |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |