CODING WIZARD REPORT

--->

---> SELECT 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.Agency_ID,Assessment_New.billed_date,Assessment_New.billed_end_date,Assessment_New.Invoice_number, Assessment_New.Assessment_Completed_M0090, Assessment_New.Certification_Start, Assessment_New.Certification_End, Assessment_New.Transmission_Status FROM #Request.prefix_db_agency#.Assessment_New WHERE Patient_ID =#Patient_ID# 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.Record_Creation_Date > '2017-10-01' Group by Assessment_New.Assessment_Reason_M0100,Assessment_New.Assessment_Completed_M0090, Assessment_New.Certification_Start, Assessment_New.Certification_End

	Date Uploaded	Last Name	First Name	Assessment Reason	Date Completed	Bill Date	Invoice Number
	#DateFormat(cdate_cdarte,"mm/dd/yyyy")#	#PatientLast#	#PatientFirst#	#Assessment_Reason_M0100#	#DateFormat(Assessment_Completed_M0090,"mm/dd/yyyy")#	#Casemix#	#OASIS#%
	#DateFormat(cdate_cdarte,"mm/dd/yyyy")#	#Get_patient.PatientLast#	#Get_patient.PatientFirst#	#Assessment_Reason_M0100#	#DateFormat(Assessment_Completed_M0090,"mm/dd/yyyy")#	#DateFormat(billed_date,"mm/dd/yyyy")# - #DateFormat(billed_end_date,"mm/dd/yyyy")#	#Invoice_number#