SELECT * FROM #Request.prefix_db_agency#.Communication
WHERE Comm_ID = #url.Id#
SELECT * FROM #Request.prefix_db_agency#.Comm_Progress
WHERE Comm_ID = #url.Id#
SELECT CommSub_Id, Subject
FROM #Request.prefix_db_agency#.CommunicationSubjects
WHERE Agency_Id = #session.AgencyId#
AND active = 'Y'
AND Subject like 'Missed Visit'
ORDER BY Subject
INSERT INTO #Request.prefix_db_agency#.CommunicationSubjects( Agency_ID, Subject,active,
Created_By, Created_Date, Mod_By, Mod_Date)
VALUES (#session.agencyid#,'Missed Visit','Y',#session.employeeid#,#now()#,#session.employeeid#,#now()#)
SELECT LAST_INSERT_ID() as LastInsertID
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Schedule_ID = #URL.Schedule_ID#
AND Status = '0'
Missed #GetSchedules.Skill# visit on: #DateFormat(GetSchedules.Visit_Date,"mm/dd/yyyy")#
SELECT Emp_ID, Emp_First, Emp_Last,Emp_Type
FROM #Request.prefix_db_lookup#.pEmployee
WHERE pEmployee.Loc_ID = '#session.AgencyID#'
AND Status = '0'
ORDER BY Emp_Last
SELECT pEmployee.Emp_ID, Emp_First, Emp_Last, "" AS eaType,Emp_Type, pPhysicians.Status AS phy_Status,
pPhysicians.Phys_First,pPhysicians.Phys_Last
FROM #Request.prefix_db_lookup#.pEmployee
LEFT OUTER JOIN #Request.prefix_db_lookup#.pPhysicians ON pPhysicians.Emp_ID = pEmployee.Emp_ID AND pPhysicians.Status = 0
WHERE pEmployee.Loc_ID = '#session.AgencyID#'
AND pEmployee.Status = '0'
AND Emp_Type = 'Employee'
ORDER BY pEmployee.Emp_Last
SELECT pPatients.Patient_ID, pPatients.Pt_Last, pPatients.Pt_First,pAdmit.M0104_PHYSN_RFRL_DT,
pAdmit.Admit_ID,pAdmit.Render_Phys_ID,pPhysicians.* FROM #Request.prefix_db_agency#.pPatients
JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_ID = pPatients.Patient_ID
JOIN #Request.prefix_db_lookup#.pPhysicians ON pPhysicians.Phys_ID = pAdmit.Render_Phys_ID
WHERE pPatients.Status < 2
AND pPatients.Patient_ID =
AND pAdmit.Status = 0
ORDER BY pPatients.Pt_Last, pPatients.Pt_First
SELECT pAssessments.* FROM #Request.prefix_db_agency#.pAssessments
JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID
WHERE pAssessments.Patient_ID =
AND pAssessments.Status = 0
GROUP BY pAssessments.Assmt_ID
ORDER BY pAssessments.F26
SELECT * FROM getallassessments
WHERE (F26 like '1%' or F26 like 'SN Adult%' OR F26 like '4%')
ORDER BY F26 ASC
SELECT* FROM getallassessments
WHERE F26 like 'PT Adult%'
ORDER BY F26 ASC
SELECT * FROM #Request.prefix_db_agency#.pProblem
WHERE Assmt_ID =
AND Status = 0
AND M0_No like "M102%"
ORDER BY dx_order ASC
SELECT * FROM #Request.prefix_db_agency#.pCareplan
WHERE Assmt_ID =
AND Skill = 'SN'
AND Skill = 'PT'
AND Skill = 'OT'
AND Skill = 'ST'
AND Skill = 'MSW'
AND Status = 0
ORDER BY Skill ASC
SELECT * FROM getpCareplan
WHERE Type =
SELECT * FROM getpCareplan
WHERE Type =
SELECT pPatients.Patient_ID, pPatients.Pt_Last,
pPatients.Pt_First, pPatients.Pt_Middle,pPatients.Status, pPatients.Status
FROM #Request.prefix_db_agency#.pPatients
WHERE (pPatients.Pt_Last LIKE '%%' OR pPatients.Patient_Id = '%' )
AND pPatients.Loc_ID = '#session.AgencyID#'
AND Status = 0
ORDER BY pPatients.Pt_Last, pPatients.Pt_First
SELECT CommSub_Id, Subject
FROM #Request.prefix_db_agency#.CommunicationSubjects
WHERE Agency_Id = #session.AgencyId#
AND active = 'Y'
ORDER BY Subject
>
#Description#
SELECT * FROM #Request.prefix_db_lookup#.pPathway
WHERE Pathway_ID =
AND Type =
SELECT * FROM getpCareplan
WHERE Type =
AND Item_ID IN ()
Goals: #ValueList(getgoals.Description)#
Discharge plan: #getproblem.Assign#
SELECT * FROM #Request.prefix_db_lookup#.pPathway
WHERE Pathway_ID =
AND Type =
SELECT * FROM getpCareplan
WHERE Type =
AND Item_ID IN ()
Services Provided: #url.Skill# for #ValueList(getprocedure.Description)#
Notes: #getproblem.Notes#
--->
SELECT Contact_ID, First_Name AS ContactName, Pt_Realtionship, Telephone1, Telephone2, 0 AS PrimaryContact,
Emergency, status
FROM #Request.prefix_db_agency#.pPtContacts
WHERE Patient_ID =
AND status = 0
Order by Emergency DESC, status ASC
SELECT * FROM #Request.prefix_db_agency#.pPtmeds
LEFT OUTER JOIN #Request.prefix_db_lookup#.Meds_New ON pPtmeds.Drug_ID = Meds_New.Trade_Num
WHERE pPtmeds.Patient_ID =
AND pPtmeds.status = 0
ORDER BY pPtmeds.Drug_Name ASC
Admitted on: #DateFormat(GetP.M0104_PHYSN_RFRL_DT,"mm/dd/yyyy")#
Emergency Contact: #ContactName#, #Telephone1#
Diagnoses:
#ValueList(getproblem.Description)#
Medications:
#Drug_Name# #Dose# #Dose_Units# #Route# #Freq#
Services Provided:
#Skill#,
Services Provided:
#ValueList(getpCareplanprocedure.Description)#
#ValueList(getpCareplanteach.Description)#
New Communication
#getP.Pt_Last#, #getP.Pt_First# - Update Communication