Department of Government, Sociology, Social Work & Psychology
Undergraduate Programmes: B.Sc. Psychology with Political Science
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 III courses.  Please check the course catalog on CHOL or the Handbook which indicate prerequisites before selecting elective courses
.
 

 LEVEL 1     
                                                                                                                     
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.             One (1) of:
                FOUN 1101            Caribbean Civilization OR                                      
                FOUN 1210            Science, Medicine and Technology                         
9.             One (1) of:
                FOUN 1001            English for Academic Purposes OR                       
                FOUN 1008            Rhetoric II: Writing for Special Purposes               
10.           One (1) of:                                                                                                                             
                SOCI 1000              Introduction to Sociology II                                   
                MGMT 1001           Introduction to Management                                   
                ECON 1001            Introduction to Microeconomics                            
                ECON 1002            Introduction to Macroeconomics                           
                GOVT 1000            Introduction to Political Institutions and Analysis     
                SOWK 1001           Introduction to Social Work                                  
 
 
LEVEL II
                                                                                                                                                                                                    
1.             PSYC 2012             Developmental Psychology                                    
2.             SOCI 2006              Qualitative Research Methods
3.             SOCI 2007              Survey Design and Analysis                                  
4.             PSYC 2003             Physiological Psychology                                      
5.             PSYC 2002             Abnormal Psychology                                           
6.             PSYC 2009             Learning Theory and Practice                                
7.            GOVT 2014             Western Political Thought                                      
8.            GOVT 2015              Modern Political Thought                                      
9.            One (1) approved Level II/III Political Science course.
10.          One (1) approved Level II/III course.                                                          
               
                                                          
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 3024             Applied Psychology Research Methods                
7              PSYC 3008             Elements of Counselling and Psychotherapy         
8.             GOVT 3017            Caribbean Governance I                                         
9.             GOVT 3018            Caribbean Governance II                                       
10.           One (1) of:
                PSYC 2025             Communication Psychology                                   
                PSYC 3013             Contemporary Issues in Social Psychology             
                PSYC 3014             Industrial and Organisational Psychology                
                PSYC 2026             Gender and Psychology                                          
                PSYC 2015             Culture and Psychology                                         

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 >> URLRewritingEvents.ProcessABTest.Execute ApplicationModule.PostResolveRequestCache
>>> ABHandlers.ProcessABTest
9 >> URLRewritingEvents.ProcessRewritingResult ApplicationModule.PostResolveRequestCache
10 RequestEvents.PostMapRequestHandler.Execute ApplicationModule.PostMapRequestHandler
> CsrfProtection.OnPostMapRequestHandlerExecute
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
11 ApplicationEvents.SessionStart.Execute CMSHttpApplication.Session_Start
> MembershipHandlers.SessionStart
12 >> SessionEvents.UpdateSession CMSHttpApplication.Session_Start
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
13 RequestEvents.AcquireRequestState.Execute ApplicationModule.AcquireRequestState
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
14 RequestEvents.PostAcquireRequestState.Execute ApplicationModule.PostAcquireRequestState
> MembershipHandlers.UpdateSession
15 >> SessionEvents.UpdateSession ApplicationModule.PostAcquireRequestState
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
16 >> DocumentEvents.GetData ApplicationModule.PostAcquireRequestState
17 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostAcquireRequestState
18 >>>> TypeInfo(cms.versionhistory).Events.GetData ApplicationModule.PostAcquireRequestState
19 >> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
20 >>> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
21 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
22 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
23 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
24 DocumentEvents.GetData PageContext.CurrentPage_InitComplete
25 TypeInfo(cms.document.slider.cameraitem).Events.GetData PageContext.CurrentPage_InitComplete
26 DocumentEvents.GetData CMSAbstractMenuProperties.OnLoad
27 TypeInfo(cms.document).Events.GetData CMSAbstractMenuProperties.OnLoad
28 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/00B2/m1800710742.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], 799 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/8844|en-gb||false ApplicationModule.PostResolveRequestCache
2 GET pageinfo|gssw|/7337|en-gb||false
3 ADD pageinfo|gssw|/undergraduate-programmes/psychology/psychology-with-political-science|en-gb|/undergraduate-programmes/psychology/psychology-with-political-science|true
template|295
nodeid|8323
pageinfo
ApplicationModule.PostResolveRequestCache
4 ADD pageinfobyurl|gssw|https://www.cavehill.uwi.edu/fss/gssw/undergraduate-programmes/psychology/psychology-with-political-science.aspx|en-gb||true|true
template|295
nodeid|8323
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/8387|en-gb|false|cms.menuitem;cms.office||true|
node|gssw|/7337/8844/8387|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-political-science.aspx 0.000
0.141
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.141
1.250
 
3 > OnPreInit 1.391
0.000
 
4 > OnInit 1.391
0.109
 
5 > OnLoad 1.500
0.281
 
6 > OnPreRender 1.781
N/A
    1.781  
Request cookies:
 NameValue
1 CMSPreferredCultureen-GB
2 CMSCsrfCookieFH0bxWYOrffWchuESfAliD/SK5YVqt656GqNeJ9d
3 ASP.NET_SessionIdmg0egxs0pfaijfy354ru2rpv
4 Campaign 
5 Source 
6 CMSCurrentThemeFSSDepartmentCSS
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-GB24/04/2020 10:28:48
2 CMSCsrfCookieFH0bxWYOrffWchuESfAliD/SK5YVqt656GqNeJ9d 
3 ASP.NET_SessionIdmg0egxs0pfaijfy354ru2rpv 
4 Campaign 24/04/2018 10:28:48
5 Source 24/04/2018 10:28:48
6 CMSCurrentThemeFSSDepartmentCSS25/04/2019 10:28: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 SessionIDmg0egxs0pfaijfy354ru2rpv
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-political-science';
DECLARE @NodeAliasPath nvarchar(max) = N'/undergraduate-programmes/psychology/psychology-with-political-science';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';
DECLARE @Now datetime2 = '4/24/2019 10:28:48 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-political-science' 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], 20 kB)
 
ApplicationModule.PostResolveRequestCache 0.109
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
2
(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.031
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
3
(cms.document.generalselect)
DECLARE @NodeSiteID int = 62;
DECLARE @NodeGUID uniqueidentifier = 'f241a054-540c-4640-b032-33fb76677756';
DECLARE @Now datetime2 = '4/24/2019 10:28:48 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], 21 kB)
 
ApplicationModule.PostAcquireRequestState 0.016
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
4
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 20321
Table (1 [23], 34 kB)
 
ApplicationModule.PostAcquireRequestState 1.156
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
5
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/7337/8844/8387';
DECLARE @ABVariantSiteID int = 62;

SELECT *
FROM OM_ABVariant
WHERE [ABVariantPath] = @ABVariantPath AND [ABVariantSiteID] = @ABVariantSiteID
ApplicationModule.PostAcquireRequestState 0.031
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
6
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 8387
PageContext.CurrentPage_InitComplete 0.031
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
7
(slider.cameraitem.generalselect)
DECLARE @NodeSiteID int = 62;
DECLARE @Now datetime2 = '4/24/2019 10:28: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.031
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
8
(cms.document.generalselect)
DECLARE @NodeSiteID int = 62;
DECLARE @Now datetime2 = '4/24/2019 10:28: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/8387', 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], 799 B)
 
CMSAbstractMenuProperties.OnLoad 0.047
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
9
(cms.acl.generalselect)
DECLARE @ACLID int = 70;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
Table (1 [5], 52 B)
 
CMSAbstractMenuProperties.OnLoad 0.031
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
10
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 62;
DECLARE @Date datetime2 = '4/24/2019 10:28: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.047
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
11
(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.156
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
  11 queries, 9 kB write, 84 kB read   1.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.000
> 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 Political Science 0.000
> pagetitle_orelse_name Psychology with Political Science 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-political-science.aspx" (84 B)
84 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