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

LEVEL I

                                                                                                                                               
1.  SOCI 1001  Introduction to Social Research                          
2.  SOCI 1000  Introduction to Sociology II                                   
3.  SOCI 1002  Introduction to Sociology I                                  
4.  One (1) of:
     FOUN 1001  English for Academic Purposes OR                      
     FOUN 1008  Rhetoric II: Writing for Special Purposes             
5.  SOCI 1005    Introductory Statistics for the Behaviour Sciences            
6.  GOVT 1000   Introduction to Political Institutions and Analysis  
7.  GOVT 1011   Introduction to Caribbean Politics                          
8.  MGMT 1000  Introduction to Computers                                                                                        
9.  One (1) of:
     FOUN 1101   Caribbean Civilization OR                                     
     FOUN 1210   Science, Medicine and Technology                       
10. One (1) of:
      ECON 1001  Introduction to Microeconomics                            
      ECON 1002  Introduction to Macroeconomics                           
      HIST 1004    Introductory History of the Caribbean                   
      INRL1000     Introduction to International Relations                   
 

 LEVEL II
            
1.  SOCI 2000     Classical Social Theory                                        
2.  SOCI 2001     Modern Social Theory                                         
3.  SOCI 2006     Qualitative Methods in Sociological Research       
4.  SOCI 2007     Survey Design and Analysis                                 
5.  GOVT 2014    Western Political Thought                                     
6.  GOVT 2015     Modern Political Thought                                     
7.  SOCI 3026      Sociology of Development                                   
8.  SOCI 3035      Caribbean Social Problems 
                                                                                                   
 9. One (1) of:
     GOVT 2010    Politics of Developing Nations                              
     GOVT 2024    Contemporary Political Democracy                      
     GOVT 3014    Theories of International Politics                           
10. An approved Level II/III course.
 
 
LEVEL III
                                                                                                                                                  
1-2.  SOCI 3000  Supervised Research Study OR                            
        Any two (2) approved Level II/III Sociology courses
3.     SOCI 3012  Caribbean Social Planning                                     
4.     SOCI 3013  Caribbean Social Policy                                        
5-6. Any two (2) Level II or III Sociology courses not previously selected.
7.    GOVT 3017 Caribbean Governance I                                       
8.    GOVT 3018 Caribbean Governance II                                      
9-10.  Any two (2) approved Level II/III courses from the Department of Government,
          Sociology and Social Work
               

 

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/00B0/207652708.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], 792 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 ADD pageinfo|gssw|/undergraduate-programmes/sociology/sociology-with-political-science|en-gb|/undergraduate-programmes/sociology/sociology-with-political-science|true
template|295
nodeid|8727
pageinfo
ApplicationModule.PostResolveRequestCache
2 ADD pageinfobyurl|gssw|https://www.cavehill.uwi.edu/fss/gssw/undergraduate-programmes/sociology/sociology-with-political-science.aspx|en-gb||true|true
template|295
nodeid|8727
pageinfo
ApplicationModule.PostResolveRequestCache
3 GET cms.searchengine|cachedids|crawlers ApplicationModule.PostAcquireRequestState
4 GET pageinfo|gssw|/7337/8847|en-gb||false PageContext.CurrentPage_InitComplete
5 GET pageinfo|gssw|/7337|en-gb||false
6 GET pageinfo|gssw|/|en-gb||false
7 GET siteresourcerolespermissions|62|cms.content CMSAbstractMenuProperties.OnLoad
8 ADD breadcrumbs|gssw|/7337/8847/8793|en-gb|false|cms.menuitem;cms.office||true|
node|gssw|/7337/8847/8793|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/sociology/sociology-with-political-science.aspx 0.000
0.406
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.406
0.375
 
3 > OnPreInit 0.781
0.000
 
4 > OnInit 0.781
0.156
 
5 > OnLoad 0.938
0.297
 
6 > OnPreRender 1.234
N/A
    1.234  
Request cookies:
 NameValue
1 CMSPreferredCultureen-GB
2 CMSCsrfCookieiAc9gTsv/JRwxxqnoQBaOt2alb1pUq9xwJAwr1HC
3 ASP.NET_SessionIdqbpei0dt1cfawwndx0wwqkza
4 Campaign 
5 Source 
6 CMSCurrentThemeFSSDepartmentCSS
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-GB24/04/2020 10:39:30
2 CMSCsrfCookieiAc9gTsv/JRwxxqnoQBaOt2alb1pUq9xwJAwr1HC 
3 ASP.NET_SessionIdqbpei0dt1cfawwndx0wwqkza 
4 Campaign 24/04/2018 10:39:30
5 Source 24/04/2018 10:39:30
6 CMSCurrentThemeFSSDepartmentCSS25/04/2019 10:39:30
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 SessionIDqbpei0dt1cfawwndx0wwqkza
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/sociology/sociology-with-political-science';
DECLARE @NodeAliasPath nvarchar(max) = N'/undergraduate-programmes/sociology/sociology-with-political-science';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';
DECLARE @Now datetime2 = '4/24/2019 10:39:30 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/sociology/sociology-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], 12 kB)
 
ApplicationModule.PostResolveRequestCache 0.297
 
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/8847', N'/7337', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (3 [157], 9.7 kB)
 
ApplicationModule.PostResolveRequestCache 0.063
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
3
(cms.document.generalselect)
DECLARE @NodeSiteID int = 62;
DECLARE @NodeGUID uniqueidentifier = 'e857d342-3999-4970-85e8-080a36d0959e';
DECLARE @Now datetime2 = '4/24/2019 10:39:30 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], 12.3 kB)
 
ApplicationModule.PostAcquireRequestState 0.063
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
4
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 20334
Table (1 [23], 21 kB)
 
ApplicationModule.PostAcquireRequestState 0.219
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
5
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/7337/8847/8793';
DECLARE @ABVariantSiteID int = 62;

SELECT *
FROM OM_ABVariant
WHERE [ABVariantPath] = @ABVariantPath AND [ABVariantSiteID] = @ABVariantSiteID
ApplicationModule.PostAcquireRequestState 0.047
 
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 = 8793
PageContext.CurrentPage_InitComplete 0.047
 
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:39:30 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.047
 
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:39:31 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/8847/8793', N'/7337/8847', 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], 792 B)
 
CMSAbstractMenuProperties.OnLoad 0.094
 
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.047
 
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:39:31 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.063
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
  11 queries, 9 kB write, 57 kB read   1.031
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 %} Sociology with Political Science 0.000
> pagetitle_orelse_name Sociology 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/sociology/sociology-with-political-science.aspx" (82 B)
82 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