query
RESULTSET
query
  CDACOMPETENCYAREA CDAFUNCTIONALAREA CDAGOALDESC COURSEHOURVALUE COURSEID COURSELEVEL COURSELEVELDESC COURSELEVELSPDESC COURSENAME FUNCTIONALAREADESC UCCERTID UCCOURSEENDDATE UCCOURSEID UCUSERCOURSEID UCUSERID
CACHED false
EXECUTIONTIME 12
SQL SELECT DISTINCT dbo.userCourses.ucCourseEndDate, dbo.userCourses.ucCourseID, dbo.userCourses.ucUserID, dbo.userCourses.ucUserCourseID, dbo.userCourses.ucCertID, dbo.courses.courseID, dbo.courses.courseName, dbo.courses.courseHourValue, dbo.courses.CDACompetencyArea, dbo.courses.CDAFunctionalArea, dbo.courses.courseLevel, dbo.courseLevels.courseLevelDesc, dbo.courseLevels.courseLevelSpDesc, CCA.CDAGoalDesc, CFA.FunctionalAreaDesc FROM dbo.userCourses INNER JOIN dbo.courses ON dbo.userCourses.ucCourseID = dbo.courses.courseID LEFT OUTER JOIN dbo.courseLevels ON dbo.courses.courseLevel = dbo.courseLevels.courseLevelID LEFT OUTER JOIN CDA_Competency_Areas CCA ON CCA.CompetencyAreaID = courses.CDACompetencyArea LEFT OUTER JOIN CDA_Functional_Areas CFA ON CFA.FunctionalAreaID = courses.CDAFunctionalArea WHERE (dbo.userCourses.ucCourseID = '') AND (dbo.userCourses.ucUserID = 0) AND (dbo.userCourses.ucUserCourseID = '')
query
RESULTSET
query
  CERTIFICATEID CERTRAINERACTIVE CERTSTATE CERTSTATEACTIVE CERTSTATEAGENCYABR CERTSTATEAGENCYNAME CERTSTATEAPPROVALSPECIALTEXT CERTSTATEAPPROVALTEXT CERTSTATEAPPROVEDCODE CERTSTATECERTTYPE CERTSTATECOURSELEVELREQ CERTSTATEID CERTSTATELOGO CERTSTATEREQ CERTSTATETRAINERAPPROVALCODE CERTSTATETRAINERAPPROVALTEXT CERTSTATETRAINERCCEIAPPROVEDDATE CERTSTATETRAINERCCEIDEPRECATEDDATE CERTSTATETRAINERCODEREQ CERTSTATETRAINERDEFAULT CERTSTATETRAINEREXPIRATIONDATE CERTSTATETRAINERID CERTSTATE_APPROVED CERTSTATE_DEPRECATED CERTTRAINERCOMPANY CERTTRAINERDEFAULT CERTTRAINERID CERTTRAINERNAME CERTTRAINERSIGNATURE CERTTRAINERTITLE CERTTRAINER_ACTIVE CERTTRAINER_DEPRECATED
CACHED false
EXECUTIONTIME 4
SQL SELECT * FROM dbo.certStates INNER JOIN dbo.certTrainers ON dbo.certStates.certStateTrainerID = dbo.certTrainers.certTrainerID WHERE (dbo.certStates.certState = '' and certStates.certStateActive = 1) AND certStateCertType = 0 AND (((certStates.certStateTrainerCCEIDeprecatedDate >= '') AND (certStates.certStateTrainerCCEIApprovedDate <= '')) OR ((certStates.certStateTrainerCCEIDeprecatedDate IS NULL) AND (certStates.certStateTrainerCCEIApprovedDate <= '')) ) ORDER BY certStates.certStateTrainerDefault desc, certStates.certStateTrainerCCEIDeprecatedDate desc
query
RESULTSET
query
  CERTSTATEAPPROVALSPECIALTEXT CERTSTATEREQ CERTSTATETRAINERID COUSELEVELREQ SPECIALUSETEXT STATEAPPROVALTEXT STATECODE STATECOMPETENCYCODE STATECOURSECODE STATECOURSEEXP STATECOURSEHOURS STATECOURSEIACET STATECOURSELEVEL STATECOURSETRAINER STATELOGO TRAINERCODEREQ
CACHED false
EXECUTIONTIME 8
SQL SELECT certStateReq,stateCode,stateApprovalText,stateLogo,trainerCodeReq,couseLevelReq,stateCompetencyCode,stateCourseCode, stateCourseExp,stateCoursetrainerID AS 'stateCourseTrainer',stateCourseHours,stateCourseLevel,stateCourseIacet, specialStatment1 AS 'certStateApprovalSpecialText', specialUseText, certStateTrainerID FROM dbo.ApprovedCourse('','','')

I'm sorry we were unable to find the course you were requesting a certificate for.