SELECT
a.Mileage_Rate
,si.Schedule_Id
,si.Emp_ID, si.Assmt_ID,an.Patient_ID
,IFNULL(si.Emp_ID, 0) AS Schedule_Emp_ID
,si.Visit_Date,si.Missed
,DATE_FORMAT(si.Visit_Date, '%Y-%m-%d') vd
,DATE_FORMAT(py.pay_date, '%Y-%m-%d') dd
,si.Skill
,si.Schedule_Id
,LEFT(TIMEDIFF(EndTime,StartTime),2) hours
,si.StartTime
,si.EndTime
,IFNULL(pProgress.Progress_ID,0 ) AS Progress_ID
,si.Progress_Note,si.pgnotesdraft
,si.Travel travel
,si.Total_EPay paid
,si.Paperwork paper
,si.Mileage miles
,si.Mi_Pay AS PayMileage, si.Visit_Type
,e.Emp_ID
,e.Emp_Last
,e.Emp_First
,e.Emp_Custom_1
,e.Emp_Street1,e.Emp_City,e.Emp_State,e.Emp_Zip
,ep.Pay_Rate
,UPPER(ep.Measure) measure
,p.Pt_Last pl
,p.Pt_First pf
,p.Pt_Agy_ID
,p.Pt_Street
,p.Pt_City
,p.Pt_State
,p.Pt_Zip
,(SELECT DATE_FORMAT(pa.M0030_START_CARE_DT, '%m/%d/%Y')
FROM #Request.prefix_db_agency#.pAdmit pa
INNER JOIN #Request.prefix_db_agency#.pAssessments ass ON ass.Admit_ID = pa.Admit_ID
AND ass.Assmt_ID = si.Assmt_ID
AND ass.Status = 0
WHERE pa.Status = 0
LIMIT 1) AS patient_admit_date
,(SELECT payr.Pay_Name
FROM #Request.prefix_db_agency#.pPtPayer pp
INNER JOIN #Request.prefix_db_agency#.pPayer payr ON payr.Pay_ID = pp.Payer_ID AND payr.Status = 0
WHERE pp.PtPayer_ID = si.PtPayer_ID AND pp.Status = 0
LIMIT 1) AS patient_payer_name
,IFNULL(rc.HCPCS, '') AS HCPCS
,py.id AS PayrollId, py.pay_type, ap.Description
,py.Pay_Date,
,py.total_paid
FROM
#Request.prefix_db_lookup#.Agency a,
#Request.prefix_db_lookup#.pEmployee e,
#Request.prefix_db_agency#.Employee_Payroll ep,
#Request.prefix_db_agency#.Agency_Payroll ap,
#Request.prefix_db_agency#.pPatients p,
#Request.prefix_db_agency#.pAssessments an,
#Request.prefix_db_agency#.pSchedules si
LEFT OUTER JOIN #Request.prefix_db_agency#.payroll py ON py.Schedule_Id = si.Schedule_Id
LEFT OUTER JOIN #Request.prefix_db_agency#.pProgress ON pProgress.Schedule_Id = si.Schedule_Id
LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee e ON e.Emp_ID = si.Emp_ID AND si.Emp_ID > 0
LEFT OUTER JOIN #Request.prefix_db_agency#.Employee_Payroll ep ON ep.Emp_ID = e.Emp_ID AND ep.EmpPay_Id = si.Pay_ID
LEFT OUTER JOIN #Request.prefix_db_agency#.Agency_Payroll ap ON ap.Payroll_Id = ep.Payroll_ID
LEFT OUTER JOIN #Request.prefix_db_agency#.pRevenue_Code rc ON rc.Rev_CodeID = si.HCPCS_ID AND rc.Status = 0
WHERE a.Agency_Id = '#session.AgencyId#'
AND si.Visit_Date BETWEEN #CreateODBCDate(form.df)# AND #CreateODBCDate(form.dt)#
AND si.Visit_Date BETWEEN #CreateODBCDate(url.df)# AND #CreateODBCDate(url.dt)#
AND si.Status = 0
AND si.Emp_ID IS NOT NULL
AND si.Emp_ID > 0
AND si.Missed NOT IN (1,3)
AND (
si.Schedule_Id IN ()
OR IFNULL(si.Emp_ID, 0) = 0
)
AND (
py.Schedule_Id = si.Schedule_Id
OR IFNULL(si.Emp_ID, 0) = 0
)
AND (py.exported = 'N' OR IFNULL(si.Emp_ID, 0) = 0)
AND si.Schedule_Id NOT IN (SELECT Schedule_Id FROM #Request.prefix_db_agency#.payroll WHERE Schedule_Id = si.Schedule_Id)
AND e.Emp_ID = si.Emp_ID
AND (e.Emp_ID IN (#form.emps#)
OR IFNULL(si.Emp_ID, 0) = 0
)
AND ep.Emp_ID = e.Emp_ID
AND ep.EmpPay_Id = si.Pay_ID
AND ap.Payroll_Id = ep.Payroll_ID
AND p.Patient_Id = si.Patient_Id
AND an.Assmt_ID = si.Assmt_ID
AND an.Status = 0
AND p.Status IN (0,1,4)
GROUP BY si.Schedule_Id
ORDER BY si.Visit_Date, e.Emp_Last, e.Emp_First, ep.Measure
SELECT * FROM GetVisitsall
WHERE
pgnotesdraft = 1
AND Visit_Type IS NULL
(pgnotesdraft = 2 OR assessments_completed = 1)
(Visit_Type IS NOT NULL AND (assessments_completed IS NULL OR assessments_completed <> 1)
AND (Missed = 0 OR Missed IS NULL))
Please Right Click Here and choose "Save Target As..." to download the Exported data file and save it to your computer.
Click Here to start a new Payroll Report search.
UPDATE #Request.prefix_db_agency#.payroll
SET exported = 'Y'
WHERE Schedule_Id IN ()
No data could be found based on your search criteria.
Please try again.