Directory

UCEDD and LEND Programs by State
US Virgin Islands Puerto Rico American Samoa Hawai'i N. Mariana Islands Alaska Guam District of Columbia Maine New Hampshire Vermont Massachusettes New York Rhode Island Connecticut New Jersey Delaware Maryland Pennsylvania West Virginia Virginia Ohio Michigan Indiana Wisconsin Illinois Kentucky North Carolina South Carolina Tennessee Georgia Florida Alabama Mississippi Louisiana PIRK in Arkansas Missouri Iowa Minnesota Oklahoma Kansas Nebraska South Dakota North Dakota Montana Wyoming Nevada Texas New Mexico Arizona California Oregon Washington Idaho Utah Colorado Map of the US
Alabama
Alaska
American Samoa
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
District of Columbia
Florida
Georgia
Guam
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Northern Mariana Islands
Ohio
Oklahoma
Oregon
Pennsylvania
Puerto Rico
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virgin Islands
Virginia
Washington
West Virginia
Wisconsin
Wyoming
Browse or Search Programs
Browse:
Search:
Enter information to search by key word or select a position from the menu

Funded in part by the Administration on Intellectual and Developmental Disabilities (AIDD)
Administration on Intellectual and Developmental Disabilities


Debugging Information
ColdFusion Server Standard 9,0,0,251028
Template /directory/directory.cfm
Time Stamp 20-Jul-18 10:50 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.162.128.159
Host Name 54.162.128.159


Execution Time

Total Time Avg Time Count Template
86 ms 86 ms 1 top level E:\www\aauapweb\aucd\directory\Directory.cfm
40 ms 40 ms 1 E:/www/aauapweb/aucd/directory/qry_statelist.cfm
33 ms 33 ms 1 E:/www/aauapweb/aucd/template/header_2column.cfm
32 ms 32 ms 1 E:/www/aauapweb/aucd/directory/Application.cfm
30 ms 30 ms 1 E:/www/aauapweb/aucd/Application.cfm
24 ms 24 ms 1 E:/www/aauapweb/aucd/template/qry_menu.cfm
22 ms 22 ms 1 E:/www/aauapweb/aucd/template/inc_header.cfm
5 ms 5 ms 1 E:/www/aauapweb/aucd/directory/dir_search.cfm
5 ms 5 ms 1 E:/www/aauapweb/aucd/template/common.cfm
5 ms 5 ms 1 E:/www/aauapweb/aucd/template/inc_fourth.cfm
4 ms 4 ms 1 E:/www/aauapweb/aucd/template/footer_2column.cfm
2 ms 2 ms 1 E:/www/aauapweb/aucd/include/body.cfm
1 ms 1 ms 2 E:/www/aauapweb/aucd/template/ct_combo.cfm
1 ms 1 ms 1 E:/www/aauapweb/aucd/template/inc_footer.cfm
1 ms 1 ms 1 E:/www/aauapweb/aucd/template/inc_nav.cfm
0 ms 0 ms 1 E:/www/aauapweb/aucd/directory/Usamap.cfm
0 ms 0 ms 2 E:/www/aauapweb/aucd/directory/ct_program.cfm
0 ms 0 ms 1 E:/www/aauapweb/aucd/include/cmsview.cfm
0 ms 0 ms 1 E:/www/aauapweb/aucd/template/ct_breadcrumbs.cfm
0 ms 0 ms 1 E:/www/aauapweb/aucd/template/ct_session.cfm
0 ms 0 ms 1 E:/www/aauapweb/aucd/template/inc_leftnav.cfm
0 ms 0 ms 1 E:/www/aauapweb/aucd/template/udf.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
119 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

qry_config (Datasource=aucd, Time=1ms, Records=88) in E:\www\aauapweb\aucd\template\common.cfm @ 10:50:48.048
	SELECT name, value FROM config
	WHERE
		
		host = 'remote' OR host = '' OR host is null
		
lang (Datasource=aucd, Time=0ms, Records=0) in E:\www\aauapweb\aucd\template\common.cfm @ 10:50:48.048
SELECT id, description FROM code WHERE name = 'content_language' ORDER BY orderby
page (Datasource=aucd, Time=2ms, Records=4) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:50:48.048
SELECT page.page_id, page.page_section, page.page_title, page.hide_search, page.hide_navigation,
	page.owner, page.template, page.browser_title, page.meta_description, page.page_filename,
	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_title
		WHEN gparent.page_id IS NOT NULL THEN gparent.page_title
		WHEN parent.page_id IS NOT NULL THEN parent.page_title
		ELSE page.page_title END AS section_name,
	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_id
		WHEN gparent.page_id IS NOT NULL THEN gparent.page_id
		WHEN parent.page_id IS NOT NULL THEN parent.page_id
		ELSE page.page_id END AS section_id,
	CASE WHEN ggparent.page_id IS NOT NULL THEN URL('',ggparent.page_filename,ggparent.page_id)
		WHEN gparent.page_id IS NOT NULL THEN URL('',gparent.page_filename,gparent.page_id)
		WHEN parent.page_id IS NOT NULL THEN URL('',parent.page_filename,parent.page_id)
		ELSE URL('',page.page_filename,page.page_id) END AS section_filename,
	CASE WHEN page.header_image IS NOT NULL THEN page.header_image
		WHEN parent.header_image IS NOT NULL THEN parent.header_image
		WHEN gparent.header_image IS NOT NULL THEN gparent.header_image
		ELSE ggparent.header_image END AS header_image,
	gparent.page_title AS gparent_name, gparent.page_id AS gparent_id,
	gparent.page_filename AS gparent_filename,
	parent.page_title AS parent_name, parent.page_id AS parent_id,
	parent.page_filename AS parent_filename
FROM page LEFT JOIN page AS parent ON page.page_section = parent.page_id
	LEFT JOIN page AS gparent ON parent.page_section = gparent.page_id
	LEFT JOIN page AS ggparent ON gparent.page_section = ggparent.page_id
WHERE
	
		page.page_filename like '%directory/directory.cfm%' /* 5 */
	
	AND page.template NOT IN ('ITAC','NGSD','ECP')
	
		AND (page.IsTraineeSitePage = 0 or page.IsTraineeSitePage is null)
	
ORDER BY page_id
getrole (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:50:48.048
	SELECT code.code
	FROM link_page_role INNER JOIN code ON link_page_role.code_id = code.id
	WHERE fk_id = 5 
parentinfo (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:50:48.048
SELECT page.page_id, page.page_section, page.template, page.page_title,
	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_title
		WHEN gparent.page_id IS NOT NULL THEN gparent.page_title
		WHEN parent.page_id IS NOT NULL THEN parent.page_title
		ELSE page.page_title END AS section_name,
	CASE WHEN ggparent.page_id IS NOT NULL THEN ggparent.page_id
		WHEN gparent.page_id IS NOT NULL THEN gparent.page_id
		WHEN parent.page_id IS NOT NULL THEN parent.page_id
		ELSE page.page_id END AS section_id,
	CASE WHEN ggparent.page_id IS NOT NULL THEN URL('',ggparent.page_filename,ggparent.page_id)
		WHEN gparent.page_id IS NOT NULL THEN URL('',gparent.page_filename,gparent.page_id)
		WHEN parent.page_id IS NOT NULL THEN URL('',parent.page_filename,parent.page_id)
		ELSE URL('',page.page_filename,page.page_id) END AS section_filename,
	gparent.page_title AS gparent_name, gparent.page_id AS gparent_id,
	gparent.page_filename AS gparent_filename,
	parent.page_title AS parent_name, parent.page_id AS parent_id,
	parent.page_filename AS parent_filename
FROM page LEFT JOIN page AS parent ON page.page_section = parent.page_id
	LEFT JOIN page AS gparent ON parent.page_section = gparent.page_id
	LEFT JOIN page AS ggparent ON gparent.page_section = ggparent.page_id
WHERE
	
	1=2
	
qry_menutop (Datasource=aucd, Time=17ms, Records=90) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:50:48.048
	SELECT page.page_id, page.page_title, page.page_section, page.orderby, page.meta_description,
		ifnull(parent.page_title,page.page_title) AS section_name,
		URL('',page.page_filename,page.page_id) AS page_filename
	FROM page LEFT JOIN page AS parent ON page.page_section = parent.page_id
	WHERE ifnull(page.hide_navigation,0) = 0 AND page.live = 1 AND
		parent.page_section is null
		
		AND page.orderby <= 70000
		AND (parent.page_id in (2,3,25,26,27,28,1,507,489) or
			(parent.page_id is null and page.page_id <> 514))
		AND (SELECT COUNT(*) FROM link_page_role WHERE fk_id = page.page_id AND code_id = 113) > 0
		
			AND (page.IsTraineeSitePage = 0 or page.IsTraineeSitePage is null)
		
		 
	ORDER BY page.orderby
affiliates (Datasource=aucd, Time=31ms, Records=6) in E:\www\aauapweb\aucd\directory\qry_statelist.cfm @ 10:50:48.048
SELECT ID
FROM tbl_directory_programs
WHERE state IN ('UF','IF')
	
	AND (1=2
	
	OR program_type LIKE '%UCEDD%'
	
	OR program_type LIKE '%LEND%'
	)
statelist (Datasource=aucd, Time=6ms, Records=56) in E:\www\aauapweb\aucd\directory\qry_statelist.cfm @ 10:50:48.048
SELECT tbl_directory_address.state, MIN(tbl_directory_address.address_id) AS address_id, COUNT(*) AS Count,
	code.description 
FROM tbl_directory_address
	LEFT JOIN code ON tbl_directory_address.state = code.code AND code.name = 'state'
WHERE 
	length(tbl_directory_address.state) > 0 AND
	program_id not in (1,193,194,195,138,170,166,206,207,217,173,167,164,216,223) AND
	
	program_id NOT IN (137,146,147,174,226,227)
	
	AND (1=2
	
	OR program_type LIKE '%UCEDD%'
	
	OR program_type LIKE '%LEND%'
	)

GROUP BY code.description
ORDER BY code.description 
submenu (Datasource=aucd, Time=4ms, Records=6) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:50:48.048
SELECT page.page_id, page.page_title, page.orderby, 0 AS sub,
	URL('',page.page_filename,page.page_id) AS page_filename
FROM page
WHERE page.live = 1 AND ifnull(page.hide_navigation,0)=0 
	
		AND ifnull(page.page_section,0) = 2 
UNION
SELECT page_id, page_title, orderby, 1 AS sub,
	URL('',child.page_filename,child.page_id) AS page_filename
FROM page AS child
WHERE live = 1 AND ifnull(hide_navigation,0)=0 AND
	
	ifnull(page_section,0) = 24 
ORDER BY 3,2
menu_network (Datasource=, Time=4ms, Records=0) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:50:48.048
SELECT * FROM qry_menutop
WHERE section_name = 'Network Resources' AND page_section > 0 AND page_filename not like '%nirs%'
ORDER BY orderby
menu_home (Datasource=, Time=10ms, Records=0) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:50:48.048
SELECT * FROM qry_menutop
WHERE section_name = 'Home' AND page_section > 0
ORDER BY orderby
issub (Datasource=, Time=2ms, Records=1) in E:\www\aauapweb\aucd\template\inc_fourth.cfm @ 10:50:48.048
	SELECT sub FROM submenu
	WHERE page_id = 5 
fourth (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\inc_fourth.cfm @ 10:50:48.048
	SELECT page.page_id, page.page_title, page.orderby,
		CASE WHEN ifnull(page.page_filename,'') <> '' AND locate('?',page.page_filename) > 0
		THEN concat(page.page_filename,'&parent=',page.page_section)
		WHEN ifnull(page.page_filename,'') <> '' AND locate('?',page.page_filename) = 0
		THEN concat(page.page_filename,'?parent=',page.page_section)
		ELSE concat('template/page.cfm?id=',page.page_id,'&parent=',page.page_section) 
		END AS page_filename
	FROM page
	WHERE
		
		ifnull(page.hide_navigation,0)=0 AND
		page_section = 5 
	ORDER BY orderby
	
related (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\include\body.cfm @ 10:50:48.048
SELECT page_module.link_id, page_type, page_module.title, page_module.orderby,
	page_subtype, page_topic, page_layout, page_criteria, replace(module.type,' ','') AS type,
	module.subtype, rssaddress, topic.topic_title, replace(page_module.custom,',',' ') as custom,
	'' AS rss,
	
	concat_ws(',',page_module.detail1_id,page_module.detail2_id,page_module.detail3_id) AS detail_id
	
FROM page_module INNER JOIN module ON page_module.page_type = module.type AND (module.sidebar = 0 OR module.sidebar is null)
	LEFT JOIN topic ON page_module.page_topic = topic.topic_id
WHERE
	
		page_id = 5 
ORDER BY page_module.orderby
positions (Datasource=aucd, Time=1ms, Records=63) in E:\www\aauapweb\aucd\directory\dir_search.cfm @ 10:50:48.048
SELECT position AS id, position AS description, 1 AS which
FROM tbl_directory_positions
WHERE (ifnull(position_program_type,'') = '' OR locate(position_program_type, 'UCEDD,LEND') > 0)
	

ORDER BY 3, 2
combo (Datasource=aucd, Time=1ms, Records=46) in E:\www\aauapweb\aucd\template\ct_combo.cfm @ 10:50:48.048
	SELECT id as id,
		description as description
	FROM crm_code
	WHERE 1=1
	AND name='discipline' 
	ORDER BY orderby,description 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=COMODO CA Limited, CN=COMODO RSA Domain Validation Secure Server CA
CERT_SERVER_SUBJECT=OU=Domain Control Validated, OU=EssentialSSL, CN=www.aucd.org
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\www\aauapweb\aucd\directory\Directory.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=GB, S=Greater Manchester, L=Salford, O=COMODO CA Limited, CN=COMODO RSA Domain Validation Secure Server CA
HTTPS_SERVER_SUBJECT=OU=Domain Control Validated, OU=EssentialSSL, CN=www.aucd.org
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.aucd.org
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=/directory/directory.cfm
PATH_TRANSLATED=E:\www\aauapweb\aucd\directory\Directory.cfm
QUERY_STRING=program=UCEDD,LEND
REMOTE_ADDR=54.162.128.159
REMOTE_HOST=54.162.128.159
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/directory/directory.cfm
SERVER_NAME=www.aucd.org
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Client Variables:
cfid=22758125
cftoken=19766554
hitcount=1
lastvisit={ts '2018-07-20 10:50:48'}
timecreated={ts '2018-07-20 10:50:48'}
urltoken=CFID=22758125&CFTOKEN=19766554
Cookie Variables:
CFID=22758125
CFTOKEN=19766554
Session Variables:
cfg_admin_directory=/aucd_admin/
cfg_article_url=../resources/digest/issue.cfm?article_id=
cfg_authentication=HTML
cfg_client_full_name=AUCD
cfg_client_id=247
cfg_client_short_name=AUCD
cfg_database_type=mysql
cfg_dateformat=m/d/yyyy
cfg_doc_extension=doc,pdf,xls,txt,wpd,rtf,jpg,jpeg,gif,bmp,png,ppt,pps,mp3
cfg_doc_path=/docs/
cfg_ecp_feedback=bkaufman@AUCD.ORG
cfg_ecp_share=bkaufman@AUCD.ORG
cfg_editor_path=/tiny_mce/
cfg_email_actearlynews_submission=agriffen@AUCD.ORG, oklimova@aucd.org
cfg_email_council_cis=
cfg_email_council_coca=
cfg_email_council_core=
cfg_email_council_mcc=oklimova@aucd.org
cfg_email_council_ncedc=
cfg_email_council_ntdc=
cfg_email_developments_submission=lvaldez@aucd.org
cfg_email_digest_submission=acostalas@AUCD.ORG
cfg_email_hdd_submission=jminor@aucd.org
cfg_email_lend_application_submission=jperry@AUCD.ORG
cfg_email_pmu_submission=ynikola-lisa@aucd.org
cfg_email_spotlight_submission=cpariseau@aucd.org
cfg_email_stimulus=oklimova@aucd.org
cfg_email_website_feedback=oklimova@aucd.org
cfg_encoding=ISO-8859-1
cfg_evaluation_review=agriffen@AUCD.ORG
cfg_has_article_dept=Yes
cfg_has_article_issue=Yes
cfg_has_article_issuedept=Yes
cfg_has_article_type=0
cfg_has_crm=No
cfg_has_document=0
cfg_has_event_topic=Yes
cfg_has_feature_home_page=0
cfg_has_friendly_urls=No
cfg_has_issue_number=Yes
cfg_has_issue_summary=Yes
cfg_has_issue_volume=Yes
cfg_has_module_heading=Yes
cfg_has_new_topic=Yes
cfg_has_news_author=1
cfg_has_news_topic=Yes
cfg_has_person_address=0
cfg_has_person_board=Yes
cfg_has_person_country=0
cfg_has_person_custom=Yes
cfg_has_person_department=1
cfg_has_person_fax=Yes
cfg_has_person_photo=Yes
cfg_has_photo_expiration=0
cfg_has_sidebar=0
cfg_has_topic_parent_id=0
cfg_has_xml_import=0
cfg_live_default=No
cfg_log_number_of_months=4
cfg_mail_from=aucdinfo@aucd.org
cfg_mail_server=
cfg_module_detail_options=3
cfg_ngsd_about=681
cfg_ngsd_email_notification=oklimova@aucd.org,drudolph@aucd.org,beckmanncc@umkc.edu,spalmer@ku.edu,walkerla@umkc.edu,ericecook@sbcglobal.net,gottog@umkc.edu
cfg_ngsd_events=685
cfg_ngsd_join_listserve=687
cfg_ngsd_links=686
cfg_ngsd_news=684
cfg_ngsd_resources=683
cfg_ngsd_topics=682
cfg_ngsd_training=680
cfg_paging_count_landing=3
cfg_paging_count_list=15
cfg_path=
cfg_path_include=
cfg_paths_relative_to=root
cfg_person_notes_label=Notes
cfg_photo_album_view=JavaScript:openNewWindow('../template/slideshow.cfm?album_id={{id}}',800,750);
cfg_photo_path=/images2/
cfg_remember_login=1
cfg_rtoi_year=2012
cfg_search_resilience=per session
cfg_show_error_details=0
cfg_sidebar_positions=Left,Right
cfg_specific_items_days=730
cfg_specific_items_sort=Name
cfg_title=Content Management System
cfg_type_link_to=code
cfid=22758125
cftoken=19766554
sessionid=AUCDWEBSITE_22758125_19766554
urltoken=CFID=22758125&CFTOKEN=19766554
URL Parameters:
program=UCEDD,LEND
Debug Rendering Time: 57 ms