Rehabilitation Act Section 504

 

Section 504 of the Rehabilitation Act forbids organizations and employers from excluding or denying individuals with disabilities an equal opportunity to receive program benefits and services. It defines the rights of individuals with disabilities to participate in, and have access to, program benefits and services.

 
 

Resources

 

2/13/2017

Guidance on Section 504 and Restraint and Seclusion

The U.S. Department of Education released a set of guidance documents that provide information about the legal limitations on the use of restraint and seclusion with regard to students with disabilities. These include a new Parent and Educator Resource Guide to Section 504, a Q & A sheet, and a Dear Colleague Letter issued by the Office for Civil Rights.

 
 
 

Latest In Brief

7/16/2018

Disability Policy News In Brief

AUCD, Disability Policy News In Brief, every Mondayouse Appropriations Full Committee Markup of FY19; Trump Administration announced $25 million in cuts to the Navigator program; Medicaid LTSS Expenditures Webinar; Supreme Court Nomination; and more


More Publications >

 


Debugging Information
ColdFusion Server Standard 9,0,0,251028
Template /template/page.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
217 ms 217 ms 1 top level E:\www\aauapweb\aucd\template\page.cfm
190 ms 27 ms 7 E:/www/aauapweb/aucd/template/ct_blurb_documents.cfm
163 ms 163 ms 1 E:/www/aauapweb/aucd/template/header_public.cfm
149 ms 149 ms 1 E:/www/aauapweb/aucd/include/body.cfm
51 ms 51 ms 1 E:/www/aauapweb/aucd/template/footer_public.cfm
46 ms 46 ms 1 E:/www/aauapweb/aucd/template/ct_sidebar.cfm
27 ms 27 ms 1 E:/www/aauapweb/aucd/Application.cfm
16 ms 16 ms 1 E:/www/aauapweb/aucd/template/qry_menu.cfm
10 ms 10 ms 1 E:/www/aauapweb/aucd/template/inc_header.cfm
7 ms 7 ms 1 E:/www/aauapweb/aucd/template/common.cfm
3 ms 3 ms 1 E:/www/aauapweb/aucd/template/inc_fourth.cfm
1 ms 1 ms 1 E:/www/aauapweb/aucd/template/ct_blurb_text.cfm
1 ms 1 ms 1 E:/www/aauapweb/aucd/template/ct_breadcrumbs.cfm
1 ms 0 ms 7 E:/www/aauapweb/aucd/template/ct_get_dates.cfm
1 ms 1 ms 1 E:/www/aauapweb/aucd/template/inc_leftnav.cfm
1 ms 1 ms 1 E:/www/aauapweb/aucd/template/inc_nav.cfm
0 ms 0 ms 1 E:/www/aauapweb/aucd/include/cmsview.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_footer.cfm
0 ms 0 ms 2 E:/www/aauapweb/aucd/template/udf.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
245 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

qry_config (Datasource=aucd, Time=2ms, Records=88) in E:\www\aauapweb\aucd\template\common.cfm @ 10:50:58.058
	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:58.058
SELECT id, description FROM code WHERE name = 'content_language' ORDER BY orderby
checkTraineeSitePage (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:50:58.058
		Select IsTraineeSitePage
		From page
		Where page.page_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 604

page (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:50:58.058
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_id = 604 /* 1 */
	
	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:58.058
	SELECT code.code
	FROM link_page_role INNER JOIN code ON link_page_role.code_id = code.id
	WHERE fk_id = 604 
parentinfo (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:50:58.058
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=8ms, Records=90) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:50:58.058
	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
submenu (Datasource=aucd, Time=4ms, Records=21) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:50:58.058
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) = 27 
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) = 309 
ORDER BY 3,2
menu_network (Datasource=, Time=3ms, Records=0) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:50:58.058
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=2ms, Records=0) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:50:58.058
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:58.058
	SELECT sub FROM submenu
	WHERE page_id = 604 
fourth (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\inc_fourth.cfm @ 10:50:58.058
	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 = 604 
	ORDER BY orderby
	
related (Datasource=aucd, Time=0ms, Records=7) in E:\www\aauapweb\aucd\include\body.cfm @ 10:50:58.058
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 = 604 
ORDER BY page_module.orderby
qry_content (Datasource=aucd, Time=0ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_text.cfm @ 10:50:58.058
	SELECT title, content
	FROM page_module
	WHERE link_id = 1017 
codename (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
SELECT code.name, code.other, 
	CASE WHEN parent.description IS NULL OR code.other like '%show%' THEN code.description
		ELSE parent.description END AS description,
	ifnull(code.id,parent.id) AS parentid 
FROM code LEFT JOIN code AS parent ON code.name = parent.other AND parent.name = 'document_type' 
WHERE code.id = 406 
gettopic (Datasource=aucd, Time=0ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
	SELECT topic_title FROM topic WHERE topic_id = 112 
subcodes (Datasource=aucd, Time=0ms, Records=11) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
	SELECT id FROM code WHERE name = 'news_type'
 	
news (Datasource=aucd, Time=56ms, Records=0) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
/* Article Title & Summary */
SELECT news.news_id, news.url,
	CASE WHEN length(url) > 0 THEN url
		WHEN ifnull(body,'') = '' AND length(document_file) > 0 THEN concat('/docs/',document_file)
		 
		ELSE concat('../template/news.cfm?news_id=',news_id,'&id=604&parent=604') END AS link,
		
	if(ifnull(body,'') <> '' AND length(document_file) > 0,1,0) AS multiple,
	if(ifnull(body,'') = '' AND (length(document_file) > 0 OR length(url) > 0),'target="_blank"','') AS target,
	document_file, news.title, news.subtitle, news.date, news.summary, news.body,
	code.description AS news_type, thumbnail_file AS photo, caption
FROM news INNER JOIN code ON news.type = code.id
WHERE live = 1
	
		AND type IN (406,85,463,465,468,475,540,555,556,557,568,587)
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 112)
	
		AND CASE WHEN alwaysShoworder IS NULL THEN (date BETWEEN {d '2018-04-11'} AND {d '2018-07-20'})
		ELSE 1=1 END
	
ORDER BY 
	CASE WHEN alwaysShowOrder IS NULL THEN 1 ELSE 0 END, alwaysShowOrder,
	date
	
	DESC
	
	, news.title
	
codename (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
SELECT code.name, code.other, 
	CASE WHEN parent.description IS NULL OR code.other like '%show%' THEN code.description
		ELSE parent.description END AS description,
	ifnull(code.id,parent.id) AS parentid 
FROM code LEFT JOIN code AS parent ON code.name = parent.other AND parent.name = 'document_type' 
WHERE code.id = 401 
gettopic (Datasource=aucd, Time=0ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
	SELECT topic_title FROM topic WHERE topic_id = 112 
news (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
/* Article Title & Summary */
SELECT news.news_id, news.url,
	CASE WHEN length(url) > 0 THEN url
		WHEN ifnull(body,'') = '' AND length(document_file) > 0 THEN concat('/docs/',document_file)
		 
		ELSE concat('../template/news.cfm?news_id=',news_id,'&id=604&parent=604') END AS link,
		
	if(ifnull(body,'') <> '' AND length(document_file) > 0,1,0) AS multiple,
	if(ifnull(body,'') = '' AND (length(document_file) > 0 OR length(url) > 0),'target="_blank"','') AS target,
	document_file, news.title, news.subtitle, news.date, news.summary, news.body,
	code.description AS news_type, thumbnail_file AS photo, caption
FROM news INNER JOIN code ON news.type = code.id
WHERE live = 1
	
		AND type IN (401)
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 112)
	
		AND CASE WHEN alwaysShoworder IS NULL THEN (date BETWEEN {d '2018-04-11'} AND {d '2018-07-20'})
		ELSE 1=1 END
	
ORDER BY 
	CASE WHEN alwaysShowOrder IS NULL THEN 1 ELSE 0 END, alwaysShowOrder,
	date
	
	DESC
	
	, news.title
	
codename (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
SELECT code.name, code.other, 
	CASE WHEN parent.description IS NULL OR code.other like '%show%' THEN code.description
		ELSE parent.description END AS description,
	ifnull(code.id,parent.id) AS parentid 
FROM code LEFT JOIN code AS parent ON code.name = parent.other AND parent.name = 'document_type' 
WHERE code.id = 118 
gettopic (Datasource=aucd, Time=0ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
	SELECT topic_title FROM topic WHERE topic_id = 112 
subcodes (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
	SELECT id FROM code WHERE name = 'legislation_type'
 	
news (Datasource=aucd, Time=2ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
/* Article Title & Summary */
SELECT news.news_id, news.url,
	CASE WHEN length(url) > 0 THEN url
		WHEN ifnull(body,'') = '' AND length(document_file) > 0 THEN concat('/docs/',document_file)
		 
		ELSE concat('../template/news.cfm?news_id=',news_id,'&id=604&parent=604') END AS link,
		
	if(ifnull(body,'') <> '' AND length(document_file) > 0,1,0) AS multiple,
	if(ifnull(body,'') = '' AND (length(document_file) > 0 OR length(url) > 0),'target="_blank"','') AS target,
	document_file, news.title, news.subtitle, news.date, news.summary, news.body,
	code.description AS news_type, thumbnail_file AS photo, caption
FROM news INNER JOIN code ON news.type = code.id
WHERE live = 1
	
		AND type IN (118)
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 112)
	
ORDER BY 
	CASE WHEN alwaysShowOrder IS NULL THEN 1 ELSE 0 END, alwaysShowOrder,
	date
	
	DESC
	
	, news.title
	
codename (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
SELECT code.name, code.other, 
	CASE WHEN parent.description IS NULL OR code.other like '%show%' THEN code.description
		ELSE parent.description END AS description,
	ifnull(code.id,parent.id) AS parentid 
FROM code LEFT JOIN code AS parent ON code.name = parent.other AND parent.name = 'document_type' 
WHERE code.id = 117 
gettopic (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
	SELECT topic_title FROM topic WHERE topic_id = 112 
subcodes (Datasource=aucd, Time=1ms, Records=9) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
	SELECT id FROM code WHERE name = 'resource_type'
 	
news (Datasource=aucd, Time=40ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
/* Article Title & Summary */
SELECT news.news_id, news.url,
	CASE WHEN length(url) > 0 THEN url
		WHEN ifnull(body,'') = '' AND length(document_file) > 0 THEN concat('/docs/',document_file)
		 
		ELSE concat('../template/news.cfm?news_id=',news_id,'&id=604&parent=604') END AS link,
		
	if(ifnull(body,'') <> '' AND length(document_file) > 0,1,0) AS multiple,
	if(ifnull(body,'') = '' AND (length(document_file) > 0 OR length(url) > 0),'target="_blank"','') AS target,
	document_file, news.title, news.subtitle, news.date, news.summary, news.body,
	code.description AS news_type, thumbnail_file AS photo, caption
FROM news INNER JOIN code ON news.type = code.id
WHERE live = 1
	
		AND type IN (117,435,436,477,537,550,552,554,561,563)
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 112)
	
ORDER BY 
	CASE WHEN alwaysShowOrder IS NULL THEN 1 ELSE 0 END, alwaysShowOrder,
	date
	
	DESC
	
	, news.title
	
codename (Datasource=aucd, Time=3ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
SELECT code.name, code.other, 
	CASE WHEN parent.description IS NULL OR code.other like '%show%' THEN code.description
		ELSE parent.description END AS description,
	ifnull(code.id,parent.id) AS parentid 
FROM code LEFT JOIN code AS parent ON code.name = parent.other AND parent.name = 'document_type' 
WHERE code.id = 391 
gettopic (Datasource=aucd, Time=0ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
	SELECT topic_title FROM topic WHERE topic_id = 112 
subcodes (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
	SELECT id FROM code WHERE name = 'letter_type'
 	
news (Datasource=aucd, Time=8ms, Records=0) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
/* Article Title & Summary */
SELECT news.news_id, news.url,
	CASE WHEN length(url) > 0 THEN url
		WHEN ifnull(body,'') = '' AND length(document_file) > 0 THEN concat('/docs/',document_file)
		 
		ELSE concat('../template/news.cfm?news_id=',news_id,'&id=604&parent=604') END AS link,
		
	if(ifnull(body,'') <> '' AND length(document_file) > 0,1,0) AS multiple,
	if(ifnull(body,'') = '' AND (length(document_file) > 0 OR length(url) > 0),'target="_blank"','') AS target,
	document_file, news.title, news.subtitle, news.date, news.summary, news.body,
	code.description AS news_type, thumbnail_file AS photo, caption
FROM news INNER JOIN code ON news.type = code.id
WHERE live = 1
	
		AND type IN (391,460)
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 112)
	
		AND CASE WHEN alwaysShoworder IS NULL THEN (date BETWEEN {d '2018-04-11'} AND {d '2018-07-20'})
		ELSE 1=1 END
	
ORDER BY 
	CASE WHEN alwaysShowOrder IS NULL THEN 1 ELSE 0 END, alwaysShowOrder,
	date
	
	DESC
	
	, news.title
	
codename (Datasource=aucd, Time=2ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
SELECT code.name, code.other, 
	CASE WHEN parent.description IS NULL OR code.other like '%show%' THEN code.description
		ELSE parent.description END AS description,
	ifnull(code.id,parent.id) AS parentid 
FROM code LEFT JOIN code AS parent ON code.name = parent.other AND parent.name = 'document_type' 
WHERE code.id = 390 
gettopic (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
	SELECT topic_title FROM topic WHERE topic_id = 112 
subcodes (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
	SELECT id FROM code WHERE name = 'testimony_type'
 	
news (Datasource=aucd, Time=2ms, Records=0) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
/* Article Title & Summary */
SELECT news.news_id, news.url,
	CASE WHEN length(url) > 0 THEN url
		WHEN ifnull(body,'') = '' AND length(document_file) > 0 THEN concat('/docs/',document_file)
		 
		ELSE concat('../template/news.cfm?news_id=',news_id,'&id=604&parent=604') END AS link,
		
	if(ifnull(body,'') <> '' AND length(document_file) > 0,1,0) AS multiple,
	if(ifnull(body,'') = '' AND (length(document_file) > 0 OR length(url) > 0),'target="_blank"','') AS target,
	document_file, news.title, news.subtitle, news.date, news.summary, news.body,
	code.description AS news_type, thumbnail_file AS photo, caption
FROM news INNER JOIN code ON news.type = code.id
WHERE live = 1
	
		AND type IN (390,461)
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 112)
	
		AND CASE WHEN alwaysShoworder IS NULL THEN (date BETWEEN {d '2017-07-20'} AND {d '2018-07-20'})
		ELSE 1=1 END
	
ORDER BY 
	CASE WHEN alwaysShowOrder IS NULL THEN 1 ELSE 0 END, alwaysShowOrder,
	date
	
	DESC
	
	, news.title
	
related_sidebar (Datasource=aucd, Time=2ms, Records=1) in E:\www\aauapweb\aucd\template\ct_sidebar.cfm @ 10:50:58.058
SELECT sidebar_module.link_id, page_type, sidebar_module.title, sidebar_module.orderby,
	page_topic, page_subtype, page_layout, page_criteria, replace(module.type,' ','') AS type,
	module.subtype, rssaddress, topic.topic_title, sidebar_module.custom, sidebar_module.content,
	'' AS rss,
	
	concat_ws(',',sidebar_module.detail1_id,sidebar_module.detail2_id,sidebar_module.detail3_id) AS detail_id
	
FROM sidebar_module INNER JOIN module ON sidebar_module.page_type = module.type AND module.sidebar = 1
	LEFT JOIN topic ON sidebar_module.page_topic = topic.topic_id
WHERE page_id = 604 
	AND position = 'R'
	
ORDER BY sidebar_module.orderby
codename (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
SELECT code.name, code.other, 
	CASE WHEN parent.description IS NULL OR code.other like '%show%' THEN code.description
		ELSE parent.description END AS description,
	ifnull(code.id,parent.id) AS parentid 
FROM code LEFT JOIN code AS parent ON code.name = parent.other AND parent.name = 'document_type' 
WHERE code.id = 474 
gettopic (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
	SELECT topic_title FROM topic WHERE topic_id = 80 
news (Datasource=aucd, Time=39ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:58.058
/* Small Title with date */
SELECT news.news_id, news.url,
	CASE WHEN length(url) > 0 THEN url
		WHEN ifnull(body,'') = '' AND length(document_file) > 0 THEN concat('/docs/',document_file)
		 
		ELSE concat('../template/news.cfm?news_id=',news_id,'&id=604&parent=604') END AS link,
		
	if(ifnull(body,'') <> '' AND length(document_file) > 0,1,0) AS multiple,
	if(ifnull(body,'') = '' AND (length(document_file) > 0 OR length(url) > 0),'target="_blank"','') AS target,
	document_file, news.title, news.subtitle, news.date, news.summary, news.body,
	code.description AS news_type, thumbnail_file AS photo, caption
FROM news INNER JOIN code ON news.type = code.id
WHERE live = 1
	
		AND type IN (474)
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 80)
	
		AND CASE WHEN alwaysShoworder IS NULL THEN (date BETWEEN {d '2018-07-15'} AND {d '2018-07-21'})
		ELSE 1=1 END
	
ORDER BY 
	CASE WHEN alwaysShowOrder IS NULL THEN 1 ELSE 0 END, alwaysShowOrder,
	date
	
	DESC
	
	, news.title
	


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\template\page.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=/template/page.cfm
PATH_TRANSLATED=E:\www\aauapweb\aucd\template\page.cfm
QUERY_STRING=id=604
REMOTE_ADDR=54.162.128.159
REMOTE_HOST=54.162.128.159
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/template/page.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=22758136
cftoken=64704708
hitcount=1
lastvisit={ts '2018-07-20 10:50:58'}
timecreated={ts '2018-07-20 10:50:58'}
urltoken=CFID=22758136&CFTOKEN=64704708
Cookie Variables:
CFID=22758136
CFTOKEN=64704708
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=22758136
cftoken=64704708
sessionid=AUCDWEBSITE_22758136_64704708
urltoken=CFID=22758136&CFTOKEN=64704708
URL Parameters:
id=604
Debug Rendering Time: 49 ms