Goal Variance TypeVariance ClassificationVariance DescrVariance Documented TsVariance Originator NameVariance Stated Ts
| Business Data Model Data Model |
| Description | A variance is a deviation that is either positive or negative from a pre-defined goal or standard. They are documented against expected outcomes, orders or a patient's progress within a care pathway. A variance is determined when a change from the anticipated course of events in a clinical pathway occurs. For example: Appointment not available Equipment not available Wound has not full healed |
| Attributes | |
| Goal Variance Type |
|
| Variance Classification |
|
| Variance Descr |
|
| Variance Documented Ts |
|
| Variance Originator Name |
|
| Variance Stated Ts |
|
| Relationship | |
 Variance_Clinical Order_FK |
|
| Variance_Goal_FK |
|
| Variance_Care Team Member_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Goal Variance Type
| Description | Indicates the type of goal variance. For example: Pathway Clinical order Patient Problem Practitioner |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Variance Classification
| Description | Identifies a categorical set of variances. Classification may be used by applications for presentation and processing functions. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Variance Descr
| Description | Specifies the details of a variance. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Variance Documented Ts
| Description | The date and time upon which the occurrence of the variance is documentation. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Variance Originator Name
| Description | The originator who has documented the variance in the care plan or pathway. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Variance Stated Ts
| Description | The date and time upon which the variance was stated. This may be different than the time it was documented. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Variance_Clinical Order_FK
| Is Identifying Relationship | false |
| Child Table | Goal Variance |
| Child Role Name | have noted |
| 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 | Clinical Order |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Variance_Goal_FK
| Is Identifying Relationship | false |
| Child Table | Goal Variance |
| 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 | Goal |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Variance_Care Team Member_FK
| Is Identifying Relationship | true |
| Child Table | Goal Variance |
| 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 | Care Team Member |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |