SELECT patient.Patient_ID, Assessment_New.Assessment_Reason_M0100,Assessment_New.Assessment_ID,Assessment_New.Assessment_Tracker_ID, Assessment_New.cdate_cdarte, Assessment_New.Assessment_Number,Assessment_New.Start_of_Care_M0030, Assessment_New.Transmission_Status, Assessment_New.Assessment_Completed_M0090, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Transmission_Status, patient.Last_Name_M0040 AS PatientLast, patient.First_Name_M0040 AS PatientFirst, Assessment_New.Admission_Status,Coding_Results.Casemix,Coding_Results.OASIS FROM #Request.prefix_db_agency#.patient LEFT OUTER JOIN #Request.prefix_db_agency#.Assessment_New on patient.Patient_ID = Assessment_New.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.Coding_Results on (Assessment_New.Assessment_ID = Coding_Results.Assessment_ID AND Coding_Results.Message_ID = '0' AND Coding_Results.M0_Item_Medication = 'User Coding Score') WHERE patient.Agency_ID = #session.AgencyID# AND patient.Status = 'active' AND Assessment_New.deleted <> 1 AND Assessment_New.Archive <> 1 AND (Assessment_Reason_M0100 like '%Start of Care%' OR Assessment_Reason_M0100 like '%Resumption of Care%' OR Assessment_Reason_M0100 like '%Recertification%') AND Assessment_New.Certification_Start <> '0000-00-00' AND Assessment_New.Certification_End <> '0000-00-00' AND Assessment_New.Certification_End <> '0000-00-00' AND Assessment_New.Certification_Start > '2015-09-30' GROUP BY Assessment_New.Assessment_ID Order by Assessment_New.cdate_cdarte DESC,Assessment_New.Start_of_Care_M0030 DESC , PatientLast ASC SELECT * FROM Get_patient ORDER BY PatientLast ASC,cdate_cdarte DESC SELECT * FROM Get_patient ORDER BY Assessment_Reason_M0100 ASC,cdate_cdarte DESC
CODING WIZARD REPORT

  Upload   
  Upload Med List   
   Book a 15 minute training   
  Send Message   
  View Message   
  OLD Dashboard
  View by Patient
  Go to Dashboard

Last First Oasis Uploaded Problems Score Actions
#PatientLast##PatientFirst##Assessment_Reason_M0100# - #DateFormat(Start_of_Care_M0030,"mm/dd/yyyy")# #DateFormat(cdate_cdarte,"mm/dd/yyyy")#
#Casemix#
#OASIS#%
 Coding Report
Medications >Careplan >Teachplan Print OASIS Assessment Print ROC Print Transfer Print Transfer Print Death Print Hospice Discharge Print Discharge Print Hospice Print SN Eval Print Pediatric Eval Print PT Eval Print OT Eval Print Hospice SN Print C Hospice Chaplain Eval Print PT Adult Print PT Pediatric Eval Print OT Adult Print OT Pediatric Eval Print ST Adult Eval Print ST Pediatric Eval Print MSW Adult Eval Print MSW Pediatric Eval Print SN Adult Eval Print SN Hospice Eval Print Chaplain Comprehensive Eval Print SN Pediatric Eval Print Private Duty Assessment Print Discharge Non-OASIS Print Psychiatric Eval
 Teaching Plan
 Care Plan
#PatientLast# #PatientFirst#
Oasis Uploaded Problems Score Actions
#Assessment_Reason_M0100# - #DateFormat(Start_of_Care_M0030,"mm/dd/yyyy")# #DateFormat(cdate_cdarte,"mm/dd/yyyy")#
#Casemix#
#OASIS#%
 Coding Report
Medications >Careplan >Teachplan Print OASIS Assessment Print ROC Print Transfer Print Transfer Print Death Print Hospice Discharge Print Discharge Print Hospice Print SN Eval Print Pediatric Eval Print PT Eval Print OT Eval Print Hospice SN Print C Hospice Chaplain Eval Print PT Adult Print PT Pediatric Eval Print OT Adult Print OT Pediatric Eval Print ST Adult Eval Print ST Pediatric Eval Print MSW Adult Eval Print MSW Pediatric Eval Print SN Adult Eval Print SN Hospice Eval Print Chaplain Comprehensive Eval Print SN Pediatric Eval Print Private Duty Assessment Print Discharge Non-OASIS Print Psychiatric Eval
 Teaching Plan
 Care Plan
#Assessment_Reason_M0100#
Last First Oasis Date Uploaded Problems Score Actions
#PatientLast##PatientFirst# #DateFormat(Start_of_Care_M0030,"mm/dd/yyyy")# #DateFormat(cdate_cdarte,"mm/dd/yyyy")#
#Casemix#
#OASIS#%
 Coding Report
Medications >Careplan >Teachplan Print OASIS Assessment Print ROC Print Transfer Print Transfer Print Death Print Hospice Discharge Print Discharge Print Hospice Print SN Eval Print Pediatric Eval Print PT Eval Print OT Eval Print Hospice SN Print C Hospice Chaplain Eval Print PT Adult Print PT Pediatric Eval Print OT Adult Print OT Pediatric Eval Print ST Adult Eval Print ST Pediatric Eval Print MSW Adult Eval Print MSW Pediatric Eval Print SN Adult Eval Print SN Hospice Eval Print Chaplain Comprehensive Eval Print SN Pediatric Eval Print Private Duty Assessment Print Discharge Non-OASIS Print Psychiatric Eval
 Teaching Plan
 Care Plan