index.cfm?page=dashboard&cat=chartcompliance&rpt=
SELECT patient.patient_ID, patient.Status, patient.Last_Name_M0040 AS patientLast, patient.First_Name_M0040 AS patientFirst,
Assessment_Forms.Assessment_Forms_ID, Assessment_Forms.Form_Type, Assessment_Forms.Date_Sent,
Assessment_Forms.Cert_Start_Item_3a, Assessment_Forms.Cert_End_Item_3b, Assessment_Forms.Record_Mod_Date
FROM #Request.prefix_db_agency#.patient, #Request.prefix_db_agency#.Assessment_Forms
WHERE patient.patient_ID = Assessment_Forms.patient_ID
AND patient.Agency_ID = #session.AgencyID#
AND Assessment_Forms.Form_Status NOT IN ('Signed','Delete')
ORDER BY Assessment_Forms.Date_Sent, patient.Last_Name_M0040 ASC, Assessment_Forms.Cert_End_Item_3b
Un-Signed Orders by Date Mailed to Physician
New Order
by patient
by Physician
|
___________________________________________
no date sent#DateFormat(Date_Sent,"mm/dd/yyyy")#
#patientLast#, #patientFirst# (#status#) #Form_Type##Form_Type# #DateFormat(Cert_Start_Item_3a,"mm/dd/yy")#
- #DateFormat(Cert_End_Item_3b,"mm/dd/yy")# PrintPrint Edit
new #DateFormat(Record_Mod_Date,"mm/dd/yy")#