Effective From DtEffective To DtGeneric Drug Code SkLoad Info SkRelationship Type Code SkSource Code SkSusceptibility Test Code SkTenant SkValid From TsValid To Ts
| Atomic Warehouse Model Data Model |
| Description | An association between a generic drug and a common code. 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. |
| Attributes | |
| Effective From Dt |
|
| Effective To Dt |
|
| Generic Drug Code Sk |
|
| Load Info Sk |
|
| Relationship Type Code Sk |
|
| Source Code Sk |
|
| Susceptibility Test Code Sk |
|
| Tenant Sk |
|
| Valid From Ts |
|
| Valid To Ts |
|
| Relationship | |
 Susceptibility Test Drug Mapping_Generic Drug_FK |
|
| Susceptibility Test Drug Mapping_Common Code_FK |
|
| Primary Key | |
 Susceptibility Test Drug Mapping PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Effective From Dt
| Description | Establishes a period where a set of attributes are true according to the business. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective To Dt
| Description | Ends a period of effectivity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Generic Drug Code Sk
| Description | The generated unique key for Common Code table. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Relationship Type Code Sk
| Description | Identifies the type of the relationship as defined in the business data model. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Source Code Sk
| Description | The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Susceptibility Test Code Sk
| Description | The generated unique key for Common Code table. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid From Ts
| Description | Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid To Ts
| Description | Ends a period of validity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Susceptibility Test Drug Mapping_Generic Drug_FK
| Is Identifying Relationship | true |
| Child Table | Susceptibility Test Drug Mapping |
| 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 |
Susceptibility Test Drug Mapping_Common Code_FK
| Is Identifying Relationship | true |
| Child Table | Susceptibility Test Drug Mapping |
| 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 |
| Primary Key Details |
Susceptibility Test Drug Mapping PK
| Key Attribute | Generic Drug Code Sk |
| Key Attribute | Susceptibility Test Code Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |