Medicaid

 

Medicaid is the nation's primary way of financing and delivering community-based health and long-term services to children and adults with disabilities.  It is the nation's largest health care program, and serves nearly 60 million low-income Americans, including an estimated 9.9 million people with disabilities.  AUCD advocates for the maintenance of the individual entitlement to a full range of Medicaid health and long-term supports and services for all eligible children and adults with disabilities.

 
 

Legislation

  • Community Integration Act

    A bill to reverse the institutional bias in Medicaid and ensure that Medicaid beneficiaries have an opportunity to receive care in a home and community-based setting.

 
 

Resources

 

6/12/2018

CMS Guidance: Addressing Neonatal Abstinence Syndrome

Medicaid services can play a critical role in helping ensure access to treatment for these vulnerable infants who have Neonatal Abstinence Syndrome (NAS). Neonatal Abstinence Syndrome (NAS) is a postnatal drug withdrawal syndrome that occurs primarily among opioid-exposed infants shortly after birth. The Centers for Medicare & Medicaid Services CMS released guidance aimed at building on our commitment to partner with states to ensure that they have flexibilities and the tools necessary to combat the opioid crisis.

 
 
 

Letters

 

9/5/2017

Extension of Childrens Health Insurance Program

(CHIP)

The undersigned member organizations of the Save Medicaid in the Schools Coalition urge you to support a full, clean extension of funding for the Childrens Health Insurance Program (CHIP) for five years at current funding levels. CHIP has benefitted from strong bipartisan support since its creation in 1997. By providing medical assistance to children who are not eligible for Medicaid, CHIP provides essential funding to support states to cover uninsured children. Any delay or a failure to immediately extend funding for CHIP will jeopardize coverage for children who are eligible for school-based health-related services leading to immediate and lasting harmful effects for America�s most vulnerable citizens. A lapse in coverage for children places more barriers on their ability to come to school ready to learn. During a time of great uncertainty in the healthcare system, children need the consistent, reliable health coverage CHIP provides today.

 
 
 

Related Links

 

6/1/2011

Kaiser Commission on Medicaid and the Uninsured

The Kaiser Commission on Medicaid and the Uninsured provides information and analysis on health care coverage and access for the low-income population, with a special focus on Medicaid's role and coverage of the uninsured.

 
 

9/10/2010

Centers for Medicare and Medicaid Services

Information on CMS programs
 
 
 

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 12:28 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.161.40.41
Host Name 54.161.40.41


Execution Time

Total Time Avg Time Count Template
295 ms 295 ms 1 E:/www/aauapweb/aucd/template/page.cfm
254 ms 28 ms 9 E:/www/aauapweb/aucd/template/ct_blurb_documents.cfm
250 ms 250 ms 1 E:/www/aauapweb/aucd/template/header_public.cfm
230 ms 230 ms 1 E:/www/aauapweb/aucd/include/body.cfm
44 ms 44 ms 1 E:/www/aauapweb/aucd/template/footer_public.cfm
40 ms 40 ms 1 E:/www/aauapweb/aucd/template/ct_sidebar.cfm
24 ms 24 ms 1 E:/www/aauapweb/aucd/Application.cfm
15 ms 15 ms 1 E:/www/aauapweb/aucd/template/qry_menu.cfm
11 ms 11 ms 1 E:/www/aauapweb/aucd/template/inc_header.cfm
6 ms 6 ms 1 E:/www/aauapweb/aucd/template/common.cfm
4 ms 4 ms 1 E:/www/aauapweb/aucd/template/inc_fourth.cfm
2 ms 2 ms 1 E:/www/aauapweb/aucd/template/ct_blurb_text.cfm
1 ms 0 ms 9 E:/www/aauapweb/aucd/template/ct_get_dates.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_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_footer.cfm
0 ms 0 ms 1 E:/www/aauapweb/aucd/template/inc_leftnav.cfm
0 ms 0 ms 2 E:/www/aauapweb/aucd/template/udf.cfm
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
322 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

12:28:37.037 - Expression Exception - in E:/www/aauapweb/aucd/Application.cfm : line 873
	    Error processing CFX custom tag CFX_GIFGD.
	    


SQL Queries

qry_config (Datasource=aucd, Time=2ms, Records=88) in E:\www\aauapweb\aucd\template\common.cfm @ 12:28:37.037
	SELECT name, value FROM config
	WHERE
		
		host = 'remote' OR host = '' OR host is null
		
lang (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\common.cfm @ 12:28:37.037
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 @ 12:28:37.037
		Select IsTraineeSitePage
		From page
		Where page.page_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 277

page (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 12:28:37.037
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 = 277 /* 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=0ms, Records=1) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 12:28:37.037
	SELECT code.code
	FROM link_page_role INNER JOIN code ON link_page_role.code_id = code.id
	WHERE fk_id = 277 
parentinfo (Datasource=aucd, Time=0ms, Records=0) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 12:28:37.037
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 @ 12:28:37.037
	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=3ms, Records=16) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 12:28:37.037
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) = 277 
ORDER BY 3,2
menu_network (Datasource=, Time=3ms, Records=0) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 12:28:37.037
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=3ms, Records=0) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 12:28:37.037
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 @ 12:28:37.037
	SELECT sub FROM submenu
	WHERE page_id = 277 
fourth (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\inc_fourth.cfm @ 12:28:37.037
	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
		
		1=2
		
	ORDER BY orderby
	
related (Datasource=aucd, Time=1ms, Records=9) in E:\www\aauapweb\aucd\include\body.cfm @ 12:28:37.037
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 = 277 
ORDER BY page_module.orderby
qry_content (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_text.cfm @ 12:28:37.037
	SELECT title, content
	FROM page_module
	WHERE link_id = 714 
codename (Datasource=aucd, Time=0ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
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=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
	SELECT topic_title FROM topic WHERE topic_id = 25 
subcodes (Datasource=aucd, Time=1ms, Records=11) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
	SELECT id FROM code WHERE name = 'news_type'
 	
news (Datasource=aucd, Time=103ms, Records=0) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
/* 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=277&parent=277') 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 = 25)
	
		AND CASE WHEN alwaysShoworder IS NULL THEN (date BETWEEN {d '2018-05-21'} 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 @ 12:28:37.037
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=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
	SELECT topic_title FROM topic WHERE topic_id = 25 
news (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
/* 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=277&parent=277') 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 = 25)
	
		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
	
codename (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
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 @ 12:28:37.037
	SELECT topic_title FROM topic WHERE topic_id = 25 
subcodes (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
	SELECT id FROM code WHERE name = 'legislation_type'
 	
news (Datasource=aucd, Time=3ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
/* Bulleted List & Heading */
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=277&parent=277') 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 = 25)
	
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 @ 12:28:37.037
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 = 435 
gettopic (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
	SELECT topic_title FROM topic WHERE topic_id = 53 
news (Datasource=aucd, Time=4ms, Records=0) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
/* 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=277&parent=277') 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 (435)
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 53)
	
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 @ 12:28:37.037
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=0ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
	SELECT topic_title FROM topic WHERE topic_id = 25 
subcodes (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
	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 @ 12:28:37.037
/* Bulleted List & Heading */
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=277&parent=277') 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 = 25)
	
		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
	
codename (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
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=0ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
	SELECT topic_title FROM topic WHERE topic_id = 25 
subcodes (Datasource=aucd, Time=0ms, Records=9) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
	SELECT id FROM code WHERE name = 'resource_type'
 	
news (Datasource=aucd, Time=43ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
/* 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=277&parent=277') 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 = 25)
	
		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
	
codename (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
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 @ 12:28:37.037
	SELECT topic_title FROM topic WHERE topic_id = 25 
subcodes (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
	SELECT id FROM code WHERE name = 'letter_type'
 	
news (Datasource=aucd, Time=7ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
/* 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=277&parent=277') 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 = 25)
	
		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
	
codename (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
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 = 569 
gettopic (Datasource=aucd, Time=0ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
	SELECT topic_title FROM topic WHERE topic_id = 25 
news (Datasource=aucd, Time=2ms, Records=2) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
/* 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=277&parent=277') 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 (569)
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 25)
	
ORDER BY 
	CASE WHEN alwaysShowOrder IS NULL THEN 1 ELSE 0 END, alwaysShowOrder,
	date
	
	DESC
	
	, news.title
	
related_sidebar (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_sidebar.cfm @ 12:28:37.037
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 = 277 
	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 @ 12:28:37.037
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 @ 12:28:37.037
	SELECT topic_title FROM topic WHERE topic_id = 80 
news (Datasource=aucd, Time=30ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 12:28:37.037
/* 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=277&parent=277') 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=277
REMOTE_ADDR=54.161.40.41
REMOTE_HOST=54.161.40.41
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=22762764
cftoken=28720772
hitcount=1
lastvisit={ts '2018-07-20 12:28:37'}
timecreated={ts '2018-07-20 12:28:37'}
urltoken=CFID=22762764&CFTOKEN=28720772
Cookie Variables:
CFID=22762764
CFTOKEN=28720772
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=22762764
cftoken=28720772
sessionid=AUCDWEBSITE_22762764_28720772
urltoken=CFID=22762764&CFTOKEN=28720772
URL Parameters:
id=277
Debug Rendering Time: 59 ms