Department of Government, Sociology, Social Work & Psychology
Undergraduate Programmes: B.Sc. Psychology with Sociology
Please note that this programme structure acts as a guideline, refer to your Undergraduate Handbook for official programme information.

Please be advised that your 1st year electives are prerequisites for Levels II and IIIcourses Please check the course catalog on CHOL or the Handbook which indicate prerequisites before selecting elective courses
.
 
                                                                                         
LEVEL I                                                                                                                                                                                                                                                                                                                                            
                                                                                                                         

1              PSYC 1004             Introduction to Social Psychology                         
2              PSYC 1003             Introduction to Psychology                                    
3.             SOCI 1001              Introduction to Social Research                            
4.             SOCI 1002              Introduction to Sociology I                                   
5.             MGMT 1000           Introduction to Computers                                    
6.             SOCI 1005              Introductory Statistics for the Behavioural Sciences              
7.             GOVT 1011             Introduction to Caribbean Politics                          
8.             SOCI 1000              Introduction to Sociology II                                   
9.             One (1) of:
                FOUN 1101            Caribbean Civilization OR                                      
                FOUN 1210            Science, Medicine and Technology                         
10.           One (1) of:
                FOUN 1001            English for Academic Purposes OR                         
                FOUN 1008            Rhetoric II: Writing for Special Purposes                  
 
 
LEVEL II
                                                                                                                                                                                                                                                               
1.             SOCI 2000              Classical Social Theory                                          
2              SOCI 2001               Modern Social Theory                                           
3.             PSYC 2012              Developmental Psychology                                    
4.             SOCI 2006              Qualitative Research Methods 
5.             SOCI 2007              Survey Design and Analysis                                  
6.             PSYC 2002             Abnormal Psychology                                            
7.             SOCI 3026              Sociology of Development                                     
8.             PSYC 2003             Physiological Psychology                                       
9-10.        Two (2) approved Level II/III Sociology/ Psychology/ Political Science or
                 Social Work courses.

  
                                         
LEVEL III
                                                                                                                                                                                                                                              
1.             PSYC 2008             Cognitive Psychology                                            
2.             PSYC 2004             Personality Theory and Assessment I                    
3.             PSYC 3017             Personality Theory and Assessment II                   
4-5           PSYC 3021             Research Thesis in Applied Psychology                 
6              PSYC 2009             Learning Theory and Practice                                
7              PSYC 3008             Elements of Counselling and Psychotherapy         
8.             SOCI 3035              Caribbean Social Problems                                    
9.             PSYC 3024             Applied Psychology Research Methods                
10.           One (1) approved Level II/III Sociology/Psychology/Political Science/
                Social Work course.


Department of Government Sociology, Social Work & Psychology
Telephone: (246) 417-4288/4293/4996 Fax: (246) 422-4425 E-mail: gss@cavehill.uwi.edu
Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute ApplicationModule.BeginRequest
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> URLRewritingHandlers.BeginRequest
> WebDAVHandlers.PropFindEndRequest
> WIFIntegrationHandlers.ProcessRequest
2 RequestEvents.Authenticate.Execute ApplicationModule.AuthenticateRequest
> MembershipHandlers.HandleAutomaticSignIn
3 RequestEvents.Authorize.Execute ApplicationModule.AuthorizeRequest
> URLRewritingHandlers.AuthorizeRequest
4 RequestEvents.PostAuthorize.Execute ApplicationModule.PostAuthorizeRequest
> HelpersHandlers.HandleClickjacking
5 RequestEvents.PostResolveRequestCache.Execute ApplicationModule.PostResolveRequestCache
> URLRewritingHandlers.RewriteUrl
6 >> DocumentEvents.GetData ApplicationModule.PostResolveRequestCache
7 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostResolveRequestCache
8 >> DocumentEvents.GetData ApplicationModule.PostResolveRequestCache
9 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostResolveRequestCache
10 >> URLRewritingEvents.ProcessABTest.Execute ApplicationModule.PostResolveRequestCache
>>> ABHandlers.ProcessABTest
11 >> URLRewritingEvents.ProcessRewritingResult ApplicationModule.PostResolveRequestCache
12 RequestEvents.PostMapRequestHandler.Execute ApplicationModule.PostMapRequestHandler
> CsrfProtection.OnPostMapRequestHandlerExecute
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
13 ApplicationEvents.SessionStart.Execute CMSHttpApplication.Session_Start
> MembershipHandlers.SessionStart
14 >> SessionEvents.UpdateSession CMSHttpApplication.Session_Start
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
15 RequestEvents.AcquireRequestState.Execute ApplicationModule.AcquireRequestState
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
16 RequestEvents.PostAcquireRequestState.Execute ApplicationModule.PostAcquireRequestState
> MembershipHandlers.UpdateSession
17 >> SessionEvents.UpdateSession ApplicationModule.PostAcquireRequestState
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
18 >> DocumentEvents.GetData ApplicationModule.PostAcquireRequestState
19 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostAcquireRequestState
20 >>>> TypeInfo(cms.versionhistory).Events.GetData ApplicationModule.PostAcquireRequestState
21 >> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
22 >>> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
23 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
24 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
25 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
26 DocumentEvents.GetData PageContext.CurrentPage_InitComplete
27 TypeInfo(cms.document.slider.cameraitem).Events.GetData PageContext.CurrentPage_InitComplete
28 DocumentEvents.GetData CMSAbstractMenuProperties.OnLoad
29 TypeInfo(cms.document).Events.GetData CMSAbstractMenuProperties.OnLoad
30 TypeInfo(cms.acl).Events.GetData CMSAbstractMenuProperties.OnLoad
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/App_Data/Persistent/Cache/GSSW/outputdata/00AA/m994682497.cache Local ApplicationModule.AuthorizeRequest
2 DIREXISTS
~/App_Themes/FSSDepartmentCSS Local ContentPage.OnPreInit
3 EXISTS
~/CMSControls/960_cave_footer.ascx Local DbPathProvider.GetFileHash
4 EXISTS
~/CMSControls/cave_footer.ascx.cs Local
5 EXISTS
~/CMSControls/fss/960_cave_header_new.ascx Local
6 EXISTS
~/CMSControls/fss/960_cave_header_new.ascx.cs Local
7 EXISTS
~/CMSControls/fss/department_footer.ascx Local
8 EXISTS
~/CMSControls/fss/department_footer.ascx.cs Local
9 EXISTS
~/CMSWebParts/navigation/cmsbreadcrumbs.ascx Local
10 EXISTS
~/CMSWebParts/Navigation/cmsbreadcrumbs.ascx.cs Local
11 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
12 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
13 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
14 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Security checks called by this request / thread:
 UserOperationResultResource / Class / IDPermission / UI element / ValueSite / DomainContext
1 ValidateHash True currentsite.sitedisplaynameadministrator PageContext.CurrentPage_InitComplete
2 public FilterDataSetByPermissions DataSet: DataSet: Table (3 [37], 775 B) read GSSW CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False
CheckPrivilegeLevel False GlobalAdmin CMSAbstractMenuProperties.OnLoad
        
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 GET pageinfo|gssw|/7337|en-gb||false ApplicationModule.PostResolveRequestCache
2 ADD pageinfo|gssw|/7337/8844|en-gb||false
template|295
nodeid|8778
pageinfo
ApplicationModule.PostResolveRequestCache
3 ADD pageinfo|gssw|/undergraduate-programmes/psychology/psychology-with-sociology|en-gb|/undergraduate-programmes/psychology/psychology-with-sociology|true
template|295
nodeid|8322
pageinfo
ApplicationModule.PostResolveRequestCache
4 ADD pageinfobyurl|gssw|https://www.cavehill.uwi.edu/fss/gssw/undergraduate-programmes/psychology/psychology-with-sociology.aspx|en-gb||true|true
template|295
nodeid|8322
pageinfo
ApplicationModule.PostResolveRequestCache
5 GET cms.searchengine|cachedids|crawlers ApplicationModule.PostAcquireRequestState
6 GET pageinfo|gssw|/|en-gb||false PageContext.CurrentPage_InitComplete
7 GET siteresourcerolespermissions|62|cms.content CMSAbstractMenuProperties.OnLoad
8 ADD breadcrumbs|gssw|/7337/8844/8386|en-gb|false|cms.menuitem;cms.office||true|
node|gssw|/7337/8844/8386|childnodes
CMSAbstractMenuProperties.OnLoad
9 GET cmsmenudatasource||en-gb|newfacultyofsocialsciences|/%|en-gb|false|cms.menuitem|||2|true||false|false CMSListMenu.OnLoad
10 GET cmsmenudatasource||en-gb|gssw|/%|en-gb|false|cms.menuitem|||2|true||false|false CMSTreeMenu.OnLoad
11 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /undergraduate-programmes/psychology/psychology-with-sociology.aspx 0.000
1.047
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 1.047
1.797
 
3 > OnPreInit 2.844
0.000
 
4 > OnInit 2.844
0.078
 
5 > OnLoad 2.922
0.922
 
6 > OnPreRender 3.844
N/A
    3.844  
Request cookies:
 NameValue
1 CMSPreferredCultureen-GB
2 CMSCsrfCookieGPYIANwyxKaBvjhcuv9HquBiPU/pCv/qK/wfAcEp
3 ASP.NET_SessionIdovgaibvkg4ngkxn1e0vhsbkd
4 Campaign 
5 Source 
6 CMSCurrentThemeFSSDepartmentCSS
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-GB24/04/2020 10:21:46
2 CMSCsrfCookieGPYIANwyxKaBvjhcuv9HquBiPU/pCv/qK/wfAcEp 
3 ASP.NET_SessionIdovgaibvkg4ngkxn1e0vhsbkd 
4 Campaign 24/04/2018 10:21:47
5 Source 24/04/2018 10:21:47
6 CMSCurrentThemeFSSDepartmentCSS25/04/2019 10:21:49
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (https://commoncrawl.org/faq/)
4 UserHostAddress54.90.86.231
5 UserLanguagesen-US;en;q=0.5
6 UserName 
7 SessionIDovgaibvkg4ngkxn1e0vhsbkd
8 ServerNameARES2_fss_gssw
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
new SqlConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
1
(.generalselect)
DECLARE @NodeSiteID int = 62;
DECLARE @DocumentUrlPath nvarchar(max) = N'/undergraduate-programmes/psychology/psychology-with-sociology';
DECLARE @NodeAliasPath nvarchar(max) = N'/undergraduate-programmes/psychology/psychology-with-sociology';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';
DECLARE @Now datetime2 = '4/24/2019 10:21:46 AM';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-GB' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/undergraduate-programmes/psychology/psychology-with-sociology' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.8 kB
 
Table (1 [64], 18.6 kB)
 
ApplicationModule.PostResolveRequestCache 0.750
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
2
(.generalselect)
DECLARE @NodeSiteID int = 62;
DECLARE @NodeAliasPath nvarchar(max) = N'/7337/8844';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';
DECLARE @Now datetime2 = '4/24/2019 10:21:47 AM';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-GB' THEN 2 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE ([NodeSiteID] = @NodeSiteID AND ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.4 kB
 
Table (1 [64], 2 kB)
 
ApplicationModule.PostResolveRequestCache 0.031
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
3
(cms.document.generalselect)
DECLARE @NodeSiteID int = 62;
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/7337', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (2 [157], 3.5 kB)
 
ApplicationModule.PostResolveRequestCache 0.047
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
4
(cms.document.generalselect)
DECLARE @NodeSiteID int = 62;
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/7337/8844', N'/7337', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (3 [157], 5.9 kB)
 
ApplicationModule.PostResolveRequestCache 0.219
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
5
(cms.document.generalselect)
DECLARE @NodeSiteID int = 62;
DECLARE @NodeGUID uniqueidentifier = 'de17eca2-8646-4c91-8824-28362480c0ad';
DECLARE @Now datetime2 = '4/24/2019 10:21:47 AM';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [NodeGUID] = @NodeGUID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
524 B
 
Table (1 [157], 19 kB)
 
ApplicationModule.PostAcquireRequestState 0.125
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
6
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 20320
Table (1 [23], 32 kB)
 
ApplicationModule.PostAcquireRequestState 1.531
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
7
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/7337/8844/8386';
DECLARE @ABVariantSiteID int = 62;

SELECT *
FROM OM_ABVariant
WHERE [ABVariantPath] = @ABVariantPath AND [ABVariantSiteID] = @ABVariantSiteID
ApplicationModule.PostAcquireRequestState 0.063
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
8
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 8386
PageContext.CurrentPage_InitComplete 0.016
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
9
(slider.cameraitem.generalselect)
DECLARE @NodeSiteID int = 62;
DECLARE @Now datetime2 = '4/24/2019 10:21:49 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Images/Rotator%';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN slider_cameraitem AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.CameraitemID AND V.ClassName = N'slider.cameraitem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
768 B
 
Table (2 [166], 1.7 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
10
(cms.document.generalselect)
DECLARE @NodeSiteID int = 62;
DECLARE @Now datetime2 = '4/24/2019 10:21:49 AM';
DECLARE @NodeLevel int = 3;
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [NodeSiteID], [NodeACLID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings], [DocumentID]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE ([NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/7337/8844/8386', N'/7337/8844', N'/7337', N'/'))) AND ([ClassName] IN (N'CMS.MenuItem', N'cms.office')) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeAliasPath DESC
1.5 kB
 
Table (3 [37], 775 B)
 
CMSAbstractMenuProperties.OnLoad 0.344
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
11
(cms.acl.generalselect)
DECLARE @ACLID int = 70;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
Table (1 [5], 52 B)
 
CMSAbstractMenuProperties.OnLoad 0.203
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
12
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 62;
DECLARE @Date datetime2 = '4/24/2019 10:21:49 AM';

SELECT DISTINCT X.Allowed,X.Denied,X.ValidTo,X.ACLID
FROM (
SELECT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, null AS 'ValidTo',CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
WHERE
--User
(CMS_ACLItem.UserID IN (SELECT CMS_User.UserID FROM CMS_User JOIN CMS_UserSite ON CMS_User.UserID = CMS_UserSite.UserID
WHERE CMS_User.UserID = @UserID AND CMS_UserSite.SiteID = @SiteID )
-- Specific roles
OR CMS_ACLItem.RoleID IN (SELECT RoleID FROM CMS_Role WHERE RoleName IN ('_everyone_','_notauthenticated_'))
)
-- Membership
UNION ALL
SELECT DISTINCT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, UserRole.ValidTo, CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
INNER JOIN [View_CMS_UserRoleMembershipRole] AS UserRole ON UserRole.RoleID = CMS_ACLItem.RoleID
WHERE (UserRole.ValidTo > @Date OR UserRole.ValidTo IS NULL)
AND (UserRole.SiteID = @SiteID OR UserRole.SiteID IS NULL)
AND UserRole.UserID = @UserID
) AS X
WHERE ACLID IN (70)

1.3 kB
 
CMSAbstractMenuProperties.OnLoad 0.016
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
13
(cms.class.selectrequiredroles)
DECLARE @ClassID int = 2214;
DECLARE @PermissionName nvarchar(max) = N'read';
DECLARE @SiteID int = 62;

SELECT * FROM CMS_Role WHERE RoleID IN (SELECT RoleID FROM CMS_RolePermission WHERE PermissionID IN (SELECT PermissionID FROM CMS_Permission WHERE ClassID=@ClassID AND PermissionName=@PermissionName)) AND (SiteID=@SiteID OR SiteID IS NULL)
Table (2 [10], 182 B)
 
CMSAbstractMenuProperties.OnLoad 0.328
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
  13 queries, 12.7 kB write, 83 kB read   3.688
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% currentsite.sitedisplayname %} Department of Government, Sociology, Social Work & Psychology administrator PageContext.CurrentPage_InitComplete 0.016
 
> currentsite.sitedisplayname Department of Government, Sociology, Social Work & Psychology administrator 0.000
 
2 {% prefix %} Department of Government, Sociology, Social Work and Psychology ContentPage.OnLoad 0.000
 
> prefix Department of Government, Sociology, Social Work and Psychology 0.000
 
3 {% pagetitle_orelse_name %} Psychology with Sociology 0.000
 
> pagetitle_orelse_name Psychology with Sociology 0.000
 
      
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/fss/gssw/undergraduate-programmes/psychology/psychology-with-sociology.aspx" (76 B)
76 B
 
2 p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
3 lt
cave_header1
DropDownList1
No
No
AutoPostBack = True
Width = 119px
0 B
 
4 lt
cave_header1
ImageButton1
No
ImageUrl = "http://www.cavehill.uwi.edu/CMSSiteFiles/images/go_button.png" (61 B)
61 B
 
5 lt
partPlaceholder
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
6 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes