UPDATE #Request.prefix_db_agency#.Assessment_New set Physician_Last_Seen_Date=#CreateODBCDate(url.dateval)# where Assessment_ID ='#url.assid#' SELECT p.Patient_Id, p.Last_Name_M0040, p.First_Name_M0040, p.Admission_Status ,an.Assessment_Id, an.Start_of_Care_M0030, an.Physician_Last_Seen_Date, an.Certification_Start, an.Certification_End, y.PayName FROM #Request.prefix_db_agency#.patient p, #Request.prefix_db_agency#.Assessment_New an LEFT JOIN #Request.prefix_db_agency#.Payer y ON an.Payer_ID = y.Payer_ID WHERE p.Agency_Id = '#session.AgencyId#' AND p.Status = 'Active' AND an.Patient_Id = p.Patient_Id AND an.NotAdmitted = 0 AND SUBSTR(an.Start_of_Care_M0030, 1, 10) >= '2011-01-01' AND an.Deleted <> 1 AND SUBSTR(an.Assessment_Reason_M0100, 1, 1) = '1' AND ( an.Physician_Last_Seen_Date IS NULL OR DATE_SUB(an.Start_of_Care_M0030, INTERVAL -30 DAY) <= SUBSTR(an.Physician_Last_Seen_Date, 1, 10) OR DATE_SUB(an.Start_of_Care_M0030, INTERVAL 90 DAY) >= SUBSTR(an.Physician_Last_Seen_Date, 1, 10) ) AND an.Physician_Last_Seen_Date IS NULL AND ( p.Employee_ID = ' #Session.EmployeeID#' OR '#session.EmployeeId#' IN ( select distinct employee_id from #Request.prefix_db_agency#.ScheduleItems where patient_id = p.Patient_Id and deleted <> 1 ) ) ORDER BY p.Last_Name_M0040 ASC, p.First_Name_M0040 ASC, an.Start_of_Care_M0030 ASC SELECT Assessment_Tracker_ID, Assessment_Number, Start_of_Care_M0030, Resump_of_Care_M0032, Resump_of_Care_NA_M0032, Assessment_note, Assessment_Completed_M0090, M0104_Date_of_Referral, Assessment_Reason_M0100, Source_of_Admission, Admission_Description, Certification_Start, Certification_End, HIPPS_Code, SN_Visit_Orders, Therapy_Visit_Orders, HHA_Visit_Orders, Claim_Key, Information_Release, NotAdmitted, Deleted, Archive,Payer_ID, UniqueAuth, Date_Discharge_M0906, Previous_Assessment_Number ,Physician_Last_Seen_Date ,Admission_Status FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID = '#session.cs.AssessmentId#'
Patients needing Face to Face with Physician
Click a Start of Care date to enter a Face to Face Visit Date for that Assessment... bgcolor="FFFFFF" bgcolor="e7e7e9">
Patient Payer Start of Care Last Physician
Face to Face		 Cert Start Cert End
#Last_Name_M0040#, #First_Name_M0040# #PayName# #DateFormat(Start_of_Care_M0030, 'mm/dd/yyyy')# #DateFormat(ftf.Physician_Last_Seen_Date,'mm/dd/yyyy')# Edit #DateFormat(Certification_Start, 'mm/dd/yyyy')# #DateFormat(Certification_End, 'mm/dd/yyyy')#
#DateFormat(Certification_Start, 'mm/dd/yy')# #DateFormat(Certification_End, 'mm/dd/yy')# --->