pathwaydash = CreateObject("Component", "pathway");
SN_Visit_Count = pathwaydash.get_pAuth(#url.assessment_id#,'SN');
HHA_Visit_Count = pathwaydash.get_pAuth(#url.assessment_id#,'HHA');
PT_visit = pathwaydash.get_pAuth(#url.assessment_id#,'PT');
OT_visit = pathwaydash.get_pAuth(#url.assessment_id#,'OT');
total_st_visit = pathwaydash.get_pAuth(#url.assessment_id#,'ST');
total_msw_visit = pathwaydash.get_pAuth(#url.assessment_id#,'MSW');
SELECT * FROM
#Request.prefix_db_lookup#.OASIS_lookup
WHERE
Assessment_Type like '1 - Start %'
OR Assessment_Type like '3 - Resumption%'
OR Assessment_Type like '4 - Recertification%'
OR Assessment_Type like '5 - Other%';
SELECT
pPatients.Safety_Hazards_M0320, pPatients.Structural_Barriers_M0310, pPatients.Financial_Factors_M0150, Current_Residence_M0300, pPatients.Patient_ID,pPatients.Pt_Last, pPatients.Pt_First, pPatients.Pt_Middle, pPatients.Assisting_Persons_M0350, pPatients.Employee_ID,pAssessments.F26, pAssessments.F176,pAssessments.F177,pAssessments.F178, pAssessments.Assmt_ID,0 as CW_ID, pPatients.Record_Creation_Date, pPatients.Record_Created_By,pAssessments.F1,pAssessments.F2, pAssessments.F3, pAssessments.F4, 0 AS OASIS_2019_2020_PDGM,0 AS HIPPS_Code ,pAssessments.F5,pAssessments.F6
FROM
#Request.prefix_db_agency#.pPatients
Left join
#Request.prefix_db_agency#.pAssessments on pAssessments.Patient_ID = pPatients.Patient_ID
Left join
#Request.prefix_db_agency#.Assessment_New_CW on Assessment_New_CW.Patient_ID = pPatients.Patient_ID
where
pPatients.Patient_ID=
and patient.Agency_ID=
AND pAssessments.Assmt_ID=
AND pAssessments.status = 0
ORDER BY pPatients.Patient_ID desc
dash = CreateObject("Component", "pathway");
get_emp = dash.get_Employee();