HHA System Administration

SELECT * FROM #Request.prefix_db_lookup#.Coding_Request Where Agency_ID = #url.AID# AND Deleted <> 1 AND (Coding_status like 'eligibility' OR Coding_status like 'completed_eligibility' OR Coding_status like 'unable_to_complete_eligibility' OR Coding_status like 'authorization' OR Coding_status like 'completed_authorization' OR Coding_status like 'unable_to_complete_authorization') AND (Coding_status like 'intake_dataentry' OR Coding_status like 'intake_dataentry_transition' OR Coding_status like 'completed_intake_dataentry' OR Coding_status like 'completed_intake_dataentry_transition' OR Coding_status like 'unable_to_complete_intake_dataentry' OR Coding_status like 'unable_to_complete_intake_dataentry_transition' ) AND (Coding_status like 'H_P_Review' OR Coding_status like 'completed_H_P_Review' OR Coding_status like 'unable_to_complete_H_P_Review' OR Coding_status like 'coding' OR Coding_status like 'completed_coding' OR Coding_status like 'unable_to_complete_coding' ) AND (Assessment_Type like '1%' OR Assessment_Type like '3%' OR Assessment_Type like '4%') ORDER BY Created_Date DESC HHA System Administration Superadmin Home

Billing Request ListData Entry Request ListCoding Request List

Request Date	Last Name	First Name	Assessment Type	Completed Date	MHCB Entered	Billing StatusData Entry Status Coding status	Uploaded_EMR
#DATEFORMAT(Request_Date,"mm/dd/yyyy")#	#Last_Name#	#First_Name#	#Assessment_Type#	#DATEFORMAT(completeddate,"mm/dd/yyyy")#	#DATEFORMAT(MHCB_Entered,"mm/dd/yyyy")#	#Coding_status#	#DATEFORMAT(Uploaded_EMR,"mm/dd/yyyy")#
There is no records