| Business Data Model Data Model |
| Description | A group of clinically related services for a patient for a discrete diagnostic condition from the onset of symptoms until treatment is complete. One episode only pertains to one patient, but one patient can be in multiple episodes at once. An episode will relate to at least one encounter, but could contain many encounters. For example: Physiotherapy treatment for back pain over 6 sessions. This is completed over 6 outpatient encounters. |
| Relationship | |
 Episode Of Care_Encounter_FK |
|
| Episode Of Care_Claim_FK |
|
| Episode Of Care_Claim Line_FK |
|
| Episode Of Care_Patient Problem_FK |
|
| Episode Of Care_Medical Condition_FK |
|
| Generalization | |
 Generalization1 |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Episode Criticality
| Description | Indicates the relative importance of the episode for the patient. |
| 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 |
Episode Descr
| Description | The textual representation of information about an occurrence of episode of care. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Episode Group
| Description | Classifies the Episode according to a Grouper Classification system. For example: Episode Treatment Group (ETG) Code |
| 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 |
Episode Methodology
| Description | The grouper engine used to establish the Episode. |
| 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 |
Episode Methodology Version
| Description | Indicates the specific version of the methodology used to establish the Episode. |
| 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 |
Episode Name
| Description | The word or phrase used to identify the episode of care. |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Episode Num
| Description | Indicates the string assigned by the grouper defining the Episode. |
| 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 |
Episode of Care End Date
| Description | The treatment completion date marking the end of the episode of care. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Episode of Care Start Date
| Description | The initial date upon which the treatment starts marking the beginning of the episode of care. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Episode Status
| Description | Indicates the status of the Episode. For example: Open Closed |
| 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 |
Episode Status Date
| Description | The date upon which the status for the episode of care is defined. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Episode Status Reason
| Description | Indicates the reason for the episode status. |
| 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 |
Episode Treatment Group ETG Code
| Description | Indicates the episode treatment group code. |
| 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 |
Episode Of Care_Encounter_FK
| Is Identifying Relationship | false |
| Child Table | Episode Of Care |
| 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 |
Episode Of Care_Claim_FK
| Is Identifying Relationship | false |
| Child Table | Episode Of Care |
| 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 |
Episode Of Care_Claim Line_FK
| Is Identifying Relationship | false |
| Child Table | Episode Of Care |
| 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 Line |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Episode Of Care_Patient Problem_FK
| Is Identifying Relationship | false |
| Child Table | Episode Of Care |
| Child Role Name | relates to |
| 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 Problem |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Episode Of Care_Medical Condition_FK
| Is Identifying Relationship | false |
| Child Table | Episode Of Care |
| Child Role Name | is for |
| 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 | Medical Condition |
| Parent Role Name | is subject of |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Generalization Details |
Generalization1
| Supertype | Group |
| Subtype | Episode Of Care |
| Transform As | TABLE |
| Business Data Model Data Model |