| Business Data Model Data Model |
| Description | An evaluation of the likelihood of a person or organization encountering a problem. Risks can be re-assessed and recorded as a series of scores indicating a trend of improving or deteriorating risk. |
| Attributes | |
Risk Assessment Engine Version Num |
|
Risk Assessment Subtype |
|
Risk Assessment Type |
|
Risk Score |
|
| Relationship | |
Risk Score_Party_FK |
|
Risk Score_Claim_FK |
|
Risk Score_Encounter_FK |
|
Risk Score_Patient_FK |
|
Risk Score_Plan Member_FK |
|
Risk Score_Provider_FK |
|
Risk Score_Organization_FK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Risk Assessment Engine Version Num
| Description | The version number of the third-party risk assessment 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 |
Risk Assessment Subtype
| Description | Identifies the source of a risk assessment. For example: Credit score Likelihood of readmission Probability of disease |
| 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 |
Risk Assessment Type
| Description | Indicates the kind of risk assessment performed. |
| 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 |
Risk Score
| Description | The rating or value that indicates the result of a risk assessment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Score [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Risk Score_Party_FK
| Is Identifying Relationship | false |
| Child Table | Risk Assessment |
| Child Role Name | assessed 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 | assesses |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Risk Score_Claim_FK
| Is Identifying Relationship | false |
| Child Table | Risk Assessment |
| 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 |
Risk Score_Encounter_FK
| Is Identifying Relationship | false |
| Child Table | Risk Assessment |
| 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 |
Risk Score_Patient_FK
| Is Identifying Relationship | false |
| Child Table | Risk Assessment |
| 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 |
Risk Score_Plan Member_FK
| Is Identifying Relationship | false |
| Child Table | Risk Assessment |
| 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 |
Risk Score_Provider_FK
| Is Identifying Relationship | false |
| Child Table | Risk Assessment |
| 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 |
Risk Score_Organization_FK
| Is Identifying Relationship | false |
| Child Table | Risk Assessment |
| 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 |
| Business Data Model Data Model |