Stephen Rock, Ph.D.

Nevada Center for Excellence in Disabilities
University of Nevada, Reno
Mail Stop 285
Reno, NV 89557
 
Phone: 775-784-6385
Email: rock@unr.edu
Login to Update Your Profile
Last Updated: August 29, 2011

Stephen Rock
 

Leadership: UCEDD Director
LEND Director
Discipline Coordinators: Special Education
 
Discipline(s): Education/Special Education
 
AUCD Council Membership: Community Education Directors' Council
Council on Research and Evaluation

Vita/Bio

Education
Ph.D., 1985, Special Education, University of Illinois at Urbana-Champaign, Champaign, Illinois
M.S., 1976, Learning Disabilities & Emotional Handicapped, Utah State University, Logan, Utah
B.A., 1972, Psychology, University of Arizona, Tucson, Arizona

Relevant Professional Experience

2008-Present, Director, Nevada Center for Excellence in Disabilities, University of Nevada, Reno
2003-Present, Professor, Department of Educational Specialties, University of Nevada, Reno
1997-2003, Professor, Department of Curriculum and Instruction, University of Nevada, Reno
Feb, 2000-2003, Chair, Department of Curriculum and Instruction, University of Nevada, Reno
1997-2001, Evaluator, Western Center for the Application of Prevention Technology
1993-2001, Evaluator, Mountain West Addiction Technology Transfer Center, University of Nevada, Reno
1991-Feb, 2001, Director, Nevada University Affiliated Program in Developmental Disabilities, University of Nevada, Reno
1990-Feb, 2001, Director, Research and Educational Planning Center, University of Nevada, Reno
1997-1998, Acting Dean, College of Education, University of Nevada, Reno
1989-1990, Associate Director, University of Arkansas University Affiliated Program, University of Arkansas at Little Rock
1983-1990, Associate Professor (1988-90), Assistant Professor (1983-88), Center for Research on Teaching and Learning & Department of Teacher Education, University of Arkansas at Little Rock, Little Rock, Arkansas
1981-1983, Assistant Professor, Department of Specialized Educational Development, Illinois State University, Normal, Illinois
1976-1978, Teacher, Self-contained classroom for emotionally handicapped, Mountainview Elementary School, Box Elder School District, Brigham City, Utah
Summer-1977, Supervising Teacher, Learning Disabilities Summer Program, Exceptional Child Center, Utah State University, Logan, Utah
1970-1974, Chazen Institute (treatment center for emotionally disturbed children, ages 9-18), Tucson, Arizona

Relevant University Service Activities:

Chair, University Human Subjects Review Board, May 2008 to May 2010; Member, 2004 - present.
Chair, UNR Faculty Senate 2007-2008 ╨ Chair-elect 2006-2007, Past Chair 2008-2009
Member, UNR Faculty Senate, 2005-06

Selected Publications

Rock, S (2004). Reviewing Prevention Research. Tip of the CAPT (Newsletter), Reno, NV: Western Center for Application of Prevention Technology

Albers, E., Santangelo, L., McKinley, G., Cavote, S., & Rock, S. (2001). Gender, Grade, and Ethnic Differences in Student Attitudes and Perception of Harm Toward Substance Abuse. Journal of Ethnicity and Substance Abuse, vol 1 issue 2.

Albers, E., Santangelo, L., McKinley, G., Cavote, S., & Rock, S. ( 2001). A Conceptual Three Dimensional Model for Evaluating Community Based Substance Abuse Prevention Programs. Journal of Child and Adolescent Substance Abuse. .

Rock, S.L. (1994). Holding inclusion to a higher standard: Discussion of inclusion in childhood services. In S. Hayes, L. Hayes, S. Moore & P. Ghezzi (Eds.), Ethical Issues in Developmental Disabilities (pp. 100-102). Reno, NV: Context Press.

Rock, S.L., Head, D.N. & Bradley (1994) Use of the HOME Inventory with children with visual impairments. Journal of Visual Impairments and Blindness, 88(2), 140-151.

Bradley, R.H., Rock, S.L., Caldwell, B.M., Brisby, J, Magee, M, & Whiteside, L (1992). The HOME Inventory: A new scale for families of pre- and early adolescent children with disabilities. Research in Developmental Disabilities, 13, 313-333.

Cline, D.N & Rock, S.L. (1992). Organization analysis and social maladjustment: Third invited reaction to the Maag and Howell paper. Remedial and Special Education, 13(1), 63-66.

Rock, S.L., Gieger, W.L. & Hood, G. (1992). CEC's standard's for professional practice in advocacy: Member's attitudes and activities. Exceptional Children, 58(6), 541-547.

Parrette, H.P., Hendricks, M.D., & Rock, S.L. (1991). Efficacy of therapeutic intervention intensity with infants and young children with cerebral palsy. Infants and Young Children, 4(2), 1-19.

Croce, R.V. & Rock, S.L. (1991). Effect of peer presence on the fine-motor performance of adults with mental retardation. Clinical Kinesiology, 45(3),11-17.

Bradley, R., Rock, S. Whiteside, L., Caldwell, B. & Brisby, J. (1991). Dimensions of parenting in families having children with disabilities. Exceptionality, 2, 41-61.

Croce, R.V. & Rock, S.L. (1990). Behavior Modification: Its application in physical education/motor development in children with special needs. In R. French & B Lavay (Eds.) Behavior management techniques for physical educators and recreators. Kearney, NE: Educational Systems Associations.

Head, D.N., Bradley, R.H. & Rock, S.L. (1990). Consideration for the use of home environment measures with visually handicapped children. Journal of Visual Impairments and Blindness, 84(7),377-380.

Rock, S.L., Pelt, M.H., & Swanson, M. (1990). Implementation of a comprehensive system of early intervention services: Policy implications for part H of public law 99-457. Austin, TX: Southwest Educational Development Laboratory

Bradley, R.H., Rock, S.L., Caldwell, B.M., & Brisby, J.A. (1989). The use of the HOME Inventory for families with handicapped children. American Journal on Mental Retardation, 94(3), 313-330.

Bradley, R. H., Caldwell, B. M., Rock, S. L., Ramey, C. T., Barnard, K. E., Gray, C., Hammond, M. A., Mitchell, S., Gottfried, A.W., Siegel, L., & Johnson, D.L. (1989). Home environment and cognitive development in the first 3 years of life: A collaborative study involving six sites and three ethnic groups in North America. Developmental Psychology, 25(2), 217-235.

Geiger, W.L., Whiteside, L. & Rock, S.L (1989). The status of personnel preparation in special education (1982): A report on the results of a national survey conducted by the Teacher Education Division of the Council for Exceptional Children. Washington, DC: National Clearinghouse for Professions in Special Education.

Bradley, R. H., Caldwell, B. M., & Rock, S. L. (1988). Home environment and school performance: A ten year follow-up and examination of three models of environmental action. Child Development, 59, 852-867.

Rock, S.L., Flanzer, S., Bradley, R.H., & Pardeck, J.T. (1988). Frequency of maladaptive behavior in foster children. Early Child Development and Care, 30(2), 133-139.

 

Grants and Contracts (Role of PI, Evaluator or Co-author)

Nevada Center for Excellence in Disabilities (Nevada's UCEDD). US Department of Health and Human Services, Administration for Children and Families, Administration for Developmental Disabilities, (2008-2013 $524,000 per year), PI/Director, (Most recent 5-year proposal authored by Dr. JoAnn Johnson, George McKinlay, Tami Brancamp, Scott Youngs, and Scott Harrington).

Nevada Professional Development for Teachers of English Language Learners (Nevada ProTELL), US Department of Education; 2002-2007 ($278,744 per year), Co-PI and evaluator with Elza Major and Rod Case.

Evaluation Team for Bureau of Alcohol and Drug Abuse Prevention Program, Nevada Bureau of Alcohol and Drug Abuse, 1999-2001 ($100,000), 2002-2004 ($375,000), Co-PI with Eric Albers, Linda Santangelo, George McKinlay.

Evaluation of Western Center of Application of Prevention Technology, US Department of Health and Human Service; Gary Fischer, principal investigator (1997-2001).

Evaluation of Mountain West Addiction Technology Transfer Center, US Department of Health and Human Service; Gary Fischer, principal investigator (1993-2001).

Nevada University Affiliated Program in Developmental Disabilities (Nevada UAP). US Department of Health and Human Services, Administration for Children and Families, Administration for Developmental Disabilities, 1991-2001, Director

Nevada Family Support Network, US Department of Health and Human Services, Administration for Children and Families, Administration for Developmental Disabilities, 1999-2000 ($200,000 per year) with Cheryl Dinnell; Project is managed by Ms. Dinnell. My role was supervisory.

Nevada Partners in Policymaking, US Department of Health and Human Services, Administration for Children and Families, Administration for Developmental Disabilities, 1997-2002 ($90,000 per year) with Cheryl Dinnell; Project is managed by Ms. Dinnell. My role was supervisory.

Quality Assessment and Consumer Satisfaction, Nevada Division of Mental Hygiene and Mental Retardation, 1995-97 ($198,000) co-investigator with Stephen C. Moore, 1997-99 ($198,000) with George H. Hill; 1999-2001 with JoAnn Johnson; Project was managed by Dr. Johnson 99-01.

Americans with Disabilities Act Training Initiative for Nevada (ADA Nevada), US Department of Health and Human Services, Administration for Children and Families, Administration for Developmental Disabilities, 1994-1997 ($90,000 per year) principal investigator.

Preparation of Rural Early Education Professionals, US Department of Education, Office of Special Education and Rehabilitation Services, Personnel Preparation, 1991-1994 ($77,000 per year), Co-director with Sandra Doctoroff. A cooperative project with community colleges to develop and offer disabilities training to paraprofessionals.

Evaluation of class reduction, Nevada Department of Education, Educational Planning and Research, 1992-93, $20,000, with D. Cline, C. Maddux, & L. Johnson.

Preparation of personnel for careers in special education: Project STRETCH (Specialized Training for Rural Educators who Teach Children with Handicaps). US Department of Education, Office of Special Education and Rehabilitation Services, Personnel Preparation, 1991-1994 ($87,000 per year), Co-director with Rhoda Cummings.

Preparation of personnel for careers in special education: The UNR early childhood special education program. US Department of Education, Office of Special Education and Rehabilitation Services, Personnel Preparation, 1991-1994 ($85,000 per year), Co-director with Sarah Drinkwater and Sandra Doctoroff. Project help develop and expand early childhood special education program master's program.

Institutional Evaluation for Little Rock New Futures Project. Contract with Center for the Study of Social Policy and the University of Wisconsin at Madison (funded by Annie E. Casey Foundation). 1988-89 ($65,000), 1989-90 ($9,000). This was an educational reform project in cooperative with Little Rock School District.

Preparation of personnel for careers in special education and early education: The early childhood special education program, US Department of Education, Office of Special Education and Rehabilitation Services, Personnel Preparation, 1989-92 ($80,000 per year). Principal Investigator. This project established the Early Childhood Special Education Master's Program at University of Arkansas at Little Rock.

Preparation of special educators: The resource and consulting teaching program. US Department of Education, Personnel Preparation, 1988-91 ($51,000 per year). Principal Investigator. This project created the Resource and Consulting Teachers Master's Program at University of Arkansas at Little Rock.

Handicapped Children, their families, and school settings: An ecological study. US Department of Education, Research in Education of the Handicapped, Field Initiated Research, 1986-89 ($93,000 per year). Co-investigator with Robert Bradley and Bettye Caldwell.

Technical Assistance and Consultation
Evaluation Consultant, The Redwood Valley Rancheria, Redwood, CA; Western Center for Application of Prevention Technology and the Native American Center for Excellence,?Prevention Technical Assistance Resource Center (NACE), January - April, 2009.

Evaluation Consultant, Synergy Works, Orofina, Idaho; Western Center for Application of Prevention Technology, September 2008.

Evaluation Consultant, The Coalition for Healthy and Resilient Youth, McKinlay County and Navajo Nation, New Mexico; Western Center for Application of Prevention Technology and the Native American Center for Excellence, Prevention Technical Assistance Resource Center (NACE), February-July, 2008.




Debugging Information
ColdFusion Server Standard 9,0,0,251028
Template /directory/detailbio.cfm
Time Stamp 15-Jul-18 04:51 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.198.170.159
Host Name 54.198.170.159


Execution Time

Total Time Avg Time Count Template
80 ms 80 ms 1 top level E:\www\aauapweb\aucd\directory\detailbio.cfm
47 ms 47 ms 1 E:/www/aauapweb/aucd/include/dir_contact_view.cfm
27 ms 27 ms 1 E:/www/aauapweb/aucd/directory/Application.cfm
26 ms 26 ms 1 E:/www/aauapweb/aucd/Application.cfm
22 ms 22 ms 1 E:/www/aauapweb/aucd/template/header_plain.cfm
21 ms 21 ms 1 E:/www/aauapweb/aucd/template/header_2column.cfm
16 ms 16 ms 1 E:/www/aauapweb/aucd/template/qry_menu.cfm
12 ms 12 ms 1 E:/www/aauapweb/aucd/template/inc_header.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
3 ms 3 ms 1 E:/www/aauapweb/aucd/template/footer_plain.cfm
2 ms 2 ms 1 E:/www/aauapweb/aucd/template/footer_2column.cfm
1 ms 1 ms 1 E:/www/aauapweb/aucd/include/body.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/udf.cfm
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
110 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 @ 16:51:45.045
	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 @ 16:51:45.045
SELECT id, description FROM code WHERE name = 'content_language' ORDER BY orderby
page (Datasource=aucd, Time=2ms, Records=1) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 16:51:45.045
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/detailbio.cfm%' /* 5 */
	
	AND page.template NOT IN ('ITAC','NGSD','ECP')
ORDER BY page_id
getrole (Datasource=aucd, Time=0ms, Records=1) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 16:51:45.045
	SELECT code.code
	FROM link_page_role INNER JOIN code ON link_page_role.code_id = code.id
	WHERE fk_id = 143 
parentinfo (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 16:51:45.045
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=10ms, Records=90) in E:\www\aauapweb\aucd\template\qry_menu.cfm @ 16:51:45.045
	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
		
		 
	ORDER BY page.orderby
detail (Datasource=aucd, Time=3ms, Records=1) in E:\www\aauapweb\aucd\directory\detailbio.cfm @ 16:51:45.045
SELECT tbl_directory_staff.*,
	tbl_directory_address.progname, tbl_directory_address.organization, tbl_directory_address.address_id,
	tbl_directory_programs.state AS program_state,
	staff_position(tbl_directory_staff.staffid,'','') AS all_position
FROM tbl_directory_staff 
	INNER JOIN tbl_directory_programs ON tbl_directory_staff.id = tbl_directory_programs.id
	LEFT JOIN tbl_directory_address ON tbl_directory_staff.id = tbl_directory_address.program_id
		 
		AND tbl_directory_address.program_type like '%UCEDD%' 
		
WHERE tbl_directory_staff.staffid = 3797 
get_desc (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\template\udf.cfm @ 16:51:45.045
			SELECT description AS description FROM code
			WHERE name = ? AND code = 'NV'
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = state

submenu (Datasource=aucd, Time=3ms, Records=3) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 16:51:45.045
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) = 5 
ORDER BY 3,2
menu_network (Datasource=, Time=3ms, Records=0) in E:\www\aauapweb\aucd\template\inc_header.cfm @ 16:51:45.045
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 @ 16:51:45.045
SELECT * FROM qry_menutop
WHERE section_name = 'Home' AND page_section > 0
ORDER BY orderby
issub (Datasource=, Time=2ms, Records=0) in E:\www\aauapweb\aucd\template\inc_fourth.cfm @ 16:51:45.045
	SELECT sub FROM submenu
	WHERE page_id = 143 
fourth (Datasource=aucd, Time=1ms, Records=0) in E:\www\aauapweb\aucd\template\inc_fourth.cfm @ 16:51:45.045
	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=0) in E:\www\aauapweb\aucd\include\body.cfm @ 16:51:45.045
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 = 143 
ORDER BY page_module.orderby
disc (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\include\dir_contact_view.cfm @ 16:51:45.045
SELECT group_concat(description SEPARATOR ', ') AS discipline
FROM crm_code INNER JOIN crm_link_contact ON crm_code.id = crm_link_contact.code_id
WHERE crm_link_contact.fk_id = 3797
	AND crm_code.name = 'discipline'
	and crm_code.description not like '%other%'
ORDER BY crm_code.orderby, crm_code.description
addr (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\include\dir_contact_view.cfm @ 16:51:45.045
	SELECT address1, address2, city, state, zip, department, organization, phone
	FROM tbl_directory_address AS c
	WHERE c.program_id = 47 
qry_positions (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\include\dir_contact_view.cfm @ 16:51:45.045
	SELECT
			(select group_concat(position_id)
				from tbl_directory_staff_position inner join tbl_directory_positions on tbl_directory_staff_position.position_id = tbl_directory_positions.id
				where tbl_directory_staff_position.staffid = 3797 and
						tbl_directory_positions.section = "TP")
		as lead_positions,
			(select group_concat(position_id)
				from tbl_directory_staff_position inner join tbl_directory_positions on tbl_directory_staff_position.position_id = tbl_directory_positions.id
				where tbl_directory_staff_position.staffid = 3797 and
						tbl_directory_positions.section = "PA")
		as activ_coord_positions,
			(select group_concat(position_id)
				from tbl_directory_staff_position inner join tbl_directory_positions on tbl_directory_staff_position.position_id = tbl_directory_positions.id
				where tbl_directory_staff_position.staffid = 3797 and
						tbl_directory_positions.section = "DC")
		as disc_coord_positions,
			(select group_concat(code_id)
				from crm_link_contact inner join crm_code on crm_link_contact.code_id = crm_code.id
				where fk_id=3797 and
						crm_code.name = 'category' and crm_code.description like 'Trainees - %')
		as categories
	FROM tbl_directory_staff
	WHERE tbl_directory_staff.staffid = 3797 
qry_lookup (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\include\dir_contact_view.cfm @ 16:51:45.045
					select position from tbl_directory_positions where id = 85 
qry_lookup (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\include\dir_contact_view.cfm @ 16:51:45.045
					select position from tbl_directory_positions where id = 3 
qry_lookup (Datasource=aucd, Time=1ms, Records=1) in E:\www\aauapweb\aucd\include\dir_contact_view.cfm @ 16:51:45.045
					select position from tbl_directory_positions where id = 56 
qry_council (Datasource=aucd, Time=1ms, Records=2) in E:\www\aauapweb\aucd\include\dir_contact_view.cfm @ 16:51:45.045
	select crm_group.description
		from crm_group inner join crm_link_contact_group as link on crm_group.group_id = link.code_id
	where link.fk_id = 3797 


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\detailbio.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/detailbio.cfm
PATH_TRANSLATED=E:\www\aauapweb\aucd\directory\detailbio.cfm
QUERY_STRING=program=UCEDD&staffid=3797
REMOTE_ADDR=54.198.170.159
REMOTE_HOST=54.198.170.159
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/directory/detailbio.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=22453998
cftoken=79654191
hitcount=1
lastvisit={ts '2018-07-15 16:51:45'}
timecreated={ts '2018-07-15 16:51:45'}
urltoken=CFID=22453998&CFTOKEN=79654191
Cookie Variables:
CFID=22453998
CFTOKEN=79654191
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=22453998
cftoken=79654191
sessionid=AUCDWEBSITE_22453998_79654191
urltoken=CFID=22453998&CFTOKEN=79654191
URL Parameters:
program=UCEDD
staffid=3797
Debug Rendering Time: 43 ms