Last Viewed

Certificates: Search for Certificates

Search for Certificates Name in order to select classes to add to your Shopping cart:

Update your site by replacing this text with your own message.

Certificates Name

Certificates Keyword

Certificate 1: AA

Contact: Engle, Alex - 660-357-8502

Number of Classes: 2

Classes to Complete: 1

Certificates Price: $60.00

Description: AA

Begin Registration »

View Certificate 1 Information »

Certificate 1: AA2

Contact: Engle, Alex - 660-357-8502

Number of Classes: 2

Classes to Complete: 1

Certificates Price: $60.00

Description: AA

Begin Registration »

View Certificate 1 Information »

Certificate 1: AA3

Contact: Engle, Alex - 660-357-8502

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $60.00

Description: AA

Begin Registration »

View Certificate 1 Information »

Certificate 1: CA

Contact: Trustwave!, Trustwave - 956-434-4901

Number of Classes: 3

Classes to Complete: 1

Certificates Price: $85.00

Description: CA

Call 956-434-4901

View Certificate 1 Information »

Certificate 1: PR test

Contact: Engle, Alex - 660-357-8502

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $60.00

Description: certificates

Begin Registration »

View Certificate 1 Information »

Certificate 1: Classroom_EG_CR_Merch

Contact: Miller, Darryl - 908-273-9121

Number of Classes: 3

Classes to Complete: 2

Certificates Price: $20.00

Description: Classroom_EG_CR_Merch

Call 908-273-9121

View Certificate 1 Information »

Certificate 1: No_Merchandise

Contact: Lane, Amy - 510-405-5448

Number of Classes: 3

Classes to Complete: 2

Certificates Price: $120.00

Description: No merchandise

Begin Registration »

View Certificate 1 Information »

Certificate 1: Online_Open_ended

Contact: Pharr, Margaret - 908-273-9121

Number of Classes: 3

Classes to Complete: 2

Certificates Price: $40.00

Description: Online open eneded

Begin Registration »

View Certificate 1 Information »

Certificate 1: View_Progress_past

Contact: Lane, Amy - 510-405-5448

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $85.00

Description: qa

Call 510-405-5448

View Certificate 1 Information »

Certificate 1: View_Progress

Contact: Lane, Amy - 510-405-5448

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $85.00

Description: qa

Call 510-405-5448

View Certificate 1 Information »

Certificate 1: Ext_Credit_Issue

Contact: Hicks, Carroll - 305-820-4537

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $85.00

Description: qa

Call 305-820-4537

View Certificate 1 Information »

Certificate 1: With PreR Off

Contact: Dacosta, Anthony - 662-718-2255

Number of Classes: 2

Classes to Complete: 2

Certificates Price: $340.00

Description: QA

Begin Registration »

View Certificate 1 Information »

Certificate 1: 100 methods of singing

Contact: Lane, Amy - 510-405-5448

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $60.00

Description: qa

Begin Registration »

View Certificate 1 Information »

Certificate 1: Ordered Certificate

Contact: Engle, Alex - 660-357-8502

Number of Classes: 3

Classes to Complete: 3

Certificates Price: $160.00

Description: qa

Begin Registration »

View Certificate 1 Information »

Certificate 1: With PreR ON

Contact: Engle, Alex - 660-357-8502

Number of Classes: 2

Classes to Complete: 2

Certificates Price: $340.00

Description: QA

Begin Registration »

View Certificate 1 Information »

Certificate 1: Prerequisites_Retroactive_releaseform

Contact: Engle, Alex - 660-357-8502

Number of Classes: 2

Classes to Complete: 1

Certificates Price: $85.00

Description: test

Call 660-357-8502

View Certificate 1 Information »

Certificate 1: 1 method of singing edited

Contact: Dacosta, Anthony - 662-718-2255

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $60.00

Description: test

Begin Registration »

View Certificate 1 Information »

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

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'

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

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

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

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

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

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

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';

SET NOCOUNT ON DECLARE @name VARCHAR(255) , @keyWord VARCHAR(255) , @categoryId INT , @subcategoryId INT , @typeId INT , @onlineOnly BIT , @certificateId INT , @LateRegDays INT , @UseProgramSection BIT , @UseCertificateGroups BIT , @DisplayToPublic BIT SET @UseCertificateGroups = 1; SET @DisplayToPublic = 1; SELECT DISTINCT CL.DescriptionNoHTML AS description , CL.description as descriptionFull , CL.* , tc.str_certificate_name AS NAME , tct.str_certificate_type_name AS typeName , tc.str_contact_email , st.Email AS Email , st.LName , st.FName , tc.int_courses_required_completion AS ClassesToComplete , tc.int_courses_offered AS classCount , tc.bit_display_to_public AS bitDisplay , tc.bit_allow_public_registration AS bitRegistration , tc.str_certificate_no , tc.str_url_slug AS CertificateSlug , tc.int_certificate_id , tc.str_graphic_name /**/ /*Added July 11 2012 Tracker 30411 Neo 00110*/ , tc.bit_multiple_elective_groups /*Added July 11 2012 Tracker 30411 Neo 00110*/ /* BEGIN: NEO 00091 Date:Sep 20,2012 AI V7.3 Full-Time Certificate Use Cases 2012-08-03 UC-13 */ , tc.bit_use_program_sections AS UseProgramSection , '' AS ProgramSectionStartDate , '' AS ProgramSectionEndDate , '' isAllProgramSectionClassesAvailable , tc.bit_use_prerequisite , '' AS isProgramSectionSeatsAvailable /* END: NEO 00091 Date:Sep 20,2012 AI V7.3 Full-Time Certificate Use Cases 2012-08-03 UC-13 */ , tc.int_certificate_merchandise , cl.bit_allow_wcg_registration , tc.str_default_text_for_call_message_class , tc.bit_use_badges , tc.int_badge_integration_id , tc.int_badge_integration_template_id , tc.str_badge_template_label , tc.int_program_version as anthology_int_program_version /* Certificate Groups Dangerfield 12/14/2020 */ , tc.bit_use_certificate_groups AS UseCertificateGroups , '' AS CertificateGroupStartDate , '' AS CertificateGroupEndDate , '' AS isAllCertificateGroupClassesAvailable , '' AS isCertificateGroupSeatsAvailable , tc.str_special_notice /* Certificate Groups Dangerfield 12/14/2020 */ FROM tbl_class_listing CL INNER JOIN tbl_certificates tc ON CL.int_certificate_id = tc.int_certificate_id AND tc.chr_status = 'P' AND tc.bit_use_certificate_groups = 0 /**/ INNER JOIN tbl_certificate_type tct ON tc.int_certificate_type_id = tct.int_certificate_type_id INNER JOIN Staff st ON tc.int_staff_contact_id = st.StaffID WHERE CL.str_class_type = 'cf' /* BEGIN: NEO 00091 Date:Sep 20,2012 AI V7.3 Full-Time Certificate Use Cases 2012-08-03 UC-13 */ AND ( @UseProgramSection IS NULL OR tc.bit_use_program_sections = 0 ) /* END: NEO 00091 Date:Sep 20,2012 AI V7.3 Full-Time Certificate Use Cases 2012-08-03 UC-13 */ /* Certificate Groups Dangerfield 12/14/2020 */ AND ( @UseCertificateGroups IS NULL OR tc.bit_use_certificate_groups = 0) /* Certificate Groups Dangerfield 12/14/2020 */ AND ( @name IS NULL OR tc.str_certificate_name LIKE @name ) AND ( @keyWord IS NULL OR tc.str_certificate_name LIKE @keyWord OR tc.str_description LIKE @keyWord ) AND ( @categoryId IS NULL OR tc.int_category_id = @categoryId ) AND ( @subcategoryId IS NULL OR tc.int_subcategory_id = @subcategoryId ) AND ( @typeId IS NULL OR tc.int_certificate_type_id = @typeId ) AND ( @onlineOnly IS NULL OR tc.bit_online_courses_only = @onlineOnly ) AND ( @certificateId IS NULL OR tc.int_certificate_id = @certificateId ) /**/ AND ( @LateRegDays IS NULL OR ( SELECT count(cl2.ClassID) FROM tbl_certificates_classes tcc INNER JOIN classes cl2 ON cl2.ClassID = tcc.int_class_id WHERE tcc.int_certificate_id = tc.int_certificate_id AND cl2.STATUS = 'R' AND DATEDIFF(dd, cl2.EndDate, dbo.fun_GetDateCT()) <= @LateRegDays AND cl2.EndDate <= dbo.fun_GetDateCT() ) > 0 ) /**/ AND ( @DisplayToPublic IS NULL OR tc.bit_display_to_public = @DisplayToPublic ) /* BEGIN: NEO 00091 Date:Sep 20,2012 AI V7.3 Full-Time Certificate Use Cases 2012-08-03 UC-13 */ /* END: NEO 00091 Date:Sep 20,2012 AI V7.3 Full-Time Certificate Use Cases 2012-08-03 UC-13 */ /* Certificate Groups Dangerfield 12/14/2020 */ UNION SELECT DISTINCT CL.DescriptionNoHTML AS description , CL.description as descriptionFull , CL.* , tc.str_certificate_name AS NAME , tct.str_certificate_type_name AS typeName , tc.str_contact_email , st.Email AS Email , st.LName , st.FName , tc.int_courses_required_completion AS ClassesToComplete , tc.int_courses_offered AS classCount , tc.bit_display_to_public AS bitDisplay , tc.bit_allow_public_registration AS bitRegistration , tc.str_certificate_no , tc.str_url_slug AS CertificateSlug , tc.int_certificate_id , tc.str_graphic_name , tc.bit_multiple_elective_groups , tc.bit_use_program_sections AS UseProgramSection , '' AS ProgramSectionStartDate , '' AS ProgramSectionEndDate , '' AS isAllProgramSectionClassesAvailable , tc.bit_use_prerequisite , '' AS isProgramSectionSeatsAvailable , tc.int_certificate_merchandise , cl.bit_allow_wcg_registration , tc.str_default_text_for_call_message_class , tc.bit_use_badges , tc.int_badge_integration_id , tc.int_badge_integration_template_id , tc.str_badge_template_label , tc.int_program_version as anthology_int_program_version , tc.bit_use_certificate_groups AS UseCertificateGroups , ( SELECT MIN(c.StartDate) FROM classes c INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id AND CG.int_certificate_group_id = CL.int_certificate_group_id ) AS CertificateGroupStartDate , ( SELECT MAX(c.EndDate) FROM classes c INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id AND CG.int_certificate_group_id = CL.int_certificate_group_id ) AS CertificateGroupEndDate , CASE WHEN ( SELECT COUNT(c.ClassID) FROM classes c INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id AND CG.int_certificate_group_id = CL.int_certificate_group_id ) = ( SELECT COUNT(c.ClassID) FROM classes c INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id AND CG.int_certificate_group_id = CL.int_certificate_group_id HAVING MAX(c.dat_public_registration_begin) <= dbo.fun_GetDateCT() AND MIN(c.dat_public_registration_closes) >= dbo.fun_GetDateCT() ) THEN 1 ELSE 0 END AS isAllCertificateGroupClassesAvailable , CASE WHEN ( SELECT COUNT(c.ClassID) FROM classes c INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id AND CG.int_certificate_group_id = CL.int_certificate_group_id ) = ( SELECT COUNT(c.ClassID) FROM classes c INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id AND CG.int_certificate_group_id = CL.int_certificate_group_id WHERE CC.int_remaining_seats > 0 AND CC.int_certificate_id = CL.int_certificate_id AND CC.int_certificate_group_id = CL.int_certificate_group_id ) THEN 1 ELSE 0 END AS isCertificateGroupSeatsAvailable , tc.str_special_notice FROM tbl_class_listing CL INNER JOIN tbl_certificates tc ON CL.int_certificate_id = tc.int_certificate_id AND tc.chr_status = 'P' AND tc.bit_use_certificate_groups = 1 INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_id = CL.int_certificate_id AND CG.int_certificate_group_id = CL.int_certificate_group_id INNER JOIN tbl_certificate_type tct ON tc.int_certificate_type_id = tct.int_certificate_type_id INNER JOIN Staff st ON tc.int_staff_contact_id = st.StaffID WHERE CL.str_class_type = 'cg' AND ( SELECT COUNT(c.ClassID) FROM classes c INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id AND CG.int_certificate_group_id = CL.int_certificate_group_id ) = ( SELECT COUNT(c.ClassID) FROM classes c INNER JOIN tbl_certificates_classes CC ON CC.int_class_id = c.ClassID INNER JOIN tbl_certificate_groups CG ON CG.int_certificate_group_id = CC.int_certificate_group_id AND CG.int_certificate_group_id = CL.int_certificate_group_id WHERE CC.int_remaining_seats > 0 AND CC.int_certificate_id = CL.int_certificate_id AND CC.int_certificate_group_id = CL.int_certificate_group_id ) AND ( @name IS NULL OR tc.str_certificate_name LIKE @name ) AND ( @keyWord IS NULL OR tc.str_certificate_name LIKE @keyWord OR tc.str_description LIKE @keyWord ) AND ( @categoryId IS NULL OR tc.int_category_id = @categoryId ) AND ( @subcategoryId IS NULL OR tc.int_subcategory_id = @subcategoryId ) AND ( @typeId IS NULL OR tc.int_certificate_type_id = @typeId ) AND ( @onlineOnly IS NULL OR tc.bit_online_courses_only = @onlineOnly ) AND ( @certificateId IS NULL OR tc.int_certificate_id = @certificateId ) AND ( @DisplayToPublic IS NULL OR tc.bit_display_to_public = @DisplayToPublic ) AND ( @LateRegDays IS NULL OR ( SELECT count(cl2.ClassID) FROM tbl_certificates_classes tcc INNER JOIN classes cl2 ON cl2.ClassID = tcc.int_class_id WHERE tcc.int_certificate_id = tc.int_certificate_id AND tcc.int_certificate_group_id = CL.int_certificate_group_id AND cl2.STATUS = 'R' AND DATEDIFF(dd, cl2.EndDate, dbo.fun_GetDateCT()) <= 365 AND cl2.EndDate <= dbo.fun_GetDateCT() ) > 0 ) /* Certificate Groups Dangerfield 12/14/2020 */

DECLARE @ContentCondition BIT SET @ContentCondition = 1 SELECT contents.name , contents.contents , contents.description , contents.str_instructor_detail_list , isNull(emailType.allowHTML, 1) AS allowHTML /**/ , contents.emailTemplate /**/ , contents.path , contents.str_page_title , contents.str_meta_description , contents.str_keywords , contents.section , contents.URL /**/ , contents.EmailSubject , contents.bit_email_confirmation , contents.ContentsNoHTML /* Custom Reminder and Confirmation Email Templates Dangerfield 202105 */ , contents.bit_custom_email_template , (SELECT name FROM Contents C2 WHERE C2.ContentID = contents.int_parent_content_id) AS ParentName , contents.int_parent_content_id /* Custom Reminder and Confirmation Email Templates Dangerfield 202105 */ , contents.CreateDate , contents.ModifyDate , IsNull(S1.FName + ' ' + S1.LName,'System') as created_by , IsNull(S2.FName + ' ' + S2.LName,'System') as modified_by , contents.str_desc_learner_erp_email , contents.str_desc_learner_erp_email_nohtml , contents.str_desc_learner_no_erp_email , contents.str_desc_learner_no_erp_email_nohtml , CASE WHEN Contents.Path IN ('ForgotPasswordNotice', 'StaffProfile') THEN 1 ELSE 0 END AS isEmailSubjectEditable , CASE WHEN 1 = 0 THEN 0 WHEN ( Contents.bit_email_confirmation = 1 OR Contents.bit_learner_class_reminder = 1 /*OR Contents.bit_instructor_class_reminder = 1*/ ) THEN 1 WHEN Contents.Path LIKE 'ClassEndReminder%' OR Contents.Path LIKE 'LearnerTransferClassMerchandiseConfirmation%' OR Contents.Path LIKE 'LearnerTransferConfirm%' OR Contents.Path LIKE 'LearnerMerchandiseConfirmation%' THEN 1 ELSE 0 END AS IsConditonalEmailTemplate , Contents.str_desc_learner_erp_email , Contents.str_desc_learner_no_erp_email , Contents.str_test_email_subject , Contents.str_test_from_email , Contents.str_test_from_name FROM Contents LEFT JOIN EmailTypeContent ON contents.contentid = EmailTypeContent.contentid LEFT JOIN emailType ON EmailTypeContent.emailTypeid = emailType.emailtypeid LEFT JOIN Users U1 ON contents.CreateUserID = U1.UserID LEFT JOIN Staff S1 ON U1.ActorID = S1.StaffID LEFT JOIN Users U2 ON contents.ModifyUserID = U2.UserID LEFT JOIN Staff S2 ON U2.ActorID = S2.StaffID WHERE @ContentCondition = @ContentCondition AND Contents.path = ?

SELECT AvailableFieldID,ContentID,VariableName,VariableDisplay FROM AvailableField WHERE /* Custom Reminder and Confirmation Email Templates Dangerfield 202105 */ ContentID = ( SELECT CASE WHEN int_parent_content_id <> 0 THEN int_parent_content_id ELSE ContentID END AS ContentID FROM Contents WHERE path = ? /* BEGIN: NEO 00091 AI Company Qty Reg Use Cases 2013-02-21 - F04 Date:04 July 2013 */ AND (ISNULL(int_slim_profile_attribute_id,0) = 0 OR int_slim_profile_attribute_id IN (SELECT int_slim_profile_attribute_id FROM tbl_slim_profile_attributes WHERE bit_required = 1)) /* END: NEO 00091 AI Company Qty Reg Use Cases 2013-02-21 - F04 Date:04 July 2013 */ ) /* Custom Reminder and Confirmation Email Templates Dangerfield 202105 */

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= HTTP_HOST=v8testing9.augusoft.net HTTP_REFERER= HTTP_URL=/index.cfm?frmMenu=1&method=Certificates.CertificateSearch 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=frmMenu=1&method=Certificates.CertificateSearch REMOTE_ADDR=172.31.103.195 REMOTE_HOST=172.31.103.195 REMOTE_USER= REQUEST_METHOD=GET SCRIPT_NAME=/index.cfm SERVER_NAME=v8testing9.augusoft.net SERVER_PORT=80 SERVER_PORT_SECURE=0 SERVER_PROTOCOL=HTTP/1.1 SERVER_SOFTWARE=Microsoft-IIS/10.0 WEB_SERVER_API=

Session Variables: actortypeid=90 addtoken=CFID=17338614&CFTOKEN=a39c1c285146215b-7205AE5B-9E5F-3E84-E253B51BF28B3CBA&jsessionid=E7507C184369CC63EA50025C7F6218E1.cfusion allowunmaskeddata=0 appname=v8Testing9 basecfcs=versions.v81QA basecode=/versions/v81QA bit_canvas_failed_process=false bit_member=0 customcct=G-4M453VEXL9 customcfcs=Customers.v8Testing9 customerid=497 custompath=/Customers/v8Testing9/custom debug=0 debugoutput=1 docxdir=DocxHTML domain=v8testing9.augusoft.net ds=v8Testing9 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=E7507C184369CC63EA50025C7F6218E1.cfusion sitepath=/Customers/v8Testing9 sslreturnurl=https://v8testing9.augusoft.net/ stylesheetpath=/Customers/v8Testing9/StyleSheets/style.css timeoutminutes=60 urltoken=CFID=17338614&CFTOKEN=a39c1c285146215b-7205AE5B-9E5F-3E84-E253B51BF28B3CBA&jsessionid=E7507C184369CC63EA50025C7F6218E1.cfusion version=v81QA

Shopping cart is empty !

Certificates: Search for Certificates

Certificate 1: AA

Contact: Engle, Alex - 660-357-8502

Number of Classes: 2

Classes to Complete: 1

Certificates Price: $60.00

Description: AA

Certificate 1: AA2

Contact: Engle, Alex - 660-357-8502

Number of Classes: 2

Classes to Complete: 1

Certificates Price: $60.00

Description: AA

Certificate 1: AA3

Contact: Engle, Alex - 660-357-8502

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $60.00

Description: AA

Certificate 1: CA

Contact: Trustwave!, Trustwave - 956-434-4901

Number of Classes: 3

Classes to Complete: 1

Certificates Price: $85.00

Description: CA

Certificate 1: PR test

Contact: Engle, Alex - 660-357-8502

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $60.00

Description: certificates

Certificate 1: Classroom_EG_CR_Merch

Contact: Miller, Darryl - 908-273-9121

Number of Classes: 3

Classes to Complete: 2

Certificates Price: $20.00

Description: Classroom_EG_CR_Merch

Certificate 1: No_Merchandise

Contact: Lane, Amy - 510-405-5448

Number of Classes: 3

Classes to Complete: 2

Certificates Price: $120.00

Description: No merchandise

Certificate 1: Online_Open_ended

Contact: Pharr, Margaret - 908-273-9121

Number of Classes: 3

Classes to Complete: 2

Certificates Price: $40.00

Description: Online open eneded

Certificate 1: View_Progress_past

Contact: Lane, Amy - 510-405-5448

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $85.00

Description: qa

Certificate 1: View_Progress

Contact: Lane, Amy - 510-405-5448

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $85.00

Description: qa

Certificate 1: Ext_Credit_Issue

Contact: Hicks, Carroll - 305-820-4537

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $85.00

Description: qa

Certificate 1: With PreR Off

Contact: Dacosta, Anthony - 662-718-2255

Number of Classes: 2

Classes to Complete: 2

Certificates Price: $340.00

Description: QA

Certificate 1: 100 methods of singing

Contact: Lane, Amy - 510-405-5448

Number of Classes: 1

Classes to Complete: 1

Certificates Price: $60.00

Description: qa

Certificate 1: 1 method of singing edited