| Business Data Model Data Model |
| Description | A set of details that describe a measure. For example: Measure name Measure type Measure description |
| Attributes | |
Improvement Ind |
|
Measure Definition Txt |
|
Measure Long Name |
|
Measure Rollup Type |
|
Measure Short Name |
|
Measure Type |
|
Quality Ind |
|
| Relationship | |
Measure Definition_Organization_FK |
|
Measure Definition_Group_FK |
|
Measure Definition_Report_FK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Improvement Ind
| Description | Indicates whether or not an increase in the measure value shows improvement. For example, Rate of Infections would have an Improvement Ind set to 'N' because an increase in the measure value does not show improvement. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Measure Definition Txt
| Description | A description of the Measure. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Measure Long Name
| Description | The Measure's full name. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name Long [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Measure Rollup Type
| Description | Specifies the reporting frequency and aggregation time frame, which could be annual, reporting period, each visit, etc. |
| 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 |
Measure Short Name
| Description | A shortened form of the Measure Long Name used in reporting. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name Medium [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Measure Type
| Description | Specifies whether the Measure is a Rate or Count. |
| 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 |
Quality Ind
| Description | Identifies the measure as a rating of quality of care. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Measure Definition_Organization_FK
| Is Identifying Relationship | false |
| Child Table | Measure Definition |
| 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_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Measure Definition_Group_FK
| Is Identifying Relationship | false |
| Child Table | Measure Definition |
| 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 | Group |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Measure Definition_Report_FK
| Is Identifying Relationship | false |
| Child Table | Measure Definition |
| 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 | Report Catalog |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |