Staging web site. (this banner will not appear on your "live" website)

Shopping cart is empty !

Last Viewed

Courses

Welcome to the Augusoft Lifelong Learning Center Online Registration site. Online registration is available 24 hours a day, seven days a week. Online Registration for University of Augusoft is secured by one of the most reputable providers of online purchasing on the internet, and your information will not be shared with third parties.

For Augusoft Lifelong Learning Center policies and information, and other ways to register for courses, please visit the Augusoft Continuing Education website. Even if you are not quite ready to register, you can sign in now and create a student login, password and profile. When you do register, this will streamline the process and save you time.

Courses Header: Update your site by replacing this text with your own message.

Creative Arts

Painting

Enrichment

Culinary

Professional Development

Courses Footer: Update your site by replacing this text with your own message.

Debugging Information

ColdFusion Server Enterprise	2021,0,21,330446
Template	/index.cfm
Time Stamp	18-Aug-25 01:35 PM
Locale	English (US)
User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP	172.31.102.63
Host Name	172.31.102.63

Execution Time

Total Time	Avg Time	Count	Template
598 ms	598 ms	1	CFC[ E:/Lumens/Application.cfc \| onRequest(/index.cfm) ] from E:/Lumens/Application.cfc
598 ms	598 ms	1	E:/Lumens/Versions/v81ERPQA/index.cfm
567 ms	567 ms	1	E:/Lumens/Versions/v81ERPQA/Fusebox1.cfm
219 ms	219 ms	1	E:/Lumens/Versions/v81ERPQA/templates/courses.cfm
176 ms	176 ms	1	CFC[ E:/Lumens/Application.cfc \| onRequestStart(/index.cfm) ] from E:/Lumens/Application.cfc
160 ms	160 ms	1	E:/Lumens/Versions/v81ERPQA/globalVariables.cfm
145 ms	145 ms	1	E:/Lumens/Versions/v81ERPQA/SQL/CatSubcatQry.cfm
144 ms	144 ms	1	E:/Lumens/Versions/v81ERPQA/Administration/SQL/CourseSubMenuQry.cfm
31 ms	16 ms	2	E:/Lumens/Versions/v81ERPQA/SQL/GetCatalog.cfm
31 ms	31 ms	1	E:/Lumens/Versions/v81ERPQA/header.cfm
31 ms	31 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/header_section.cfm
16 ms	8 ms	2	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getGraphicsDetails(1) ] from E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
16 ms	16 ms	1	E:/Lumens/Versions/v81ERPQA/SQL/GetExternalCourseProvider.cfm
15 ms	15 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/includes/nav-main.cfm
0 ms	0 ms	1	CFC[ E:/Lumens/Application.cfc \| onSessionStart() ] from E:/Lumens/Application.cfc
0 ms	0 ms	3	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/cart/cart_dao.cfc \| INIT(AnthologyDev2) ] from E:/Lumens/Versions/v81ERPQA/cfc/cart/cart_dao.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/ColorUtils.cfc \| INIT() ] from E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/ColorUtils.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| INIT() ] from E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getSiteResourcePathDetailsByID(1) ] from E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getsocialNetIconsControlFields(1) ] from E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| setLearnerfieldOrder(1, 90) ] from E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/app_setup.cfc \| FindApplicationCustomer(LumensCustomers, anthologydev2.augusoft.net) ] from E:/Lumens/app_setup.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/app_setup.cfc \| INIT() ] from E:/Lumens/app_setup.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc \| getRequestIPAddress() ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc \| processRequest(ip_address = 216.73.216.101) ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc \| shouldReInitialize() ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
0 ms	0 ms	3	CFC[ E:/Lumens/versions/v81ERPQA/cfc/cart/cart.cfc \| init(AnthologyDev2) ] from E:/Lumens/versions/v81ERPQA/cfc/cart/cart.cfc
0 ms	0 ms	8	CFC[ E:/Lumens/versions/v81ERPQA/cfc/cart/cart.cfc \| isCartExist() ] from E:/Lumens/versions/v81ERPQA/cfc/cart/cart.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/cart/cart.cfc \| isCartMerchandiseExist() ] from E:/Lumens/versions/v81ERPQA/cfc/cart/cart.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/merchandise/merchandise.cfc \| init(AnthologyDev2) ] from E:/Lumens/versions/v81ERPQA/cfc/merchandise/merchandise.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/stylesheet/styleManager.cfc \| styleExists(AnthologyDev2, /Customers/AnthologyDev2) ] from E:/Lumens/versions/v81ERPQA/cfc/stylesheet/styleManager.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/systemoptions/poweruser/poweruser.cfc \| INIT() ] from E:/Lumens/versions/v81ERPQA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/systemoptions/poweruser/poweruser.cfc \| getFooterNavItems() ] from E:/Lumens/versions/v81ERPQA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/systemoptions/poweruser/poweruser.cfc \| getUserNavItems() ] from E:/Lumens/versions/v81ERPQA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/textEdit.cfc \| returnText(courses, 1, 1, AnthologyDev2, ) ] from E:/Lumens/versions/v81ERPQA/cfc/textEdit.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/textEdit.cfc \| returnText(courses, 2, 1, AnthologyDev2, ) ] from E:/Lumens/versions/v81ERPQA/cfc/textEdit.cfc
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/Administration/SQL/CustomizationsQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/Administration/SQL/FeatureConfigurationQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/Administration/SQL/MenuQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/Administration/Templates/prcLoadCourseSubMenu.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/AppVariables.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/Circuits.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/SQL/CatalogIsExternal.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/SQL/ContentsQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/SQL/GetDefaultCatalog.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/SQL/RegionDetailQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/checkPermission.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/footer.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/intercepts.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/nLoadVars.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/plugins/GlobalFunctions.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/templates/checkPermissionForUserRole.cfm
0 ms	0 ms	2	E:/Lumens/Versions/v81ERPQA/templates/loggedUserDetail.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/udf/getText.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/udf/index.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/udf/logger.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/back-top-desktop.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/back-top-mobile.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/branding-logo.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/cart/act_cart_action.cfm
0 ms	0 ms	2	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/cart/cart.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/client-logo-footer.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/client-logo.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/facebook-pixel.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/google-analytics.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/google-tag-manager.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/menu_action.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/nav-footer-buttons.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/nav-social-media.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/nav-user.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/search-mobile.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/search.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/footer_section.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/includes/custom_style.cfm
0 ms	0 ms	2	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/includes/nav-account.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/includes/nav-banner.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/includes/nav-last-viewed.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/includes/nav-mobile.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/view/css/style.cfm
0 ms	0 ms	1	E:/Lumens/shared/CustomTags/UpdateMetaTagContent.cfm
0 ms	0 ms	1	E:/Lumens/shared/CustomTags/UpdatePageTitle.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
774 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

Exceptions

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 121

	    Element ROOMNAME is undefined in REQUESTROOMRSVNQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 128

	    Element CLASSTIMEDISPLAY is undefined in VARIABLES.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 135

	    Element LOCATIONNAME is undefined in REQUESTROOMRSVNQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 142

	    Element CLASSNAME is undefined in REQUESTROOMRSVNQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 163

	    Element CLASSSETUP.EVENTNAME is undefined in SESSION.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 170

	    Variable CLASSSCHEDULEDISP is undefined.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 177

	    Element ROOMNAME is undefined in GETROOMDATAFOREMAILQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 184

	    Element ROOMCONTACTNAME is undefined in GETROOMDATAFOREMAILQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 191

	    Element LOCATIONNAME is undefined in GETROOMDATAFOREMAILQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 201

	    Element BIRTHDATE is undefined in GETLEARNERAGEQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 208

	    Element GRADELEVEL is undefined in GETLEARNERAGEQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 222

	    Element COMPANYNAME is undefined in MASTERROSTERQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 229

	    Element COMPANYUSER is undefined in MASTERROSTERQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 236

	    Element BASECLASSFEE is undefined in MASTERROSTERQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 244

	    Element COURSENUMBER is undefined in MASTERROSTERQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 252

	    Element CLASSDESCRIPTION is undefined in MASTERROSTERQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 259

	    Element CLASSSCHEDULEDISPLAY is undefined in VARIABLES.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 266

	    Element INSTRNAME is undefined in MASTERROSTERQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 121

	    Element ROOMNAME is undefined in REQUESTROOMRSVNQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 128

	    Element CLASSTIMEDISPLAY is undefined in VARIABLES.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 135

	    Element LOCATIONNAME is undefined in REQUESTROOMRSVNQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 142

	    Element CLASSNAME is undefined in REQUESTROOMRSVNQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 163

	    Element CLASSSETUP.EVENTNAME is undefined in SESSION.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 170

	    Variable CLASSSCHEDULEDISP is undefined.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 177

	    Element ROOMNAME is undefined in GETROOMDATAFOREMAILQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 184

	    Element ROOMCONTACTNAME is undefined in GETROOMDATAFOREMAILQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 191

	    Element LOCATIONNAME is undefined in GETROOMDATAFOREMAILQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 201

	    Element BIRTHDATE is undefined in GETLEARNERAGEQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 208

	    Element GRADELEVEL is undefined in GETLEARNERAGEQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 222

	    Element COMPANYNAME is undefined in MASTERROSTERQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 229

	    Element COMPANYUSER is undefined in MASTERROSTERQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 236

	    Element BASECLASSFEE is undefined in MASTERROSTERQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 244

	    Element COURSENUMBER is undefined in MASTERROSTERQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 252

	    Element CLASSDESCRIPTION is undefined in MASTERROSTERQRY.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 259

	    Element CLASSSCHEDULEDISPLAY is undefined in VARIABLES.

13:35:32.032 - Expression Exception - in E:/Lumens/Versions/v81ERPQA/udf/getText.cfm : line 266

	    Element INSTRNAME is undefined in MASTERROSTERQRY.

SQL Queries

checkAccessControlRules (Datasource=LumensCustomers, Time=0ms, Records=10) in E:\Lumens\Versions\v81ERPQA\checkPermission.cfm @ 13:35:31.031

SELECT DISTINCT ACA.int_actor_type_id
			FROM tbl_access_control_rules ACR
			INNER JOIN tbl_access_control_allow ACA ON ACR.int_access_rule_id = ACA.int_access_rule_id
			WHERE
				
					str_fuse_action LIKE ? 
				AND ISNULL(ACA.int_actor_type_id,'')<>''
				AND ACA.bit_allow = 1

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = 1010

FeatureConfigurationQry (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\FeatureConfigurationQry.cfm @ 13:35:31.031

SET NOCOUNT ON

	DECLARE @UsesRefundRequest CHAR(1)

	SET @UsesRefundRequest = 0
	SET @UsesRefundRequest = (
			SELECT 1
			FROM RefundPaymentMethods
			WHERE RefundPaymentMethodID = 7
				AND STATUS = 'A'
			)

	SELECT TOP 1 rg.RegionID
		, rg.NAME
		, rg.Address1
		, rg.Address2
		, rtrim(rg.City) + ', ' + rg.STATE + '  ' + rg.Zip AS CSZ
		, rg.Phone1
		, rg.SiteTitle
		, rg.Footer
		/**/
		, rg.prefooter
		, rg.brandingfooter
		/**/
		, rg.MetaText
		, rg.EmailAux4
		, IsNull((
				SELECT Fee
				FROM Products
				WHERE Code = 'REGFEE'
					AND STATUS = 'A'
					AND RegionID = rg.RegionID
				), 0.00) AS RegistrationFee
		, IsNull((
				SELECT Fee
				FROM Products
				WHERE Code = 'DEFERRED_PAYMENT_FEE'
					AND STATUS = 'A'
					AND RegionID = rg.RegionID
				), 0.00) AS deferred_payment_fee
		, fc.*
		, @UsesRefundRequest AS UsesRefundRequest
		, rg.privacy_data_mask_id
		, rg.str_google_verify
		, rg.str_yahoo_verify
		, rg.str_hubspot_portal_id
		, rg.str_hubspot_salog_version
		, rg.str_hubspot_ppa
		, rg.str_genoo_api_key
		, rg.str_genoo_tracking_code
		, rg.TimeZoneHourAdjustment
		/**/
		/**/
		/**/
		, e.str_erp_name
		/**/
		/**/
		, CAST(DecryptByKeyAutoCert(cert_id('LumensCert'), NULL, ec.varbin_erp_password) AS NVARCHAR(500)) AS str_erp_password_decrypted
		/**/
		/**/
		, rg.theURL
		, rg.URLText
		, rg.str_analytics_linked_domains
		, rg.GTMContainerID
		, rg.str_social_media_sharing
		, ec.*
		, (
			SELECT TOP 1 Description
			FROM PaymentMethods
			WHERE PaymentMethodID >= 200
				AND STATUS = 'A'
		) AS str_internal_payment_method_name
	FROM FeatureConfiguration fc
	INNER JOIN Regions rg ON fc.RegionID = rg.RegionID
	LEFT JOIN tbl_erp e ON fc.int_erp_id = e.int_erp_id
	LEFT JOIN tbl_erp_config ec ON ec.str_erp_url <> ''
	WHERE rg.STATUS = 'A'

qryGetRegion (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\globalVariables.cfm @ 13:35:31.031

SELECT regionId,orgID
				FROM featureConfigurationQry
				WHERE baseurl LIKE '%anthologydev2.augusoft.net%'

qGetCoursesItemDetails (Datasource=AnthologyDev2, Time=16ms, Records=1) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\CourseSubMenuQry.cfm @ 13:35:31.031

SELECT Label
		,STATUS
		, dbo.fun_strip_html(Label) as LabelNoHTML
	FROM MenuItems WITH (NOLOCK)
	WHERE SiteURL = 'index.cfm?fuseaction=1010'

qgetUserNavLabel (Datasource=AnthologyDev2, Time=1ms, Records=1) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\CourseSubMenuQry.cfm @ 13:35:31.031

SELECT str_user_nav_label
			, dbo.fun_strip_html(str_user_nav_label) as str_user_nav_label_noHTML
		FROM tbl_user_nav_menu_label WITH (NOLOCK)
		WHERE int_menu_item_id = 1
			AND int_actor_type_id  = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

CatSubcatQry (Datasource=AnthologyDev2, Time=95ms, Records=4) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\CourseSubMenuQry.cfm @ 13:35:31.031

SET NOCOUNT ON
			SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
			DECLARE @str_alt AS VARCHAR(max)
				, @intNumber_wAltSubCat AS INT
				, @RegionID BIGINT
				, @MemberShipTypeID INT
				, @currentTimeZoneOffsetDate DATETIME2 = ?;

			SET @RegionID = ?;
			SET @MemberShipTypeID = ?

			SET @intNumber_wAltSubCat = (
					SELECT COUNT(tcl.ClassListingID) AS Number_wAltSubCat
					FROM tbl_class_listing tcl
					
					WHERE str_alt_subcategory_ids IS NOT NULL 
						AND str_alt_subcategory_ids <> ''
						AND
						/**/
						
							@currentTimeZoneOffsetDate BETWEEN tcl.AppearanceStartDate AND tcl.AppearanceEndDate
						
						/**/
						AND 0 < (
							CASE 
								WHEN tcl.str_class_type = 'CS'
									THEN (
											SELECT COUNT(ClassID)
											FROM Classes Cl
											INNER JOIN tbl_class_course_series_group tcc ON tcc.int_class_id = CL.ClassID
											WHERE tcc.int_Series_group_id = tcl.int_course_series_group_id
												AND Cl.Status = 'A'
											)
								ELSE 1
								END
							) 
						/**/
						
							AND tcl.bit_display_to_public = 1 /**/
						
								AND NOT EXISTS (
									SELECT 1
									FROM tbl_restriction_code_detail
									WHERE int_table_id = 2 /*classes*/
										AND int_primary_key_id = tcl.ClassID
								)
							
					)

			
			IF object_id('tempdb..#temp') IS NOT NULL
			BEGIN
				DROP TABLE #temp
			END

			/* sample code obtained from http://rafudb.blogspot.com/2009/04/sysconnectbypath-in-sql-server_24.html */
			/* This flattens the comma delimited values from several rows into one field and places them into a temp table */
			IF @intNumber_wAltSubCat > 0
			BEGIN
				SELECT DISTINCT t.[value]
				INTO #temp
				FROM tbl_class_listing tcl WITH (NOLOCK)
				
				CROSS APPLY STRING_SPLIT(str_alt_subcategory_ids,',') t
				WHERE str_alt_subcategory_ids IS NOT NULL
				AND
				/**/
				
					@currentTimeZoneOffsetDate BETWEEN tcl.AppearanceStartDate AND tcl.AppearanceEndDate
				
				/**/
				
					AND tcl.bit_display_to_public = 1 /**/
				
						AND NOT EXISTS (
							SELECT 1
							FROM tbl_restriction_code_detail
							WHERE int_table_id = 2 /*classes*/
								AND int_primary_key_id = tcl.ClassID
						)
					

				SELECT c.OrgID
					,c.RegionID
					,c.CategoryID
					,c.NAME AS CategoryName
					,dbo.fun_strip_html(c.NAME) as CategoryNameNoHTML
					,sc.SubcategoryID
					,(
						SELECT ExternalCourseProviderID
						FROM ExternalCourseProvider
						WHERE DefaultSubcategoryID = sc.SubCategoryID
						) AS ExternalCourseProviderID
					,sc.NAME AS SubcategoryName
					,dbo.fun_strip_html(sc.NAME) as SubcategoryNameNoHTML
					,c.SortOrder AS categsortorder
					,sc.SortOrder AS subcategsortorder
				FROM Categories c
				INNER JOIN SubCategories sc ON c.CategoryID = sc.CategoryID
				WHERE c.STATUS = 'A'
					AND sc.STATUS = 'A'
					AND c.RegionID = @RegionID
					AND (
						/**/
						EXISTS (
							SELECT Subcategories.subcategoryid
							FROM Classes
							LEFT JOIN Catalogs ON Classes.CatalogID = Catalogs.CatalogID
							INNER JOIN Courses ON Classes.CourseID = Courses.CourseID
							
							INNER JOIN tbl_class_detail tcd ON tcd.int_class_id = Classes.ClassID 
								/**/
									AND ( Classes.STATUS = 'A' OR Classes.STATUS = 'C' )
								/**/
								
									AND (tcd.bit_display_to_public = 1)
									/**/
									AND Classes.classid IN (
										SELECT classid
										FROM tbl_class_listing cl1
										LEFT JOIN MembershipTypes mt1 
											ON mt1.MembershipTypeID IN (
												SELECT value 
												FROM STRING_SPLIT(cl1.str_limit_self_reg_mbrship_type_ids, ',')
											)
										WHERE (
											MemberShipTypeID = @MemberShipTypeID
											OR bit_display_classes_members_only = 0 
										)
											/**/
										
										UNION
										
										SELECT classid
										FROM tbl_class_listing cl1
										WHERE (cl1.str_limit_self_reg_mbrship_type_ids = '')
											OR (cl1.str_limit_self_reg_mbrship_type_ids IS NULL)
											OR (cl1.str_limit_self_reg_mbrship_type_ids = '0')
										)
									/**/
								
								/* */
								
									AND @currentTimeZoneOffsetDate BETWEEN Classes.AppearanceStartDate AND DateAdd(ms, - 10, Classes.AppearanceEndDate)
								
								/**/
								AND Classes.ClassID NOT IN (
									SELECT cx.ClassID
									FROM ProgramSectionClasses cx
									GROUP BY cx.ClassID
									)
							INNER JOIN Subcategories ON Subcategories.SubcategoryID = Courses.SubcategoryID
								AND Subcategories.SubcategoryID = sc.SubCategoryID
								
									AND Subcategories.int_displayed_in_category IN (
										SELECT int_displayed_in_category
										FROM tbl_displayed_in_category
										WHERE (
												str_displayed_in_category LIKE 'Classes'
												OR str_displayed_in_category LIKE 'Both'
												)
									)
									
										AND Subcategories.bit_available_to_students = 1
									
									WHERE NOT EXISTS (
										SELECT 1
										FROM tbl_restriction_code_detail
										WHERE int_table_id = 2 /*classes*/
											AND int_primary_key_id = Classes.ClassID
									)
								
						)
						/**/
						OR sc.subcategoryid IN (
							SELECT [value]
							FROM #temp
						)
						/**/
						OR sc.subcategoryid IN (
								/**/
								/*Select SubCategoryID from tbl_class_listing where int_course_series_group_id > 0*/
								SELECT DISTINCT CL.SubCategoryID
								FROM tbl_class_listing CL
								INNER JOIN CourseSeriesGroups CSG ON CSG.SeriesGroupID = CL.int_course_series_group_id
								INNER JOIN tbl_course_series_type cst ON cst.int_course_series_type_id = CSG.int_course_series_type_id
								INNER JOIN tbl_class_course_series_group ccsg ON ccsg.int_Series_group_id = CL.int_course_series_group_id
								INNER JOIN Classes ON classes.ClassID = ccsg.int_class_id
								INNER JOIN tbl_class_detail tcd ON tcd.int_class_id = Classes.ClassID 
									/* */
									
										AND (csg.bit_disp_cs_to_public = 1)
										/**/
										AND Classes.classid IN (
											SELECT classid
											FROM tbl_class_listing cl1
											LEFT JOIN MembershipTypes mt1 
												ON mt1.MembershipTypeID IN (
													SELECT value 
													FROM STRING_SPLIT(cl1.str_limit_self_reg_mbrship_type_ids, ',')
												)
											WHERE (
												MemberShipTypeID = @MemberShipTypeID
												OR bit_display_classes_members_only = 0 /**/
											)
											
											UNION
											
											SELECT classid
											FROM tbl_class_listing cl1
											WHERE (cl1.str_limit_self_reg_mbrship_type_ids = '')
												OR (cl1.str_limit_self_reg_mbrship_type_ids IS NULL)
												OR (cl1.str_limit_self_reg_mbrship_type_ids = '0')
											)
										/**/
									
									/* */
								WHERE 
									
										@currentTimeZoneOffsetDate BETWEEN Classes.AppearanceStartDate AND DateAdd(ms, - 10, Classes.AppearanceEndDate) 
									
									/**/
									AND 0 = (
										SELECT Count(cl3.classid)
										FROM classes cl3
										WHERE classID = ccsg.int_class_id
											AND STATUS IN ('X','D','I','R')
										)
									/**/
								)
						/**/
						/**/
						/**/
						OR sc.subcategoryid IN (
								SELECT SubCategoryID
								FROM tbl_class_listing tcl
								INNER JOIN tbl_certificates_classes tcc ON tcc.int_class_id = tcl.ClassID
								INNER JOIN Classes c ON c.ClassID = tcl.ClassID
								INNER JOIN tbl_class_detail tcd ON tcd.int_class_id = c.ClassID 
									
										AND (tcl.bit_display_to_public = 1)
										/**/
										AND c.ClassID IN (
											SELECT classid
											FROM tbl_class_listing cl1
											LEFT JOIN MembershipTypes mt1 
												ON mt1.MembershipTypeID IN (
													SELECT value 
													FROM STRING_SPLIT(cl1.str_limit_self_reg_mbrship_type_ids, ',')
												)
											WHERE (
												MemberShipTypeID = @MemberShipTypeID
												OR bit_display_classes_members_only = 0 /**/	
											)
											
											UNION
											
											SELECT classid
											FROM tbl_class_listing cl1
											WHERE (cl1.str_limit_self_reg_mbrship_type_ids = '')
												OR (cl1.str_limit_self_reg_mbrship_type_ids IS NULL)
												OR (cl1.str_limit_self_reg_mbrship_type_ids = '0')
											)
										/**/
									
								)
						/* */
						/**/
						OR sc.subcategoryid IN (
								SELECT DISTINCT cl.SubCategoryID
								FROM tbl_class_listing CL
								
								INNER JOIN tbl_certificates tc ON CL.int_certificate_id = tc.int_certificate_id
									AND tc.chr_status = 'P'
								WHERE CL.str_class_type = 'cf'
									AND @currentTimeZoneOffsetDate BETWEEN CL.AppearanceStartDate
										AND DateAdd(ms, - 10, CAST(CL.AppearanceEndDate AS DATETIME2)) 
										
											AND tc.bit_display_to_public = 1 
										
												AND NOT EXISTS (
													SELECT 1
													FROM tbl_restriction_code_detail
													WHERE int_table_id = 2 /*classes*/
														AND int_primary_key_id = CL.ClassID
												)
											
								)
						/**/
					)
				ORDER BY c.SortOrder
					,c.NAME
					,sc.SortOrder
					,sc.NAME

				DROP TABLE #temp
			END
			ELSE
			BEGIN
				SELECT c.OrgID
					,c.RegionID
					,c.CategoryID
					,c.NAME AS CategoryName
					,dbo.fun_strip_html(c.NAME) as CategoryNameNoHTML
					,sc.SubcategoryID
					,(
						SELECT ExternalCourseProviderID
						FROM ExternalCourseProvider
						WHERE DefaultSubcategoryID = sc.SubCategoryID
						) AS ExternalCourseProviderID
					,sc.NAME AS SubcategoryName
					,dbo.fun_strip_html(sc.NAME) as SubcategoryNameNoHTML
					,c.SortOrder AS categsortorder
					,sc.SortOrder AS subcategsortorder
				FROM Categories c
				INNER JOIN SubCategories sc ON c.CategoryID = sc.CategoryID
				WHERE c.STATUS = 'A'
					AND sc.STATUS = 'A'
					AND c.RegionID = 1
					AND (
						EXISTS (
							SELECT Subcategories.subcategoryid
							FROM Classes
							LEFT JOIN Catalogs ON Classes.CatalogID = Catalogs.CatalogID
							INNER JOIN Courses ON Classes.CourseID = Courses.CourseID
							
							INNER JOIN tbl_class_detail tcd ON tcd.int_class_id = Classes.ClassID /**/
								AND (
									Classes.STATUS = 'A'
									OR Classes.STATUS = 'C'
									)
								/**/
								
									AND (tcd.bit_display_to_public = 1)
									/**/
									AND Classes.classid IN (
										SELECT classid
										FROM tbl_class_listing cl1
										LEFT JOIN MembershipTypes mt1 
											ON mt1.MembershipTypeID IN (
												SELECT value 
												FROM STRING_SPLIT(cl1.str_limit_self_reg_mbrship_type_ids, ',')
											)
										WHERE (
											MemberShipTypeID = @MemberShipTypeID
											OR bit_display_classes_members_only = 0 /**/
										)
										
										UNION
										
										SELECT classid
										FROM tbl_class_listing cl1
										WHERE (cl1.str_limit_self_reg_mbrship_type_ids = '')
											OR (cl1.str_limit_self_reg_mbrship_type_ids IS NULL)
											OR (cl1.str_limit_self_reg_mbrship_type_ids = '0')
										)
									/**/
								
								/**/
								/**/
								
									AND @currentTimeZoneOffsetDate BETWEEN Classes.AppearanceStartDate AND DateAdd(ms, - 10, Classes.AppearanceEndDate)
								
								/**/
								AND Classes.ClassID NOT IN (
									SELECT cx.ClassID
									FROM ProgramSectionClasses cx
									GROUP BY cx.ClassID
									)
							INNER JOIN Subcategories ON Subcategories.SubcategoryID = Courses.SubcategoryID
								AND Subcategories.SubcategoryID = sc.SubCategoryID
								
									AND Subcategories.int_displayed_in_category IN (
										SELECT int_displayed_in_category
										FROM tbl_displayed_in_category
										WHERE (
												str_displayed_in_category LIKE 'Classes'
												OR str_displayed_in_category LIKE 'Both'
												)
									)
									
										AND Subcategories.bit_available_to_students = 1
									
									WHERE NOT EXISTS (
										SELECT 1
										FROM tbl_restriction_code_detail
										WHERE int_table_id = 2 /*classes*/
											AND int_primary_key_id = Classes.ClassID
									)
								
						)
					)
				ORDER BY c.SortOrder
					,c.NAME
					,sc.SortOrder
					,sc.NAME
			END
			SET TRANSACTION ISOLATION LEVEL READ COMMITTED

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_timestamp) = 2025-08-18 13:35:31.5

			    
			        Parameter #2(cf_sql_bigint) = 1

			    
			        Parameter #3(cf_sql_integer) = 0

getCat (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\CourseSubMenuQry.cfm @ 13:35:31.031

SELECT DISTINCT categoryid
				,categoryname
				,CategoryNameNoHTML
				, LOWER(CategoryNameNoHTML) categorynamesort
			, categsortorder
			FROM CatSubCatQry
			ORDER BY categsortorder
				, categorynamesort

getSubCat (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\CourseSubMenuQry.cfm @ 13:35:31.031

SELECT categoryid
					,subcategoryname
					,subcategoryid
					,SubcategoryNameNoHTML
				FROM CatSubCatQry
				WHERE categoryid = 3
				ORDER BY subcategsortorder
					,subcategoryname

getSubCat (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\CourseSubMenuQry.cfm @ 13:35:31.031

SELECT categoryid
					,subcategoryname
					,subcategoryid
					,SubcategoryNameNoHTML
				FROM CatSubCatQry
				WHERE categoryid = 2
				ORDER BY subcategsortorder
					,subcategoryname

getSubCat (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\CourseSubMenuQry.cfm @ 13:35:31.031

SELECT categoryid
					,subcategoryname
					,subcategoryid
					,SubcategoryNameNoHTML
				FROM CatSubCatQry
				WHERE categoryid = 1
				ORDER BY subcategsortorder
					,subcategoryname

qCatalog (Datasource=AnthologyDev2, Time=16ms, Records=2) in E:\Lumens\Versions\v81ERPQA\SQL\GetCatalog.cfm @ 13:35:31.031

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
	DECLARE @currentTimeZoneOffsetDate AS DATETIME2 = ?;

	SELECT Name
		, STATUS
		, Catalogs.CatalogID
		, SortOrder
		, CampusCode
		
		, AvailableForRequest
		, CASE 
			WHEN EXISTS (
					SELECT 'x'
					FROM Classes
					INNER JOIN tbl_class_listing tcl ON classes.classid = tcl.classid
					WHERE Classes.STATUS IN ('A','C')
						
						AND @currentTimeZoneOffsetDate BETWEEN Classes.AppearanceStartDate
							AND Classes.AppearanceEndDate
						AND tcl.bit_display_to_public = 1 
						
						AND (
							Classes.CatalogID = Catalogs.CatalogID
							OR (',' + RTRIM(tcl.str_alt_catalog_ids) + ',') LIKE '%,' + CAST(Catalogs.CatalogID AS VARCHAR) + ',%'
							)
					)
				THEN 1
			ELSE 0
			END AS ClassActive
		, CASE WHEN CatalogClsCnt.CatalogID IS NOT NULL OR AltCatalogClsCnt.CatalogID IS NOT NULL
				THEN 1
			ELSE 0
			END AS EverHadClass
		, str_catalog_display_name
		, bit_hide_from_menu AS hide_from_menu
		, dbo.fun_strip_html(Name) AS NameNoHTML
	FROM Catalogs 
	LEFT JOIN (
		SELECT COUNT(ClassID) AS Cnt
			, CatalogID
		FROM Classes
		GROUP BY CatalogId
		HAVING COUNT(ClassID) > 0
	) CatalogClsCnt ON CatalogClsCnt.CatalogID = Catalogs.CatalogID
	LEFT JOIN (
		SELECT COUNT(tcd.int_class_id) AS cnt
			, altCatalogs.value AS CatalogID
		FROM tbl_class_detail tcd
		CROSS APPLY STRING_SPLIT(tcd.str_alt_catalog_ids, ',') altCatalogs
		WHERE tcd.str_alt_catalog_ids IS NOT NULL AND TRIM(tcd.str_alt_catalog_ids) != ''
		GROUP BY altCatalogs.value
		HAVING COUNT(tcd.int_class_id) > 0
	) AltCatalogClsCnt ON AltCatalogClsCnt.CatalogID = Catalogs.CatalogID
	WHERE 1 = 1
		
	ORDER BY SortOrder
	SET TRANSACTION ISOLATION LEVEL READ COMMITTED

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_timestamp) = 2025-08-18 13:35:31.595

qCatalog1 (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\CourseSubMenuQry.cfm @ 13:35:31.031

SELECT * FROM qCatalog WHERE ClassActive = 1 AND status = 'A' AND  hide_from_menu = 0 AND SortOrder <> 0

qActiveCertificateCount (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\CourseSubMenuQry.cfm @ 13:35:31.031

SELECT COUNT(int_certificate_id) AS ct_count
			FROM tbl_certificates WITH (NOLOCK)
			WHERE chr_status = 'P'
				
					AND bit_display_to_public = 1

qActiveCourseSeriesCount (Datasource=AnthologyDev2, Time=15ms, Records=1) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\CourseSubMenuQry.cfm @ 13:35:31.031

DECLARE @currentTimeZoneOffsetDate DATETIME2 = ?;
			SELECT COUNT(ClassListingID) AS cs_count
			FROM tbl_class_listing tbl WITH (NOLOCK)
			INNER JOIN tbl_class_course_series_group ccsg WITH (NOLOCK) ON ccsg.int_Series_group_id = tbl.int_course_series_group_id
			INNER JOIN Classes WITH (NOLOCK) ON classes.ClassID = ccsg.int_class_id
			WHERE tbl.chr_status = 'A'
				AND tbl.str_class_type = 'CS'
				AND @currentTimeZoneOffsetDate BETWEEN tbl.AppearanceStartDate
					AND DateAdd(ms, - 10, tbl.AppearanceEndDate)
				AND 0 = (
					SELECT Count(cl3.classid)
					FROM classes cl3 WITH (NOLOCK)
					WHERE classID = ccsg.int_class_id
						AND STATUS IN ('X','D','I','R')
					)
				
					AND tbl.bit_display_to_public = 1

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_timestamp) = 2025-08-18 13:35:31.611

MenuQry (Datasource=AnthologyDev2, Time=0ms, Records=10) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\MenuQry.cfm @ 13:35:31.031

SET NOCOUNT ON

			SELECT OrgID
				, RegionID
				, MenuItemID
				, MenuItemType
				, MainLevel
				, SubLevel
				
				,MainLevelSortOrder
				, SubLevelSortOrder
				, 
					SiteURL
				
				, AccessLevel
				, IsNull(DisplayCriteria_1, '') AS DisplayCriteria_1
				
				, IsNull(DisplayValue_1, '') AS DisplayValue_1
				, IsNull(DisplayCriteria_2, '') AS DisplayCriteria_2
				, IsNull(DisplayValue_2, '') AS DisplayValue_2
				, Condition
				, LTRIM(RTRIM(IsNull(NewWindowName, ''))) AS NewWindowName
				, m.Label AS UniqueLable
				
				, CASE
					WHEN str_user_nav_label IS NULL
						THEN CASE
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9440'
									THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Membership', 'Membership')
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9620'
									THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Member', 'Member')
										/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'Donate'
									THEN Replace(m.Label, 'Donate', 'Donate')
										/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'MERCHANDISE'
									THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise')
								WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships'
									THEN Replace(m.Label, 'Scholarships', 'Scholarship')
								ELSE Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"')
								END
					ELSE
						/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
						CASE
							WHEN str_menu_label LIKE 'Donate'
								THEN (str_user_nav_label)
							ELSE str_user_nav_label
							END
						/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
					END AS Label
				
				, CASE
					WHEN str_user_nav_label IS NULL
						THEN CASE
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9440'
									THEN Replace(m.Label, 'Membership', 'Membership')
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9620'
									THEN Replace(m.Label, 'Member', 'Member')
									/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'Donate'
									THEN Replace(m.Label, 'Donate', 'Donate')
									/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'MERCHANDISE'
									THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise')
								WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships'
									THEN Replace(m.Label, 'Scholarships', 'Scholarship')
								ELSE m.Label
								END
					ELSE
						/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
						CASE
							WHEN str_menu_label LIKE 'Donate'
								THEN dbo.fun_strip_html((str_user_nav_label))
							ELSE dbo.fun_strip_html(str_user_nav_label)
							END
						/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
					END AS LabelNoHTML 
				
				, ISNULL(int_parent_id,0) as int_parent_id
				, int_sort_order
				, m.UniqueLabel
				, m.bit_default_behavior
			FROM MenuItems m
			LEFT JOIN tbl_user_nav_menu_label u ON m.MenuItemID = u.int_menu_item_id
			WHERE STATUS = 'A'
				AND SubCategoryID IS NULL
				AND (
					
						int_actor_type_id = ?
						OR
						(
							int_actor_type_id IS NULL
							AND AccessLevel = ?
						)
					
				)
				
				AND ISNULL(SiteURL, '') NOT LIKE 'index.cfm?fuseaction=1010' /*29 MAY 2012 NEO 00043 TRACKER 29863*/
				
			ORDER BY int_sort_order

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

			    
			        Parameter #2(cf_sql_integer) = 90

qGetDashboardName (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\MenuQry.cfm @ 13:35:31.031

SET ANSI_NULLS ON

		SELECT IsNull((
					CASE
						WHEN str_dashboard_name = ''
							THEN NULL
						ELSE str_dashboard_name
						END
					), CASE
					WHEN ActorTypeID = 55
						THEN 'Dashboard'
					ELSE 'my dashboard'
					END) AS str_dashboard_name /* 02 APRIL 2014 NEO 0088 TRACKER 40005 */
		FROM ActorTypes
		WHERE ActorTypeID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

qLearnerfields (Datasource=AnthologyDev2, Time=0ms, Records=112) in E:\Lumens\Versions\v81ERPQA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 13:35:31.031

SELECT pfo.int_order
				, pf.str_field_display_name
				, pf.str_field_name
				, pfo.int_profile_field_tab_id
				, pf.str_actor_types
				, pf.chr_field_type
			FROM tbl_profile_field_order pfo
			INNER JOIN tbl_profile_field pf ON pfo.int_profile_field_id = pf.int_profile_field_id
			WHERE pf.int_region_id = ?
				AND bit_enabled = ?
				AND
				(
					(
						pf.chr_field_type not in ('C','O')
					)
					
						OR
						(
							pf.chr_field_type in ('C','O') AND
							(
								pf.str_actor_types LIKE ? 
							)
						)
					
				)
			ORDER BY pfo.int_profile_field_tab_id
				, pfo.int_order ASC

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_varchar) = %90%

qsocialNetFieldDetails (Datasource=AnthologyDev2, Time=0ms, Records=4) in E:\Lumens\Versions\v81ERPQA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 13:35:31.031

select * from tbl_social_media_details WHERE int_region_id = ?
			order by int_order asc

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qGraphics (Datasource=AnthologyDev2, Time=16ms, Records=1) in E:\Lumens\Versions\v81ERPQA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 13:35:31.031

select * from UIVariables where RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qUserNavItems (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\versions\v81ERPQA\cfc\systemoptions\poweruser\poweruser.cfc @ 13:35:31.031

SELECT menitms.SiteURL AS nav_site_url
			, menitms.label AS nav_label
			, menitms.rowNum
			, COUNT(menitms.rowNum) OVER () AS Total_Rows
			, menitms.DisplayCriteria_1
			, menitms.DisplayValue_1
			, menitms.DisplayCriteria_2
			, menitms.DisplayValue_2
			, menitms.Condition
			, menitms.NewWindowName
		FROM (
			SELECT SiteURL
				, label
				, DisplayCriteria_1
				, DisplayValue_1
				, DisplayCriteria_2
				, DisplayValue_2
				, Condition
				, Row_Number() OVER (
					ORDER BY MenuitemID ASC
					) AS rowNum
				, NewWindowName
			FROM MenuItems
			WHERE AccessLevel 
			
					= ? 
			
				AND RegionID = ?
			AND bit_display_in_nav=1
				AND STATUS = ?
				
	) menitms

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_char) = A

qFooterNavItems (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\versions\v81ERPQA\cfc\systemoptions\poweruser\poweruser.cfc @ 13:35:31.031

SELECT menitms.SiteURL
			, menitms.label
			, menitms.AccessLevel
			, menitms.rowNum
			, ((rowNum - 1) / 4) + 1 AS block
			, menitms.DisplayCriteria_1
			, menitms.DisplayValue_1
			, menitms.DisplayCriteria_2
			, menitms.DisplayValue_2
			, menitms.Condition
			, menitms.NewWindowName
		FROM (
			SELECT SiteURL
				, label
				, AccessLevel
				, DisplayCriteria_1
				, DisplayValue_1
				, DisplayCriteria_2
				, DisplayValue_2
				, Condition
				, Row_Number() OVER (
					ORDER BY MenuitemID ASC
					) AS rowNum
				, NewWindowName
			FROM MenuItems
			WHERE AccessLevel
			
			
					= ? 
			
				AND RegionID = ?
			AND bit_display_in_footer=1
				AND STATUS = ?
				
	) menitms

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_char) = A

qUser (Datasource=AnthologyDev2, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 13:35:31.031

DECLARE @currentTime DATETIME2 = ?
				UPDATE tbl_cart_class_detail
				SET EnteredDate = @currentTime
				WHERE SessionID = ?;
				UPDATE tbl_cart_merchandise_detail
				SET EnteredDate = @currentTime
				WHERE SessionID = ?;

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_timestamp) = 2025-08-18 13:35:31.642

			    
			        Parameter #2(cf_sql_varchar) = 92212C4C9DF90B4217FEE78931D58A3A.cfusion

			    
			        Parameter #3(cf_sql_varchar) = 92212C4C9DF90B4217FEE78931D58A3A.cfusion

qUser (Datasource=AnthologyDev2, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 13:35:31.031

DECLARE @expireRequestsAfter DATETIME2 = ?;
						DELETE FROM tbl_cart_class_detail WHERE EnteredDate <= @expireRequestsAfter;
						DELETE FROM tbl_cart_merchandise_detail WHERE EnteredDate <= @expireRequestsAfter;

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_timestamp) = 2025-08-18 12:35:31.642

variables.custom_scripts (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\header.cfm @ 13:35:31.031

SELECT str_header_script
				, str_footer_script
			FROM tbl_style_settings WITH (NOLOCK)
			-- WHERE int_region_id = Commented as long as multiple regions are not there

qGraphics (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 13:35:31.031

select * from UIVariables where RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qSocialMediaHeader (Datasource=, Time=0ms, Records=4) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 13:35:31.031

select * from qSocialMedia order by int_order desc

qGetDonateUserNavLabel (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\header.cfm @ 13:35:31.031

SELECT isNull(str_user_nav_label,'') AS str_menu_label
		FROM tbl_user_nav_menu_label
		WHERE int_actor_type_id = ?
		AND str_menu_label LIKE 'DONATE'
		AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1';

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

qGetDonateUserNavLabel (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\header.cfm @ 13:35:31.031

SELECT isNull(str_user_nav_label,'') AS str_menu_label
		FROM tbl_user_nav_menu_label
		WHERE int_actor_type_id = ?
		AND str_menu_label LIKE 'DONATE'
		AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1';

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

qGetDonateUserNavLabel (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\header.cfm @ 13:35:31.031

SELECT isNull(str_user_nav_label,'') AS str_menu_label
		FROM tbl_user_nav_menu_label
		WHERE int_actor_type_id = ?
		AND str_menu_label LIKE 'DONATE'
		AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1';

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 3

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 6

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 9

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 14

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qMenu where int_parent_id = 540

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qMenu where int_parent_id = 518

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qMenu where int_parent_id = 500

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qMenu where int_parent_id = 616

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qMenu where int_parent_id = 2

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qMenu where int_parent_id = 5

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qMenu where int_parent_id = 6

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qMenu where int_parent_id = 7

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 13:35:31.031

select * from qMenu where int_parent_id = 458

CustomizationsQry (Datasource=AnthologyDev2, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\CustomizationsQry.cfm @ 13:35:31.031

SELECT OrgID, RegionID, CustomizationID, rtrim(ltrim(FuseAction)) as fuseAction, Status, 
	CASE Status When 'A' Then 'Active' When 'I' Then 'Inactive' END AS StatusDesc,
	CreateDate, CustomizationName, CustomizationDesc
	FROM Customizations c
	WHERE Status = 'A'
	AND RegionID = 1
	Order By Status, Fuseaction

qCatalogIsExternal (Datasource=AnthologyDev2, Time=0ms, Records=5) in E:\Lumens\Versions\v81ERPQA\SQL\CatalogIsExternal.cfm @ 13:35:31.031

SELECT	Catalogs.CatalogID,
			Catalogs.Status,
			Catalogs.SystemCatalog,
			CASE WHEN ExternalCourseProvider.DefaultCatalogID IS NULL THEN 0
				 ELSE 1
			END AS IsExternalCourseProviderDefaultCatalog
	FROM	Catalogs
			LEFT JOIN ExternalCourseProvider
				ON ExternalCourseProvider.DefaultCatalogID = Catalogs.CatalogID

qExternalDefaultCatalog (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\SQL\CatalogIsExternal.cfm @ 13:35:31.031

SELECT * FROM qCatalogIsExternal WHERE IsExternalCourseProviderDefaultCatalog = 1 AND SystemCatalog = 1

qNotExternalDefaultCatalogs (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\SQL\CatalogIsExternal.cfm @ 13:35:31.031

SELECT * FROM qCatalogIsExternal WHERE IsExternalCourseProviderDefaultCatalog = 0

RegionDetailQry (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\SQL\RegionDetailQry.cfm @ 13:35:31.031

SET NOCOUNT ON

SELECT rg.ApplName
    , rg.NAME
    , rg.EMail
    , rg.EMailAux1
    , rg.EMailAux2
    , rg.EMailAux3
    , rg.EMailAux4
    , rg.EMailAux5
    , rg.EMailAux6
    , rg.theUrl
    , rg.BadWeatherText
    , rg.Phone1
    , rg.Phone1Ext
    , rg.Address1
    , rg.Address2
    , rtrim(rg.City) + ', ' + rg.STATE + '  ' + rg.Zip AS CSZ
    , rg.City
    , rg.STATE
    , rg.Zip
    , rg.ZipPlus4
    , rg.Footer
    , rg.SiteTitle
    , rtrim(rg.City) + ', ' + rg.STATE + ', ' + rg.Zip AS OrganizationCityStateZip
FROM Regions rg
WHERE rg.RegionID = ?
    AND rg.Status = 'A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

OrganizationDetailQry (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\SQL\RegionDetailQry.cfm @ 13:35:31.031

SET NOCOUNT ON

    SELECT rg.ApplName
        , rg.NAME AS OrganizationName
        , rg.EMail
        , rg.EMailAux1
        , rg.EMailAux2
        , rg.EMailAux3
        , rg.EMailAux4 AS Mailbox4
        , rg.EMailAux4 AS Mailbox5
        , rg.theUrl
        , rg.BadWeatherText
        , rg.Phone1 AS OrganizationPhone
        , rg.Phone1Ext
        , rg.Address1 AS OrganizationAddress
        , rg.Address2 AS OrganizationAddress2
        , rtrim(rg.City) + ', ' + rg.STATE + ', ' + rg.Zip AS OrganizationCityStateZip
        , rg.City
        , rg.State
        , rg.Zip
        , rg.ZipPlus4
        , rg.Footer
        , rg.SiteTitle
        -- Issue TT59300 OrganizationCity,OrganizationState,OrganizationZip
        , rg.City AS OrganizationCity
        , rg.State AS OrganizationState
        , rg.Zip AS OrganizationZip
    FROM Regions rg
    WHERE rg.RegionID = ?
        AND rg.Status = 'A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

GetDefaultCatalog (Datasource=AnthologyDev2, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\SQL\GetDefaultCatalog.cfm @ 13:35:31.031

SELECT TOP 1 CatalogID FROM Catalogs 
	WHERE SystemCatalog = 1
	AND Name = 'All Catalogs'
	ORDER BY SortOrder

CatSubcatQry (Datasource=AnthologyDev2, Time=145ms, Records=4) in E:\Lumens\Versions\v81ERPQA\SQL\CatSubcatQry.cfm @ 13:35:31.031

SET NOCOUNT ON

		DECLARE @str_alt AS VARCHAR(max)
			, @intNumber_wAltSubCat AS INT
			, @AllcatalogId AS INT
			, @CatalogID AS INT
			, @AltCatalogID AS VARCHAR(20)
			, @currentTimeZoneOffsetDate DATETIME2 = ?
			, @MemberShipTypeID INT;

		SET @AllcatalogId = ( SELECT catalogid FROM catalogs WHERE NAME = 'All Catalogs' );
		SET @CatalogID = ?;
		SET @AltCatalogID = ?;
		SET @MemberShipTypeID = ?;
		/**/

		SET @intNumber_wAltSubCat = (
			SELECT count(ClassListingID) AS Number_wAltSubCat
			FROM tbl_class_listing tcl WITH (NOLOCK)
			
			WHERE ( tcl.str_alt_subcategory_ids IS NULL OR tcl.str_alt_subcategory_ids > '' )
				AND
				
					@currentTimeZoneOffsetDate BETWEEN tcl.AppearanceStartDate
						AND tcl.AppearanceEndDate
				
					AND tcl.bit_display_to_public = 1
				
						AND NOT EXISTS (
							SELECT 1
							FROM tbl_restriction_code_detail
							WHERE int_table_id = 2 /*classes*/
								AND int_primary_key_id = tcl.ClassID
						)
					
		)


		IF object_id('tempdb..#temp') IS NOT NULL
		BEGIN
			DROP TABLE #temp
		END

		IF object_id('tempdb..#temp1') IS NOT NULL
		BEGIN
			DROP TABLE #temp1
		END

		IF object_id('tempdb..#temp2') IS NOT NULL
		BEGIN
			DROP TABLE #temp2
		END

		IF object_id('tempdb..#temp3') IS NOT NULL
		BEGIN
			DROP TABLE #temp3
		END

		SELECT Subcategories.subcategoryid
		INTO #temp1
		FROM tbl_class_listing Classes WITH (NOLOCK)
		LEFT JOIN Catalogs WITH (NOLOCK) ON Classes.CatalogID = Catalogs.CatalogID
		INNER JOIN Courses WITH (NOLOCK) ON Classes.CourseID = Courses.CourseID
		
		INNER JOIN tbl_class_detail tcd WITH (NOLOCK) ON tcd.int_class_id = classes.classid
			AND (
				Classes.chr_Status = 'A'
				OR Classes.chr_Status = 'C'
			)
			
				AND (tcd.bit_display_to_public = 1)
				AND Classes.classid IN (
					SELECT classid
					FROM tbl_class_listing cl1 WITH (NOLOCK)
					LEFT JOIN MembershipTypes mt1 
						ON mt1.MembershipTypeID IN (
							SELECT value 
							FROM STRING_SPLIT(cl1.str_limit_self_reg_mbrship_type_ids, ',')
						)
					WHERE (
						mt1.MemberShipTypeID = @MemberShipTypeID 
						OR mt1.bit_display_classes_members_only = 0
					)

					UNION

					SELECT classid
					FROM tbl_class_listing cl1 WITH (NOLOCK)
					WHERE (cl1.str_limit_self_reg_mbrship_type_ids = '')
						OR (cl1.str_limit_self_reg_mbrship_type_ids IS NULL)
						OR (cl1.str_limit_self_reg_mbrship_type_ids = '0')
					)
			
			AND
			
				@currentTimeZoneOffsetDate BETWEEN Classes.AppearanceStartDate
					AND Classes.AppearanceEndDate
			
			AND Classes.ClassID NOT IN (
				SELECT cx.ClassID
				FROM ProgramSectionClasses cx
				GROUP BY cx.ClassID
				)
			
					AND NOT EXISTS (
						SELECT 1
						FROM tbl_restriction_code_detail
						WHERE int_table_id = 2 /*classes*/
							AND int_primary_key_id = Classes.ClassID
					)
				
		INNER JOIN Subcategories WITH (NOLOCK) ON Subcategories.SubcategoryID = Courses.SubcategoryID

		SELECT sbc.subcategoryid
			, cl1.AppearanceEndDate
			, Cl1.classid
			, cl1.str_limit_self_reg_mbrship_type_ids
			, AppearanceStartDate
			, Cl1.CatalogID
			, cl1.str_alt_catalog_ids
		INTO #temp2
		FROM tbl_class_listing cl1 WITH (NOLOCK)
		LEFT JOIN Catalogs WITH (NOLOCK) ON cl1.CatalogID = Catalogs.CatalogID
		INNER JOIN Courses WITH (NOLOCK) ON cl1.CourseID = Courses.CourseID
		INNER JOIN tbl_class_detail tcd WITH (NOLOCK) ON tcd.int_class_id = cl1.classid
		
		INNER JOIN tbl_class_course_series_group tcs WITH (NOLOCK) ON tcs.int_class_id = tcd.int_class_id
			AND (
				cl1.chr_Status = 'A'
				OR cl1.chr_Status = 'C'
				)
			AND (tcd.bit_display_to_public = 1)
			AND cl1.ClassID NOT IN (
				SELECT cx.ClassID
				FROM ProgramSectionClasses cx WITH (NOLOCK)
				GROUP BY cx.ClassID
				)
			
			
					AND NOT EXISTS (
						SELECT 1
						FROM tbl_restriction_code_detail
						WHERE int_table_id = 2 /*classes*/
							AND int_primary_key_id = cl1.ClassID
					)
				
		INNER JOIN Subcategories sbc WITH (NOLOCK) ON sbc.SubcategoryID = Courses.SubcategoryID

		/*Multiple subcategory display PAV 26 Aug 2009 This section gets a list of subcategory ids which have been assigned to classes as alternate subcategory ids*/
		/* sample code obtained from http://rafudb.blogspot.com/2009/04/sysconnectbypath-in-sql-server_24.html */
		/* This flattens the comma delimited values from several rows into one field and places them into a temp table */
		IF @intNumber_wAltSubCat > 0
		BEGIN
			
			SELECT DISTINCT t.[value]
			INTO #temp
			FROM tbl_class_listing col1 WITH (NOLOCK)
			
			CROSS APPLY STRING_SPLIT(str_alt_subcategory_ids,',') t
			WHERE str_alt_subcategory_ids IS NOT NULL
				
					AND @currentTimeZoneOffsetDate BETWEEN AppearanceStartDate
						AND AppearanceEndDate
				
				AND 0 < (
					CASE
						WHEN str_class_type = 'CS'
							THEN (
									SELECT COUNT(ClassID)
									FROM Classes Cl
									INNER JOIN tbl_class_course_series_group tcc ON tcc.int_class_id = CL.ClassID
									WHERE tcc.int_Series_group_id = col1.int_course_series_group_id
										AND Cl.STATUS = 'A'
									)
						ELSE 1
						END
					)
				
					AND bit_display_to_public = 1
				
				AND col1.ClassID NOT IN (
					SELECT cx.ClassID
					FROM ProgramSectionClasses cx
					GROUP BY cx.ClassID
				)
				
				
						AND NOT EXISTS (
							SELECT 1
							FROM tbl_restriction_code_detail
							WHERE int_table_id = 2 /*classes*/
								AND int_primary_key_id = col1.ClassID
						)
					

			SELECT classid
			INTO #temp3
			FROM tbl_class_listing cl1 WITH (NOLOCK)
			
			LEFT JOIN MembershipTypes mt1 
				ON mt1.MembershipTypeID IN (
					SELECT value 
					FROM STRING_SPLIT(cl1.str_limit_self_reg_mbrship_type_ids, ',')
				)
			WHERE 1 = 1
				AND ( 
					MemberShipTypeID = @MemberShipTypeID
					OR bit_display_classes_members_only = 0 
				)
				
					AND bit_display_to_public = 1
				
						AND NOT EXISTS (
							SELECT 1
							FROM tbl_restriction_code_detail
							WHERE int_table_id = 2 /*classes*/
								AND int_primary_key_id = cl1.ClassID
						)
					

			UNION

			SELECT classid
			FROM tbl_class_listing cl1 WITH (NOLOCK)
			
			WHERE ((cl1.str_limit_self_reg_mbrship_type_ids = '')
				OR (cl1.str_limit_self_reg_mbrship_type_ids IS NULL)
				OR (cl1.str_limit_self_reg_mbrship_type_ids = '0'))
				AND ClassID NOT IN (
					SELECT cx.ClassID
					FROM ProgramSectionClasses cx
					GROUP BY cx.ClassID
				)
				
					AND bit_display_to_public = 1
				
						AND NOT EXISTS (
							SELECT 1
							FROM tbl_restriction_code_detail
							WHERE int_table_id = 2 /*classes*/
								AND int_primary_key_id = cl1.ClassID
						)
					

			SELECT c.OrgID
				, c.RegionID
				, c.CategoryID
				, c.NAME AS CategoryName
				, sc.SubcategoryID
				, (
					SELECT ExternalCourseProviderID
					FROM ExternalCourseProvider WITH (NOLOCK)
					WHERE DefaultSubcategoryID = sc.SubCategoryID
					) AS ExternalCourseProviderID
				, sc.NAME AS SubcategoryName
				, sc.SubCategoryID AS SubCategoryID
				, sc.str_subCat_graphic AS SubCategoryImg
				, c.str_cat_graphic AS CategoryImg
				, c.SortOrder AS CategorySortOrder
				, sc.SortOrder AS SubCategorySortOrder
			FROM Categories c WITH (NOLOCK)
			LEFT JOIN SubCategories sc WITH (NOLOCK) ON c.CategoryID = sc.CategoryID
			WHERE c.STATUS = 'A'
				AND sc.STATUS = 'A'
				
				
				AND sc.int_displayed_in_category IN (
				SELECT int_displayed_in_category FROM tbl_displayed_in_category WHERE
				 (str_displayed_in_category LIKE 'Classes' OR str_displayed_in_category LIKE 'Both')
				 )
					
						AND sc.bit_available_to_students=1
					
				
				AND c.RegionID = 1 
						AND (
							EXISTS (
									SELECT subcategoryid
									FROM #temp1 t1
									WHERE t1.SubcategoryID = sc.SubCategoryID
						)
						OR sc.subcategoryid IN (
								SELECT [value]
								FROM #temp
								)
						OR sc.subcategoryid IN (
								SELECT DISTINCT CL.SubCategoryID
								FROM tbl_class_listing CL WITH (NOLOCK)
								INNER JOIN CourseSeriesGroups CSG WITH (NOLOCK) ON CSG.SeriesGroupID = CL.int_course_series_group_id
								INNER JOIN tbl_course_series_type cst WITH (NOLOCK) ON cst.int_course_series_type_id = CSG.int_course_series_type_id
								INNER JOIN tbl_class_course_series_group ccsg WITH (NOLOCK) ON ccsg.int_Series_group_id = CL.int_course_series_group_id
								LEFT JOIN tbl_class_detail tcd WITH (NOLOCK) ON tcd.int_class_id = ccsg.int_class_id
								
									AND (CSG.bit_disp_cs_to_public = 1)
								
								WHERE @currentTimeZoneOffsetDate BETWEEN CL.AppearanceStartDate AND CL.AppearanceEndDate
									
										AND tcd.int_class_id IN (
											SELECT classid FROM #temp3
											)
									
								)
						OR sc.subcategoryid IN (
								SELECT SubCategoryID
								FROM tbl_class_listing tcl WITH (NOLOCK)
								INNER JOIN tbl_certificates tc WITH (NOLOCK) ON tcl.int_certificate_id = tc.int_certificate_id
								INNER JOIN tbl_certificates_classes tcc WITH (NOLOCK) ON tcc.int_certificate_id = tc.int_certificate_id
								INNER JOIN tbl_class_detail tcd WITH (NOLOCK) ON tcd.int_class_id = tcc.int_class_id
									
										AND (tc.bit_display_to_public = 1)
									
									AND tcl.dat_publish_date IS NOT NULL
									AND tc.chr_status = 'P'
									AND (
										SELECT count(int_certificate_class_id)
										FROM tbl_certificates_classes cc WITH (NOLOCK)
										INNER JOIN tbl_class_listing cl WITH (NOLOCK) ON cc.int_class_id = cl.classid
											
										) > 0
								)
						OR sc.subcategoryid IN (
								SELECT DISTINCT cl.SubCategoryID
								FROM tbl_class_listing CL WITH (NOLOCK)
								INNER JOIN tbl_certificates tc WITH (NOLOCK) ON CL.int_certificate_id = tc.int_certificate_id
									AND tc.chr_status = 'P'
								WHERE CL.str_class_type = 'cf'
									AND @currentTimeZoneOffsetDate BETWEEN CL.AppearanceStartDate
										AND CL.AppearanceEndDate
										
											AND tc.bit_display_to_public = 1
										
									)
						
							OR EXISTS (
									SELECT subcategoryid
									FROM #temp2
									WHERE @currentTimeZoneOffsetDate BETWEEN AppearanceStartDate
									AND AppearanceEndDate
									AND SubcategoryID = sc.SubCategoryID
									AND classid IN (SELECT classid FROM #temp3)
										
										
										
									)
						
						)
					
			ORDER BY c.SortOrder
				, c.NAME
				, sc.SortOrder
				, sc.NAME
		END
		ELSE
		BEGIN
			SELECT c.OrgID
				, c.RegionID
				, c.CategoryID
				, c.NAME AS CategoryName
				, sc.SubcategoryID
				, (
					SELECT ExternalCourseProviderID
					FROM ExternalCourseProvider WITH (NOLOCK)
					WHERE DefaultSubcategoryID = sc.SubCategoryID
					) AS ExternalCourseProviderID
				, sc.NAME AS SubcategoryName
				, sc.SubCategoryID AS SubCategoryID
				, sc.str_subCat_graphic AS SubCategoryImg
				, c.str_cat_graphic AS CategoryImg
				, c.SortOrder AS CategorySortOrder
				, sc.SortOrder AS SubCategorySortOrder
			FROM Categories c WITH (NOLOCK)
			LEFT JOIN SubCategories sc WITH (NOLOCK) ON c.CategoryID = sc.CategoryID
			WHERE c.STATUS = 'A'
				AND sc.STATUS = 'A'
				AND c.RegionID = 1
				/* Filter by a list of catalog ID's */
				
				
				AND sc.int_displayed_in_category IN (
				SELECT int_displayed_in_category FROM tbl_displayed_in_category WHERE
				 (str_displayed_in_category LIKE 'Classes' OR str_displayed_in_category LIKE 'Both')
				 )
					
						AND sc.bit_available_to_students=1
					

					AND (
							/*
								First part of ShowOnlyCatSubCatWithActiveClass
								to get subcategories of classes that are active or confirmed
							*/
							EXISTS (
									SELECT subcategoryid
									FROM #temp1 t1
									WHERE t1.SubcategoryID = sc.SubCategoryID
								)
							/*
								Second part of ShowOnlyCatSubCatWithActiveClass to get subcategories of course series groups that are active
								Same conditions of membership, public display and display dates applies here as well.
								Condition is written only for public and not staff like above - why?? -
								AP: ***Fill in if you know the reason***
								AP: Probably because, if a course series group is active the associated class is active?
							*/
							
								OR 	EXISTS (
										SELECT subcategoryid
										FROM #temp2
										WHERE @currentTimeZoneOffsetDate BETWEEN AppearanceStartDate
										AND AppearanceEndDate
										AND SubcategoryID = sc.SubCategoryID
										
										)
							
							/*
								Third part of ShowOnlyCatSubCatWithActiveClass to get subcategories for certificates that are active
								The dates are checeked agains appearance dates only - Probabaly needs to be written similar to first part.
							*/
							OR sc.subcategoryid IN (
								SELECT DISTINCT cl.SubCategoryID
								FROM tbl_class_listing CL WITH (NOLOCK)
								INNER JOIN tbl_certificates tc WITH (NOLOCK) ON CL.int_certificate_id = tc.int_certificate_id
									AND tc.chr_status = 'P'
								WHERE CL.str_class_type = 'cf'
									AND @currentTimeZoneOffsetDate BETWEEN CL.AppearanceStartDate AND CL.AppearanceEndDate
										
											AND tc.bit_display_to_public = 1
										
							)
						)
			
			ORDER BY c.SortOrder
				, c.NAME
				, sc.SortOrder
				, sc.NAME
		END

		IF object_id('tempdb..#temp') IS NOT NULL
		BEGIN
			DROP TABLE #temp
		END

		IF object_id('tempdb..#temp1') IS NOT NULL
		BEGIN
			DROP TABLE #temp1
		END

		IF object_id('tempdb..#temp2') IS NOT NULL
		BEGIN
			DROP TABLE #temp2
		END

		IF object_id('tempdb..#temp3') IS NOT NULL
		BEGIN
			DROP TABLE #temp3
		END

		SET NOCOUNT OFF

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_timestamp) = 2025-08-18 13:35:31.751

			    
			        Parameter #2(cf_sql_integer) = 0

			    
			        Parameter #3(cf_sql_varchar) = 0

			    
			        Parameter #4(cf_sql_integer) = 0

qCatalog (Datasource=AnthologyDev2, Time=15ms, Records=2) in E:\Lumens\Versions\v81ERPQA\SQL\GetCatalog.cfm @ 13:35:31.031

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
	DECLARE @currentTimeZoneOffsetDate AS DATETIME2 = ?;

	SELECT Name
		, STATUS
		, Catalogs.CatalogID
		, SortOrder
		, CampusCode
		
		, AvailableForRequest
		, CASE 
			WHEN EXISTS (
					SELECT 'x'
					FROM Classes
					INNER JOIN tbl_class_listing tcl ON classes.classid = tcl.classid
					WHERE Classes.STATUS IN ('A','C')
						
						AND @currentTimeZoneOffsetDate BETWEEN Classes.AppearanceStartDate
							AND Classes.AppearanceEndDate
						AND tcl.bit_display_to_public = 1 
						
						AND (
							Classes.CatalogID = Catalogs.CatalogID
							OR (',' + RTRIM(tcl.str_alt_catalog_ids) + ',') LIKE '%,' + CAST(Catalogs.CatalogID AS VARCHAR) + ',%'
							)
					)
				THEN 1
			ELSE 0
			END AS ClassActive
		, CASE WHEN CatalogClsCnt.CatalogID IS NOT NULL OR AltCatalogClsCnt.CatalogID IS NOT NULL
				THEN 1
			ELSE 0
			END AS EverHadClass
		, str_catalog_display_name
		, bit_hide_from_menu AS hide_from_menu
		, dbo.fun_strip_html(Name) AS NameNoHTML
	FROM Catalogs 
	LEFT JOIN (
		SELECT COUNT(ClassID) AS Cnt
			, CatalogID
		FROM Classes
		GROUP BY CatalogId
		HAVING COUNT(ClassID) > 0
	) CatalogClsCnt ON CatalogClsCnt.CatalogID = Catalogs.CatalogID
	LEFT JOIN (
		SELECT COUNT(tcd.int_class_id) AS cnt
			, altCatalogs.value AS CatalogID
		FROM tbl_class_detail tcd
		CROSS APPLY STRING_SPLIT(tcd.str_alt_catalog_ids, ',') altCatalogs
		WHERE tcd.str_alt_catalog_ids IS NOT NULL AND TRIM(tcd.str_alt_catalog_ids) != ''
		GROUP BY altCatalogs.value
		HAVING COUNT(tcd.int_class_id) > 0
	) AltCatalogClsCnt ON AltCatalogClsCnt.CatalogID = Catalogs.CatalogID
	WHERE 1 = 1
		
			AND Status IN (?)
		
	ORDER BY SortOrder
	SET TRANSACTION ISOLATION LEVEL READ COMMITTED

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_timestamp) = 2025-08-18 13:35:31.896

			    
			        Parameter #2(cf_sql_varchar) = A

qDistinctCat (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81ERPQA\templates\courses.cfm @ 13:35:32.032

SELECT DISTINCT CategoryName FROM CatSubCatQry

qExternalCourseProvider (Datasource=AnthologyDev2, Time=16ms, Records=0) in E:\Lumens\Versions\v81ERPQA\SQL\GetExternalCourseProvider.cfm @ 13:35:32.032

SELECT	ExternalCourseProvider.ExternalCourseProviderID,
			ExternalCourseProvider.DefaultSubcategoryID,
			ExternalCourseProvider.DefaultCatalogID,
			ExternalCourseProvider.IsFeatured,
			ExternalCourseProvider.FeaturedImagePath,
			Categories.CategoryID AS DefaultCategoryID,
			Subcategories.Name AS DefaultSubcategoryName,
			Categories.Name AS DefaultCategoryName,
			Subcategories.BaseCourseNumber,
			ExternalCourseProvider.CourseImportTranslationURL,
			ExternalCourseProvider.Name,
			ExternalCourseProvider.Status,
			ExternalCourseProviderType.Description AS ExternalCourseProviderTypeDescription,
			ExternalCourseProvider.ExternalCourseProviderCustomerCode,
			ExternalCourseProvider.SendRegistrationURL,
			ExternalCourseProvider.SendRegistrationEmail,
			ExternalCourseProvider.username,
			ExternalCourseProvider.password,
			ExternalCourseProvider.unit
	FROM	ExternalCourseProvider
			INNER JOIN ExternalCourseProviderType
				ON ExternalCourseProviderType.ExternalCourseProviderTypeID = ExternalCourseProvider.ExternalCourseProviderTypeID
			LEFT JOIN Subcategories
				ON ExternalCourseProvider.DefaultSubcategoryID = Subcategories.SubcategoryID
			LEFT JOIN Categories
				ON Categories.CategoryID = Subcategories.CategoryID
	WHERE	1=1
	
		AND ExternalCourseProvider.IsFeatured = 1

ContentsQry (Datasource=AnthologyDev2, Time=0ms, Records=2) in E:\Lumens\Versions\v81ERPQA\SQL\ContentsQry.cfm @ 13:35:32.032

SELECT ContentID
		, OrgID
		, RegionID
		, Section
		, Path
		, Contents
		, ContentsNoHTML
		, Description
		, Name
		, emailTemplate
		, str_default_condition
		, str_page_title
		, str_meta_description
		, str_keywords
	FROM Contents
	WHERE Path = ?
		AND	orgid = ?
		AND	regionid= ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = courses

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_integer) = 1

qCatalog (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81ERPQA\templates\courses.cfm @ 13:35:32.032

SELECT * FROM qCatalog WHERE ClassActive = 1

qGetText (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\versions\v81ERPQA\cfc\textEdit.cfc @ 13:35:32.032

Declare @ContentCondition bit
			SET @ContentCondition = 1
			SELECT contents
				
				,contents.path
                ,contents.str_page_title
				,contents.str_meta_description
				,contents.str_keywords
				,contents.section
	    		,contents.str_desc_learner_erp_email
	    		,contents.str_desc_learner_no_erp_email
				
			FROM Contents
			WHERE @ContentCondition = @ContentCondition
			
			AND Path = ?
			AND section = ? 
			AND RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = courses

			    
			        Parameter #2(cf_sql_varchar) = 1

			    
			        Parameter #3(cf_sql_integer) = 1

CatalogCoursesQry (Datasource=AnthologyDev2, Time=0ms, Records=5) in E:\Lumens\Versions\v81ERPQA\templates\courses.cfm @ 13:35:32.032

/*Select SubCategoryIDs where CatalogID conditions are met*/
		SELECT DISTINCT SubCategoryID
		FROM tbl_class_listing
		WHERE 1 = 1
			

		UNION

		/*Select individual subcategory ids from str_alt_subcategory_ids*/
		SELECT DISTINCT TRIM(value) AS SubCategoryID
		FROM tbl_class_listing
		CROSS APPLY STRING_SPLIT(str_alt_subcategory_ids, ',')
		WHERE 1 = 1
			AND str_alt_subcategory_ids IS NOT NULL AND TRIM(str_alt_subcategory_ids) != ''

CatSubCatQryFilter (Datasource=, Time=0ms, Records=4) in E:\Lumens\Versions\v81ERPQA\templates\courses.cfm @ 13:35:32.032

SELECT *
		FROM CatSubCatQry
			, CatalogCoursesQry
		WHERE CatSubCatQry.SubCategoryID = CatalogCoursesQry.SubCategoryID
		ORDER BY 
			
			 CategorySortOrder
			,CategoryName
			,SubCategorySortOrder
			,SubcategoryName

qGetText (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\versions\v81ERPQA\cfc\textEdit.cfc @ 13:35:32.032

Declare @ContentCondition bit
			SET @ContentCondition = 1
			SELECT contents
				
				,contents.path
                ,contents.str_page_title
				,contents.str_meta_description
				,contents.str_keywords
				,contents.section
	    		,contents.str_desc_learner_erp_email
	    		,contents.str_desc_learner_no_erp_email
				
			FROM Contents
			WHERE @ContentCondition = @ContentCondition
			
			AND Path = ?
			AND section = ? 
			AND RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = courses

			    
			        Parameter #2(cf_sql_varchar) = 2

			    
			        Parameter #3(cf_sql_integer) = 1

Stored Procedures

q_customer_by_domain (Datasource=LumensCustomers, Time=0ms) in E:\Lumens\app_setup.cfc @ 13:35:31.031

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`cf_sql_varchar`	`anthologydev2.augusoft.net`

resultsets
`name`	`resultset`
`qCustomer`	`1`

Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\Lumens\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=AWSALBAPP-1=_remove_; AWSALBAPP-0=_remove_; AWSALBAPP-3=_remove_; AWSALBAPP-2=_remove_
HTTP_HOST=anthologydev2.augusoft.net
HTTP_REFERER=
HTTP_URL=/index.cfm?fuseaction=1010
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=172.31.100.171
PATH_INFO=
PATH_TRANSLATED=E:\Lumens\index.cfm
QUERY_STRING=fuseaction=1010
REMOTE_ADDR=172.31.102.63
REMOTE_HOST=172.31.102.63
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=anthologydev2.augusoft.net
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
AWSALBAPP-0=_remove_
AWSALBAPP-1=_remove_
AWSALBAPP-2=_remove_
AWSALBAPP-3=_remove_
LUMPERSIST=24FCE777BE096F299B2A80FB23CBFF93

Session Variables:
actortypeid=90
addtoken=CFID=17338015&CFTOKEN=8225adc210480e5a-70A67B8E-BCF5-8A45-3C3B9DC65312F8DF&jsessionid=92212C4C9DF90B4217FEE78931D58A3A.cfusion
allowunmaskeddata=0
appname=AnthologyDev2
basecfcs=versions.v81ERPQA
basecode=/versions/v81ERPQA
bit_canvas_failed_process=false
bit_member=0
customcct=
customcfcs=Customers.AnthologyDev2
customerid=618
custompath=/Customers/AnthologyDev2/custom
debug=0
debugoutput=1
docxdir=DocxHTML
domain=anthologydev2.augusoft.net
ds=AnthologyDev2
enabledlivechat=false
enabledsupportwidget=false
enteredsiteusingipaddress=1
foundeo_firewall_ip=216.73.216.101
foundeo_firewall_ua=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
loggedin=No
loggeduseremail=
loggeduserfname=Guest
loggeduserlname=
membershiptypeid=0
menuid=1
orgid=1
privacypolicyack=
regionid=1
sessionid=92212C4C9DF90B4217FEE78931D58A3A.cfusion
sitepath=/Customers/AnthologyDev2
sslreturnurl=https://anthologydev2.augusoft.net/
stylesheetpath=/Customers/AnthologyDev2/StyleSheets/style.css
timeoutminutes=60
urltoken=CFID=17338015&CFTOKEN=8225adc210480e5a-70A67B8E-BCF5-8A45-3C3B9DC65312F8DF&jsessionid=92212C4C9DF90B4217FEE78931D58A3A.cfusion
version=v81ERPQA

URL Parameters:
fuseaction=1010

Debug Rendering Time: 15 ms