HEALTH INSURANCE
The Sagicor CariCARE Medical Assistance Plan is a Comprehensive Major Medical Plan that functions on a reimbursement basis. This plan does NOT cover Vision, Dental, Maternity and Routine Services.
 
When claiming you must fully complete and sign the claim form and attach all relating itemized bills/receipts.
 
Refund cheques are collected from The Office of Student Services during office hours Monday – Friday from 8:30 am – 4:30 pm.

NOTE: CLAIMS MUST BE SUBMITTED WITHIN 3 MONTHS OF BEING INCURRED TO BE ELIGIBLE FOR REIMBURSEMENT

For further assistance please contact the Health Plan Administrator at 417-4165/4915

Schedule of Benefits
UNIVERSITY OF THE WEST INDIES
CARICARE HEALTH INSURANCE SCHEDULE OF BENEFITS
Policy Number GB1000768
   
Comprehensive Major Medical  
Benefit Maximum for each student $100,000.00
Benefit Period (University Lifetime)
Deductible per calendar year $50.00
Benefit Payment: Co-insurance Percentage
On the First $20,000 per Calendar Year 80%
Thereafter for the remainder of the Calendar Year 100%
   
Carry Over provision Last Three (3) Months of Calendar Year
   
Pre-existing Condition (Maximum per Disability) Applicable to New Students ONLY          $1,000.00
   
Internal Plan Limits: (Applies toward Lifetime Major Medical Maximum)
AIDS or AIDS-related illnesses $20,000.00
   
   
Daily Room and Board Limit (Subject to the deductible & Co-insurance)
Local  $300.00
Overseas Caricom $1,000.00
Intensive Care 2.5 times ASPRR
ASPRR Means "Average Semi-Private Room Rate"  
   
Surgical Expense Benefit  
Benefit Payment  After the deductible 80% of R & C Charges
   
Other Hospital Services Benefit  
Benefit Payment  After the deductible 80% of R & C Charges
   
Miscellaneous Benefit  
Benefit Payment  After the deductible 80% of R & C Charges
   
Prescription Drug Benefit (Not Subject to the deductible)
Benefit Payment  80% of R & C Charges
   
Diagnostic Expense Benefit  
Benefit Payment  After the deductible 80% of R & C Charges
   
Doctors Visit Benefit (Office, Home, Hospital)
Benefit Payment  
Outside of University Panel After the deductible 80% of R & C Charges
Within Panel $30.00
   
Specialist(by referral only)  
Benefit Payment  
Out of Network After the deductible 80% of R & C Charges
Within Network $50.00
Within Panel Not Subject to Deductible or Co-insurance
   
Emergency Doctors Visit Benefit (Home/Hospital)  
Benefit Payment After the deductible 80% of R & C Charges
   
Psychiatric Benefit (Subject to the deductible & Co-insurance)
Lifetime Maximum (Applicable to Out-patient & Hospital Care) $25,000.00
Out-patient Care  
Maximum per Treatment $50.00
Co-insurance percentage 50%
Maximum visits per year 20
Hospital Confinement  
Co-insurance after deductible 80%
   
Physiotherapy and other Health Care Professional Groups  
Maximum per visit  $40.00
Benefit Payment  After the deductible 80%
   
Local Ground Ambulance  
Benefit Payment Percentage  After the deductible 80% of R & C Charges
   
Medical Air Transportation Benefit  
Maximum Number of Trips per Calendar Year 2
Airfare (Subject to the deductible & Co-insurance)
Benefit Maximum per calendar year $1,500
Benefit Payment  Percentage 80%
Emergency Air Ambulance ( Not Subject to the deductible  or Co-insurance)
Benefit Payment percentage 100%
Medical Air Transportation Limited to the Caribbean Region
   
Preventative Care  
Annual GYN and Pap Smear test for each female student $35
Annual Proctology/Prostate Examination for each male student age 40 and over $35
   
*R & C - Reasonable and Customary
   
NB 80% of the Reasonable and Customary Charges are eligible for reimbursement
   
Prescription Drugs Reimbursement/Payment limited to "prescribed drugs" as setout and required by law in the insurer's jurisdiction

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/0093/196853984.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], 466 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 GET pageinfo|oss|/7247|en-us||false ApplicationModule.PostResolveRequestCache
2 ADD pageinfo|oss|/health-wellness/health-insurance|en-us|/health-wellness/health-insurance|true
template|297
nodeid|7467
pageinfo
ApplicationModule.PostResolveRequestCache
3 ADD pageinfobyurl|oss|https://www.cavehill.uwi.edu/studentservices/health-wellness/health-insurance.aspx|en-us||true|true
template|297
nodeid|7467
pageinfo
ApplicationModule.PostResolveRequestCache
4 GET cms.searchengine|cachedids|crawlers ApplicationModule.PostAcquireRequestState
5 GET pageinfo|oss|/|en-us||false PageContext.CurrentPage_InitComplete
6 GET siteresourcerolespermissions|65|cms.content CMSAbstractMenuProperties.OnLoad
7 ADD breadcrumbs|oss|/7247/7526|en-us|false|cms.menuitem;cms.office||true|
node|oss|/7247/7526|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 /health-wellness/health-insurance.aspx 0.000
0.438
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.438
0.438
 
3 > OnPreInit 0.875
0.000
 
4 > OnInit 0.875
0.078
 
5 > OnLoad 0.953
0.328
 
6 > OnPreRender 1.281
N/A
    1.281  
Request cookies:
 NameValue
1 CMSPreferredCultureen-US
2 CMSCsrfCookieRQR5ZT+pu2Y62310YP8aRp80Upk/sCTXYCanReAP
3 ASP.NET_SessionIduzl0tkvo2ifkfymk135t1aoj
4 Campaign 
5 Source 
6 CMSCurrentThemeOSS_css
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-US4/24/2020 11:06:53 AM
2 CMSCsrfCookieRQR5ZT+pu2Y62310YP8aRp80Upk/sCTXYCanReAP 
3 ASP.NET_SessionIduzl0tkvo2ifkfymk135t1aoj 
4 Campaign 4/24/2018 11:06:54 AM
5 Source 4/24/2018 11:06:54 AM
6 CMSCurrentThemeOSS_css4/25/2019 11:06:54 AM
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 SessionIDuzl0tkvo2ifkfymk135t1aoj
8 ServerNameARES1_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'/health-wellness/health-insurance';
DECLARE @NodeAliasPath nvarchar(max) = N'/health-wellness/health-insurance';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @Now datetime2 = '4/24/2019 11:06:53 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-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/health-wellness/health-insurance' 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], 14.3 kB)
 
ApplicationModule.PostResolveRequestCache 0.297
 
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'/7247', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (2 [157], 7.9 kB)
 
ApplicationModule.PostResolveRequestCache 0.109
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
3
(cms.document.generalselect)
DECLARE @NodeSiteID int = 65;
DECLARE @NodeGUID uniqueidentifier = '65a58b3e-86a5-4b7f-94af-d0ffc6f5ad07';
DECLARE @Now datetime2 = '4/24/2019 11:06:54 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], 14.6 kB)
 
ApplicationModule.PostAcquireRequestState 0.047
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
4
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 32910
Table (1 [23], 20 kB)
 
ApplicationModule.PostAcquireRequestState 0.281
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
5
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/7247/7526';
DECLARE @ABVariantSiteID int = 65;

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 = 7526
PageContext.CurrentPage_InitComplete 0.063
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
7
(cms.document.generalselect)
DECLARE @NodeSiteID int = 65;
DECLARE @Now datetime2 = '4/24/2019 11:06:54 AM';
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'/7247/7526', N'/7247', 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], 466 B)
 
CMSAbstractMenuProperties.OnLoad 0.109
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
8
(cms.acl.generalselect)
DECLARE @ACLID int = 74;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
Table (1 [5], 52 B)
 
CMSAbstractMenuProperties.OnLoad 0.063
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
9
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 65;
DECLARE @Date datetime2 = '4/24/2019 11:06:54 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 (74)

1.3 kB
 
CMSAbstractMenuProperties.OnLoad 0.047
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
10
(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.094
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
  10 queries, 8.1 kB write, 58 kB read   1.156
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 %} Health Insurance 0.000
> pagetitle_orelse_name Health Insurance 0.000
      
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/studentservices/health-wellness/health-insurance.aspx" (54 B)
54 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