| Dimensional Warehouse Model Data Model |
| Description | A clinical observation of the patients integumentary or skin system status. |
| Primary Key | |
OASIS Integumentary Status Snapshot PK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Encounter Dk
| 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 |
Load Info Sk
| 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 |
Medicaid Ind
| 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 |
Medicare Ind
| 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 |
Patient Dk
| 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 |
Point Of Care Location Dk
| 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 |
Practitioner Dk
| 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 |
Pressure Ulcer Assessment Ind
| 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 |
Pressure Ulcer Depth Qty
| 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 |
Pressure Ulcer Depth UOM
| 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 |
Pressure Ulcer Development Risk Ind
| 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 |
Pressure Ulcer Identified Date
| 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 |
Pressure Ulcer Length Qty
| 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 |
Pressure Ulcer Length UOM
| 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 |
Pressure Ulcer Oldest NonEpithelialized Stage II
| 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 |
Pressure Ulcer Stage
| 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 |
Pressure Ulcer Stage I Cnt
| 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 |
Pressure Ulcer Stage II Admission Cnt
| 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 |
Pressure Ulcer Stage II Count
| 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 |
Pressure Ulcer Stage III Admission Cnt
| 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 |
Pressure Ulcer Stage III Cnt
| 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 |
Pressure Ulcer Stage II or Higher Ind
| 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 |
Pressure Ulcer Stage IV Admission Cnt
| 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 |
Pressure Ulcer Stage IV Cnt
| 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 |
Pressure Ulcer Status
| 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 |
Pressure Ulcer Unstageable I Admission Cnt
| 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 |
Pressure Ulcer Unstageable I Cnt
| 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 |
Pressure Ulcer Unstageable II Admission Cnt
| 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 |
Pressure Ulcer Unstageable II Cnt
| 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 |
Pressure Ulcer Unstageable III Admission Cnt
| 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 |
Pressure Ulcer Unstageable III Cnt
| 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 |
Pressure Ulcer Width Qty
| 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 |
Pressure Ulcer Width UOM
| 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 |
Provider Dk
| 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 |
Skin Lesion Or Open Wound Ind
| 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 |
Stasis Ulcer Cnt
| 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 |
Stasis Ulcer Ind
| 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 |
Stasis Ulcer Status
| 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 |
Surgical Wound Ind
| 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 |
Surgical Wound Status
| 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 |
Survey Date Dk
| 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 |
Survey Dk
| 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 |
Tenant Sk
| 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 |
OASIS Integumentary Status Snapshot_Provider Dimension_FK
| 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 |
OASIS Integumentary Status Snapshot_Patient Dimension_FK
| 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 |
OASIS Integumentary Status Snapshot_Encounter Dimension_FK
| 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 |
OASIS Integumentary Status Snapshot_Practitioner Dimension_FK
| 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 |
OASIS Integumentary Status Snapshot_Survey Dimension_FK
| 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 |
OASIS Integumentary Status Snapshot_Point Of Care Location Dimension_FK
| 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 |
OASIS Integumentary Status Snapshot_Calendar Dimension_FK
| 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 |
OASIS Integumentary Status Snapshot PK
| 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 |