SELECT pPTG.*,pAssessments.F322 ,
(SELECT F322 FROM #Request.prefix_db_agency#.pAssessments pAss
WHERE pAss.Patient_ID = pPTG.Patient_ID
AND pAss.Admit_ID = pPTG.Admit_ID
AND pAss.F26 = ( CASE
WHEN (pPTG.Skill = "PT" ) THEN 'PT Adult Evaluation'
WHEN (pPTG.Skill = "OT" ) THEN 'OT Adult Evaluation'
ELSE 0
END )
AND pAss.Status = 0 AND pPTG.Visit_Date = pAss.F176 ORDER BY F25 ASC LIMIT 0,1) AS VBP_Adult
FROM #Request.prefix_db_agency#.pPTG
JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pPTG.Assmt_ID AND pAssessments.status = 0
WHERE pPTG.Patient_ID IN (SELECT pSchedules.Patient_ID FROM #Request.prefix_db_agency#.pSchedules
JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID
WHERE pSchedules.Emp_ID =
AND pSchedules.Status = 0 AND pAssessments.Status =0 )
AND pPTG.Emp_ID =
ORDER BY Patient_ID ASC
SELECT p.Patient_ID, p.Pt_Last, p.Pt_First, p.Status
FROM #Request.prefix_db_agency#.pPatients p
WHERE p.Loc_ID = '#session.agencyid#'
AND p.Status < 0
ORDER BY p.Pt_Last ASC, p.Pt_First ASC
SELECT e.Emp_ID, e.Emp_Last, e.Emp_First, e.Status
FROM #Request.prefix_db_lookup#.pEmployee e
WHERE e.Loc_ID = '#session.agencyid#'
AND e.Emp_Type = 'employee'
ORDER BY e.Emp_Last ASC, e.Emp_First ASC