Other Helpful Websites

 
 

Insure Kids Now

Connecting Kids to Coverage
 
 

Putting Patients First

A resource for estimating costs and understanding options
 
 

Healthcare.gov

The primary source of health insurance coverage information for consumers

Sign up for email updates, find FAQs, get linked to your state's Marketplace, and sign up for coverage starting October 1, 2013.

 
 

CuidadoDeSalud.gov

The primary source of health insurance coverage information in Spanish

Sign up for email updates, find FAQs, get linked to your state's Marketplace, and sign up for coverage starting October 1, 2013.

 
 

CMS Health Reform Center

Health reform implementation resources for partners and organizations

Find navigator and other consumer assistance training, official resources, and ways to partner with CMS.

 
 

Enroll America

The leading nonprofit focused on enrollment, Enroll America provides tools and resources for state-based organizations to help people enroll in health coverage.

 
 

Get Covered America

Key information for those seeking coverage or individuals interested in helping to spread the word about affordable health coverage.

 
 

Kaiser Family Foundation's Health Reform Source

KFF's online gateway providing easy access to new and comprehensive resources on the health reform law.
 
 

State Refor(u)m

A project of the Robert Wood Johnson Foundation and National Academy for State Health Policy

This forum provides detailed state-based information on health reform implementation in each state, as well as national trends.

 
 

Health Reform GPS

A project of the George Washington University Hirsch Health Law and Policy Program and the Robert Wood Johnson Foundation

This website provides detailed analysis and commentary on health reform implementation updates including regulatory decisions.

 
 

Families USA: Health Reform Central

Families USA explains key implementation developments

 
 

The Catalyst Center: A Catalyst for Change

The Catalyst Center is a national center dedicated to improving health care insurance and financing for Children and Youth with Special Health Care Needs (CYSHCN)

Health reform information focused on children and youth with special health care needs.

 
 

Pre-Existing Condition Insurance Plan

Learn how to transition from the PCIP to the Health Insurance Marketplaces

This website offers information about the Pre-Existing Condition Insurance Plan created by the Affordable Care Act to insure individuals with pre-existing conditions until the law takes full effect in 2014.

 
 

Advance Class Website

A national advocacy organization dedicated the implementation of a strong and vital long-term services and supports program.
 
 

The Alliance for Health Reform

Find resources and view archived briefings on health care reform and related topics.

 
 

Coalition for Health Funding

AUCD is a member of the CHF, the oldest and largest nonprofit alliance working to preserve and strengthen public health investments.

 
 


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
45 ms 45 ms 1 top level E:\www\aauapweb\aucd\template\page.cfm
36 ms 36 ms 1 E:/www/aauapweb/aucd/template/header_public.cfm
23 ms 23 ms 1 E:/www/aauapweb/aucd/Application.cfm
19 ms 19 ms 1 E:/www/aauapweb/aucd/include/body.cfm
16 ms 16 ms 1 E:/www/aauapweb/aucd/template/ct_blurb_documents.cfm
14 ms 14 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/footer_public.cfm
5 ms 5 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_sidebar.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_breadcrumbs.cfm
0 ms 0 ms 1 E:/www/aauapweb/aucd/template/ct_get_dates.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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
70 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:40.040
	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 @ 10:50:40.040
SELECT id, description FROM code WHERE name = 'content_language' ORDER BY orderby
checkTraineeSitePage (Datasource=aucd, Time=0ms, Records=1) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:50:40.040
		Select IsTraineeSitePage
		From page
		Where page.page_id = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 988

page (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:50:40.040
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 = 988 /* 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:40.040
	SELECT code.code
	FROM link_page_role INNER JOIN code ON link_page_role.code_id = code.id
	WHERE fk_id = 988 
parentinfo (Datasource=aucd, Time=0ms, Records=0) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 10:50:40.040
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:40.040
	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=18) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:50:40.040
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) = 25 
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) = 987 
ORDER BY 3,2
menu_network (Datasource=, Time=2ms, Records=0) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 10:50:40.040
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:40.040
SELECT * FROM qry_menutop
WHERE section_name = 'Home' AND page_section > 0
ORDER BY orderby
issub (Datasource=, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\inc_fourth.cfm @ 10:50:40.040
	SELECT sub FROM submenu
	WHERE page_id = 988 
fourth (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\inc_fourth.cfm @ 10:50:40.040
	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 = 988 
	ORDER BY orderby
	
related (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\include\body.cfm @ 10:50:40.040
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 = 988 
ORDER BY page_module.orderby
codename (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:40.040
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 = 402 
gettopic (Datasource=aucd, Time=0ms, Records=1) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:40.040
	SELECT topic_title FROM topic WHERE topic_id = 186 
subcodes (Datasource=aucd, Time=1ms, Records=2) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:40.040
	SELECT id FROM code WHERE name = 'relatedlinks_type'
 	
news (Datasource=aucd, Time=7ms, Records=16) in E:\www\aauapweb\aucd\template\ct_blurb_documents.cfm @ 10:50:40.040
/* Small Title no 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=988&parent=988') 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 (402,538,569)
	
		AND news_id IN (SELECT news_id FROM link_news_topic WHERE topic_id = 186)
	
ORDER BY 
	CASE WHEN alwaysShowOrder IS NULL THEN 1 ELSE 0 END, alwaysShowOrder,
	date
	
	DESC
	
	, news.title
	
related_sidebar (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\ct_sidebar.cfm @ 10:50:40.040
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 = 988 
	AND position = 'R'
	
ORDER BY sidebar_module.orderby


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=988
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=22758116
cftoken=18022340
hitcount=1
lastvisit={ts '2018-07-20 10:50:40'}
timecreated={ts '2018-07-20 10:50:40'}
urltoken=CFID=22758116&CFTOKEN=18022340
Cookie Variables:
CFID=22758116
CFTOKEN=18022340
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=22758116
cftoken=18022340
sessionid=AUCDWEBSITE_22758116_18022340
urltoken=CFID=22758116&CFTOKEN=18022340
URL Parameters:
id=988
Debug Rendering Time: 41 ms