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

Welcome

Welcome to the Pepin College Continuing Education Online Registration site. Online registration is available 24 hours a day, seven days a week. Online Registration for Pepin College 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 Pepin College Continuing Education policies and information, and other ways to register for courses, please visit the Pepin College 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.

Once you Sign In, you can:

  • Register online, anytime at your convenience.
  • Get email reminders for class starting dates.
  • Create and update your own student profile, which you can access anytime and keep up-to-date (for example, with address or phone number changes).
  • Review your student transcript at any time.
  • Review and monitor your financial transactions with Pepin College Continuing Education at any time.

Other Ways to Register

To Register by Phone:

Please Call (763) 331-8318
Please have course and section numbers, as well as your Credit Card information, ready when you call.

Hours of Operation

Open M-F, 7:30am - 5:45pm, except Pepin College Holidays.

To Register by Email:

Please scan and send your Registration Form or Purchase Order to staging@augusoft.net.

To Register in Person:

Please stop by our Registration Office at:
Pepin College Continuing Education
8441 Wayzata Blvd, Suite 200
Minneapolis MN, 55426-1360
View Map

Parking is free!

Hours of Operation

Open M-F, 7:30am - 5:45pm, except Pepin College Holidays.

To Register by Fax:

The Pepin College Continuing Education Fax line is open 24/7. Faxes are processed during regular business hours in the order received.

Please fax a completed Registration Form. Include all course and section numbers as well as your credit card information*.
Fax Number: (763) 331-8318

To Register by Mail:

Please mail a completed Registration Form, Including all course and section numbers as well as your credit card information* to:

Pepin College Continuing Education
Attn: Registration
8441 Wayzata Blvd, Suite 200
Minneapolis MN, 55426-1360


Student Transcripts

Your transcript can help you track your progress towards our professional certifications. You can review your transactions to date in your student profile.

Download a Transcript Request Form



More at modern campus.com

PREFOOTER: Website Comments
Legal | Security | Accessibility


Debugging Information
ColdFusion Server Enterprise 2021,0,18,330341
Template /index.cfm
Time Stamp 01-Apr-25 10:15 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.103.142
Host Name 172.31.103.142


Execution Time

Total Time Avg Time Count Template
79 ms 79 ms 1 CFC[ E:/Lumens/Application.cfc | onRequestStart(/index.cfm) ] from E:/Lumens/Application.cfc
63 ms 63 ms 1 CFC[ E:/Lumens/Application.cfc | onRequest(/index.cfm) ] from E:/Lumens/Application.cfc
63 ms 63 ms 1 E:/Lumens/Versions/v81QA/globalVariables.cfm
63 ms 63 ms 1 E:/Lumens/Versions/v81QA/index.cfm
47 ms 47 ms 1 E:/Lumens/Versions/v81QA/Administration/SQL/FeatureConfigurationQry.cfm
32 ms 32 ms 1 E:/Lumens/Versions/v81QA/header.cfm
32 ms 32 ms 1 E:/Lumens/Versions/v81QA/vendor/site_templates/template1/header_section.cfm
16 ms 16 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
16 ms 16 ms 1 CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc | processRequest(ip_address = 3.17.152.174) ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
16 ms 16 ms 1 E:/Lumens/Versions/v81QA/SQL/ContentsQry.cfm
16 ms 16 ms 1 E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/custom_style.cfm
16 ms 8 ms 2 E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-account.cfm
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(v8Template1) ] from E:/Lumens/Versions/v81QA/cfc/cart/cart_dao.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 2 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/app_setup.cfc | FindApplicationCustomer(LumensCustomers, v8template1.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 | shouldReInitialize() ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
0 ms 0 ms 1 CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc | init(v8Template1) ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc
0 ms 0 ms 6 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(v8Template1) ] from E:/Lumens/versions/v81QA/cfc/merchandise/merchandise.cfc
0 ms 0 ms 1 CFC[ E:/Lumens/versions/v81QA/cfc/stylesheet/styleManager.cfc | styleExists(v8Template1, /Customers/v8Template1) ] from E:/Lumens/versions/v81QA/cfc/stylesheet/styleManager.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/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/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/home.cfm
0 ms 0 ms 2 E:/Lumens/Versions/v81QA/templates/loggedUserDetail.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-desktop.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 2 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-footer.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-footer-buttons.cfm
0 ms 0 ms 1 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/nav-user.cfm
0 ms 0 ms 1 E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/search-mobile.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/template1/footer_section.cfm
0 ms 0 ms 1 E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-banner.cfm
0 ms 0 ms 1 E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-last-viewed.cfm
0 ms 0 ms 1 E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-main.cfm
0 ms 0 ms 1 E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-mobile.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
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
157 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

FeatureConfigurationQry (Datasource=v8Template1, Time=47ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\FeatureConfigurationQry.cfm @ 22:15:44.044
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\v81QA\globalVariables.cfm @ 22:15:44.044
SELECT regionId,orgID
				FROM featureConfigurationQry
				WHERE baseurl LIKE '%v8template1.augusoft.net%'
MenuQry (Datasource=v8Template1, Time=0ms, Records=18) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 22:15:44.044
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=v8Template1, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 22:15:44.044
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=v8Template1, Time=16ms, Records=96) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 22:15:44.044
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=v8Template1, Time=0ms, Records=4) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 22:15:44.044
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=v8Template1, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 22:15:44.044
select * from UIVariables where RegionID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1

qUserNavItems (Datasource=v8Template1, Time=0ms, Records=7) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 22:15:44.044
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=v8Template1, Time=0ms, Records=6) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 22:15:44.044
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=v8Template1, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 22:15:44.044
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-04-01 22:15:44.045
Parameter #2(cf_sql_varchar) = 976B6ED3114D6A6ABCFA54562A2578EB.cfusion
Parameter #3(cf_sql_varchar) = 976B6ED3114D6A6ABCFA54562A2578EB.cfusion

qUser (Datasource=v8Template1, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 22:15:44.044
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-04-01 21:15:44.045

variables.custom_scripts (Datasource=v8Template1, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 22:15:44.044
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=v8Template1, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 22:15:44.044
select * from UIVariables where RegionID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1

qTempMenu (Datasource=, Time=0ms, Records=16) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\menu_action.cfm @ 22:15:44.044
select * from qTempMenu where MenuItemID NOT IN  (582,655)
qSocialMediaHeader (Datasource=, Time=0ms, Records=4) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 22:15:44.044
select * from qSocialMedia order by int_order desc
qGetDonateUserNavLabel (Datasource=v8Template1, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 22:15:44.044
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=v8Template1, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 22:15:44.044
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=v8Template1, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 22:15:44.044
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

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 22:15:44.044
select * from qMenu where int_parent_id = 627
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 22:15:44.044
select * from qMenu where int_parent_id = 502
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 22:15:44.044
select * from qMenu where int_parent_id = 7
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 22:15:44.044
select * from qMenu where int_parent_id = 555
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 22:15:44.044
select * from qMenu where int_parent_id = 551
qTempMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 22:15:44.044
select * from qMenu where int_parent_id = 515
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 22:15:44.044
select * from qMenu where int_parent_id = 5
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 22:15:44.044
select * from qMenu where int_parent_id = 491
CustomizationsQry (Datasource=v8Template1, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\Administration\SQL\CustomizationsQry.cfm @ 22:15:44.044
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=v8Template1, Time=16ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\ContentsQry.cfm @ 22:15:44.044
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) = Home
Parameter #2(cf_sql_integer) = 1
Parameter #3(cf_sql_integer) = 1


Stored Procedures

q_customer_by_domain (Datasource=LumensCustomers, Time=0ms) in E:\Lumens\app_setup.cfc @ 22:15:43.043

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  v8template1.augusoft.net    
    
resultsets
nameresultset
 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-0=_remove_; AWSALBAPP-1=_remove_; AWSALBAPP-2=_remove_
HTTP_HOST=v8template1.augusoft.net
HTTP_REFERER=
HTTP_URL=/index.cfm
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=
REMOTE_ADDR=172.31.103.142
REMOTE_HOST=172.31.103.142
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=v8template1.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=28BCE391597C9BE3C0A9BEBF940EE92D
Session Variables:
actortypeid=90
addtoken=CFID=13174147&CFTOKEN=bb408ae8b45fc880-8CF91EEF-BCB4-4210-F7D25CFDF5A29CD4&jsessionid=976B6ED3114D6A6ABCFA54562A2578EB.cfusion
allowunmaskeddata=0
appname=v8Template1
basecfcs=versions.v81QA
basecode=/versions/v81QA
bit_canvas_failed_process=false
bit_member=0
customcct=
customcfcs=Customers.v8Template1
customerid=486
custompath=/Customers/v8Template1/custom
debug=0
debugoutput=1
docxdir=DocxHTML
domain=v8template1.augusoft.net
ds=v8Template1
enabledlivechat=false
enabledsupportwidget=false
enteredsiteusingipaddress=1
foundeo_firewall_ip=3.17.152.174
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=976B6ED3114D6A6ABCFA54562A2578EB.cfusion
sitepath=/Customers/v8Template1
sslreturnurl=https://v8template1.augusoft.net/
stylesheetpath=/Customers/v8Template1/StyleSheets/style.css
timeoutminutes=60
urltoken=CFID=13174147&CFTOKEN=bb408ae8b45fc880-8CF91EEF-BCB4-4210-F7D25CFDF5A29CD4&jsessionid=976B6ED3114D6A6ABCFA54562A2578EB.cfusion
version=v81QA
Debug Rendering Time: 15 ms