SELECT pPatients.Pt_First AS First_Name,pPatients.Pt_Last AS Last_Name,PCR.*,pAssessments.Admit_ID, (SELECT count(*) FROM #Request.prefix_db_agency#.pAssessments pa WHERE pa.Admit_ID = pAssessments.Admit_ID AND (pa.F26 like '%PT Adult%' OR pa.F26 like '%PT Followup%') AND pa.Status = 0 ) AS PT_Count, (SELECT count(*) FROM #Request.prefix_db_agency#.pAssessments pa WHERE pa.Admit_ID = pAssessments.Admit_ID AND (pa.F26 like '%OT Adult%' OR pa.F26 like '%OT Followup%') AND pa.Status = 0 ) AS OT_Count, (SELECT count(*) FROM #Request.prefix_db_agency#.pAssessments pa WHERE pa.Admit_ID = pAssessments.Admit_ID AND (pa.F26 like '%ST Adult%' OR pa.F26 like '%ST Followup%') AND pa.Status = 0 ) AS ST_Count FROM #Request.prefix_db_agency#.PCR JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = PCR.Assmt_ID JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = PCR.Patient_ID WHERE PCR.Status=0 AND (PCR.PCR_Status != 'submitted' OR PCR_Status IS NULL) AND pAssessments.Status=0 AND pPatients.Status <2 ORDER BY Pt_First,pAssessments.Assmt_ID ASC
Pre Claim Review Tracker
Fetch latest report Back
pm = CreateObject("Component", "pcr_menu"); myArgument = 'Create_PCR'; pm.MenuFunction(myArgument);

* Changes made below update database


style="background-color: ##E5E4E2;">
checked disabled>
style="background-color: ##E5E4E2;">
checked disabled>
style="background-color: ##E5E4E2;">
checked disabled>
Patient & Episode Face to Face Plan of Care OASIS PT Assessments OT Assessments ST Assessments Episode Visit Verified Status Action
#First_Name#, #Last_Name#
(#DATEFORMAT(Cert_Start,"mm/dd/yyyy")# - #DATEFORMAT(Cert_End,"mm/dd/yyyy")#)
checked disabled>
checked disabled>
checked disabled>
#Episode#
checked disabled>
checked disabled>
Document view