Dimensional Warehouse Model Data Model

Entity

Entity OASIS - Integumentary Status Observation Analysis

Description

Measures of clinical observations of the patients' integumentary, or skin system, status.

Attributes
Administered Calendar Dk
Average Number Of Pressure Ulcers Stage II
Average Number Of Pressure Ulcers Stage II At Admission
Average Number Of Pressure Ulcers Stage III
Average Number Of Pressure Ulcers Stage III At Admission
Average Number Of Pressure Ulcers Stage IV
Average Number Of Pressure Ulcers Stage IV At Admission
Average Number Of Pressure Ulcers Unstageable I
Average Number Of Pressure Ulcers Unstageable I At Admission
Average Number Of Pressure Ulcers Unstageable II
Average Number Of Pressure Ulcers Unstageable II At Admission
Average Number Of Pressure Ulcers Unstageable III
Average Number Of Pressure Ulcers Unstageable III At Admission
Average Pressure Ulcer Depth Qty
Average Pressure Ulcer Length
Average Pressure Ulcer Stage
Average Pressure Ulcer Width Qty
Average Stasis Ulcers Per Patient
Average Survey Admin Duration
Average Survey Completion Time
Average Time Stage II Pressure Ulcer Unhealed
Encounter Dk
Number Of Adolescent Respondents
Number Of Child Respondents
Number Of Individuals Surveyed
Number Of Medicaid Respondents
Number Of Medicare Respondents
Number Of Other Skin Lesions or Open Wounds
Number Of Pressure Ulcer Assessments
Number Of Pressure Ulcer Development Risks
Number Of Pressure Ulcers Present At SOC ROC
Number Of Pressure Ulcers Stage I
Number Of Pressure Ulcers Stage II
Number Of Pressure Ulcers Stage II At Admission
Number Of Pressure Ulcers Stage III
Number Of Pressure Ulcers Stage III At Admission
Number Of Pressure Ulcers Stage II or Higher
Number Of Pressure Ulcers Stage IV
Number Of Pressure Ulcers Stage IV At Admission
Number Of Pressure Ulcer Status Fully Granulating
Number Of Pressure Ulcer Status Newly Epithelialized
Number Of Pressure Ulcer Status Not Healing
Number Of Pressure Ulcer Status No Ulcer Noted
Number Of Pressure Ulcer Status Partial Granulation
Number Of Pressure Ulcers Unstageable I
Number Of Pressure Ulcers Unstageable I At Admission
Number Of Pressure Ulcers Unstageable II
Number Of Pressure Ulcers Unstageable II At Admission
Number Of Pressure Ulcers Unstageable III
Number Of Pressure Ulcers Unstageable III At Admission
Number Of Respondents
Number Of Stage II Pressure Ulcers Developed During Care
Number Of Stasis Ulcer Patients
Number Of Stasis Ulcer Status Fully Granulating
Number Of Stasis Ulcer Status Newly Epithelialized
Number Of Stasis Ulcer Status Not Healing
Number Of Stasis Ulcer Status Partial Granulation
Number Of Statis Ulcers
Number Of Surgical Wounds
Number Of Surgical Wounds Status Fully Granulating
Number Of Surgical Wounds Status Newly Epithelialized
Number Of Surgical Wounds Status Not Healing
Number Of Surgical Wounds Status Partial Granulation
Number Of Surveys
Patient Dk
Point Of Care Location Dk
Practitioner Dk
Pressure Ulcer Depth
Pressure Ulcer Identified Dt
Pressure Ulcer Length
Pressure Ulcer Width
Provider Dk
Response Calendar Dk
Survey Admin Duration
Survey Completion Time
Survey Dk
Time Stage II Pressure Ulcer Unhealed

Relationship
OASIS - Integumentary Status Observation Analysis_Encounter Dimension_FK
OASIS - Integumentary Status Observation Analysis_Point Of Care Location Dimension_FK
OASIS - Integumentary Status Observation Analysis_Calendar Dimension_FK
OASIS - Integumentary Status Observation Analysis_Calendar Dimension_FK1
OASIS - Integumentary Status Observation Analysis_Patient Dimension_FK
OASIS - Integumentary Status Observation Analysis_Practitioner Dimension_FK
OASIS - Integumentary Status Observation Analysis_Provider Dimension_FK
OASIS - Integumentary Status Observation Analysis_Survey Dimension_FK

Primary Key
OASIS - Integumentary Status Observation Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Administered Calendar 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

Average Number Of Pressure Ulcers Stage II

Description	Identifies the average 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. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Number Of Pressure Ulcers Stage II At Admission

Description	Identifies the average 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. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Number Of Pressure Ulcers Stage III

Description	Identifies the average number of Stage III 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. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Number Of Pressure Ulcers Stage III At Admission

Description	Identifies the average number of Stage III 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. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Number Of Pressure Ulcers Stage IV

Description	Identifies the average number of Stage IV 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. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Number Of Pressure Ulcers Stage IV At Admission

Description	Identifies the average number of Stage IV 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. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Number Of Pressure Ulcers Unstageable I

Description	Identifies the average number of Unstageable 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. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Number Of Pressure Ulcers Unstageable I At Admission

Description	Identifies the average number of Unstageable 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. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Number Of Pressure Ulcers Unstageable II

Description	Identifies the average number of Unstageable II 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. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Number Of Pressure Ulcers Unstageable II At Admission

Description	Identifies the average number of Unstageable II 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. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Number Of Pressure Ulcers Unstageable III

Description	Identifies the number of Stage III 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. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Number Of Pressure Ulcers Unstageable III At Admission

Description	Identifies the number of Stage III 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. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Pressure Ulcer Depth Qty

Description	The average, within the respondent population, 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) Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Pressure Ulcer Length

Description	The average, within the respondent population, of 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) Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Pressure Ulcer Stage

Description	Identifies the average 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/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Pressure Ulcer Width Qty

Description	The average, within the respondent population, 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) Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Stasis Ulcers Per Patient

Description	Identifies the average number of visible (observable) stasis ulcers pre patient in the respondent population. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
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

Average Survey Admin Duration

Description	Average time survey was administered. From start to end time of survey being active. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Survey Completion Time

Description	Average time for a respondent to complete the survey. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Time Stage II Pressure Ulcer Unhealed

Description	Average time a Pressure Ulcer remains un healed. If seen at SOC/ROC then Survey Date - Admit Date. If acquired during stay then Survey Date - Pressure Ulcer Identified Dt. Sum of these is divided by respondent population. Formula: [(A/B) *100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Ratio [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Number Of Adolescent Respondents

Description	Count of respondents who are adolescents.
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

Number Of Child Respondents

Description	Count of respondents who are children.
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

Number Of Individuals Surveyed

Description	Count of individuals surveyed.
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

Number Of Medicaid Respondents

Description	Count of respondents classified as Medicaid recipients.
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

Number Of Medicare Respondents

Description	Count of respondents classified as Medicare recipients.
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

Number Of Other Skin Lesions or Open Wounds

Description	Identifies the number of patients with 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Pressure Ulcer Assessments

Description	Identifies number of cases where 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Pressure Ulcer Development Risks

Description	Count of the number of times patients were identified as at risk for developing 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

Number Of Pressure Ulcers Present At SOC ROC

Description	The number of Stage 2 pressure ulcers seen at the Start of Care or Resumption of Care
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

Number Of Pressure Ulcers Stage I

Description	Counts the total number of Stage I pressure ulcers present in respondent population..
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

Number Of Pressure Ulcers Stage II

Description	Identifies the average 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

Number Of Pressure Ulcers Stage II At Admission

Description	Identifies the average 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

Number Of Pressure Ulcers Stage III

Description	Identifies the average number of Stage III 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

Number Of Pressure Ulcers Stage III At Admission

Description	Identifies the average number of Stage III 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

Number Of Pressure Ulcers Stage II or Higher

Description	Identifies the number of patients with the presence or absence of unstageable or unhealed Stage II or higher pressure ulcers only.
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

Number Of Pressure Ulcers Stage IV

Description	Identifies the average number of Stage IV 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

Number Of Pressure Ulcers Stage IV At Admission

Description	Identifies the average number of Stage IV 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

Number Of Pressure Ulcer Status Fully Granulating

Description	Counts the patients where the pressure ulcers where the degree of closure visible in the most problematic observable pressure ulcer, stage II or higher is 'Fully granulating'. Please note, Stage I pressure ulcers are not considered for this item.
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

Number Of Pressure Ulcer Status Newly Epithelialized

Description	Counts the patients where the pressure ulcers where the degree of closure visible in the most problematic observable pressure ulcer, stage II or higher is 'Newly epithelialized'. Please note, Stage I pressure ulcers are not considered for this item.
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

Number Of Pressure Ulcer Status Not Healing

Description	Counts the patients where the pressure ulcers where the degree of closure visible in the most problematic observable pressure ulcer, stage II or higher is 'Not healing'. Please note, Stage I pressure ulcers are not considered for this item.
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

Number Of Pressure Ulcer Status No Ulcer Noted

Description	Counts the patients where the pressure ulcers where the degree of closure visible in the most problematic observable pressure ulcer, stage II or higher is 'No observable pressure ulcer'. Please note, Stage I pressure ulcers are not considered for this item.
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

Number Of Pressure Ulcer Status Partial Granulation

Description	Counts the patients where the pressure ulcers where the degree of closure visible in the most problematic observable pressure ulcer, stage II or higher is 'Early/partial granulation'. Please note, Stage I pressure ulcers are not considered for this item.
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

Number Of Pressure Ulcers Unstageable I

Description	Identifies the average number of Unstageable 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

Number Of Pressure Ulcers Unstageable I At Admission

Description	Identifies the average number of Unstageable 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

Number Of Pressure Ulcers Unstageable II

Description	Identifies the average number of Unstageable II 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

Number Of Pressure Ulcers Unstageable II At Admission

Description	Identifies the average number of Unstageable II 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

Number Of Pressure Ulcers Unstageable III

Description	Identifies the number of Stage III 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

Number Of Pressure Ulcers Unstageable III At Admission

Description	Identifies the number of Stage III 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

Number Of Respondents

Description	Count of individuals responding to the survey.
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

Number Of Stage II Pressure Ulcers Developed During Care

Description	The number of patients who develop Stage II pressure ulcers while under the care of the agency.
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

Number Of Stasis Ulcer Patients

Description	Identifies the number of 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Stasis Ulcer Status Fully Granulating

Description	Counts the patients with the stasis ulcers where the degree of healing visible in the most problematic observable stasis ulcer 'Fully granulating'. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Stasis Ulcer Status Newly Epithelialized

Description	Counts the patients with the stasis ulcers where the degree of healing visible in the most problematic observable stasis ulcer 'Newly epithelialized'. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Stasis Ulcer Status Not Healing

Description	Counts the patients with the stasis ulcers where the degree of healing visible in the most problematic observable stasis ulcer 'Not healing'. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Stasis Ulcer Status Partial Granulation

Description	Counts the patients with the stasis ulcers where the degree of healing visible in the most problematic observable stasis ulcer 'partial granulation'. 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/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Statis Ulcers

Description	A count of the totla number of stais ulcers identified.
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

Number Of Surgical Wounds

Description	Identifies the number of any wound resulting from a surgical procedure in the respondent population.
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

Number Of Surgical Wounds Status Fully Granulating

Description	Identifies the number of patients where the degree of healing present in the most problematic, observable surgical wound is 'Fully granulating'
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

Number Of Surgical Wounds Status Newly Epithelialized

Description	Identifies the number of patients where the degree of healing present in the most problematic, observable surgical wound is 'Newly epithelialized'
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

Number Of Surgical Wounds Status Not Healing

Description	Identifies the number of patients where the degree of healing present in the most problematic, observable surgical wound is 'Not healing'
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

Number Of Surgical Wounds Status Partial Granulation

Description	Identifies the number of patients where the degree of healing present in the most problematic, observable surgical wound is Newly epithelialized
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

Number Of Surveys

Description	Count of surveys.
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

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 Depth

Description	The sum of the depth of the pressure ulcer with the largest surface area (length x width) per patient 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 Identified Dt

Description	Developed since the most recent Start Of Care/Resumption Of Care 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

Description	The sum of the length of the pressure ulcer with the largest surface area (length x width) per patient 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 Width

Description	The sum of the width of the pressure ulcer with the largest surface area (length x width) per patient 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

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

Response Calendar 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 Admin Duration

Description	Total time (in minutes) survey was administered. From start to end time of survey being active.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Survey Completion Time

Description	Total time for a respondent to complete the survey.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
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

Time Stage II Pressure Ulcer Unhealed

Description	Average time a Pressure Ulcer remains un healed. If seen at SOC/ROC then Survey Date - Admit Date. If acquired during stay then Survey Date - Pressure Ulcer Identified Dt. Sum of these is divided by respondent population.
Data Type	Standards - Data Domains.ddm/Data Domains/Ratio [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

OASIS - Integumentary Status Observation Analysis_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Integumentary Status Observation Analysis
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 Observation Analysis_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Integumentary Status Observation Analysis
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 Observation Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Integumentary Status Observation Analysis
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	Calendar 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 Observation Analysis_Calendar Dimension_FK1

Is Identifying Relationship	true
Child Table	OASIS - Integumentary Status Observation Analysis
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	Calendar 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 Observation Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Integumentary Status Observation Analysis
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 Observation Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Integumentary Status Observation Analysis
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 Observation Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Integumentary Status Observation Analysis
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 Observation Analysis_Survey Dimension_FK

Is Identifying Relationship	true
Child Table	OASIS - Integumentary Status Observation Analysis
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	Survey 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 Observation Analysis PK

Key Attribute	Provider Dk
Key Attribute	Patient Dk
Key Attribute	Encounter Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Practitioner Dk
Key Attribute	Administered Calendar Dk
Key Attribute	Response Calendar Dk
Key Attribute	Survey Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model