SELECT Patient_ID, Last_Name_M0040, First_Name_M0040, Middle_Initial_M0040, Payer_ID FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = SELECT patient.Patient_ID, patient.Last_Name_M0040, patient.First_Name_M0040, patient.Middle_Initial_M0040, patient.Payer_ID, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Assessment_ID, Assessment_New.SN_Visit_Orders, Assessment_New.Therapy_Visit_Orders, Assessment_New.HHA_Visit_Orders, Assessment_New.SN_Schedule, Assessment_New.Therapy_Schedule, Assessment_New.HHA_Schedule, Assessment_New.Admission_Status, Assessment_New.Homebound_Status, Assessment_New.HIPPS_Code, Assessment_New.Assessment_Tracker_ID FROM #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Assessment_New WHERE patient.Patient_ID = Assessment_New.Patient_ID AND Assessment_ID = SELECT Payer_ID, PayName, Output_Type,Ties_Associated_Assesment FROM #Request.prefix_db_agency#.Payer WHERE Agency_ID = ORDER BY PayName SELECT Employee_ID, First_Name, Last_Name FROM #Request.prefix_db_lookup#.Employee WHERE Agency_ID = AND EmployeeType != 'Physician' AND Status = 'Active' ORDER BY Last_Name SELECT Rev_CodeID, Rev_Code, HCPCS, Visit_Type, Description FROM #Request.prefix_db_agency#.Revenue_Code WHERE Agency_ID = AND Payer_ID = And EClaim_Price IS NOT NULL And Quick_Books_Price IS NOT NULL Order by Visit_Type ASC Certification Start Date of [#GetAssess.Certification_Start#] or Certification End Date of [#GetAssess.Certification_End#] is illegal.
Add Schedule
#GetPatient.Last_Name_M0040#, #GetPatient.First_Name_M0040# #GetPatient.Middle_Initial_M0040#
#DateFormat(Certification_Start, "mmm d, yyyy")# to #DateFormat(Certification_End, "mmm d, yyyy")#
#TempPayer#
">
Date Format: mm/dd/yyyy
No SN orders on 485 SN Orders: #SN_Visit_Orders# No therapy ordered on 485 Therapy Orders: #Therapy_Visit_Orders# No HHA ordered on 485 HHA Orders: #HHA_Visit_Orders#