Entity OASIS Integumentary Status Snapshot

DescriptionA clinical observation of the patients integumentary or skin system status.

Attributes
Encounter DkEncounter Dk
Load Info SkLoad Info Sk
Medicaid IndMedicaid Ind
Medicare IndMedicare Ind
Patient DkPatient Dk
Point Of Care Location DkPoint Of Care Location Dk
Practitioner DkPractitioner Dk
Pressure Ulcer Assessment IndPressure Ulcer Assessment Ind
Pressure Ulcer Depth QtyPressure Ulcer Depth Qty
Pressure Ulcer Depth UOMPressure Ulcer Depth UOM
Pressure Ulcer Development Risk IndPressure Ulcer Development Risk Ind
Pressure Ulcer Identified DatePressure Ulcer Identified Date
Pressure Ulcer Length QtyPressure Ulcer Length Qty
Pressure Ulcer Length UOMPressure Ulcer Length UOM
Pressure Ulcer Oldest NonEpithelialized Stage IIPressure Ulcer Oldest NonEpithelialized Stage II
Pressure Ulcer StagePressure Ulcer Stage
Pressure Ulcer Stage I CntPressure Ulcer Stage I Cnt
Pressure Ulcer Stage II Admission CntPressure Ulcer Stage II Admission Cnt
Pressure Ulcer Stage II CountPressure Ulcer Stage II Count
Pressure Ulcer Stage III Admission CntPressure Ulcer Stage III Admission Cnt
Pressure Ulcer Stage III CntPressure Ulcer Stage III Cnt
Pressure Ulcer Stage II or Higher IndPressure Ulcer Stage II or Higher Ind
Pressure Ulcer Stage IV Admission CntPressure Ulcer Stage IV Admission Cnt
Pressure Ulcer Stage IV CntPressure Ulcer Stage IV Cnt
Pressure Ulcer StatusPressure Ulcer Status
Pressure Ulcer Unstageable I Admission CntPressure Ulcer Unstageable I Admission Cnt
Pressure Ulcer Unstageable I CntPressure Ulcer Unstageable I Cnt
Pressure Ulcer Unstageable II Admission CntPressure Ulcer Unstageable II Admission Cnt
Pressure Ulcer Unstageable II CntPressure Ulcer Unstageable II Cnt
Pressure Ulcer Unstageable III Admission CntPressure Ulcer Unstageable III Admission Cnt
Pressure Ulcer Unstageable III CntPressure Ulcer Unstageable III Cnt
Pressure Ulcer Width QtyPressure Ulcer Width Qty
Pressure Ulcer Width UOMPressure Ulcer Width UOM
Provider DkProvider Dk
Skin Lesion Or Open Wound IndSkin Lesion Or Open Wound Ind
Stasis Ulcer CntStasis Ulcer Cnt
Stasis Ulcer IndStasis Ulcer Ind
Stasis Ulcer StatusStasis Ulcer Status
Surgical Wound IndSurgical Wound Ind
Surgical Wound StatusSurgical Wound Status
Survey Date DkSurvey Date Dk
Survey DkSurvey Dk
Tenant SkTenant Sk

Relationship
OASIS Integumentary Status Snapshot_Provider Dimension_FKOASIS Integumentary Status Snapshot_Provider Dimension_FK
OASIS Integumentary Status Snapshot_Patient Dimension_FKOASIS Integumentary Status Snapshot_Patient Dimension_FK
OASIS Integumentary Status Snapshot_Encounter Dimension_FKOASIS Integumentary Status Snapshot_Encounter Dimension_FK
OASIS Integumentary Status Snapshot_Practitioner Dimension_FKOASIS Integumentary Status Snapshot_Practitioner Dimension_FK
OASIS Integumentary Status Snapshot_Survey Dimension_FKOASIS Integumentary Status Snapshot_Survey Dimension_FK
OASIS Integumentary Status Snapshot_Point Of Care Location Dimension_FKOASIS Integumentary Status Snapshot_Point Of Care Location Dimension_FK
OASIS Integumentary Status Snapshot_Calendar Dimension_FKOASIS Integumentary Status Snapshot_Calendar Dimension_FK

Primary Key
OASIS Integumentary Status Snapshot PKOASIS Integumentary Status Snapshot PK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Encounter Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Medicaid Ind
DescriptionIndicator if respondent is classified as Medicaid recipient.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medicare Ind
DescriptionIndicator if respondent is classified as Medicare recipient.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Point Of Care Location Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Practitioner Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Assessment Ind
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Depth Qty
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Depth UOM
DescriptionUnit of Measure for the Depth of the pressure ulcer. OASIS shows cms.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Development Risk Ind
DescriptionIdentifies if the patient is at risk for developing pressure ulcers.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Identified Date
DescriptionDeveloped since the most recent SOC/ROC assessment: record date pressure ulcer first identified:
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Length Qty
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Length UOM
DescriptionUnit of Measure for the Length of the pressure ulcer. OASIS shows cms.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Oldest NonEpithelialized Stage II
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Stage
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Stage I Cnt
DescriptionIdentifies the presence of Stage I pressure ulcers.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Stage II Admission Cnt
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Stage II Count
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Stage III Admission Cnt
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Stage III Cnt
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Stage II or Higher Ind
DescriptionIdentifies the presence or absence of unstageable or unhealed Stage II or higher pressure ulcers only.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Stage IV Admission Cnt
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Stage IV Cnt
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Status
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Unstageable I Admission Cnt
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Unstageable I Cnt
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Unstageable II Admission Cnt
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Unstageable II Cnt
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Unstageable III Admission Cnt
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Unstageable III Cnt
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Width Qty
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Decimal Float [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pressure Ulcer Width UOM
DescriptionUnit of Measure for the Width of the pressure ulcer. OASIS shows cms.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Skin Lesion Or Open Wound Ind
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Stasis Ulcer Cnt
DescriptionIdentifies the number of visible (observable) stasis ulcers.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Stasis Ulcer Ind
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Stasis Ulcer Status
DescriptionIdentifies 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 TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Surgical Wound Ind
DescriptionIdentifies the presence of any wound resulting from a surgical procedure.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Surgical Wound Status
DescriptionIdentifies the degree of healing present in the most problematic, observable surgical wound.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Survey Date Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Survey Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 OASIS Integumentary Status Snapshot_Provider Dimension_FK
Is Identifying Relationshiptrue
Child TableOASIS Integumentary Status Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableProvider Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 OASIS Integumentary Status Snapshot_Patient Dimension_FK
Is Identifying Relationshiptrue
Child TableOASIS Integumentary Status Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 OASIS Integumentary Status Snapshot_Encounter Dimension_FK
Is Identifying Relationshiptrue
Child TableOASIS Integumentary Status Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableEncounter Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 OASIS Integumentary Status Snapshot_Practitioner Dimension_FK
Is Identifying Relationshiptrue
Child TableOASIS Integumentary Status Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePractitioner Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 OASIS Integumentary Status Snapshot_Survey Dimension_FK
Is Identifying Relationshiptrue
Child TableOASIS Integumentary Status Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableSurvey Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 OASIS Integumentary Status Snapshot_Point Of Care Location Dimension_FK
Is Identifying Relationshiptrue
Child TableOASIS Integumentary Status Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePoint Of Care Location Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 OASIS Integumentary Status Snapshot_Calendar Dimension_FK
Is Identifying Relationshiptrue
Child TableOASIS Integumentary Status Snapshot
Child MultiplicityZERO_TO_ONE
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCalendar Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 OASIS Integumentary Status Snapshot PK
Key AttributeProvider Dk
Key AttributePatient Dk
Key AttributeEncounter Dk
Key AttributePractitioner Dk
Key AttributeSurvey Dk
Key AttributePoint Of Care Location Dk
Key AttributeSurvey Date Dk