SELECT Assessment_Completed_M0090,Assessment_Reason_M0100, Emergent_Care_M0830,Emergent_Care_Reason_M0840, Inpatient_Facility_M0855,Discharge_Disposition_M0870, After_Discharge_Services_M0880,Hospital_Reason_M0890, Hospital_Reason_List_M0895,Nursing_Home_M0900, Date_Most_Recent_M0903,Date_Discharge_M0906, Agency_ID,M0110,M0826_NA,M0826_Ther_Need, Discharged_From_M0175,M0102_Physician_SOC, M0104_Date_of_Referral,M1012_Inpat_DX_NA, M1012_Inpat_DX_UK,M1016_DX_NA,M1032_Frailty, Rehab_Prognosis_M0270,Hearing_M0400,M1220_Verbal_Under, M1240_Pain_Assess,Freq_of_Pain_M0420,M1300_Pressure, M1302_Pressure,M1306_Unhealed_Pressure, Pressure_Ulcer_b_M0450,Pressure_Ulcer_c_M0450, Pressure_Ulcer_d_M0450,Pressure_Ulcer_e_M0450, M1308_d_2_Pressure,M1308_d_3_Pressure,M1310_1, M1310_Length,M1312_Width,M1312_1,M1314_Depth, M1314_1,Pressure_Ulcer_Status_M0464, Stasis_Ulcer_M0468,Stasis_Ulcer_Num_M0470, Stasis_Ulcer_Status_M0476,Surgical_Wound_M0482, Surgical_Wound_Status_M0488,M1350_Other_Wounds, Urinary_INcont_M0520,Urinary_INcont_when_M0530, M1730_Depression,M1730a,M1730b,Bathing_M0670, M1840_Toilet,M1845_Toilet,Transferring_M0690, Ambulation_M0700,M0826_NA,M1900a_SelfCare,M1900b_Amb, M1900c_Transfer,M1900d_House,M1910_Fall_Risk,M2000_Adverse, M2002_Med_FU,M2010_Med_Edu,Oral_Meds_M0780,Inject_Meds_M0800, HIPPS_Code,Oral_Meds_M0780p,Inject_Meds_m0800p,M2100a_Equip, M2100b_Equip,M2100c_Equip,M2100d_Equip,M2100e_Equip,M2100f_Equip, M2100g_Equip,M2110_Assist_Freq,M2250a_PhysNot,M2250b_Diabetic, M2250c_FallsPrev,M2250d_Depress,M2250e_Pain,M2250f_PressUlc, M2250g_PressUlcMoist,Patient_ID,M1308_a_12_Pressure,M1308_b_12_Pressure, M1308_c_12_Pressure,M1308_d_12_Pressure,M1308_d_22_Pressure, M1308_d_32_Pressure,M1040_Influ,M1050_Pneu,M1055_Pneu,M1307_Date, M1307_Oldest,M1500_Symptoms,M1510_Hrt_FU,M2004_Med_Int,M2015_Drug_Edu, M2400a_Diabetic,M2400b_FallsPrev,M2400c_Depress,M2400d_Pain,M2400e_PressUlc, M2400f_PressUlcMoist FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID='158481' SELECT HHA_Record_Data FROM #Request.prefix_db_agency#.Datasets WHERE Assessment_ID='158481' SELECT Natl_Provider_ID FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID='#Assessment_New.Agency_ID#' SELECT M0245_ICD FROM #Request.prefix_db_agency#.Diagnosis WHERE Assessment_ID='158481' limit 0,1 SELECT M1100_Living_Situation FROM #Request.prefix_db_agency#.patient WHERE Patient_ID='#Assessment_New.Patient_ID#' HHA_Record_Data = #HHA_Record_Data# .