SELECT * FROM #Request.prefix_db_lookup#.X_OASIS_C where Email is null and Agency_ID = 1 SELECT * FROM #Request.prefix_db_lookup#.Readiness SELECT Captivate.Accuracy, Captivate.Test, Captivate.Date, OASIS_C.FirstName, OASIS_C.LastName FROM #Request.prefix_db_lookup#.Captivate, #Request.prefix_db_lookup#.X_OASIS_C WHERE Captivate.User_ID = OASIS_C.OASISC_ID And (Captivate.Test = 20 or Captivate.Test = 21) User Information

User Information

Bolded fields are required.

Screen Information

First Name
Last Name
Username

#LastName#, #FirstName# | #UserName#

First	Last	Project Manager time/day	Staff time/day	Project Mgr avail/day	How long to implement	How not to fall behind	Electronic Billing	AR, Payroll etc
#FirstName#	#LastName#	#QU1#	#QU2#	#QU3#	#QU4#	#QU5#	#QU6#	#QU7#

First	Last	Test	Accuracy	Date
#FirstName#	#LastName#	BillingCompliance	#Accuracy#	#DateFormat(Date,'mm-dd-yyyy')#