| Business Data Model Data Model |
Description | A survey response answer to a specific National Healthcare Safety Network survey question that deals with patient drug changes and includes the start and end dates of using the drug. |
Attributes | |
![]() |
|
![]() |
Relationship | |
![]() |
Generalization | |
![]() |
Dependencies | |
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | The date upon which a drug was discontinued by the practitioner. |
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 |
Description | The date upon which a drug was commenced by the practitioner. |
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 |
Relationship Details |
Is Identifying Relationship | false |
Child Table | Survey NHSN Drug Change |
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 |
Generalization Details |
Supertype | Survey Response Answer |
Subtype | Survey NHSN Drug Change |
Transform As | TABLE |
| Business Data Model Data Model |