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; $35,156 DSW
Dr. John L. Jackson, Jr., Dean

GRADUATE ADMISSIONS CONTACT
Dr. Mary Mazzola, Associate Dean, Enrollment Management
Penn School of Social Policy & Practice is located near Center City Philadelphia. The city of Philadelphia as well as the University offer a variety of cultural, recreational, and educational opportunities.

Located in the heart of the University of Pennsylvania's Ivy League campus, Penn Social Policy & Practice is known for its interdisciplinary focus as well as its emphasis on leadership for social change.

Penn 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.

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

Throughout its 107-year history, the MSW program has emphasized the integration of field and classroom learning. It draws on 500 different human-service agencies for student field placements. MSW students are able to concentrate in clinical practice or macro practice.

The MSW program offers opportunities for full-time and part-time study. An Advanced Standing option as well as an Employed Practitioners Program are also offered. Additionally, 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 in Catholic Social Ministry, Christian Social Ministry, Home-School Visitor, Jewish Communal Service and Lutheran Social Ministry. The MSW program also has the following Certificate Programs, Concentrations and Specializations: The Child Well-Being & Child Welfare Specialization (CW2); Goldring Reentry Initiative (GRI); Penn Aging Certificate Fellows Program (PAC); Program in Mental Health Education Assessment, Recovery, and Leadership for Social Workers (P.E.A.R.L.S.) Fellowship Program; and the Global Human Rights Certificate.

The Master of Science in Nonprofit Leadership 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 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.
6 + 7 =

SCHOOL LINKS


SOCIAL NETWORKING


    Debugging Information
    ColdFusion Server Standard 10,0,13,287689
    Template /college.cfm
    Time Stamp 09-Feb-16 05:05 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
    1881 ms 1881 ms 1 D:/Websites/graduateguide_PROD/college.cfm
    1284 ms 1284 ms 1 D:/Websites/graduateguide_PROD/header.cfm
    904 ms 904 ms 1 D:/Websites/graduateguide_PROD/leftNav.cfm
    796 ms 88 ms 9 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(4) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
    376 ms 376 ms 1 D:/Websites/graduateguide_PROD/footer.cfm
    201 ms 201 ms 1 D:/Websites/graduateguide_PROD/rightNav.cfm
    156 ms 156 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(pos = 1, ad_id = 0) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
    138 ms 138 ms 1 D:/Websites/graduateguide_PROD/navigation.cfm
    133 ms 133 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc | displayAd(2) ] from D:/Websites/graduateguide_PROD/cfc/AdDataCFC.cfc
    87 ms 87 ms 1 CFC[ D:/Websites/graduateguide_PROD/Application.cfc | onSessionStart() ] from D:/Websites/graduateguide_PROD/Application.cfc
    85 ms 85 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | page_tracking(')U/+W=3/WP , , 0, 1, 2, college_id=985) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
    55 ms 55 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | INIT_tracking() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
    30 ms 30 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | referTracking_save_UA_reference(10, 6779218) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
    30 ms 30 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | sp_referTracking_MV_insert(6779218, 20=985&, 4718202) ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
    28 ms 28 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | sp_referTracking_USER_AGENT_insert() ] from D:/Websites/graduateguide_PROD/cfc/tracking.cfc
    26 ms 26 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
    21 ms 21 ms 1 CFC[ D:/Websites/graduateguide_PROD/cfc/tracking.cfc | page_view_track(pagetypeid = 2, session_UUID = ')U/+W=3/WP , pagename = /college.cfm?college_id=985, PageItemID = 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 = 1) ] from D:/Websites/graduateguide_PROD/cfc/AdRotationCFC.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(SP2 Updates have moved! Please follow @PennSP2 for all the latest news from the School of Social Policy and Practice) ] 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, ')U/+W=3/WP , ) ] 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, ')U/+W=3/WP ) ] 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, 6779218) ] from D:/Websites/graduateguide_PROD/cfc/cf_function.cfc
    0 ms 0 ms 1 D:/Websites/graduateguide_PROD/includes/pod0.cfm
    0 ms 0 ms 1 D:/Websites/security/application.cfm
    59 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
    2027 ms  TOTAL EXECUTION TIME
    red = over 250 ms average execution time


    SQL Queries

    getAdIDs (Datasource=graduateguide_prod, Time=0ms, Records=11, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 17:04:59.059
    	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=3, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 17:04:59.059
    	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=5, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 17:04:59.059
    	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=12, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 17:04:59.059
    	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=4, Cached Query) in D:\Websites\graduateguide_PROD\cfc\AdRotationCFC.cfc @ 17:04:59.059
    	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=26ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:04:59.059
    		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=28ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:04:59.059
    		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=30ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:04:59.059
        UPDATE referTracking_sessionID
        SET agent_ID = ?
        WHERE session_UUID = ? 
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 10
    Parameter #2(cf_sql_integer) = 6779218

    saveStart (Datasource=graduateguide_prod, Time=28ms, Records=1) in D:\Websites\graduateguide_PROD\Application.cfc @ 17:04:59.059
                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) = 6779218

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

    qryGetGallery (Datasource=graduateguide_prod, Time=28ms, Records=3) in D:\Websites\graduateguide_PROD\college.cfm @ 17:04:59.059
    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=28ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:04:59.059
    		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) = 6779218
    Parameter #2(CF_SQL_INTEGER) = 0
    Parameter #3(CF_SQL_INTEGER) = 1
    Parameter #4(CF_SQL_INTEGER) = 2

    qryGetAd (Datasource=graduateguide_prod, Time=22ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:04:59.059
    	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) = 23

    trackAd_viewing (Datasource=graduateguide_prod, Time=130ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:04:59.059
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '02/09/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) = 23

    getSubnav (Datasource=graduateguide_prod, Time=20ms, Records=5) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:04:59.059
    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=20ms, Records=11) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:04:59.059
    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=19ms, Records=6) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:04:59.059
    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=19ms, Records=10) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:04:59.059
    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=18ms, Records=2) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:04:59.059
    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=20ms, Records=5) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:04:59.059
    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=21ms, Records=12) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 17:04:59.059
      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=24ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 17:04:59.059
             Select * From Majors ORDER BY Major ASC
             
    getMajors3 (Datasource=graduateguide_prod, Time=19ms, Records=47) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 17:04:59.059
               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=24ms, Records=52) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 17:05:00.000
             Select * From Majors ORDER BY Major ASC
             
    getAdIDs4 (Datasource=graduateguide_prod, Time=18ms, Records=9) in D:\Websites\graduateguide_PROD\leftNav.cfm @ 17:05:00.000
    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=18ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	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) = 11

    trackAd_viewing (Datasource=graduateguide_prod, Time=80ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '02/09/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) = 11

    qryGetAd (Datasource=graduateguide_prod, Time=20ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	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=97ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '02/09/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=17ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	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=66ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '02/09/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=17ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	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:05:00.000
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '02/09/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

    qryGetAd (Datasource=graduateguide_prod, Time=16ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	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) = 13

    trackAd_viewing (Datasource=graduateguide_prod, Time=64ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '02/09/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) = 13

    qryGetAd (Datasource=graduateguide_prod, Time=17ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	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=63ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '02/09/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=19ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	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=61ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '02/09/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=19ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	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) = 12

    trackAd_viewing (Datasource=graduateguide_prod, Time=60ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '02/09/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) = 12

    qryGetAd (Datasource=graduateguide_prod, Time=19ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	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=59ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:00.000
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '02/09/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

    checkRelated (Datasource=graduateguide_prod, Time=20ms, Records=1) in D:\Websites\graduateguide_PROD\college.cfm @ 17:05:00.000
        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=15ms, Records=1) in D:\Websites\graduateguide_PROD\college.cfm @ 17:05:00.000
            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=19ms, Records=1) in D:\Websites\graduateguide_PROD\college.cfm @ 17:05:00.000
    SELECT college_id FROM banners
    where college_id = ?
    and subcollege_id = 0 and date = '2016-02-09'
    
    Query Parameter Value(s) -
    Parameter #1(cf_sql_integer) = 985

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

    qryGetEditLinks (Datasource=graduateguide_prod, Time=24ms, Records=5) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:05:00.000
    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=28ms, Records=1) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:05:00.000
    UPDATE college_links_track
    SET imps = imps	+ 1
    WHERE clinkid = ? 
    AND edate = '2016-02-09 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=36ms, Records=1) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:05:00.000
    UPDATE college_links_track
    SET imps = imps	+ 1
    WHERE clinkid = ? 
    AND edate = '2016-02-09 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=25ms, Records=1) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:05:01.001
    UPDATE college_links_track
    SET imps = imps	+ 1
    WHERE clinkid = ? 
    AND edate = '2016-02-09 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=35ms, Records=1) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:05:01.001
    UPDATE college_links_track
    SET imps = imps	+ 1
    WHERE clinkid = ? 
    AND edate = '2016-02-09 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=33ms, Records=1) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:05:01.001
    UPDATE college_links_track
    SET imps = imps	+ 1
    WHERE clinkid = ? 
    AND edate = '2016-02-09 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=19ms, Records=1) in D:\Websites\graduateguide_PROD\rightNav.cfm @ 17:05:01.001
    	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=20ms, Records=7) in D:\Websites\graduateguide_PROD\footer.cfm @ 17:05:01.001
    	select * from footer_links_vw
    
    qryGetAd (Datasource=graduateguide_prod, Time=18ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:01.001
    	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) = 194

    trackAd_viewing (Datasource=graduateguide_prod, Time=94ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\AdDataCFC.cfc @ 17:05:01.001
    	DECLARE @adID INT, @currDate varchar(10);
    	SET @adID = ?;
    	SET @currDate = '02/09/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) = 194

    updTracking (Datasource=graduateguide_prod, Time=20ms, Records=1) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:05:01.001
    	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) = 6779218
    Parameter #3(CF_SQL_INTEGER) = 2
    Parameter #4(CF_SQL_INTEGER) = 985


    Stored Procedures

    sp_referTracking_USER_AGENT_insert (Datasource=graduateguide_prod, Time=28ms) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:04:59.059

        
    parameters
    typeCFSQLTypevaluevariabledbVarName
     IN  CF_SQL_VARCHAR  ColdFusion    
        
    resultsets
    nameresultset
     result  1
    sp_referTracking_Query_Variable (Datasource=graduateguide_prod, Time=26ms) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:04:59.059
        
    parameters
    typeCFSQLTypevaluevariabledbVarName
     IN  CF_SQL_VARCHAR  college_id=985    
        
    resultsets
    nameresultset
     result  1
    sp_referTracking_MV_insert (Datasource=graduateguide_prod, Time=29ms) in D:\Websites\graduateguide_PROD\cfc\tracking.cfc @ 17:04:59.059
        
    parameters
    typeCFSQLTypevaluevariabledbVarName
     IN  CF_SQL_INTEGER  6779218    
     IN  CF_SQL_VARCHAR  20=985&    
     IN  CF_SQL_INTEGER  4718202    
        
    resultsets
    nameresultset
    dbo.main_navigation (Datasource=graduateguide_prod, Time=22ms) in D:\Websites\graduateguide_PROD\navigation.cfm @ 17:04:59.059
        
    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=4100363
    CFTOKEN=ae0637992f81d0ea-D0920A15-B08F-D4B2-25ACEF91024D28C4
    POPFIRST=
    SESSION_UUID=%27%29U%2F%2BW%3D3%2FWP%20%20
    SHOW_DEBUG=Yes
    
    Session Variables:
    cfid=4100363
    cftoken=ae0637992f81d0ea-D0920A15-B08F-D4B2-25ACEF91024D28C4
    entryid=6806572
    session_uuid=6779218
    sessionid=GARDUATEGUIDE_4100363_ae0637992f81d0ea-D0920A15-B08F-D4B2-25ACEF91024D28C4
    urltoken=CFID=4100363&CFTOKEN=ae0637992f81d0ea-D0920A15-B08F-D4B2-25ACEF91024D28C4
    
    URL Parameters:
    college_id=985
    
    Debug Rendering Time: 23 ms