GraduateGuide.com Welcome to GraduateGuide.com - a directory of Graduate Schools
in the United States and Canada

SEARCH PROGRAMS

Program Zip Distance Learning

Name or Keyword
Graduate Major
State or Province


SPONSORED GRADUATE SCHOOLS

Advertisement

UNIVERSITY OF PENNSYLVANIA - School of Social Policy & Practice


TUITION & FEES:
(full-time and per-year)
$44,960 MSW
$55,092 MSSP
$55,092 MSNPL
$34,268 PhD
$85,700 DSW

For a detailed view of tuition, fees, and living expenses please visit: www.sp2.upenn.edu/admissions/tuition/tuition-fees-2016/
Dr. John L. Jackson, Jr., Dean
Richard Perry University Professor
Penn Integrates Knowledge (PIK)Professor

Graduate Admissions Contact:
Dr. Mary Mazzola, Associate Dean, Enrollment Management & Global Outreach
The University of Pennsylvania is nestled in the historic and vibrant city of Philadelphia – America’s fifth largest city. Hailed as a “city of neighborhoods,” Philadelphia offers much to explore, including a thriving arts and culture sector, delicious and diverse dining destinations, iconic historic sites, and one of the Nation’s largest City Park systems. Located in the heart of the University of Pennsylvania's Ivy League campus, the School of Social Policy & Practice is known for its interdisciplinary focus as well as its emphasis on leadership for social change.

One Mission
The School of Social Policy & Practice contributes to the advancement of more effective, efficient and humane human services through education, research and civic engagement. The passionate pursuit of social innovation, impact, and justice is at the heart of the School’s knowledge-building activities.

One School
For more than 100 years, SP2 has been a powerful force for good in the world, working towards social justice and social change through research and practice. Students are encouraged to embrace the interdisciplinary opportunities that SP2 and the University of Pennsylvania have to offer.

One World
Students come to SP2 from around the world to learn how to be powerful forces for good. After earning their degrees, alumni take their gifts, skills, and knowledge to all sectors of society, connecting the dots between issues that are local and international, intimate and institutional.

The School is proud to offer five degree programs: Master of Social Work (MSW), Master of Science in Social Policy (MSSP), Master of Science in Nonprofit Leadership (MSNPL), Clinical Doctorate in Social Work (DSW), and PhD in Social Welfare.

Throughout its 108-year history, the Master of Social Work program has emphasized the integration of field and classroom learning. It draws on 600 different human-service agencies for student field placements. MSW students are able to concentrate in clinical practice or macro practice. Fully accredited by the Council on Social Work Education, the MSW prepares social workers to develop and provide services to individuals, families, groups, communities, and organizations at local, national, and global levels.

The MSW program offers opportunities for full-time and part-time study. An Advanced Standing option as well as an Employed Practitioners Program is also offered. Eleven dual degree programs are offered. These degree programs include: Social Work/Juris Doctor (MSW/JD); Social Work and Bioethics (MSW/MBE); Social Work and Business Administration (MSW/MBA); Social Work and City Planning (MSW/MCP); Social Work and Criminology (MSW/MS); Social Work and Public Administration (MSW/MPA); Social Work and Public Health (MSW/MPH); Social Work and Education (MSW/MSEd); Social Work and Social Policy (MSW/MSSP); Bachelor of Arts and Master’s degree in Social Work (BA/MSW); Social Work and Nonprofit Leadership (MSW/NPL), and MSW/PhD in Social Welfare.

Additionally, the MSW program offers joint MSW/Certificate Programs and specializations in:
MSW/Home-School Visitor Certificate
MSW/Certificate in Jewish Communal Service
Child Well-Being & Child Welfare Specialization (CW2)
Goldring Reentry Initiative (GRI)
Ann Nolan Reese Penn Aging Certificate (PAC)
Program in Mental Health Education Assessment, Recovery, and Leadership for Social Workers (P.E.A.R.L.S.) Fellowship Program
Global Human Rights Certificate

The Master of Science in Nonprofit Leadership (MSNPL) offers both a full- and part-time option. This graduate program is designed for professionals who want to assume leadership positions in nonprofit or non-governmental organizations.

The Master of Science in Social Policy (MSSP) offers both a full- and part-time option, as well as four dual degree programs. This program prepares students for leadership positions in policy leadership positions in government, philanthropic foundations, research institutes, and more. Students learn to use policy to increase equality, promote equity, and forge social change.

The Clinical Doctorate in Social Work (DSW) is intended for clinicians with at least two years post-MSW experience who want to remain clinicians or teach clinical social work practice. Penn's DSW is an intensive program that enables students to complete the course work and dissertation in three years, without career disruption.

The PhD in Social Welfare is an interdisciplinary program that prepares students to be scholars, researchers, and leaders in the field of social welfare.

Financial aid is available.

M.S.W., M.S.S.P., M.S.N.P.L., D.S.W., Ph.D. DEGREES

The DSW program is a hybrid distance program and offers all the advantages of a world class learning community in a highly interactive, relational, accessible and convenient format.
View University of Pennsylvania Undergraduate Programs


CONTACT THIS SCHOOL

The University of Pennsylvania Admissions Department would like to hear from you. Fill out the quick form below to connect with them and hear more about their programs, application, requirements and enrollment information.
5 + 3 =

SCHOOL LINKS


SOCIAL NETWORKING


    Debugging Information
    ColdFusion Server Standard 10,0,13,287689
    Template /college.cfm
    Time Stamp 29-Aug-16 05:01 PM
    Locale English (US)
    User Agent ColdFusion
    Remote IP 108.54.112.66
    Host Name 108.54.112.66


    Execution Time

    Total Time Avg Time Count Template
    1562 ms 1562 ms 1 D:/Websites/graduateguide_PROD/college.cfm
    968 ms 968 ms 1 D:/Websites/graduateguide_PROD/header.cfm
    765 ms 765 ms 1 D:/Websites/graduateguide_PROD/leftNav.cfm
    687 ms 76 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(4) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
    219 ms 219 ms 1 D:/Websites/graduateguide_PROD/footer.cfm
    203 ms 203 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onSessionStart() ] from D:/Websites/graduateguide_PROD/Application.cfc
    125 ms 125 ms 1 D:/Websites/graduateguide_PROD/rightNav.cfm
    94 ms 94 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(pos = 1, ad_id = 0) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
    78 ms 78 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | referTracking_save_UA_reference(10, 8934031) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
    78 ms 78 ms 1 D:/Websites/graduateguide_PROD/navigation.cfm
    63 ms 63 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | INIT_tracking() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
    62 ms 62 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(2) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
    62 ms 62 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | sp_referTracking_USER_AGENT_insert() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
    31 ms 31 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | page_tracking('*5W/T-;-U@ , , 0, 1, 2, college_id=985) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
    16 ms 16 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 1) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
    16 ms 16 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | sp_referTracking_MV_insert(8934031, 20=985&, 6373702) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
    15 ms 15 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | sp_referTracking_Query_Variable(college_id=985) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onRequestEnd(/college.cfm) ] from D:/Websites/graduateguide_PROD/Application.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onRequestStart(/college.cfm) ] from D:/Websites/graduateguide_PROD/Application.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 2) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
    0 ms 0 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc | getCurrAdID(POS = 4) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | ParagraphFormat3(Acclaimed Global Researcher Joins SP2 Faculty - https://t.co/B4EXOazx4Y https://t.co/COc4C4oAT5) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | ParagraphFormat3(Join SP2’s Corporate Awareness Program (CAP) this Wednesday from 6 to 8 p.m. as we welcome SP2 Board of Overseers... https://t.co/vF4pxKp2FB) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | ParagraphFormat3(President’s Task Force Aims To Help End Discrimination In Mental Health Coverage https://t.co/niXaNy0Atl) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | ParagraphFormat3(RT @AASWSWorg: @PennSP2's @RDashford discusses the intersection of criminal justice, behavioral health https://t.co/cBbEJ5gRHT via @HuffPos…) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | ParagraphFormat3(RT @AmyBakker13: To create a culture of diversity, Start with love and empathy. Thanks @johnljacksonjr @phillychamber @PennSP2 @partnerscon…) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | ParagraphFormat3(RT @HIV_Insight: Childhood Sexual Abuse: How Does It Matter in HIV Sexual Risk Behaviors among Women in Methadone Tx? https://t.co/ShC2ERCO…) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | ParagraphFormat3(RT @Jacquie_Posey: Diverse breakfast club- @Penn hosting @phillychamber workshop on inclusion w/ speaker @pennsp2 dean @johnljacksonjr. htt…) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | ParagraphFormat3(RT @phillychamber: All of our @PennSP2 students come to this school for the same reason: they want to make this world a better place - Dr.…) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | ParagraphFormat3(RT @upennlib: Interested in #globaljustice? Check out this new e-resource! @PennSP2 @PennLaw @PennSAS https://t.co/NMJYNNqOtG https://t.co/…) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | ParagraphFormat3(Two School of Social Policy & Practice (SP2) students have been selected to present at this spring’s APPAM... https://t.co/oV1gpxHJ6z) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | cfcookie(session_UUID, '*5W/T-;-U@ , ) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | cfcookie(show_debug, Yes) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 3 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | de_crypt(stretchtite, '*5W/T-;-U@ ) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/cf_function.cfc | en_crypt(stretchtite, 8934031) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | page_view_track(pagetypeid = 2, session_UUID = '*5W/T-;-U@ , pagename = /college.cfm?college_id=985, PageItemID = 985) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
    0 ms 0 ms 1 D:/Websites/graduateguide_PROD/includes/pod0.cfm
    0 ms 0 ms 1 D:/Websites/security/application.cfm
    63 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
    1828 ms  TOTAL EXECUTION TIME
    red = over 250 ms average execution time


    SQL Queries

    getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=10, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 17:01:20.020
    	SELECT adID FROM active_data_ad_list_vw
    	WHERE positionID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 1

    getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=2, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 17:01:20.020
    	SELECT adID FROM active_data_ad_list_vw
    	WHERE positionID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 2

    getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=4, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 17:01:20.020
    	SELECT adID FROM active_data_ad_list_vw
    	WHERE positionID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 3

    getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=9, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 17:01:20.020
    	SELECT adID FROM active_data_ad_list_vw
    	WHERE positionID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 4

    getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=6, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 17:01:20.020
    	SELECT adID FROM active_data_ad_list_vw
    	WHERE positionID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 5

    checkDOMAIN (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:01:20.020
    		SELECT     site_ID, p_site_ID
    		FROM         frontend_site
    		WHERE site_URL = ? 
    Query Parameter Value(s) -
    Parameter #1(CF_SQL_VARCHAR) = www.graduateguide.com

    INITsessionlog (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:01:20.020
    		INSERT INTO referTracking_SessionID(ipaddress, site_ID)
    		VALUES(
    			?,
    			?
    			);
    		
    		SELECT SCOPE_IDENTITY() AS session_UUID;
    	
    Query Parameter Value(s) -
    Parameter #1(CF_SQL_VARCHAR) = 108.54.112.66
    Parameter #2(CF_SQL_INTEGER) = 2

    save_UA_reference (Datasource=graduateguide_prod, Time=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:01:20.020
        UPDATE referTracking_sessionID
        SET agent_ID = ?
        WHERE session_UUID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 10
    Parameter #2(cf_sql_integer) = 8934031

    saveStart (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\Application.cfc @ 17:01:21.021
                INSERT INTO user_session ( dateStart, ip_address, host_name, agent_ID, session_UUID )
                VALUES
                (
                getDate(),
                ?,
                ?,
                ?,
                ?
                )
                SELECT scope_identity() as new_entryID
                
    Query Parameter Value(s) -
    Parameter #1(cf_sql_varchar) = 108.54.112.66
    Parameter #2(cf_sql_varchar) = graduateguide.com
    Parameter #3(cf_sql_integer) = 10
    Parameter #4(cf_sql_integer) = 8934031

    getInfo (Datasource=graduateguide_prod, Time=187ms, Records=1) in D:\Websites\graduateguide_PROD\college.cfm @ 17:01:21.021
    SELECT * FROM college_listings WHERE college_id= ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 985

    qryGetGallery (Datasource=graduateguide_prod, Time=110ms, Records=3) in D:\Websites\graduateguide_PROD\college.cfm @ 17:01:21.021
    DECLARE @college_id INT; SET @college_id = ?;
    		
    SELECT image, caption, status, video from school_images_vw
    where college_id = @college_id
    ORDER BY sort;
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 985

    sessionlog (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:01:21.021
    		INSERT INTO referTracking( session_UUID, group_ID, site_ID, page_ID )
    		VALUES ( ?,
    				 ?,
    				 ?,
    				 ?
    				 );
    		SELECT SCOPE_IDENTITY() AS referTracking_ID
    	
    Query Parameter Value(s) -
    Parameter #1(CF_SQL_INTEGER) = 8934031
    Parameter #2(CF_SQL_INTEGER) = 0
    Parameter #3(CF_SQL_INTEGER) = 1
    Parameter #4(CF_SQL_INTEGER) = 2

    qryGetAd (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:21.021
    	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
        ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
        FROM Data_ads
    	WHERE adID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 201

    trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:21.021
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '08/29/2016';
    	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
    				WHERE date_viewed = @currDate 
    				AND adID = @adID)
    	BEGIN
    		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
    		VALUES (@adID, 1, @currDate)
    	END
    	ELSE
    	BEGIN
    		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
    		WHERE adID = @adID
    		AND date_viewed = @currDate
    	END
    	
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 201

    getSubnav (Datasource=graduateguide_prod, Time=0ms, Records=5) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:01:21.021
    SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
    ORDER BY sortOrder
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 1

    getSubnav (Datasource=graduateguide_prod, Time=0ms, Records=11) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:01:21.021
    SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
    ORDER BY sortOrder
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 2

    getSubnav (Datasource=graduateguide_prod, Time=16ms, Records=6) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:01:21.021
    SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
    ORDER BY sortOrder
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 4

    getSubnav (Datasource=graduateguide_prod, Time=15ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:01:21.021
    SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
    ORDER BY sortOrder
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 5

    getSubnav (Datasource=graduateguide_prod, Time=0ms, Records=2) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:01:21.021
    SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
    ORDER BY sortOrder
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 6

    getSubnav (Datasource=graduateguide_prod, Time=16ms, Records=5) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:01:21.021
    SELECT typeID, pageID, url, label, target FROM Data_Navigation_Item WHERE parentID = ? and status = 'A'
    ORDER BY sortOrder
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 7

    major_links (Datasource=graduateguide_prod, Time=15ms, Records=12) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 17:01:21.021
      SELECT m.major_id, m.major, ml.display_name, ss.displayname, count(cm.major_id) as total
      FROM major_links ml
        LEFT JOIN majors m ON ml.major_id = m.major_id
        RIGHT JOIN college_majors cm ON cm.major_id = m.major_id
        inner join saved_search ss ON ss.major = m.major_id
      WHERE ml.status = 'true' AND
      ss.state = 'none'
        AND ss.status = 'A'
      group by m.major_id, m.major, ml.display_name, ss.displayname
      ORDER BY TOTAL DESC
    
    getMajors (Datasource=graduateguide_prod, Time=32ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 17:01:21.021
             Select * From Majors ORDER BY Major ASC
             
    getMajors3 (Datasource=graduateguide_prod, Time=0ms, Records=47) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 17:01:21.021
               SELECT DISTINCT majors.major_id, majors.major as major_name 
               FROM college_majors INNER JOIN majors ON college_majors.major_id =majors.major_id 
               WHERE (college_majors.online = 1) ORDER BY majors.major
               
    getMajors2 (Datasource=graduateguide_prod, Time=16ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 17:01:21.021
             Select * From Majors ORDER BY Major ASC
             
    getAdIDs4 (Datasource=graduateguide_prod, Time=0ms, Records=9) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 17:01:21.021
    SELECT TOP 9 adID FROM active_data_ad_list_vw
    WHERE positionID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 4

    qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:21.021
    	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
        ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
        FROM Data_ads
    	WHERE adID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 139

    trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:21.021
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '08/29/2016';
    	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
    				WHERE date_viewed = @currDate 
    				AND adID = @adID)
    	BEGIN
    		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
    		VALUES (@adID, 1, @currDate)
    	END
    	ELSE
    	BEGIN
    		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
    		WHERE adID = @adID
    		AND date_viewed = @currDate
    	END
    	
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 139

    qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:21.021
    	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
        ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
        FROM Data_ads
    	WHERE adID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 200

    trackAd_viewing (Datasource=graduateguide_prod, Time=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:21.021
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '08/29/2016';
    	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
    				WHERE date_viewed = @currDate 
    				AND adID = @adID)
    	BEGIN
    		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
    		VALUES (@adID, 1, @currDate)
    	END
    	ELSE
    	BEGIN
    		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
    		WHERE adID = @adID
    		AND date_viewed = @currDate
    	END
    	
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 200

    qryGetAd (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:21.021
    	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
        ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
        FROM Data_ads
    	WHERE adID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 16

    trackAd_viewing (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:21.021
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '08/29/2016';
    	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
    				WHERE date_viewed = @currDate 
    				AND adID = @adID)
    	BEGIN
    		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
    		VALUES (@adID, 1, @currDate)
    	END
    	ELSE
    	BEGIN
    		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
    		WHERE adID = @adID
    		AND date_viewed = @currDate
    	END
    	
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 16

    qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:21.021
    	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
        ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
        FROM Data_ads
    	WHERE adID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 9

    trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:21.021
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '08/29/2016';
    	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
    				WHERE date_viewed = @currDate 
    				AND adID = @adID)
    	BEGIN
    		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
    		VALUES (@adID, 1, @currDate)
    	END
    	ELSE
    	BEGIN
    		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
    		WHERE adID = @adID
    		AND date_viewed = @currDate
    	END
    	
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 9

    qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:21.021
    	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
        ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
        FROM Data_ads
    	WHERE adID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 206

    trackAd_viewing (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:22.022
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '08/29/2016';
    	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
    				WHERE date_viewed = @currDate 
    				AND adID = @adID)
    	BEGIN
    		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
    		VALUES (@adID, 1, @currDate)
    	END
    	ELSE
    	BEGIN
    		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
    		WHERE adID = @adID
    		AND date_viewed = @currDate
    	END
    	
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 206

    qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:22.022
    	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
        ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
        FROM Data_ads
    	WHERE adID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 175

    trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:22.022
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '08/29/2016';
    	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
    				WHERE date_viewed = @currDate 
    				AND adID = @adID)
    	BEGIN
    		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
    		VALUES (@adID, 1, @currDate)
    	END
    	ELSE
    	BEGIN
    		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
    		WHERE adID = @adID
    		AND date_viewed = @currDate
    	END
    	
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 175

    qryGetAd (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:22.022
    	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
        ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
        FROM Data_ads
    	WHERE adID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 169

    trackAd_viewing (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:22.022
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '08/29/2016';
    	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
    				WHERE date_viewed = @currDate 
    				AND adID = @adID)
    	BEGIN
    		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
    		VALUES (@adID, 1, @currDate)
    	END
    	ELSE
    	BEGIN
    		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
    		WHERE adID = @adID
    		AND date_viewed = @currDate
    	END
    	
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 169

    qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:22.022
    	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
        ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
        FROM Data_ads
    	WHERE adID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 10

    trackAd_viewing (Datasource=graduateguide_prod, Time=78ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:22.022
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '08/29/2016';
    	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
    				WHERE date_viewed = @currDate 
    				AND adID = @adID)
    	BEGIN
    		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
    		VALUES (@adID, 1, @currDate)
    	END
    	ELSE
    	BEGIN
    		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
    		WHERE adID = @adID
    		AND date_viewed = @currDate
    	END
    	
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 10

    qryGetAd (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:22.022
    	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
        ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
        FROM Data_ads
    	WHERE adID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 167

    trackAd_viewing (Datasource=graduateguide_prod, Time=62ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:22.022
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '08/29/2016';
    	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
    				WHERE date_viewed = @currDate 
    				AND adID = @adID)
    	BEGIN
    		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
    		VALUES (@adID, 1, @currDate)
    	END
    	ELSE
    	BEGIN
    		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
    		WHERE adID = @adID
    		AND date_viewed = @currDate
    	END
    	
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 167

    checkRelated (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\college.cfm @ 17:01:22.022
        SELECT ug_college_id FROM relatedSchools WHERE g_college_id = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 985

    getSG_school (Datasource=schoolguides_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\college.cfm @ 17:01:22.022
            SELECT College_Name FROM School_Details WHERE college_id = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 1219

    getBanner_imp (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\college.cfm @ 17:01:22.022
    SELECT college_id FROM banners
    where college_id = ?
    and subcollege_id = 0 and date = '2016-08-29'
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 985

    upBanner (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\college.cfm @ 17:01:22.022
        UPDATE banners SET impressions = impressions + 1
        WHERE college_id = ?
        AND subcollege_id = 0
        AND date = '2016-08-29'
        
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 985

    qryGetEditLinks (Datasource=graduateguide_prod, Time=0ms, Records=5) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:01:22.022
    select clinkid, urlstring as webaddr, displayname as label, sortOrder as sort from college_links
    where college_id = ?
    AND status = 'A'
    order by sort
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 985

    doTracking (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:01:22.022
    UPDATE college_links_track
    SET imps = imps	+ 1
    WHERE clinkid = ? 
    AND edate = '2016-08-29 00:00:00'
    
    IF @@ROWCOUNT = 0
    	INSERT INTO college_links_track(clinkid, college_id, hits, imps, edate)
    	VALUES (?, 
        	?, 
            0, 
            1,
            DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
            )
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 102
    Parameter #2(cf_sql_integer) = 102
    Parameter #3(cf_sql_integer) = 985

    doTracking (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:01:22.022
    UPDATE college_links_track
    SET imps = imps	+ 1
    WHERE clinkid = ? 
    AND edate = '2016-08-29 00:00:00'
    
    IF @@ROWCOUNT = 0
    	INSERT INTO college_links_track(clinkid, college_id, hits, imps, edate)
    	VALUES (?, 
        	?, 
            0, 
            1,
            DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
            )
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 440
    Parameter #2(cf_sql_integer) = 440
    Parameter #3(cf_sql_integer) = 985

    doTracking (Datasource=graduateguide_prod, Time=15ms, Records=1) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:01:22.022
    UPDATE college_links_track
    SET imps = imps	+ 1
    WHERE clinkid = ? 
    AND edate = '2016-08-29 00:00:00'
    
    IF @@ROWCOUNT = 0
    	INSERT INTO college_links_track(clinkid, college_id, hits, imps, edate)
    	VALUES (?, 
        	?, 
            0, 
            1,
            DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
            )
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 706
    Parameter #2(cf_sql_integer) = 706
    Parameter #3(cf_sql_integer) = 985

    doTracking (Datasource=graduateguide_prod, Time=32ms, Records=1) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:01:22.022
    UPDATE college_links_track
    SET imps = imps	+ 1
    WHERE clinkid = ? 
    AND edate = '2016-08-29 00:00:00'
    
    IF @@ROWCOUNT = 0
    	INSERT INTO college_links_track(clinkid, college_id, hits, imps, edate)
    	VALUES (?, 
        	?, 
            0, 
            1,
            DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
            )
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 952
    Parameter #2(cf_sql_integer) = 952
    Parameter #3(cf_sql_integer) = 985

    doTracking (Datasource=graduateguide_prod, Time=31ms, Records=1) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:01:22.022
    UPDATE college_links_track
    SET imps = imps	+ 1
    WHERE clinkid = ? 
    AND edate = '2016-08-29 00:00:00'
    
    IF @@ROWCOUNT = 0
    	INSERT INTO college_links_track(clinkid, college_id, hits, imps, edate)
    	VALUES (?, 
        	?, 
            0, 
            1,
            DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))
            )
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 1136
    Parameter #2(cf_sql_integer) = 1136
    Parameter #3(cf_sql_integer) = 985

    checkTweets (Datasource=graduateguide_prod, Time=0ms, Records=10) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:01:22.022
    	SELECT top 10 tweet_id, tweet_content
    	FROM Data_Twitter WHERE college_id = ? order by tweet_date DESC
    	
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 985

    qryGetFooterLinks (Datasource=graduateguide_prod, Time=16ms, Records=7) in D:\Websites\graduateguide_PROD\footer.cfm @ 17:01:22.022
    	select * from footer_links_vw
    
    qryGetAd (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:22.022
    	SELECT adID, positionID, typeID, ad_target_url, ad_feature_name, ad_feature_url, ad_feature_desc, ad_image_URL, ad_js_container, ad_sponsorID, ad_schoolID, ad_nonschoolID, 
        ad_swf_name, ad_swf_width, ad_swf_height, status, eDate, startDate, endDate, notes, major, ad_location, ad_target_url_label
        FROM Data_ads
    	WHERE adID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 140

    trackAd_viewing (Datasource=graduateguide_prod, Time=47ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:01:22.022
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '08/29/2016';
    	IF NOT EXISTS (SELECT * FROM track_ad_viewed 
    				WHERE date_viewed = @currDate 
    				AND adID = @adID)
    	BEGIN
    		INSERT INTO track_ad_viewed (adID, times_viewed, date_viewed)
    		VALUES (@adID, 1, @currDate)
    	END
    	ELSE
    	BEGIN
    		UPDATE track_ad_viewed SET times_viewed = times_viewed + 1
    		WHERE adID = @adID
    		AND date_viewed = @currDate
    	END
    	
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 140

    updTracking (Datasource=graduateguide_prod, Time=0ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:01:22.022
    	INSERT INTO referTracking_pages(url,session_UUID,pageTypeID,PageItemID)
    	VALUES(
    		?,
    		?,
    		?,
    		?
    	)
    	
    Query Parameter Value(s) -
    Parameter #1(CF_SQL_VARCHAR) = /college.cfm?college_id=985
    Parameter #2(CF_SQL_INTEGER) = 8934031
    Parameter #3(CF_SQL_INTEGER) = 2
    Parameter #4(CF_SQL_INTEGER) = 985


    Stored Procedures

    sp_referTracking_USER_AGENT_insert (Datasource=graduateguide_prod, Time=62ms) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:01:20.020

        
    parameters
    typeCFSQLTypevaluevariabledbVarName
     IN  CF_SQL_VARCHAR  ColdFusion    
        
    resultsets
    nameresultset
     result  1
    sp_referTracking_Query_Variable (Datasource=graduateguide_prod, Time=15ms) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:01:21.021
        
    parameters
    typeCFSQLTypevaluevariabledbVarName
     IN  CF_SQL_VARCHAR  college_id=985    
        
    resultsets
    nameresultset
     result  1
    sp_referTracking_MV_insert (Datasource=graduateguide_prod, Time=16ms) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:01:21.021
        
    parameters
    typeCFSQLTypevaluevariabledbVarName
     IN  CF_SQL_INTEGER  8934031    
     IN  CF_SQL_VARCHAR  20=985&    
     IN  CF_SQL_INTEGER  6373702    
        
    resultsets
    nameresultset
    dbo.main_navigation (Datasource=graduateguide_prod, Time=31ms) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:01:21.021
        
    parameters
    typeCFSQLTypevaluevariabledbVarName
        
    resultsets
    nameresultset
     getMain  1


    Scope Variables

    CGI Variables:
    AUTH_PASSWORD=
    AUTH_TYPE=
    AUTH_USER=
    CERT_COOKIE=
    CERT_FLAGS=
    CERT_ISSUER=
    CERT_KEYSIZE=
    CERT_SECRETKEYSIZE=
    CERT_SERIALNUMBER=
    CERT_SERVER_ISSUER=
    CERT_SERVER_SUBJECT=
    CERT_SUBJECT=
    CF_TEMPLATE_PATH=D:\Websites\graduateguide_PROD\college.cfm
    CONTENT_LENGTH=0
    CONTENT_TYPE=
    CONTEXT_PATH=
    GATEWAY_INTERFACE=CGI/1.1
    HTTPS=off
    HTTPS_KEYSIZE=
    HTTPS_SECRETKEYSIZE=
    HTTPS_SERVER_ISSUER=
    HTTPS_SERVER_SUBJECT=
    HTTP_ACCEPT=
    HTTP_ACCEPT_ENCODING=
    HTTP_ACCEPT_LANGUAGE=
    HTTP_CONNECTION=close
    HTTP_COOKIE=
    HTTP_HOST=www.graduateguide.com
    HTTP_REFERER=
    HTTP_USER_AGENT=ColdFusion
    PATH_INFO=/college.cfm
    PATH_TRANSLATED=D:\Websites\graduateguide_PROD\college.cfm
    QUERY_STRING=college_id=985
    REMOTE_ADDR=108.54.112.66
    REMOTE_HOST=108.54.112.66
    REMOTE_USER=
    REQUEST_METHOD=GET
    SCRIPT_NAME=/college.cfm
    SERVER_NAME=www.graduateguide.com
    SERVER_PORT=80
    SERVER_PORT_SECURE=0
    SERVER_PROTOCOL=HTTP/1.1
    SERVER_SOFTWARE=Microsoft-IIS/7.5
    WEB_SERVER_API=
    
    Cookie Variables:
    CFID=6258197
    CFTOKEN=37a97f4f0c10feba-710FE885-0FAD-FCD8-D233D9527EE30777
    POPFIRST=
    SESSION_UUID=%27%2A5W%2FT%2D%3B%2DU%40%20%20
    SHOW_DEBUG=Yes
    
    Session Variables:
    cfid=6258197
    cftoken=37a97f4f0c10feba-710FE885-0FAD-FCD8-D233D9527EE30777
    entryid=8973240
    session_uuid=8934031
    sessionid=GARDUATEGUIDE_6258197_37a97f4f0c10feba-710FE885-0FAD-FCD8-D233D9527EE30777
    urltoken=CFID=6258197&CFTOKEN=37a97f4f0c10feba-710FE885-0FAD-FCD8-D233D9527EE30777
    
    URL Parameters:
    college_id=985
    
    Debug Rendering Time: 16 ms