VACANT POSTS OF RESIDENT ASSISTANTS
THE UNIVERSITY OF THE WEST INDIES CAVE HILL CAMPUS
OFFICE OF STUDENT SERVICES
 
Applications are invited from suitably qualified persons for the above post for the Academic Year 2019-2020.
 
Requirements:
 
Applicants should hold at least a first Degree or professional qualification. Applicants MUST be registered full-time students in good academic standing with a GPA of 3.0.
 
Previous work experience would be an asset.
 
Interested persons should send their completed application form, cover letter, curriculum vitae and two character references to the Director of Student Services no later than April 4, 2019.
 
 
Job Description
The Resident Assistant (RA) is the live-in person with primary responsibility for his/her Hall community. While RAs are assigned to one hall of residence, they have a shared responsibility for all residents and may be required to fulfill duties on another hall, as directed by the Student Services Manager or Halls Administrator. RAs engage in all aspects of the residential living experience with direction from the Student Services Manager and Halls Administrator. They work closely with the Halls Council to foster a healthy living and learning community. RAs service as a liaison between the University administration and the residents of the hall and help residents to appreciate and comply with University policies and regulations.
 
Compensation
  • Free On-Campus housing
  • Access to professional development
RA-Application

The Office of Student Services
Tel.: (246) 417-4165/6/7 Fax: (246) 424-5348 | Email: studentservices@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 CMSAbstractMenuProperties.OnLoad
25 TypeInfo(cms.document).Events.GetData CMSAbstractMenuProperties.OnLoad
26 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/OSS/outputdata/0096/m2017556925.cache Local ApplicationModule.AuthorizeRequest
2 DIREXISTS
~/App_Themes/OSS_css Local ContentPage.OnPreInit
3 EXISTS
~/CMSControls/960_cave_footer.ascx Local DbPathProvider.GetFileHash
4 EXISTS
~/CMSControls/cave_footer.ascx.cs Local
5 EXISTS
~/CMSControls/cave_footer_menu.ascx Local
6 EXISTS
~/CMSControls/cave_footer_menu.ascx.cs Local
7 EXISTS
~/CMSControls/studentservices/960_cave_header_new.ascx Local
8 EXISTS
~/CMSControls/studentservices/960_cave_header_new.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 public FilterDataSetByPermissions DataSet: DataSet: Table (2 [37], 473 B) read OSS 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|oss|/support-services/resident-assistant|en-us|/support-services/resident-assistant|true
template|297
nodeid|20647
pageinfo
ApplicationModule.PostResolveRequestCache
2 ADD pageinfobyurl|oss|https://www.cavehill.uwi.edu/studentservices/support-services/resident-assistant.aspx|en-us||true|true
template|297
nodeid|20647
pageinfo
ApplicationModule.PostResolveRequestCache
3 GET cms.searchengine|cachedids|crawlers ApplicationModule.PostAcquireRequestState
4 GET pageinfo|oss|/7524|en-us||false PageContext.CurrentPage_InitComplete
5 ADD pageinfo|oss|/|en-us||false
template|298
nodeid|7127
pageinfo
PageContext.CurrentPage_InitComplete
6 GET siteresourcerolespermissions|65|cms.content CMSAbstractMenuProperties.OnLoad
7 ADD breadcrumbs|oss|/7524/21457|en-us|false|cms.menuitem;cms.office||true|
node|oss|/7524/21457|childnodes
CMSAbstractMenuProperties.OnLoad
8 GET cmsmenudatasource||en-us|oss|/%|en-us|false|||nodelevel, nodeorder,nodename|2|true||false|false CMSListMenu.OnLoad
9 GET cmsdatasource||en-us|oss|/7589/%|en-us|false|cms.news||newsreleasedate desc|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|4||false|| BasicRepeater.OnLoad
10 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /support-services/resident-assistant.aspx 0.000
17.547
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 17.547
4.141
 
3 > OnPreInit 21.688
0.000
 
4 > OnInit 21.688
0.063
 
5 > OnLoad 21.750
0.766
 
6 > OnPreRender 22.516
N/A
    22.516  
Request cookies:
 NameValue
1 CMSPreferredCultureen-US
2 CMSCsrfCookie8X30nwoR5JhZ0EmAuNrc51+dVmxC1vFV5maTnsKZ
3 ASP.NET_SessionIdswutkbbb420xhrm5oyfv3rez
4 Campaign 
5 Source 
6 CMSCurrentThemeOSS_css
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-US4/23/2020 6:32:23 PM
2 CMSCsrfCookie8X30nwoR5JhZ0EmAuNrc51+dVmxC1vFV5maTnsKZ 
3 ASP.NET_SessionIdswutkbbb420xhrm5oyfv3rez 
4 Campaign 4/23/2018 6:32:40 PM
5 Source 4/23/2018 6:32:40 PM
6 CMSCurrentThemeOSS_css4/24/2019 6:32:44 PM
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (https://commoncrawl.org/faq/)
4 UserHostAddress54.91.121.255
5 UserLanguagesen-US;en;q=0.5
6 UserName 
7 SessionIDswutkbbb420xhrm5oyfv3rez
8 ServerNameARES2_studentservices
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 = 65;
DECLARE @DocumentUrlPath nvarchar(max) = N'/support-services/resident-assistant';
DECLARE @NodeAliasPath nvarchar(max) = N'/support-services/resident-assistant';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @Now datetime2 = '4/23/2019 6:32:23 PM';

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-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/support-services/resident-assistant' 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.7 kB
 
Table (1 [64], 2.4 kB)
 
ApplicationModule.PostResolveRequestCache 17.484
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
2
(cms.document.generalselect)
DECLARE @NodeSiteID int = 65;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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'/7524', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (2 [157], 3.1 kB)
 
ApplicationModule.PostResolveRequestCache 0.047
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
3
(cms.document.generalselect)
DECLARE @NodeSiteID int = 65;
DECLARE @NodeGUID uniqueidentifier = '5d0ff598-388b-4e9f-95e5-a5804f337984';
DECLARE @Now datetime2 = '4/23/2019 6:32:40 PM';

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))
523 B
 
Table (1 [157], 2.8 kB)
 
ApplicationModule.PostAcquireRequestState 0.031
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
4
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 37909
Table (1 [23], 5.3 kB)
 
ApplicationModule.PostAcquireRequestState 4.031
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
5
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/7524/21457';
DECLARE @ABVariantSiteID int = 65;

SELECT *
FROM OM_ABVariant
WHERE [ABVariantPath] = @ABVariantPath AND [ABVariantSiteID] = @ABVariantSiteID
ApplicationModule.PostAcquireRequestState 0.016
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
6
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 7127;
DECLARE @Now datetime2 = '4/23/2019 6:32:44 PM';

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-US' THEN 2 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 ([DocumentCulture] = @DocumentCulture AND [NodeID] = @NodeID) 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.3 kB
 
Table (1 [64], 364 B)
 
PageContext.CurrentPage_InitComplete 0.031
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
7
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 21457
PageContext.CurrentPage_InitComplete 0.031
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
8
(cms.document.generalselect)
DECLARE @NodeSiteID int = 65;
DECLARE @Now datetime2 = '4/23/2019 6:32:44 PM';
DECLARE @NodeLevel int = 2;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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'/7524/21457', N'/7524', 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 (2 [37], 473 B)
 
CMSAbstractMenuProperties.OnLoad 0.031
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
9
(cms.acl.generalselect)
DECLARE @ACLID int = 74;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
Table (1 [5], 52 B)
 
CMSAbstractMenuProperties.OnLoad 0.016
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
10
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 65;
DECLARE @Date datetime2 = '4/23/2019 6:32:44 PM';

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 (74)

1.3 kB
 
CMSAbstractMenuProperties.OnLoad 0.016
 
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 = 65;

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 (1 [10], 82 B)
 
CMSAbstractMenuProperties.OnLoad 0.656
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
  11 queries, 11.3 kB write, 14.5 kB read   22.391
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% prefix %} Office of Student Services | The University of the West Indies at Cave Hill, Barbados ContentPage.OnLoad 0.000
> prefix Office of Student Services | The University of the West Indies at Cave Hill, Barbados 0.000
2 {% pagetitle_orelse_name %} Resident Assistant 0.000
> pagetitle_orelse_name Resident Assistant 0.000
      
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/studentservices/support-services/resident-assistant.aspx" (57 B)
57 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 RightContentArea
LatestNews
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
NestedControlsID = "" (0 B)
TransformationName = "CMS.News.FSTNewsSimple" (22 B)
ShowEditButton = False
_!ItemCount = 3
ShowDeleteButton = False
HideControlForZeroRows = True
DataSourceName = "" (0 B)
ZeroRowsText = "No data found" (13 B)
AlternatingTransformationName = "" (0 B)
EnablePaging = False
35 B
 
7 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes