FACT Processing Inspector Training Course

FACT Laboratory Processing Inspector Training Course Registration

Register now for the FACT Laboratory Processing Inspector Training Course on Thursday, September 7, 2023 at the Hyatt Regency Houston in Houston, TX.

Training Course Fees:

Inspector and Inspector Trainee: $0

FACT Processing Inspector Training Course

Hyatt Regency Houston Houston, TX

Debugging Info
pagedictsize=0
sqltime = 0.030 s
cpu time = 0.130 s
real time = 0.162 s
memory increase = 17876 kB
fields =
templates =
/data/fact/current/generic/themes/www/mako/meetings/microsite_footer.html
/data/fact/current/generic/themes/www/mako/meetings/microsite_header_pixel
/data/fact/current/generic/themes/www/mako/meetings/microsite_header_responsive.html
/data/fact/current/generic/themes/www/mako/meetings/microsite_index_responsive.html
dg = [] | []
extra debug info =
queries = 26 queries

Total TimeCountAvg TimeQuery
0.0061 call
0 rows		0.006 INSERT INTO PageRequest SET mxxCreated='2025-05-09 13:48:50',mxxCreatedBy=NULL, PageRequestId=0x2113DD00000000, path='forms/meeting/Microsite/factProcessinginspectortraining,1', formName='Microsite', site='www', clientAcronym='FACT', pid='316106', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='103689', startTime='2025-05-09 13:48:50', sessionId=0x4AC0D965797FF507, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='18.116.15.98'
0.0061 call
0 rows		0.006 COMMIT
0.0051 call
1 row		0.005 SELECT DISTINCT hex(MicrositeTabComponent.MicrositeTabComponentId) AS MicrositeTabComponentId, MicrositeTabComponent.type, MicrositeTabComponent.text, MicrositeTabComponent.orderindex FROM (MicrositeTab, MicrositeTabComponent) WHERE MicrositeTabComponent.MicrositeTabId=MicrositeTab.MicrositeTabId AND MicrositeTab.MicrositeTabId=0x1B08160000054B ORDER BY MicrositeTabComponent.orderindex
0.0031 call
1 row		0.003 SELECT DISTINCT hex(Meeting.MeetingId) AS MeetingId, Meeting.name, Meeting.hostName, Meeting.description, Meeting.audienceDescription, Meeting.cosponsors, Meeting.includes, Meeting.attire, Meeting.cancellationPolicy, Meeting.thankYouText, Meeting.registrationStarts, Meeting.registrationEnds, Meeting.earlybirdCutoff, Meeting.onlineRegistrationsEnabled, Meeting.selectSessionsOnRegForm, Meeting.accountingCode, Meeting.maximumNumAttendees, Meeting.type, Meeting.showPublicSessionSearch, Meeting.allowSpouseReg, Meeting.continuingEdUnits, Meeting.mediaAllowed, Meeting.travelInfo, Meeting.hotelBlurb, Meeting.dateClosed, Meeting.showFeesOnPublicView, Meeting.showPublicSchedule, Meeting.calendarLinkType, Meeting.calendarBlurb, Meeting.retainedEarningsAcctCode, Meeting.enableHousing, Meeting.eventId, Meeting.staffNotificationEmail, Meeting.paymentInstructions, Meeting.staffCancellationEmail, Meeting.lowRoomTrigger, Meeting.continuingEdNumber, Meeting.enableRSVP, Meeting.micrositePath, Meeting.bgcolor, Meeting.accentColor, Meeting.tabTitleColor, Meeting.bodyTextColor, Meeting.linkTextColor, Meeting.rightNavTextColor, Meeting.fontTitleSize, Meeting.fontBodySize, Meeting.fontName, Meeting.navbarColor, Meeting.sidebarColor, Meeting.highlightedTabTextColor, Meeting.headlineColor, Meeting.highlightedTabColor, Meeting.inSiteAccentColor, Meeting.inSiteBodyTextColor, Meeting.inSiteHeadlineColor, Meeting.inSiteHighlightedTabColor, Meeting.inSiteHighlightedTabTextColor, Meeting.inSiteLinkTextColor, Meeting.inSiteNavbarColor, Meeting.inSiteRightNavTextColor, Meeting.inSiteSidebarColor, Meeting.inSiteTabTitleColor, Meeting.inSiteFontBodySize, Meeting.inSiteFontName, Meeting.inSiteFontTitleSize, Meeting.useBadges, Meeting.staffNotificationRevisitedEmail, Meeting.anticipatedRegistrations, Meeting._budgetedRevenue, Meeting.groupRegistrationOn, Meeting.allowPlaceholders, Meeting.feesPageTopText, Meeting.badgesPageTopText, Meeting.questionsPageTopText, Meeting.eventsPageTopText, Meeting.reviewPageTopText, Meeting.paymentPageTopText, Meeting.micrositeTemplate, Meeting.inSiteTemplate, Meeting.isWebinar, Meeting.housingPageTopText, Meeting.attendeesPageTopText, Meeting.shortCalDescription, Meeting.allowAddToCalendar, Meeting.campaignCode, Meeting.recordOrigin, Meeting.additionalFeesPageTopText, Meeting.referralText, Meeting.hasReferrals, Meeting.wwwRegistrationsEditAlwaysApprove, Meeting.thankYouFullyPaidText, Meeting.venue, Meeting.sendToLMS, Meeting.showSponsorLogos, Meeting.confSponsorText, Meeting.isArchived FROM (Meeting) WHERE Meeting.micrositePath='factProcessinginspectortraining'
0.0031 call
1 row		0.003 SELECT DISTINCT hex(Website.WebsiteId) AS WebsiteId, Website.description, Website.address FROM (Meeting, Website) WHERE Website.MeetingId=Meeting.MeetingId AND Meeting.MeetingId=0x1B081600000539
0.0021 call
1 row		0.002 SELECT DISTINCT hex(Fee.FeeId) AS FeeId, Fee.expirationDate, Fee.amount, hex(Fee.itemId) AS itemId, Fee.name, Fee.description, Fee.minGroupSize, Fee.isEarlyDiscount, Fee.membersOnly, Fee.guestsOnly, Fee.availableToGuests, Fee.accountingCode, Fee.availableToSpouses, Fee.feeCode, Fee.published, Fee.rateCategory, Fee.showOnWWW, Fee.showMembershipTypesAsMembersOnWWW, Fee.membershipTypesLabelForWWW, Fee.groupSizeRule, Fee.specialDealType, Fee.recordOrigin, Fee.confirmationText FROM (Fee, Meeting) WHERE Fee.itemId=Meeting.MeetingId AND Meeting.MeetingId=0x1B081600000539
0.0021 call
1 row		0.002 SELECT DISTINCT hex(MyMeeting.MyMeetingId) AS MyMeetingId, MyMeeting.published, MyMeeting.description, MyMeeting.mxxCreated, hex(MyMeeting.mxxCreatedBy) AS mxxCreatedBy, MyMeeting.mxxUpdated, hex(MyMeeting.mxxUpdatedBy) AS mxxUpdatedBy, MyMeeting.rule, MyMeeting.introText, MyMeeting.embedCode FROM (Meeting, MyMeeting) WHERE MyMeeting.MeetingId=Meeting.MeetingId AND Meeting.MeetingId=0x1B081600000539
0.0011 call
1 row		0.001 SELECT DISTINCT hex(FeeDateRange.FeeDateRangeId) AS FeeDateRangeId, FeeDateRange.name, FeeDateRange.startDate, FeeDateRange.endDate FROM (FeeDateRange, Meeting) WHERE FeeDateRange.MeetingId=Meeting.MeetingId AND Meeting.MeetingId=0x1B081600000539
0.0016 calls
1 row		0.000 SELECT version from databasemap;
0.0011 call
6 rows		0.001 SELECT DISTINCT hex(MicrositeTab.MicrositeTabId) AS MicrositeTabId, MicrositeTab.title, MicrositeTab.orderindex, MicrositeTab.enabled, MicrositeTab.isInSite FROM (MicrositeTab, Meeting) WHERE MicrositeTab.MeetingId=Meeting.MeetingId AND Meeting.MeetingId=0x1B081600000539
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.dontEmail, Individual.preferredMethodOfComm, Individual.mxxCreated, Individual.jobLevel, Individual.publishInDirectory, Individual.individualNum, Individual.birthDay, Individual.ageGroup, Individual.degreeLevel, Individual.maritalStatus, Individual.designations, Individual.yearJoined, Individual.otherJobFunction, Individual.numberOfChildren, Individual.namesOfChildren, Individual.groupAffiliations, Individual.schoolAttended, Individual.SACompanyName, Individual.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.emergencyContact, Individual.signedForms, Individual.affiliatedWithBank, Individual.affiliatedWithOrg, Individual.affiliatedWithOrgName, Individual.affiliatedWithBankName, Individual.inspectionAgencyNumber, Individual.otherProfessionalSocieties, Individual.membershipNumberASBMT, Individual.membershipNumberISCT, Individual.readConfidentialityPolicy, Individual.conflictOfInterests, Individual.medicalLicenseExpiration, Individual.professionalLiabilityUploaded, Individual.professionalHistoryRestrictions, Individual.professionalLiabilityCase, Individual.professionalLiabilityReasonToDeny, Individual.appropriateAffiliation, Individual.affiliationComments, Individual.cellularTherapyWorkshopDate, Individual.cordBloodWorkshopDate, Individual.cellularTherapyTestDate, Individual.cordBloodTestDate, Individual.professionalInspectionWebinarDate, Individual.trainingInspectionWebinarDate, Individual.trainingInspectionDate, Individual.satisfactoryEvaluationReport, Individual.satisfactoryInspectionReport, Individual.isInspectorPending, Individual.accreditationEndDate, Individual.accreditationStartDate, Individual.congresspersonFor, Individual.factWebAssessmentDate, Individual.factWebEventDate, Individual.congressParty, Individual.mailChimpMergeCache, Individual.otherMemberships, Individual.dateCVReceived, Individual.iieCTTestDate, Individual.anniversaryVideoDate, Individual.iecTutorialDate, Individual.accredPortalTrainingDate, Individual.annualComplianceReceived, Individual.medicalLicenseExpDate, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.SAIsBoard, Individual.delinquentSince FROM (Address, Individual) WHERE Address.AddressId=0x1B08160000053D AND Address.IndividualId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial
0.0001 call
54 rows		0.000 SELECT * FROM StateProvince ORDER BY orderindex, id
0.0001 call
158 rows		0.000 SELECT * FROM webselect
0.0001 call
1 row		0.000 SELECT DISTINCT CalendarItem.type, CalendarItem.startDate, CalendarItem.endDate, CalendarItem.location, hex(CalendarItem.CalendarItemId) AS CalendarItemId, CalendarItem.name, CalendarItem.status, CalendarItem.contactName, CalendarItem.contactPhone, CalendarItem.contactEmail, CalendarItem.description, CalendarItem.URL, CalendarItem.URLDescription, CalendarItem.handOut, CalendarItem.handOutDescription, CalendarItem.minutesUpload, CalendarItem.minutes, CalendarItem.phone, CalendarItem.fax, CalendarItem.line1, CalendarItem.line2, CalendarItem.city, CalendarItem.province, CalendarItem.zip, CalendarItem.state, CalendarItem.country, CalendarItem.attendeeNames FROM (Meeting, CalendarItem) WHERE CalendarItem.MeetingId=Meeting.MeetingId AND Meeting.MeetingId=0x1B081600000539 ORDER BY CalendarItem.startDate
0.0001 call
1 row		0.000 SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.isZipVerified, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Meeting, Address) WHERE Meeting.MeetingId=0x1B081600000539 AND Meeting.locationAddressId=Address.AddressId ORDER BY Address.zip
0.0001 call
54 rows		0.000 select id, abbreviation from StateProvince
0.0001 call
1 row		0.000 SELECT DISTINCT hex(File.FileId) AS FileId, File.filename, File.description, File.caption, File.altTag, hex(File.parentId) AS parentId FROM (File, Meeting) WHERE Meeting.bannerFileId=File.FileId AND Meeting.MeetingId=0x1B081600000539
0.0001 call
1 row		0.000 SELECT DISTINCT hex(Timezone.TimezoneId) AS TimezoneId, Timezone.description, Timezone.tzname, hex(Timezone.orderindex) AS orderindex FROM (Timezone, CalendarItem) WHERE CalendarItem.CalendarItemId=0x1B081600000553 AND CalendarItem.TimezoneId=Timezone.TimezoneId ORDER BY Timezone.orderindex
0.0001 call
0 rows		0.000 SELECT DISTINCT hex(Branch.BranchId) AS BranchId, Branch.name, Branch.isMain, Branch.mainPhone, Branch.secondaryPhone, Branch.tollFree, Branch.fax FROM (Branch, Address) WHERE Address.AddressId=0x1B08160000053D AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0001 call
1 row		0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
0 rows		0.000 START TRANSACTION