--->
#session.cs.AssessmentId#
SELECT Patient_ID, Last_Name_M0040 AS Last_Name, First_Name_M0040 AS First_Name, Middle_Initial_M0040 AS Middle
,Payer_ID
FROM #Request.prefix_db_agency#.patient
WHERE Patient_Id = '#session.cs.patientid#'
AND Agency_Id = '#session.AgencyId#'
select
Date_Most_Recent_M0903,
Date_Discharge_M0906,
Discharged_From_M0175,
Medical_or_Treatment_Change_M0200,
Conditions_Prior_M0220,
Therapies_Home_M0250,
Record_Created_By,
Resp_Treatments_M0500,
UTI_M0510,
Urinary_INcont_M0520,
Urinary_INcont_when_M0530,
Overall_Prognosis_M0260,
Psy_Nursing_M0630,
Life_Exp_M0280,
High_Risk_Factors_M0290,
Vision_M0390,
Hearing_M0400,
Rehab_Prognosis_M0270,
Speech_M0410,
Depressive_Feelings_M0590,
Patient_Behav_Weekly_M0610,
Patient_Behav_freq_M0620,
Freq_of_Pain_M0420,
Intrac_Pain_M0430,
Open_Wounds_M0440,
Pressure_Ulcer_M0445,
Physician_Last_Seen_Date,
M1307_Date,
Pressure_Ulcer_a_M0450,
Pressure_Ulcer_b_M0450,
Pressure_Ulcer_c_M0450,
Pressure_Ulcer_d_M0450,
Pressure_Ulcer_e_M0450,
M0104_Date_of_Referral
FROM #Request.prefix_db_agency#.Assessment_New
where Assessment_ID='#session.cs.AssessmentId#'
select Last_Name,First_Name from #Request.prefix_db_lookup#.Employee where Employee_ID = '#AssForm.Record_Created_By#'
#GetP.First_Name# #GetP.Last_Name#, Hospice Discharge