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 Rev_Code, Rev_CodeID, HCPCS, Visit_Type, Payer_ID, Description
FROM #Request.prefix_db_agency#.Revenue_Code
WHERE Agency_ID = '#session.AgencyID#'
And EClaim_Price IS NOT NULL
And RevenueCodeStatus = 'active'
And Quick_Books_Price IS NOT NULL
And Payer_ID = '#Session.Patient.Payer#'
Order by Visit_Type, Rev_Code
SELECT Payer_ID, PayName, Output_Type 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.