Overview Top Package Entity

Business Data Model Data Model

---

Entity Grouper

Description

A process or method that uses proprietary software to analyze information about patients, health plan members or population cohorts and group them according to a set of parameters including their likelihood of having or acquiring a medical condition.

Attributes

Grouper Code

Grouper Engine Version Num

Grouper ROM Indicator

Grouper SOI Indicator

Grouper Subtype

Grouper Type

Relationship

Grouper_Party_FK

Grouper_Claim_FK

Grouper_Encounter_FK

Grouper_Patient_FK

Grouper_Plan Member_FK

Grouper_Provider_FK

Grouper_Organization_FK

Dependencies

NONE

Reverse Dependencies

Attribute Details

 Grouper Code

Description	A rating or value assigned to a specific grouping
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Grouper Engine Version Num

Description	The version number of the third-party grouper engine that was used.
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Grouper ROM Indicator

Description	Risk of mortality indicator. For example: minor moderate major extreme
Data Type	Standards - Data Domains.ddm/Data Domains/Single Letter [CHAR(1)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Grouper SOI Indicator

Description	Severity of illness indicator. For example: minor moderate major extreme
Data Type	Standards - Data Domains.ddm/Data Domains/Single Letter [CHAR(1)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Grouper Subtype

Description	Identifies the source of a grouper. For example: APR-DRG MS-DRG AHRQ-PSI Disease tags Groups
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Grouper Type

Description	Indicates the kind of grouper that is being defined or created.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

 Grouper_Party_FK

Is Identifying Relationship	false
Child Table	Grouper
Child Role Name	defined by
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	Party
Parent Role Name	defines
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Grouper_Claim_FK

Is Identifying Relationship	false
Child Table	Grouper
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	Claim
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Grouper_Encounter_FK

Is Identifying Relationship	false
Child Table	Grouper
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	Encounter
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Grouper_Patient_FK

Is Identifying Relationship	false
Child Table	Grouper
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	Patient
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Grouper_Plan Member_FK

Is Identifying Relationship	false
Child Table	Grouper
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	Plan Member
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Grouper_Provider_FK

Is Identifying Relationship	false
Child Table	Grouper
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
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

 Grouper_Organization_FK

Is Identifying Relationship	false
Child Table	Grouper
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	Organization
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

---

Overview Top Package Entity

Business Data Model Data Model