UPDATE #Request.prefix_db_agency#.pAssessments SET
F320 = ,
Orphan_Field = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
ANd Status = 0
UPDATE #Request.prefix_db_agency#.pAssessments SET
Orphan_Field = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND Patient_ID =
ANd Status = 0
UPDATE #Request.prefix_db_agency#.pSchedules SET
hi_risk = ,
QA_View = ,
Date_Change = ,
Change_by =
WHERE Schedule_ID =
ANd Status = 0
SELECT pSchedules.*,pAssessments.Admit_ID FROM #Request.prefix_db_agency#.pSchedules
LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID
AND pAssessments.Status = 0
WHERE pSchedules.Schedule_ID = '#Schedule_ID#' AND pSchedules.Status =0
SELECT * FROM #Request.prefix_db_agency#.pPatients
WHERE Patient_ID = '#getschedules.Patient_ID#'
AND status IN (0,1,4)
visit_latitude: " & #visit_latitude# & "
visit_longitude: "
& #visit_longitude# & "
Pt_Latitude: " & #getpatient.Pt_Latitude# & "
Pt_Longitude: "
& #getpatient.Pt_Longitude# >
SELECT *, '' as CODING_WIZARD FROM #Request.prefix_db_lookup#.Agency WHERE Agency_Id = '#session.AgencyId#'
UPDATE #Request.prefix_db_agency#.pSchedules SET
EVV_start = ,
GPS_start_date = ,
StartTime = ,
GPS_start_time = ,
GPS_start_latitude = ,
GPS_start_longitude = ,
EVV_end = ,
GPS_end_date = ,
EndTime = ,
GPS_end_time = ,
GPS_end_latitude = ,
GPS_end_longitude = ,
Date_Change = ,
Change_by =
WHERE Schedule_ID =
ANd Status = 0
UPDATE #Request.prefix_db_agency#.pAssessments SET
F321 = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
ANd Status = 0
UPDATE #Request.prefix_db_agency#.pCareplan SET
QA_Approve = ,
QA_Approve = ,
Date_Resolve = ,
Date_Change = ,
Change_by =
WHERE Careplan_ID =
ANd Status < 2
UPDATE #Request.prefix_db_agency#.pPatients SET
Med_Approve = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Patient_ID =
ANd Status IN (0,1)
UPDATE #Request.prefix_db_agency#.pPatients SET
Med_Recon_Field = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Patient_ID =
ANd Status IN (0,1)
UPDATE #Request.prefix_db_agency#.pAssessments SET
F310 = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE Assmt_ID =
AND Status = 0
SELECT * FROM #Request.prefix_db_lookup#.Agency
WHERE Agency_ID = '#arguments.Agency_ID#'
SELECT * FROM #Request.prefix_db_lookup#.pEmployee
WHERE Emp_ID = '#arguments.Emp_ID#'
SELECT pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast,pPatients.Pt_Middle, pPatients.Pt_First AS PatientFirst,
pPatients.Pt_Agy_ID,pPatients.Status AS clientStatus,pPatients.Pt_SSN,pPatients.Pt_Street,
pPatients.Pt_City,pPatients.Pt_State,pPatients.Pt_Zip,pPatients.Pt_Longitude,pPatients.Pt_Latitude,pPatients.Pt_Phone,
pSchedules.Schedule_ID, pSchedules.Visit_Date, pSchedules.Skill AS Type, pSchedules.Visit_Type,
pSchedules.Total_Units, pSchedules.Mi_Pay,pSchedules.GPS_start_time,pSchedules.GPS_end_time,
CASE WHEN length(pSchedules.patient_sign) > 0 THEN true
ELSE false
END AS patient_sign_indicator,
CONCAT(RIGHT(pEmployee.Emp_SSN, 5), LEFT(Emp_Last,4)) AS EmployeeIdentifier,
CONCAT(DATE_FORMAT(CONVERT_TZ(pSchedules.Date_Create, @@session.time_zone, '+00:00'),'%Y-%m-%dT%H:%i:%s'), 'Z') AS CallDateTime,
pSchedules.Progress_Note, pSchedules.pgnotesdraft,pSchedules.GPS_start_latitude,
pSchedules.GPS_start_longitude,
pSchedules.Pay_ID, 0 AS No_Days_Progress, "" AS Note_QA , pSchedules.Notes AS Memo,
IFNULL(pSchedules.Sch_Latitude,40.34455) AS Sch_Latitude,
IFNULL(pSchedules.Sch_Longitude,-21.99383) AS Sch_Longitude,
pSchedules.GPS_start_date,pSchedules.GPS_end_date,
pSchedules.StartTime,pSchedules.EndTime,pSchedules.Date_Create AS CallDateTime_old,
IFNULL(pPtPayer.Sub_HIC,pSchedules.Schedule_ID) AS Sub_HICs,
pEmployee.*, pAssessments.Assmt_ID,pAuths.*,pPayer.*,pPtPayer.*,Agency.*,pRevenue_Code.HCPCS,pPhysicians.Phys_NPI,pRevenue_Code.HCPCS
FROM #Request.prefix_db_agency#.pSchedules
LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pSchedules.Assmt_ID AND pAssessments.status = 0
LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID
JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pSchedules.Patient_ID AND pPatients.Status IN (0,1,4)
JOIN #Request.prefix_db_lookup#.pEmployee ON pSchedules.Emp_ID = pEmployee.Emp_ID AND pEmployee.Status < 2
LEFT OUTER JOIN #Request.prefix_db_agency#.pAuths ON pAuths.Patient_ID = pSchedules.Patient_ID AND pAuths.Status =0
LEFT OUTER JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.Patient_ID = pPatients.Patient_ID
AND pPtPayer.PtPayer_ID = pAuths.PtPayer_ID AND pPtPayer.Status = 0
LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPayer.Status = 0
LEFT OUTER JOIN #Request.prefix_db_lookup#.Agency ON Agency.Agency_ID = pPatients.Loc_ID AND Agency.Status = 'active'
LEFT OUTER JOIN #Request.prefix_db_agency#.pRevenue_Code ON pRevenue_Code.Rev_CodeID = pSchedules.Rev_ID AND pRevenue_Code.Status = 0
LEFT OUTER JOIN #Request.prefix_db_lookup#.pPhysicians ON pPhysicians.Emp_ID = pEmployee.Emp_ID AND pPhysicians.Status = 0
WHERE pSchedules.status= 0
AND pSchedules.Emp_ID != 0
AND pSchedules.Missed = '0'
AND pSchedules.Visit_Date >= '2024-07-31'
AND pSchedules.EVV_Export = 0
AND pSchedules.Schedule_ID IN ()
GROUP BY pSchedules.Schedule_ID
ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_First ASC, pEmployee.Emp_Last ASC, pEmployee.Emp_First ASC,
pSchedules.Skill ASC, pSchedules.Visit_Date ASC
REQUEST:
RESPONSE:
REQUEST:
RESPONSE:
SELECT * FROM #Request.prefix_db_agency#.pProblem
WHERE Status =
AND Assmt_ID = "#arguments.Assmt_ID#"
AND AutoProblem_ID = '#arguments.AutoProblem_ID#'
SELECT * FROM #Request.prefix_db_agency#.pCareplan
WHERE Status =
AND Assmt_ID = "#Assmt_ID#"
AND Type = 'goal'
AND Item_ID IN (SELECT Item_ID FROm #Request.prefix_db_lookup#.pPathway
WHERE Pathway_ID =
AND type IN ('goal'))
AND Type IN ('goal','procedure')
AND Item_ID IN (SELECT Item_ID FROm #Request.prefix_db_lookup#.pPathway
WHERE Pathway_ID =
AND type IN ('goal','procedure'))
ORDER BY Careplan_ID ASC
SELECT * FROM pCareplan_list
WHERE Date_Resolve IS NOT NULL
AND Skill = '#arguments.Skill#'
arguments.Path_ID GT 0)>
SELECT * FROM #Request.prefix_db_agency#.pProblem
WHERE Path_ID = '#arguments.Path_ID#'
AND Assmt_ID = '#arguments.Assmt_ID#'
AND status = 0
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME NOT IN ('AutoProblem_ID','record_timestamp','manual')
AND TABLE_SCHEMA='#Request.prefix_db_agency#' AND TABLE_NAME = 'pProblem';
INSERT INTO #Request.prefix_db_agency#.pProblem
(#myList#)
SELECT #myList# FROM #Request.prefix_db_agency#.pProblem
WHERE AutoProblem_ID IN ()
AND Assmt_ID = '#arguments.Assmt_ID#'
AND Status = 0
GROUP BY Problem_ID
UPDATE #Request.prefix_db_agency#.pProblem
SET Skill = '#arguments.Skill#',
Date_Change = ,
Change_by =
WHERE Problem_ID IN ()
AND Assmt_ID = '#arguments.Assmt_ID#'
AND status = 0
UPDATE #Request.prefix_db_agency#.pCareplan
SET Status = 2,
Date_Change = ,
Change_by =
WHERE Careplan_ID IN ()
AND status = 0
UPDATE #Request.prefix_db_agency#.pProblem
SET Skill = '#arguments.Skill#',
Date_Change = ,
Change_by =
WHERE AutoProblem_ID IN ()
AND Assmt_ID = '#arguments.Assmt_ID#'
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Admit_ID =
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pAuths
WHERE Auth_ID =
AND status = 0
SELECT * FROM #Request.prefix_db_agency#.pCareplan
WHERE Assmt_ID IN ()
AND Skill =
AND type =
AND status = 0
AND Date_Resolve IS NULL
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Assmt_ID IN ()
AND Skill =
AND Auth_ID =
AND status = 0
ORDER BY Visit_Date ASC
SELECT * FROM #Request.prefix_db_agency#.pSched_Procedure
WHERE Assmt_ID IN ()
AND Schedule_ID =
AND status = 0