Entity Survey NHSN Drug Change

DescriptionA 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
Survey National Healthcare Safety Network (NHSN) Drug Change End DateSurvey National Healthcare Safety Network (NHSN) Drug Change End Date
Survey National Healthcare Safety Network (NHSN) Drug Change Start DateSurvey National Healthcare Safety Network (NHSN) Drug Change Start Date

Relationship
Survey NHSN Drug Change_Generic Drug_FKSurvey NHSN Drug Change_Generic Drug_FK

Generalization
Generalization1Generalization1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Survey National Healthcare Safety Network (NHSN) Drug Change End Date
DescriptionThe date upon which a drug was discontinued by the practitioner.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Survey National Healthcare Safety Network (NHSN) Drug Change Start Date
DescriptionThe date upon which a drug was commenced by the practitioner.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Survey NHSN Drug Change_Generic Drug_FK
Is Identifying Relationshipfalse
Child TableSurvey NHSN Drug Change
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGeneric Drug
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Generalization1
SupertypeSurvey Response Answer
SubtypeSurvey NHSN Drug Change
Transform AsTABLE