Teaching - Lumens Genoo Sandbox

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

Teaching

We are always looking for new courses and instructors. If you have an idea for a workshop, you will need to mail, e-mail, or fax us your proposal; or submit your proposal using the link below. You may download both the General Information Brief and the Course Proposal Form in PDF form, or you may submit a course proposal from this page (below). Please call if you have additional questions after reading the Brief. You can reach our Program Director, John Smith, at (123) 456-7890, ext. 123. Of particular interest for the winter term are instructors for cooking & baking, yoga, French, voice lessons, reading/literary groups, holiday crafts, interior design, jewelry making, and a ladies spa group.

DOWNLOAD INFO DOWNLOAD FORM

SUBMIT COURSE PROPOSAL

If you would prefer to receive our Instructor Information Package via mail, please call (612) 605-1200 and provide your mailing information with your request.

We appreciate your interest in working with us.

Debugging Information

ColdFusion Server Enterprise	2021,0,21,330446
Template	/index.cfm
Time Stamp	02-Aug-25 10:01 AM
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.103.139
Host Name	172.31.103.139

Execution Time

Total Time	Avg Time	Count	Template
47 ms	47 ms	1	CFC[ E:/Lumens/Application.cfc \| onRequest(/index.cfm) ] from E:/Lumens/Application.cfc
47 ms	47 ms	1	E:/Lumens/Versions/v81QA/index.cfm
31 ms	31 ms	1	CFC[ E:/Lumens/Application.cfc \| onRequestStart(/index.cfm) ] from E:/Lumens/Application.cfc
16 ms	16 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/stylesheet/styleManager.cfc \| styleExists(GenooSandbox, /Customers/GenooSandbox) ] from E:/Lumens/versions/v81QA/cfc/stylesheet/styleManager.cfc
16 ms	16 ms	1	E:/Lumens/Versions/v81QA/Fusebox1.cfm
16 ms	16 ms	1	E:/Lumens/Versions/v81QA/SQL/GetTeachingLinksQry.cfm
16 ms	16 ms	1	E:/Lumens/Versions/v81QA/globalVariables.cfm
16 ms	16 ms	1	E:/Lumens/Versions/v81QA/header.cfm
16 ms	16 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template3/header_section.cfm
16 ms	16 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template3/includes/nav-main.cfm
15 ms	15 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc
15 ms	15 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc \| processRequest(ip_address = 216.73.216.8) ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Application.cfc \| onSessionStart() ] from E:/Lumens/Application.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/cart/cart_dao.cfc \| INIT(GenooSandbox) ] from E:/Lumens/Versions/v81QA/cfc/cart/cart_dao.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/ColorUtils.cfc \| INIT() ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/ColorUtils.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| INIT() ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getGraphicsDetails(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getSiteResourcePathDetailsByID(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getsocialNetIconsControlFields(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| setLearnerfieldOrder(1, 90) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/app_setup.cfc \| FindApplicationCustomer(LumensCustomers, genoosandbox.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 \| 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 \| shouldReInitialize() ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc \| init(GenooSandbox) ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc
0 ms	0 ms	4	CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc \| isCartExist() ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc \| isCartMerchandiseExist() ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/merchandise/merchandise.cfc \| init(GenooSandbox) ] from E:/Lumens/versions/v81QA/cfc/merchandise/merchandise.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc \| INIT() ] from E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc \| getFooterNavItems() ] from E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc \| getUserNavItems() ] from E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/Administration/SQL/CustomizationsQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/Administration/SQL/FeatureConfigurationQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/Administration/SQL/MenuQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/AppVariables.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/Circuits.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/SQL/Contents2Qry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/SQL/ContentsQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/checkPermission.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/footer.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/intercepts.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/nLoadVars.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/plugins/GlobalFunctions.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/templates/checkPermissionForUserRole.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/templates/loggedUserDetail.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/templates/teaching.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/udf/index.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/udf/logger.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/back-top-mobile.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/branding-logo.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/cart/act_cart_action.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/cart/cart.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/client-logo.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/facebook-pixel.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/google-analytics.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/google-tag-manager.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/menu_action.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/nav-account.cfm
0 ms	0 ms	2	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/nav-social-media.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/search.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/view-cart.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template3/footer_section.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template3/includes/custom_style.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template3/includes/nav-tabs.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/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
78 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

checkAccessControlRules (Datasource=LumensCustomers, Time=0ms, Records=9) in E:\Lumens\Versions\v81QA\checkPermission.cfm @ 10:01:19.019

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) = 1065

FeatureConfigurationQry (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\FeatureConfigurationQry.cfm @ 10:01:19.019

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=1) in E:\Lumens\Versions\v81QA\globalVariables.cfm @ 10:01:19.019

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

MenuQry (Datasource=GenooSandbox, Time=0ms, Records=9) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 10:01:19.019

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=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 10:01:19.019

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=GenooSandbox, Time=0ms, Records=107) in E:\Lumens\Versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:01:19.019

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=GenooSandbox, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:01:19.019

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=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:01:19.019

select * from UIVariables where RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qUserNavItems (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 10:01:19.019

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=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 10:01:19.019

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

q (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 10:01:19.019

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-02 10:01:19.215

			    
			        Parameter #2(cf_sql_varchar) = 78C831AE7B0CA66BE929B7581454E056.cfusion

			    
			        Parameter #3(cf_sql_varchar) = 78C831AE7B0CA66BE929B7581454E056.cfusion

q (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 10:01:19.019

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-02 09:01:19.215

variables.custom_scripts (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 10:01:19.019

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

qTempMenu (Datasource=, Time=0ms, Records=5) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\menu_action.cfm @ 10:01:19.019

select * from qTempMenu where MenuItemID NOT IN  (529,600,2,456)

qSocialMediaHeader (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 10:01:19.019

select * from qSocialMedia order by int_order desc

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

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=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

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=16ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

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) = 13

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

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) = 16

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

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) = 19

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

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) = 22

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

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) = 27

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

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) = 32

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

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) = 35

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

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) = 42

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

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) = 49

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

select * from qMenu where int_parent_id = 513

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

select * from qMenu where int_parent_id = 520

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

select * from qMenu where int_parent_id = 5

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

select * from qMenu where int_parent_id = 6

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:01:19.019

select * from qMenu where int_parent_id = 7

CustomizationsQry (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\Administration\SQL\CustomizationsQry.cfm @ 10:01:19.019

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

ContentsQry (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\ContentsQry.cfm @ 10:01:19.019

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) = Teaching

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_integer) = 1

Content2 (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\Contents2Qry.cfm @ 10:01:19.019

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	regionid= ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = Teaching2

			    
			        Parameter #2(cf_sql_integer) = 1

GetTeachingLinksQry (Datasource=GenooSandbox, Time=16ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\GetTeachingLinksQry.cfm @ 10:01:19.019

SET NOCOUNT ON
SELECT rg.RegionID, fc.UsesCourseProposal, fc.TeachingLink_1, fc.TeachingLabel_1, fc.TeachingLink_2, fc.TeachingLabel_2, fc.TeachingLink_3, fc.TeachingLabel_3, fc.TeachingLink_4, fc.TeachingLabel_4, fc.TeachingLink_5, fc.TeachingLabel_5
FROM FeatureConfiguration fc INNER JOIN Regions rg ON fc.RegionID = rg.RegionID
WHERE fc.RegionID = 1 AND rg.Status = 'A'

qSocialMediaHeader (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 10:01:19.019

select * from qSocialMedia order by int_order desc

Stored Procedures

q_customer_by_domain (Datasource=LumensCustomers, Time=0ms) in E:\Lumens\app_setup.cfc @ 10:01:19.019

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`cf_sql_varchar`	`genoosandbox.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-3=_remove_; AWSALBAPP-1=_remove_; AWSALBAPP-2=_remove_; AWSALBAPP-0=_remove_
HTTP_HOST=genoosandbox.augusoft.net
HTTP_REFERER=
HTTP_URL=/index.cfm?fuseaction=1065
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=1065
REMOTE_ADDR=172.31.103.139
REMOTE_HOST=172.31.103.139
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=genoosandbox.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=A715336F26A2CF3C9F3B491CBC091266

Session Variables:
actortypeid=90
addtoken=CFID=16814416&CFTOKEN=3092efa0b2b8629f-3103F593-EB8A-0056-000ADB81B13A789E&jsessionid=78C831AE7B0CA66BE929B7581454E056.cfusion
allowunmaskeddata=0
appname=GenooSandbox
basecfcs=versions.v81QA
basecode=/versions/v81QA
bit_canvas_failed_process=false
bit_member=0
customcct=
customcfcs=Customers.GenooSandbox
customerid=325
custompath=/Customers/GenooSandbox/custom
debug=0
debugoutput=1
docxdir=DocxHTML
domain=genoosandbox.augusoft.net
ds=GenooSandbox
enabledlivechat=false
enabledsupportwidget=false
enteredsiteusingipaddress=1
foundeo_firewall_ip=216.73.216.8
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=78C831AE7B0CA66BE929B7581454E056.cfusion
sitepath=/Customers/GenooSandbox
sslreturnurl=https://genoosandbox.augusoft.net/
stylesheetpath=/Customers/GenooSandbox/StyleSheets/style.css
timeoutminutes=60
urltoken=CFID=16814416&CFTOKEN=3092efa0b2b8629f-3103F593-EB8A-0056-000ADB81B13A789E&jsessionid=78C831AE7B0CA66BE929B7581454E056.cfusion
version=v81QA

URL Parameters:
fuseaction=1065

Debug Rendering Time: 15 ms

Shopping cart is empty !

You are not logged in.