| Dimensional Warehouse Model Data Model |
Description | A clinical observation of the patients integumentary or skin system status. |
Primary Key | |
![]() |
Dependencies | |
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicator if respondent is classified as Medicaid recipient. |
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 |
Description | Indicator if respondent is classified as Medicare recipient. |
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 |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies whether the home health agency care providers assessed the patient’s risk of developing pressure ulcers. CMS does not require the use of standardized tools, nor does it endorse one particular tool. This item is used to calculate process measures to capture the agency’s use of best practices following the completion of the comprehensive assessment. The best practices stated in the item are not necessarily required in the Conditions of Participation. |
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 |
Description | Identifies the length, width, and depth of the pressure ulcer with the largest surface area (length x width) that is also an unhealed Stage III or IV pressure ulcer or pressure ulcer unstageable due to the presence of slough or eschar (as reported in M1308 d.2). Pressure Ulcer Depth: Depth of the same pressure ulcer; from visible surface to the deepest area | ___ | ___ | . | ___ | (cm) |
Data Type | Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Unit of Measure for the Depth of the pressure ulcer. OASIS shows cms. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies if the patient is at risk for developing pressure ulcers. |
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 |
Description | Developed since the most recent SOC/ROC assessment: record date pressure ulcer first identified: |
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 |
Description | Identifies the length, width, and depth of the pressure ulcer with the largest surface area (length x width) that is also an unhealed Stage III or IV pressure ulcer or pressure ulcer unstageable due to the presence of slough or eschar (as reported in M1308 d.2). Pressure Ulcer Length: Longest length “head-to-toe” | ___ | ___ | . | ___ | (cm) |
Data Type | Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Unit of Measure for the Length of the pressure ulcer. OASIS shows cms. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The intent of this item is to a) identify the oldest Stage II pressure ulcer that is present at the time of discharge and is not fully epithelialized, and b) assess the length of time this ulcer remained unhealed while the patient received care from the home health agency and c) identify patients who develop Stage II pressure ulcers while under the care of the agency. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the stage of the most problematic observable Stage 1 or higher pressure ulcer. Definitions of pressure ulcer stages derived from the National Pressure Ulcer Advisory Panel. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the presence of Stage I pressure ulcers. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the number of Stage II or higher pressure ulcers at each stage present at the time of assessment. Stage I pressure ulcers are not reported in this item. Number of those listed that were present on admission (most recent SOC / ROC). Stage II: Partial thickness loss of dermis presenting as a shallow open ulcer with red pink wound bed, without slough. May also present as an intact or open/ruptured serum-filled blister. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the number of Stage II or higher pressure ulcers at each stage present at the time of assessment. Stage I pressure ulcers are not reported in this item. Number Currently Present. Stage II: Partial thickness loss of dermis presenting as a shallow open ulcer with red pink wound bed, without slough. May also present as an intact or open/ruptured serum-filled blister. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the number of Stage II or higher pressure ulcers at each stage present at the time of assessment. Stage I pressure ulcers are not reported in this item. Number of those listed that were present on admission (most recent SOC / ROC). Stage III: Full thickness tissue loss. Subcutaneous fat may be visible but bone, tendon, or muscles are not exposed. Slough may be present but does not obscure the depth of tissue loss. May include undermining and tunneling. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the number of Stage II or higher pressure ulcers at each stage present at the time of assessment. Stage I pressure ulcers are not reported in this item. Number Currently Present. Stage III: Full thickness tissue loss. Subcutaneous fat may be visible but bone, tendon, or muscles are not exposed. Slough may be present but does not obscure the depth of tissue loss. May include undermining and tunneling. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the presence or absence of unstageable or unhealed Stage II or higher pressure ulcers only. |
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 |
Description | Identifies the number of Stage II or higher pressure ulcers at each stage present at the time of assessment. Stage I pressure ulcers are not reported in this item. Number of those listed that were present on admission (most recent SOC / ROC). Stage IV: Full thickness tissue loss with visible bone, tendon, or muscle. Slough or eschar may be present on some parts of the wound bed. Often includes undermining and tunneling. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the number of Stage II or higher pressure ulcers at each stage present at the time of assessment. Stage I pressure ulcers are not reported in this item. Number Currently Present. Stage IV: Full thickness tissue loss with visible bone, tendon, or muscle. Slough or eschar may be present on some parts of the wound bed. Often includes undermining and tunneling. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the degree of closure visible in the most problematic observable pressure ulcer, stage II or higher. Please note, Stage I pressure ulcers are not considered for this item. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the number of Stage II or higher pressure ulcers at each stage present at the time of assessment. Stage I pressure ulcers are not reported in this item. Number of those listed that were present on admission (most recent SOC / ROC). Unstageable: Known or likely but unstageable due to non-removable dressing or device |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the number of Stage II or higher pressure ulcers at each stage present at the time of assessment. Stage I pressure ulcers are not reported in this item. Number Currently Present. Unstageable: Known or likely but unstageable due to non-removable dressing or device |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the number of Stage II or higher pressure ulcers at each stage present at the time of assessment. Stage I pressure ulcers are not reported in this item. Number of those listed that were present on admission (most recent SOC / ROC). Unstageable: Known or likely but unstageable due to coverage of wound bed by slough and/or eschar. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the number of Stage II or higher pressure ulcers at each stage present at the time of assessment. Stage I pressure ulcers are not reported in this item. Number Currently Present. Unstageable: Known or likely but unstageable due to coverage of wound bed by slough and/or eschar. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the number of Stage II or higher pressure ulcers at each stage present at the time of assessment. Stage I pressure ulcers are not reported in this item. Number of those listed that were present on admission (most recent SOC / ROC). Unstageable: Suspected deep tissue injury in evolution. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the number of Stage II or higher pressure ulcers at each stage present at the time of assessment. Stage I pressure ulcers are not reported in this item. Number Currently Present. Unstageable: Suspected deep tissue injury in evolution. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the length, width, and depth of the pressure ulcer with the largest surface area (length x width) that is also an unhealed Stage III or IV pressure ulcer or pressure ulcer unstageable due to the presence of slough or eschar (as reported in M1308 d.2). Pressure Ulcer Width: Width of the same pressure ulcer; greatest width perpendicular to the length | ___ | ___ | . | ___ | (cm) |
Data Type | Standards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Unit of Measure for the Width of the pressure ulcer. OASIS shows cms. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the presence or absence of a skin lesion or open wound NOT ALREADY ADDRESSED IN PREVIOUS ITEMS that is receiving clinical assessment or intervention from the home health agency. |
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 |
Description | Identifies the number of visible (observable) stasis ulcers. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies patients with ulcers caused by inadequate venous circulation in the area affected (usually lower legs). This lesion is often associated with stasis dermatitis. Stasis ulcers DO NOT include arterial lesions or arterial ulcers. If the home health clinician conducting the assessment is not sure the wound fits the definition of a stasis ulcer, the clinician should contact the physician for clarification. |
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 |
Description | Identifies the degree of healing present in the most problematic, observable stasis ulcer. The “most problematic” ulcer may be the largest, the most resistant to treatment, an ulcer that is infected, etc., depending on the specific situation. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Identifies the presence of any wound resulting from a surgical procedure. |
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 |
Description | Identifies the degree of healing present in the most problematic, observable surgical wound. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | The surrogate key of the entry identifying the legal owner of the data. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Relationship Details |
Is Identifying Relationship | true |
Child Table | OASIS Integumentary Status Snapshot |
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 Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | OASIS Integumentary Status Snapshot |
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 Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | OASIS Integumentary Status Snapshot |
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 Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | OASIS Integumentary Status Snapshot |
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 | Practitioner Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | OASIS Integumentary Status Snapshot |
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 | Survey Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | OASIS Integumentary Status Snapshot |
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 | Point Of Care Location Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | OASIS Integumentary Status Snapshot |
Child Multiplicity | ZERO_TO_ONE |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Calendar Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Primary Key Details |
Key Attribute | Provider Dk |
Key Attribute | Patient Dk |
Key Attribute | Encounter Dk |
Key Attribute | Practitioner Dk |
Key Attribute | Survey Dk |
Key Attribute | Point Of Care Location Dk |
Key Attribute | Survey Date Dk |
| Dimensional Warehouse Model Data Model |