Entity Procedure

DescriptionA healthcare event that is performed as part of an encounter, which usually involves an action by a practitioner treating a patient.

For example:
Major surgery
Minor surgery
Eye refraction
Wart removal
Ear lavage

Attributes
Ambulance Transport ReasonAmbulance Transport Reason
AnesthesiaAnesthesia
Anesthesia Minutes ValAnesthesia Minutes Val
Associated Diagnosis CodeAssociated Diagnosis Code
Clinical SignificanceClinical Significance
Delivery Pattern Time TypeDelivery Pattern Time Type
Derived IndDerived Ind
Duration Of Visits CntDuration Of Visits Cnt
Duration of Visits UnitDuration of Visits Unit
Emergency IndEmergency Ind
Frequency CntFrequency Cnt
Image NumImage Num
Locale CountryLocale Country
Locale LanguageLocale Language
Medical Effect Expected End DateMedical Effect Expected End Date
Medical Effect Expected Start DateMedical Effect Expected Start Date
Medically Necessary Duplicate Procedure ReasonMedically Necessary Duplicate Procedure Reason
Oxygen Delivery TypeOxygen Delivery Type
Oxygen Flow Rate QtyOxygen Flow Rate Qty
Oxygen Flow Rate Unit Of MeasureOxygen Flow Rate Unit Of Measure
Procedure Certification Revision DateProcedure Certification Revision Date
Procedure CodeProcedure Code
Procedure Code DescrProcedure Code Descr
Procedure Code FamilyProcedure Code Family
Procedure Coding MethodProcedure Coding Method
Procedure Functional TypeProcedure Functional Type
Procedure Last Certification DateProcedure Last Certification Date
Procedure Last Service DateProcedure Last Service Date
Procedure MethodProcedure Method
Procedure Minutes ValProcedure Minutes Val
Procedure NumProcedure Num
Procedure OutcomeProcedure Outcome
Procedure PriorityProcedure Priority
Procedure ReasonProcedure Reason
Procedure StatusProcedure Status
Procedure TsProcedure Ts
Responsivity StatusResponsivity Status
Round Trip Purpose DescrRound Trip Purpose Descr
Service Delivery PatternService Delivery Pattern
Side EffectSide Effect
Stretcher Purpose DescrStretcher Purpose Descr
Translated Procedure CodeTranslated Procedure Code
Translated Procedure Code DescrTranslated Procedure Code Descr
Translated Procedure Code FamilyTranslated Procedure Code Family
Translation DateTranslation Date
Translation Rule AppliedTranslation Rule Applied
Translation Rule DescrTranslation Rule Descr
Transport Distance QtyTransport Distance Qty
Transport Distance Unit Of MeasureTransport Distance Unit Of Measure
Treatment Consent TypeTreatment Consent Type
Visit CntVisit Cnt
X-Ray Availability IndX-Ray Availability Ind

Relationship
Procedure_Procedure Order_FKProcedure_Procedure Order_FK
Procedure_Clinical Order Item_FKProcedure_Clinical Order Item_FK
AnesthesiologistAnesthesiologist
Procedure_Encounter_FKProcedure_Encounter_FK
Procedure_Surgery Case_FKProcedure_Surgery Case_FK
SurgeonSurgeon
PractitionerPractitioner
Procedure_Patient Consent_FKProcedure_Patient Consent_FK
Procedure_Patient_FKProcedure_Patient_FK
Procedure_Plan Member_FKProcedure_Plan Member_FK

Generalization
Generalization1Generalization1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Ambulance Transport Reason
DescriptionIndicates the reason for an ambulance transport.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Anesthesia
DescriptionIdentifies the anesthesia used during the procedure.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Anesthesia Minutes Val
DescriptionThe length of time expressed in minutes that the anesthesia was administered.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Small [SHORT]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Associated Diagnosis Code
DescriptionIdentifies the diagnosis that is the primary reason this procedure was performed. Diagnosis codes are generally recorded using the International Classification of Diseases ICD-9 or ICD-10 coding systems.

For example:
In the US, Medicare wants to know for which diagnosis this procedure is submitted for inclusion on CMS 1500 form.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Clinical Significance
DescriptionA code identifying the importance or severity level of the procedure.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Delivery Pattern Time Type
DescriptionIndicates the time delivery pattern of the services.
For example:
A.M.
P.M.
As Directed
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Derived Ind
DescriptionIndicates whether the Procedure was submitted or derived.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Duration Of Visits Cnt
DescriptionThe number of units (month, week, etc.) over which home health visits occur.
For example:
1 visit every 3 days for 21 days.
This element indicates the number of units, in this case - 21 days.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Duration of Visits Unit
DescriptionThe type of unit (month, week, etc.) used to measure the duration of visits.
For example:
1 visit every 3 days for 21 days. 
This element indicates the type of units, in this case - days.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Emergency Ind
DescriptionIndicates whether emergency care was rendered in response to the sudden and unexpected onset of a medical condition, a severe injury, or an acute exacerbation of a chronic condition which was threatening to life, limb or sight.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Frequency Cnt
DescriptionThe count of the frequency units of home health visits.

For example:
One visit every three days for 21 days.
This element indicates the frequency, in this case three-day intervals.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Image Num
DescriptionA reference pointer to an image file stored on an external system.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Locale Country
DescriptionThe country where the event has occurred. This indicator can be used to determe aspects of the event that are locale-specific.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Locale Language
DescriptionIdentifies the primary language of the event. All text fields contained in the event are assumed to be in this language.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medical Effect Expected End Date
DescriptionThe date upon which the treatment is expected to become medically ineffective.

For example:
A vaccination administered on July 01, 2008 will cease to be effective in protecting the patient from July 01, 2011 (i.e. three years from administration)
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medical Effect Expected Start Date
DescriptionThe date upon which the treatment is expected to become medically effective.

For example:
A vaccination administered on July 01, 2008 will become effective in protecting the patient from July 15, 2008 (i.e. 15 days from administration)
A chemotherapy cancer treatment administered from January 10, 2008 to January 31, 2008 is expected to become effective (for example, reducing cancer cell counts by more than 10%) from February 15, 2008
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medically Necessary Duplicate Procedure Reason
DescriptionIndicates the reason why a duplicate procedure for the same patient within the same date of service has been determined to be medically necessary.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Oxygen Delivery Type
DescriptionIndicates the method used in the administration of oxygen.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Oxygen Flow Rate Qty
DescriptionThe oxygen flow rate typically expressed in liters per minute.
Data TypeStandards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Oxygen Flow Rate Unit Of Measure
DescriptionIdentifies the units in which the Oxygen Flow Rate is measured. Common Units are Liters per Minute.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Certification Revision Date
DescriptionThe date upon which the certification for the procedure was revised.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Code
DescriptionA unique code that identifies a procedure within a coding system. Standard procedure code sets include Current Procedural Terminology (CPT), SNOMED and Healthcare Common and Universal Billing (UB) Revenue codes.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Code Descr
DescriptionA textual description of the procedure or service.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Code Family
DescriptionThe code set or standard coding reference that was used for specifying the procedure code.

For example:
Current Dental Terminology (CDT)
Current Procedural Terminology (CPT)
Healthcare Common Procedural Coding System (HCPCS)
International Classification of Diseases (ICD9 or ICD10) Procedure
Logical Observation Identifiers Names and Codes (LOINC)
Systematized Nomenclature of Medicine Clinical Terms (SNOMED CT)
UB Revenue
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Coding Method
DescriptionIdentifies the code set or standardized to identify the procedure.

For example:
CPT
ICD10-PCS
UB Revenue Codes
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Functional Type
DescriptionIndicates the functional nature of the procedure.

For example:
Anesthesia
Procedure for treatment (therapeutic, including operations)
Surgical Procedure
Invasive procedure not classified elsewhere (for example, IV, catheter, etc.)
Diagnostic procedure
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Last Certification Date
DescriptionThe date upon which the most recent certification for a procedure was completed.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Last Service Date
DescriptionThe date upon which a procedure was most recently carried out.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Method
DescriptionIdentifies the technique that is used for the procedure.

For example:
Finger stick
Veni puncture
Abdominal/ ascites effusion
Biopsy
Bronchial alveolar lavage (BAL)
Open
Laparoscopic
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Minutes Val
DescriptionThe length of time expressed in whole minutes that the procedure took to complete.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Small [SHORT]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Num
DescriptionUniquely identifies a single procedure for an encounter. It is unique across all segments and messages for an encounter.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Outcome
DescriptionIndicates how the procedure has affected the patient in relation to the primary condition being addressed.

For example:
Full recovery
Improvement
No Improvement
Worsening condition
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Priority
DescriptionIdentifies the significance or priority of a procedure.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Reason
DescriptionIndicates the reason for a procedure being carried out. A procedure can be triggered at a patient's or practitioner's request and is normally done on the basis of medical need.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Status
DescriptionIndicates the status of the procedure.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Procedure Ts
DescriptionThe date and time that the procedure was performed.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Responsivity Status
DescriptionIndicates how the patient is responding to the procedure performed.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Round Trip Purpose Descr
DescriptionA free-form description of the purpose of the ambulance transport round trip.
Data TypeStandards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Service Delivery Pattern
DescriptionIndicates the delivery schedule pattern of the services.
For example:
1st Week of the Month
1st & 3rd Weeks of the Month
Monday through Friday
Tuesday through Saturday
Whenever Necessary
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Side Effect
DescriptionIndicates the degree to which any side effects of the procedure affect the patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Stretcher Purpose Descr
DescriptionA free-form description of the purpose of the use of a stretcher during ambulance service.
Data TypeStandards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Translated Procedure Code
DescriptionA code identifying a procedure, product or service. The translated code is a code allocated to the procedure other than the original code supplied. This may be done in order to maintain consistency or to facilitate migration from one coding set to another.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Translated Procedure Code Descr
DescriptionA textual description of the translated procedure or service.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Translated Procedure Code Family
DescriptionThe code set or standard coding reference that was used for specifying the translated procedure code.

For example:
Current Dental Terminology (CDT)
Current Procedural Terminology (CPT)
Healthcare Common Procedural Coding System (HCPCS)
International Classification of Diseases (ICD9 or ICD10) Procedure
Logical Observation Identifiers Names and Codes (LOINC)
Systematized Nomenclature of Medicine Clinical Terms (SNOMED CT)
UB Revenue
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Translation Date
DescriptionThe date upon which the translation was performed.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Translation Rule Applied
DescriptionThe business rule used to perform the translation.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Translation Rule Descr
DescriptionA textual description of the business rule used to perform the translation.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Transport Distance Qty
DescriptionDistance traveled during the ambulance transport.
Data TypeStandards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Transport Distance Unit Of Measure
DescriptionIdentifies the unit of measure in which the transport distance is reported. Common Units are Miles or Kilometers.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Treatment Consent Type
DescriptionIndicates the type of consent that was obtained for permission to treat the patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Visit Cnt
DescriptionThe number of home health visits.
e.g.:
1 visit every 3 days for 21 days.
This element indicates the number of visits, in this case - 1 visit.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 X-Ray Availability Ind
DescriptionIndicates if X-Ray images are on file for the patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Procedure_Procedure Order_FK
Is Identifying Relationshipfalse
Child TableProcedure
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableProcedure Order
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Procedure_Clinical Order Item_FK
Is Identifying Relationshipfalse
Child TableProcedure
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableClinical Order Item
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Anesthesiologist
Is Identifying Relationshipfalse
Child TableProcedure
Child Role Nameanesthesiologist
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePractitioner
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Procedure_Encounter_FK
Is Identifying Relationshipfalse
Child TableProcedure
Child Role Nameis performed during
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableEncounter
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Procedure_Surgery Case_FK
Is Identifying Relationshipfalse
Child TableProcedure
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableSurgery Case
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Surgeon
Is Identifying Relationshipfalse
Child TableProcedure
Child Role Namesurgeon
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePractitioner
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Practitioner
Is Identifying Relationshipfalse
Child TableProcedure
Child Role Nameother
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePractitioner
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Procedure_Patient Consent_FK
Is Identifying Relationshipfalse
Child TableProcedure
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableTreatment Consent
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Procedure_Patient_FK
Is Identifying Relationshipfalse
Child TableProcedure
Child Role Nameperformed for
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Procedure_Plan Member_FK
Is Identifying Relationshipfalse
Child TableProcedure
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePlan Member
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Generalization1
SupertypeHealthcare Event
SubtypeProcedure
Transform AsTABLE