Entity Episode Of Care / Procedure

DescriptionAn association between an episode of care and a procedure that is performed during an episode.

Attributes
AppropriatenessAppropriateness

Relationship
Episode of Care / Procedure_Procedure_FKEpisode of Care / Procedure_Procedure_FK
Episode of Care / Procedure_Episode Of Care_FKEpisode of Care / Procedure_Episode Of Care_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Appropriateness
DescriptionAn indication of whether this service is appropriate based on the various diagnoses associated with the Episode.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Episode of Care / Procedure_Procedure_FK
Is Identifying Relationshiptrue
Child TableEpisode Of Care / Procedure
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableProcedure
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Episode of Care / Procedure_Episode Of Care_FK
Is Identifying Relationshiptrue
Child TableEpisode Of Care / Procedure
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableEpisode Of Care
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE