WoundRegistryMetrics
DM_WOUNDS is a data mart that stores information from the Wounds registry. This table consolidates information such as wound outcome, healing percentages, and encounter information. Only patient encounters that meet the inclusion criteria for the registry have information stored in this table. You can verify the current configuration by looking at the registry in Hyperspace (via the Registry Editor).
| Column Name | Type | Description |
|---|---|---|
| PercentageVolumeHealedAtSixteenWeeks | NUMERIC | Percent change of volume at 16 weeks. Calculation starts from the initial date of wound care. To see the change from the beginning of outpatient wound care, use the column PCT_VOLUME_HEALED_16W_OUTPAT. Rule: Percentage of Wound Volume Healed at 16 Weeks (68533) |
| WoundPresentOnAdmissionIndicator | VARCHAR | Indicates if the wound was present on original admission. Rule: Wound Present on Original Admission (68523) |
| WoundLineDrainOrAttachmentIdentification | VARCHAR | The LDA ID representing the wound. |
| OutpatientWoundVolumeHealedPercentageAtEightWeeks | NUMERIC | Percent change of volume at 8 weeks. Calculation starts from the date of first outpatient care. To see the change from the beginning of any wound care, use the column PCT_VOLUME_HEALED_8W. Rule: Outpatient Percentage of Wound Volume Healed at 8 Weeks (68536) |
| LastOutpatientWoundDocumentationVisitDate | DATETIME | The date of the last outpatient visit where documentation was recorded for the wound. Rule: Last Outpatient Visit (68517) |
| WoundAreaHealedPercentAtTwentyWeeks | NUMERIC | Percent change of surface area at 20 weeks. Calculation starts from the initial date of wound care. To see the change from the beginning of outpatient wound care, use the column PCT_AREA_HEALED_20W_OUTPAT. Rule: Percentage of Wound Surface Area Healed at 20 Weeks (68545) |
| WoundSurfaceAreaPercentHealedAt16Weeks | NUMERIC | Percent change of surface area at 16 weeks. Calculation starts from the initial date of wound care. To see the change from the beginning of outpatient wound care, use the column PCT_AREA_HEALED_16W_OUTPAT. Rule: Percentage of Wound Surface Area Healed at 16 Weeks (68544) |
| WoundPlacedOnCurrentAdmissionIndicator | VARCHAR | Indicates if the wound was placed on current admission. Rule: Wound Placed on Current Admission (68572) |
| WoundAcquiredCareSetting | INTEGER | The acquired care setting of the wound Rule: Acquired Care Setting (68573) |
| LastOutpatientWoundAgeInDays | NUMERIC | Age of the wound in days as of the last visit. Wound age starts from the date of first outpatient care. To see the age from the beginning of any wound care, use the column LAST_WOUND_AGE. Rule: Outpatient Age of Wound At Last Visit (68592) |
| LastHomeHealthVisitDepartmentIdentifier | NUMERIC | The department of the last Home Health visit where documentation was recorded for the wound. Rule: Last Home Health Visit Department (68557) |
| InitialWoundAssessmentDepartmentIdentifier | NUMERIC | Department where wound was first assessed. Rule: Initial Department for Wound Care (68558) |
| WoundRegistryDataStatus | INTEGER | Status of the registry data in the registry. |
| PercentSurfaceAreaHealedAtFourWeeks | NUMERIC | Percent change of surface area at 4 weeks. Calculation starts from the initial date of wound care. To see the change from the beginning of outpatient wound care, use the column PCT_AREA_HEALED_4W_OUTPAT. Rule: Percentage of Wound Surface Area Healed at 4 Weeks (68571) |
| PercentVolumeHealedAtFourWeeks | NUMERIC | Percent change of volume at 4 weeks. Calculation starts from the initial date of wound care. To see the change from the beginning of outpatient wound care, use the column PCT_VOLUME_HEALED_4W_OUTPAT. Rule: Percentage of Wound Volume Healed at 4 Weeks (68530) |
| LastEncounterWoundAgeInDays | NUMERIC | Age of the wound in days as of the last encounter. The wound age will calculate as of the initial wound placement date. The end date will be the outcome date, if populated, otherwise it will count up to the last encounter date. If the last encounter was inpatient, it will use the discharge date, or today's date if currently admitted. Rule: Age of Wound at Last Visit (68527) |
| WoundRegistryRecordIdentifier | NUMERIC | The unique identifier (.1 item) for the registry data record. |
| LastHomeHealthVisitDate | DATETIME | The date of the last Home Health visit where documentation was recorded for the wound. Rule: Last Home Health Visit Date (68555) |
| PatientAgeAtFirstWoundAssessment | NUMERIC | Patient’s age in years at time of first assessment of the wound. Rule: Patient Age at First Wound Assessment (68519) |
| PercentSurfaceAreaHealedAtFourWeeksOutpatient | NUMERIC | Percent change of surface area at 4 weeks. Calculation starts from the date of first outpatient care. To see the change from the beginning of any wound care, use the column PCT_AREA_HEALED_4W. Rule: Outpatient Percentage of Wound Surface Area Healed at 4 Weeks (68546) |
| IsWoundPresentOnAdmissionModified | VARCHAR | Indicates if the wound present on original admission row was modified more than once. Rule: Wound POA Row Modified (68580) |
| PercentageVolumeHealedAtEightWeeks | NUMERIC | Percent change of volume at 8 weeks. Calculation starts from the initial date of wound care. To see the change from the beginning of outpatient wound care, use the column PCT_VOLUME_HEALED_8W_OUTPAT. Rule: Percentage of Wound Volume Healed at 8 Weeks (68531) |
| WoundFirstAssessedDate | DATETIME | The date the wound was first assessed. This will be the date the wound LDA was placed on a patient. Rule: Wound Start of Care (68525) |
| PercentOutpatientWoundAreaHealedAt12Weeks | NUMERIC | Percent change of surface area at 12 weeks. Calculation starts from the date of first outpatient care. To see the change from the beginning of any wound care, use the column PCT_AREA_HEALED_12W. Rule: Outpatient Percentage of Wound Surface Area Healed at 12 Weeks (68548) |
| OutpatientVolumePercentHealedFourWeeks | NUMERIC | Percent change of volume at 4 weeks. Calculation starts from the date of first outpatient care. To see the change from the beginning of any wound care, use the column PCT_VOLUME_HEALED_4W. Rule: Outpatient Percentage of Wound Volume Healed at 4 Weeks (68535) |
| OutpatientWoundSurfaceAreaHealingPercentage | NUMERIC | Percent change of surface area from the initial outpatient wound assessment to the last wound assessment. To see the change from the beginning of any wound care, use the column PCT_AREA_HEALED. Rule: Outpatient Total Percentage of Wound Surface Area Healed (68541) |
| PercentSurfaceAreaHealedAtTwelveWeeks | NUMERIC | Percent change of surface area at 12 weeks. Calculation starts from the initial date of wound care. To see the change from the beginning of outpatient wound care, use the column PCT_AREA_HEALED_12W_OUTPAT. Rule: Percentage of Wound Surface Area Healed at 12 Weeks (68543) |
| PercentVolumeHealedAtTwelveWeeks | NUMERIC | Percent change of volume at 12 weeks. Calculation starts from the initial date of wound care. To see the change from the beginning of outpatient wound care, use the column PCT_VOLUME_HEALED_12W_OUTPAT. Rule: Percentage of Wound Volume Healed at 12 Weeks (68532) |
| LastWoundDocumentationDischargeDateTime | DATETIME | The most recent date that the patient was discharged from the facility, regardless of the patient's base patient class, where documentation was recorded for the wound. If the patient is currently admitted, it will return the prior admission's discharge date. Rule: Last Inpatient Discharge Date (68553) |
| LastWoundAssessmentDate | DATETIME | The date the wound was last assessed. Rule: Last Wound Assessment (68559) |
| OutpatientWoundVolumeHealedPercentage | NUMERIC | Percent change of volume from the initial outpatient wound assessment to the last wound assessment. To see the change from the beginning of any wound care, use the column PCT_VOLUME_HEALED. Rule: Outpatient Total Percentage of Wound Volume Healed (68529) |
| PercentAreaHealedAtEightWeeks | NUMERIC | Percent change of surface area at 8 weeks. Calculation starts from the initial date of wound care. To see the change from the beginning of outpatient wound care, use the column PCT_AREA_HEALED_8W_OUTPAT. Rule: Percentage of Wound Surface Area Healed at 8 Weeks (68542) |
| InitialPressureInjuryStage | INTEGER | The initial stage of a pressure injury. Rule: Pressure Injury Initial Stage (68522) |
| PercentageVolumeHealed | NUMERIC | Percent change of volume from the initial wound assessment to the last wound assessment. To see the change from the beginning of outpatient wound care, use the column PCT_VOLUME_HEALED_OUTPAT Rule: Total Percentage of Wound Volume Healed (68528) |
| LastWoundAdmissionDate | DATETIME | The most recent date that the patient was first admitted to the facility, bedded in the ED, or confirmed for an HOV for this contact, regardless of patient's base patient class, where documentation was recorded for the wound. Rule: Last Inpatient Admission Date (68552) |
| CurrentPressureInjuryStage | INTEGER | The current stage of a pressure injury. Rule: Pressure Injury Current Stage (68521) |
| OutpatientWoundAreaHealingPercentageAt16Weeks | NUMERIC | Percent change of surface area at 16 weeks. Calculation starts from the date of first outpatient care. To see the change from the beginning of any wound care, use the column PCT_AREA_HEALED_16W. Rule: Outpatient Percentage of Wound Surface Area Healed at 16 Weeks (68549) |
| LastApproximateWoundAgeInDays | NUMERIC | Estimated age of the wound in days. The initial date for this calculation is the date of first assessment of the wound, plus the approximate age at the time of the first assessment. The end date will be the outcome date, if populated, otherwise, the most recent encounter date. If the last encounter was inpatient, it will use the discharge date, or today's date if currently admitted. Rule: Approximate Wound Age At Last Visit (68590) |
| WoundResolutionDate | DATETIME | The date when the wound was resolved. This date should correspond with the outcome documented in the OUTCOME_C column. Rule: Outcome Date (68526) |
| TotalHomeHealthWoundCareVisits | NUMERIC | The total number of Home Health visits corresponding to wound care. Rule: Number of Home Health Visits (68516) |
| FirstHomeHealthVisitDate | DATETIME | The date of the first Home Health visit where documentation was recorded for the wound. Rule: First Home Health Visit Date (68556) |
| WoundFirstOutpatientAssessmentDate | DATETIME | The date the wound was first assessed in an outpatient setting. Rule: Outpatient Start of Care (68524) |
| PercentVolumeHealedAtTwentyWeeksOutpatient | NUMERIC | Percent change of volume at 20 weeks. Calculation starts from the date of first outpatient care. To see the change from the beginning of any wound care, use the column PCT_VOLUME_HEALED_20W. Rule: Outpatient Percentage of Wound Volume Healed at 20 Weeks (68539) |
| OutpatientWoundVolumeHealedPercentageAt16Weeks | NUMERIC | Percent change of volume at 16 weeks. Calculation starts from the date of first outpatient care. To see the change from the beginning of any wound care, use the column PCT_VOLUME_HEALED_16W. Rule: Outpatient Percentage of Wound Volume Healed at 16 Weeks (68538) |
| WoundHealedPercentageSinceLastEncounter | NUMERIC | How much of the wound has healed between the most recent two encounters. This will first look at volume and if no volume is documented it will use surface area. Rule: Percentage of Wound Volume Healed Since the Last Visit (68566) |
| RecordOwningCommunityIdentifier | VARCHAR | The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect. |
| WoundHealingDurationDays | NUMERIC | The number of days it took the wound to heal completely. Rule: Number of Days to Heal (68562) |
| WoundAreaHealedPercentage | NUMERIC | Percent change of surface area from the date of wound care to the last wound assessment. To see the change from the beginning of outpatient wound care, use the column PCT_AREA_HEALED_OUTPAT Rule: Total Percentage of Wound Surface Area Healed (68540) |
| OutpatientPercentAreaHealed20Weeks | NUMERIC | Percent change of surface area at 20 weeks. Calculation starts from the date of first outpatient care. To see the change from the beginning of any wound care, use the column PCT_AREA_HEALED_20W. Rule: Outpatient Percentage of Wound Surface Area Healed at 20 Weeks (68550) |
| WoundAddedInErrorIndicator | VARCHAR | Rule: Wound Added in Error (68561) |
| WoundResponsibleProviderIdentification | VARCHAR | The unique ID of the provider who is responsible for caring for this wound. Rule: Wound Responsible Provider (68593) |
| OutpatientDaysToHeal | NUMERIC | The number of days it took the wound to heal completely from the start of outpatient care. Rule: Outpatient Number of Days to Heal (68564) |
| PrimaryWoundTypeCategory | INTEGER | The primary wound type. For custom wound types, this column holds the base wound type from ECT 68500 that is mapped to the documented wound type on the LDA. Rule: Wound Type (68560) |
| LastOutpatientWoundDocumentationDepartmentIdentification | NUMERIC | The department of the last outpatient visit where documentation was recorded for the wound. Rule: Last Outpatient Visit Department (68551) |
| CommunityLogOwnerIdentification | VARCHAR | The Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect. |
| TotalWoundCareOutpatientAndHospitalVisits | NUMERIC | The total number of Outpatient and Hospital Outpatient visits corresponding to wound care. Rule: Number of OP HOV Visits (68515) |