Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Ongoing Professional Practice Evaluation

Description

Ongoing professional practice evaluation allows the organization to identify professional practice trends that impact on quality of care and patient safety. Such identified issues may require intervention by the organization's medical or administrative staff.

Attributes

Calendar Dk

Number Of Case Presentations

Number Of Complaints By Patient Or Patient Family

Number Of Complaints Related To Staff Professionalism

Number Of Continued Medical Education Courses Taken Or Completed

Number Of Delinquent Medical Records

Number Of Educational Programs Taught

Number Of Emergent Elder Care Practices Followed

Number Of Illegible Orders Sent For Review

Number Of Initial Or Renewed Board Certifications

Number Of Meetings Attended

Number Of National Patient Safety Goals Guidelines Followed

Number Of New Or Advanced Training Taken Or New Experience

Number Of Suspensions For Delinquency Warnings

Number Of Universal Protocols For Preventing Wrong Site Procedure Or Person

Number Of Utilizations Of Data

Number Of Written Negative Feedback By Patient Family Or Staff

Number Of Written Positive Feedback By Patient Family Or Staff

Practitioner Dk

Provider Dk

Survey Dk

Relationship

Ongoing Professional Practice Evaluation_Calendar Dimension_FK

Ongoing Professional Practice Evaluation_Survey Dimension_FK

Ongoing Professional Practice Evaluation_Provider Dimension_FK

Ongoing Professional Practice Evaluation_Practitioner Dimension_FK

Primary Key

Ongoing Professional Practice Evaluation PK

Dependencies

NONE

Reverse Dependencies

Attribute Details

 Calendar Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Number Of Case Presentations

Description	A count of case presentations given by the healthcare professional during the evaluation period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Complaints By Patient Or Patient Family

Description	A count of formal complaints filed by a patient or a patient's family about the healthcare professional.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Complaints Related To Staff Professionalism

Description	A count of formal complaints received during the evaluation period that were related to the professionalism of the staff.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Continued Medical Education Courses Taken Or Completed

Description	A count of hospital-recommended continued medical education courses taken or completed (specific to specialty or department) by the healthcare professional during the evaluation period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Delinquent Medical Records

Description	A count of medical records for which the healthcare professional was responsible that were classified as delinquent during the evaluation period. Medical records are classified as delinquent if they have not been appropriately completed within a defined timeframe as defined by the healthcare organization's policies.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Educational Programs Taught

Description	A count of educational programs taught by the healthcare professional during the evaluation period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Emergent Elder Care Practices Followed

Description	The number of times that an emergent elder care practice was followed by the healthcare professional during the evaluation period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Illegible Orders Sent For Review

Description	A count of illegible orders by the healthcare professional that required further clarification, explanation or review during the evaluation period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Initial Or Renewed Board Certifications

Description	The number of new or renewed board certifications recorded by the healthcare professional during the evaluation period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Meetings Attended

Description	A count of meetings attended by the healthcare professional during the evaluation period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of National Patient Safety Goals Guidelines Followed

Description	The number of times that National Patient Safety Goals (NPSG) guidelines were followed by the healthcare professional during the evaluation period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of New Or Advanced Training Taken Or New Experience

Description	A count of new training courses taken, new experience & skill sets learned, or advanced training taken by the healthcare professional during the evaluation period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Suspensions For Delinquency Warnings

Description	The number of times a practitioner was suspended during the evaluation period due to warnings relating to delinquent medical records.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Universal Protocols For Preventing Wrong Site Procedure Or Person

Description	The number of times that a universal protocol for preventing Wrong Site, Wrong Procedure, and Wrong Person Surgery was followed by the healthcare professional during the evaluation period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Utilizations Of Data

Description	The number of times that a practitioner made use of online medical data during the evaluation period.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Written Negative Feedback By Patient Family Or Staff

Description	A count of written negative feedback responses given by a patient, patient's family or staff about the healthcare professional.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Number Of Written Positive Feedback By Patient Family Or Staff

Description	A count of written positive feedback responses given by a patient, patient's family or staff about the healthcare professional.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Practitioner Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Provider Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Survey Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Relationship Details

 Ongoing Professional Practice Evaluation_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Ongoing Professional Practice Evaluation
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	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Ongoing Professional Practice Evaluation_Survey Dimension_FK

Is Identifying Relationship	true
Child Table	Ongoing Professional Practice Evaluation
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	Survey Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Ongoing Professional Practice Evaluation_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Ongoing Professional Practice Evaluation
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	Provider Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Ongoing Professional Practice Evaluation_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Ongoing Professional Practice Evaluation
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	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

 Ongoing Professional Practice Evaluation PK

Key Attribute	Provider Dk
Key Attribute	Practitioner Dk
Key Attribute	Calendar Dk
Key Attribute	Survey Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model