You can only gain access to certain items and special pricing if you have logged in. Login Now.

QM Series Module 6: Organizational Self-Assessments

Format:
Digital

Accredited Organization, Guest, NonMember - $100.00

Inspector, Inspector Trainee - $0.00

Description:

This webinar was held live on October 14, 2015, at 11:00 EDT. Lisa Cantwell, MHA, CPHQ, Quality Manager from St. David's South Austin Medical Center, and Diane Fournier, PhD, from Héma-Québec, described methods for assessing organizational performance and compliance with accreditation and quality requirements. This webinar was the second session in the Quality Management Series Module 6: The Quality Organization.

Product Details:

Product ID:	379
Publication Year:	2015
Pages, Size, or Length:	46 minutes

Total Time

Count

Avg Time

Query

0.013

24 calls
1 row

0.001

SELECT version from databasemap;

0.009

1 call
0 rows

0.009

COMMIT

0.009

1 call
0 rows

0.009

INSERT INTO PageRequest SET mxxCreated='2025-07-01 11:18:45',mxxCreatedBy=NULL, PageRequestId=0x21E36900000000, path='forms/store/ProductFormPublic/OrganizationalSelfAssessments', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='2822776', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='424163', startTime='2025-07-01 11:18:45', sessionId=0x3DB8A81AA3B74350, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='216.73.216.125'

0.005

1 call
0 rows

0.005

SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (Product) WHERE ProductId=(select PreviousProductId from Product where ProductId = 0x959E20000003C) ORDER BY Product.name

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(ProductRelation.ProductRelationId) AS ProductRelationId FROM (ProductRelation, Product) WHERE ProductRelation.ChildProductId=Product.ProductId AND Product.ProductId=0x959E20000003C

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(Category.CategoryId) AS CategoryId, Category.description, hex(Category.ParentCategoryId) AS ParentCategoryId FROM (Product, Category, Category2Product) WHERE (0x959E20000003C=Product.ProductId AND Product.ProductId=Category2Product.ProductId AND Category2Product.CategoryId=Category.CategoryId) ORDER BY Category.description

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(Committee.CommitteeId) AS CommitteeId, Committee.description, Committee.startDate, Committee.endDate, Committee.status, Committee.deleted, Committee.type, Committee.category, Committee.name, Committee.reportsTo, Committee.lifespan, Committee.hidden, Committee.showParticipationOnIndividualView, Committee.showOnMemberParticipationreport, Committee.recordOrigin, Committee.isBoard, Committee.myCommitteeNotes, Committee.inceptionYear, Committee.notes FROM (MailingList, Committee) WHERE MailingList.CommitteeId=Committee.CommitteeId AND MailingList.MailingListId=0x21E36900000013 ORDER BY Committee.name

0.004

1 call
3 rows

0.004

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x959E2000000A0=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MembershipType2ProductPrice.ProductPriceId AND MembershipType2ProductPrice.id=MembershipType.id) ORDER BY MembershipType.orderindex

0.004

1 call
2 rows

0.004

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x959E20000003F=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MembershipType2ProductPrice.ProductPriceId AND MembershipType2ProductPrice.id=MembershipType.id) ORDER BY MembershipType.orderindex

0.004

1 call
4 rows

0.004

SELECT DISTINCT hex(WebTab.WebTabId) AS WebTabId, WebTab.name, WebTab.link, WebTab.description, hex(WebTab.parent) AS parent, WebTab.requiredSetting, WebTab.defaultSubTab FROM (WebTab) WHERE WebTab.parent=0xA ORDER BY WebTab.WebTabId

0.003

1 call
3 rows

0.003

SELECT DISTINCT hex(ProductPrice.ProductPriceId) AS ProductPriceId, ProductPrice.amount, ProductPrice.minQuantity, ProductPrice.maxQuantity, ProductPrice.shipType, ProductPrice.priceType, ProductPrice.description, ProductPrice.accountingCode, ProductPrice.membershipTypesLabelForWWW FROM (Product, ProductPrice) WHERE ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0x959E20000003C ORDER BY ProductPrice.description, ProductPrice.minQuantity

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (ProductRelation, Product) WHERE ProductRelation.ProductRelationId=0x21E36900000002 AND ProductRelation.ChildProductId=Product.ProductId ORDER BY Product.name

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(FileProtectionType.FileProtectionTypeId) AS FileProtectionTypeId, FileProtectionType.name, FileProtectionType.description, FileProtectionType.path, FileProtectionType.prefix FROM (File, FileProtectionType) WHERE File.FileId=0x959E20000003D AND File.fileProtectionTypeId=FileProtectionType.FileProtectionTypeId

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(MailingList.MailingListId) AS MailingListId, MailingList.name, MailingList.shortName, MailingList.description, MailingList.shortDescription, MailingList.joinRule, MailingList.postRule, MailingList.deleted, MailingList.password, MailingList.welcomeText, MailingList.goodbyeText, MailingList.messageFooter, MailingList.replyDesination, MailingList.replyDesinationEmail, MailingList.maxEmailSizeKB, MailingList.moderated, MailingList.listVolume, MailingList.accessRules, MailingList.dynamic, MailingList.criteria, MailingList.ignoreDontEmail, MailingList.criteriaDict, MailingList.staffPostingOnly, MailingList.prepend, MailingList.criteriaName, MailingList.showOnMemberParticipationReport, MailingList.showParticipationOnIndividualView, MailingList.availableToCMS, MailingList.numberExcludedByDontEmail, MailingList.numberExcludedByCriteria, MailingList.numberIncludedByCriteria, MailingList.numberSubscribedAsDigest, MailingList.hasMailingList, MailingList.numberExcludedByNonMembership, MailingList.numberExcludedForNoEmail, MailingList.mailChimpListId, MailingList.hourlySync, MailingList.prettyName, MailingList.frequency, MailingList.grouping, MailingList.campaignMonitorListId FROM (Product, MailingList, Product2MailingList) WHERE (0x959E20000003C=Product.ProductId AND Product.ProductId=Product2MailingList.ProductId AND Product2MailingList.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name

0.003

1 call
158 rows

0.003

SELECT * FROM webselect

0.003

1 call
0 rows

0.003

1 call
1 row

0.003

SELECT DISTINCT hex(MailingList.MailingListId) AS MailingListId, MailingList.name, MailingList.shortName, MailingList.description, MailingList.shortDescription, MailingList.joinRule, MailingList.postRule, MailingList.deleted, MailingList.password, MailingList.welcomeText, MailingList.goodbyeText, MailingList.messageFooter, MailingList.replyDesination, MailingList.replyDesinationEmail, MailingList.maxEmailSizeKB, MailingList.moderated, MailingList.listVolume, MailingList.accessRules, MailingList.dynamic, MailingList.criteria, MailingList.ignoreDontEmail, MailingList.criteriaDict, MailingList.staffPostingOnly, MailingList.prepend, MailingList.criteriaName, MailingList.showOnMemberParticipationReport, MailingList.showParticipationOnIndividualView, MailingList.availableToCMS, MailingList.numberExcludedByDontEmail, MailingList.numberExcludedByCriteria, MailingList.numberIncludedByCriteria, MailingList.numberSubscribedAsDigest, MailingList.hasMailingList, MailingList.numberExcludedByNonMembership, MailingList.numberExcludedForNoEmail, MailingList.mailChimpListId, MailingList.hourlySync, MailingList.prettyName, MailingList.frequency, MailingList.grouping, MailingList.campaignMonitorListId FROM (ProductPrice, MailingList2ProductPrice, MailingList) WHERE (0x959E20000003F=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MailingList2ProductPrice.ProductPriceId AND MailingList2ProductPrice.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (ProductRelation, Product) WHERE ProductRelation.ProductRelationId=0x21E36900000002 AND ProductRelation.ParentProductId=Product.ProductId ORDER BY Product.name

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (ProductRelation, Product) WHERE ProductRelation.ProductRelationId=0x21E36900000006 AND ProductRelation.ChildProductId=Product.ProductId ORDER BY Product.name

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(ProductRelation.ProductRelationId) AS ProductRelationId FROM (ProductRelation, Product) WHERE ProductRelation.ParentProductId=Product.ProductId AND Product.ProductId=0x959E20000003C

0.002

1 call
1 row

0.002

SELECT * FROM uuid FOR UPDATE

0.002

2 calls
0 rows

0.001

SELECT hex(ReportingType.ReportingTypeId) AS ReportingTypeId, ReportingType.description, ReportingType.orderindex FROM (ReportingType) ORDER BY ReportingType.orderindex LIMIT 0, 700

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice2SpecialOffer, Product, SpecialOffer, ProductPrice) WHERE ((ProductPrice.ProductId=Product.ProductId AND Product.ProductId=0x959E20000003C AND (ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)) AND SpecialOffer.expires>'2025-07-01 11:18:45')

0.002

1 call
0 rows

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (ProductRelation, Product) WHERE ProductRelation.ProductRelationId=0x21E36900000006 AND ProductRelation.ParentProductId=Product.ProductId ORDER BY Product.name

0.002

1 call
1 row

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(Site.SiteId) AS SiteId, Site.dateDeleted, Site.face, Site.name, Site.storeFront, Site.howToOrder, Site.url FROM (Product, ProductFeaturedOn2Site, Site) WHERE (0x959E20000003C=Product.ProductId AND Product.ProductId=ProductFeaturedOn2Site.ProductId AND ProductFeaturedOn2Site.SiteId=Site.SiteId)

0.002

1 call
0 rows

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice2SpecialOffer, SpecialOffer, ProductPrice) WHERE (0x959E20000003E=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(MailingList.MailingListId) AS MailingListId, MailingList.name, MailingList.shortName, MailingList.description, MailingList.shortDescription, MailingList.joinRule, MailingList.postRule, MailingList.deleted, MailingList.password, MailingList.welcomeText, MailingList.goodbyeText, MailingList.messageFooter, MailingList.replyDesination, MailingList.replyDesinationEmail, MailingList.maxEmailSizeKB, MailingList.moderated, MailingList.listVolume, MailingList.accessRules, MailingList.dynamic, MailingList.criteria, MailingList.ignoreDontEmail, MailingList.criteriaDict, MailingList.staffPostingOnly, MailingList.prepend, MailingList.criteriaName, MailingList.showOnMemberParticipationReport, MailingList.showParticipationOnIndividualView, MailingList.availableToCMS, MailingList.numberExcludedByDontEmail, MailingList.numberExcludedByCriteria, MailingList.numberIncludedByCriteria, MailingList.numberSubscribedAsDigest, MailingList.hasMailingList, MailingList.numberExcludedByNonMembership, MailingList.numberExcludedForNoEmail, MailingList.mailChimpListId, MailingList.hourlySync, MailingList.prettyName, MailingList.frequency, MailingList.grouping, MailingList.campaignMonitorListId FROM (ProductPrice, MailingList2ProductPrice, MailingList) WHERE (0x959E20000003E=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MailingList2ProductPrice.ProductPriceId AND MailingList2ProductPrice.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (Product) WHERE Product.slug='OrganizationalSelfAssessments' ORDER BY Product.name

0.001

2 calls
1 row

0.001

select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Product where ProductId=0x959E20000003C

0.001

2 calls
1 row

0.001

select max(returnOrder) from Stack where sessionId = 4447489464397677392

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice2SpecialOffer, SpecialOffer, ProductPrice) WHERE (0x959E20000003F=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(File.FileId) AS FileId, File.filename, File.description, File.caption, File.altTag, hex(File.parentId) AS parentId FROM (Product, File) WHERE Product.downloadFileId=File.FileId AND Product.ProductId=0x959E20000003C

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(MailingList.MailingListId) AS MailingListId, MailingList.name, MailingList.shortName, MailingList.description, MailingList.shortDescription, MailingList.joinRule, MailingList.postRule, MailingList.deleted, MailingList.password, MailingList.welcomeText, MailingList.goodbyeText, MailingList.messageFooter, MailingList.replyDesination, MailingList.replyDesinationEmail, MailingList.maxEmailSizeKB, MailingList.moderated, MailingList.listVolume, MailingList.accessRules, MailingList.dynamic, MailingList.criteria, MailingList.ignoreDontEmail, MailingList.criteriaDict, MailingList.staffPostingOnly, MailingList.prepend, MailingList.criteriaName, MailingList.showOnMemberParticipationReport, MailingList.showParticipationOnIndividualView, MailingList.availableToCMS, MailingList.numberExcludedByDontEmail, MailingList.numberExcludedByCriteria, MailingList.numberIncludedByCriteria, MailingList.numberSubscribedAsDigest, MailingList.hasMailingList, MailingList.numberExcludedByNonMembership, MailingList.numberExcludedForNoEmail, MailingList.mailChimpListId, MailingList.hourlySync, MailingList.prettyName, MailingList.frequency, MailingList.grouping, MailingList.campaignMonitorListId FROM (ProductPrice, MailingList2ProductPrice, MailingList) WHERE (0x959E2000000A0=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MailingList2ProductPrice.ProductPriceId AND MailingList2ProductPrice.MailingListId=MailingList.MailingListId) ORDER BY MailingList.name

0.001

1 call
2 rows

0.001

SELECT * FROM YesNo ORDER BY orderindex, id

0.001

2 calls
1 row

0.000

select mxxCreated, mxxUpdated from Product where ProductId=0x959E20000003C;

0.001

2 calls
5 rows

0.000

SELECT * FROM ShipType ORDER BY orderindex, id

0.001

1 call
4 rows

0.001

SELECT * FROM Folks ORDER BY orderindex, id

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(Site.SiteId) AS SiteId, Site.dateDeleted, Site.face, Site.name, Site.storeFront, Site.howToOrder, Site.url FROM (Product, Site, Product2Site) WHERE (0x959E20000003C=Product.ProductId AND Product.ProductId=Product2Site.ProductId AND Product2Site.SiteId=Site.SiteId)

0.001

1 call
1 row

0.001

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 (User, Individual) WHERE Individual.userId=User.UserId AND User.UserId=0x78498000000F5 ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

2 calls
2 rows

0.000

SELECT * FROM ProductActivationStatus ORDER BY orderindex, id

0.001

2 calls
4 rows

0.000

SELECT * FROM Language ORDER BY orderindex, id

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(SpecialOffer.SpecialOfferId) AS SpecialOfferId, SpecialOffer.discount, SpecialOffer.expires, SpecialOffer.month, SpecialOffer.description FROM (ProductPrice2SpecialOffer, SpecialOffer, ProductPrice) WHERE (0x959E2000000A0=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=ProductPrice2SpecialOffer.ProductPriceId AND ProductPrice2SpecialOffer.SpecialOfferId=SpecialOffer.SpecialOfferId)

0.000

1 call
13 rows

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ReportingType.ReportingTypeId) AS ReportingTypeId, ReportingType.description, ReportingType.orderindex FROM (Product, ReportingType) WHERE Product.ProductId=0x959E20000003C AND Product.reportingTypeId=ReportingType.ReportingTypeId ORDER BY ReportingType.orderindex

0.000

1 call
3 rows

0.000

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (ProductPrice, MembershipType2ProductPrice, MembershipType) WHERE (0x959E20000003E=ProductPrice.ProductPriceId AND ProductPrice.ProductPriceId=MembershipType2ProductPrice.ProductPriceId AND MembershipType2ProductPrice.id=MembershipType.id) ORDER BY MembershipType.orderindex

0.000

1 call
5 rows

0.000

SELECT DISTINCT hex(MembershipType.id) AS id, MembershipType.description, MembershipType.campaignCode FROM (Product, MembershipType2Product, MembershipType) WHERE (0x959E20000003C=Product.ProductId AND Product.ProductId=MembershipType2Product.ProductId AND MembershipType2Product.id=MembershipType.id) ORDER BY MembershipType.orderindex

0.000

1 call
8 rows

0.000

SELECT * FROM ProductType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

1 call
2 rows

0.000

SELECT * FROM ProductStatus ORDER BY orderindex, id

0.000

1 call
12 rows

0.000

SELECT * FROM Month ORDER BY orderindex, id

0.000

1 call
3 rows

0.000

SELECT * FROM PriceType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

START TRANSACTION

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(User.UserId) AS UserId, User.username, User.password, User.encoding, hex(User.VotingId) AS VotingId, User.lastSearchType, User.oneTimeKey, User.recoverPasswordKey, User.recoverPasswordTimeout, User.disableAllNotifications, User.otCodeTime, User.otCode, User.holyGrailSections FROM (User) WHERE User.UserId=0x78498000000F5

859896 function calls (850063 primitive calls) in 1.532 seconds Ordered by: cumulative time List reduced from 2634 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.533 1.533 /data/fact/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 1.117 1.117 /data/fact/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 1.075 1.075 /data/fact/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.075 1.075 /data/fact/current/generic/sites/www/forms/store/ProductFormPublic.py:30(index) 1 0.000 0.000 1.071 1.071 /data/fact/current/libs/framework/WebForm.py:191(view) 1 0.000 0.000 0.540 0.540 /data/fact/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.539 0.539 /data/fact/current/libs/framework/WebApp.py:213(wrapHTML) 7/1 0.000 0.000 0.478 0.478 /data/fact/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 11/1 0.000 0.000 0.478 0.478 /data/fact/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 1 0.000 0.000 0.468 0.468 /data/fact/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.453 0.453 /data/fact/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 0.397 0.397 /data/fact/current/libs/framework/WebManager.py:89(createNewHandler) 1 0.000 0.000 0.397 0.397 /data/fact/current/libs/framework/WebSite.py:92(__init__) 141 0.004 0.000 0.388 0.003 /data/fact/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 1 0.000 0.000 0.291 0.291 /usr/lib/python3.11/urllib/request.py:139(urlopen) 2/1 0.000 0.000 0.290 0.290 /usr/lib/python3.11/urllib/request.py:500(open) 5/3 0.000 0.000 0.290 0.097 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 2 0.000 0.000 0.290 0.145 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 0.290 0.145 /usr/lib/python3.11/urllib/request.py:1307(do_open) 19/10 0.001 0.000 0.224 0.022 /data/fact/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 9/5 0.000 0.000 0.211 0.042 /data/fact/current/libs/framework/DGEAssocList.py:380(getBBTDictionary) 93 0.001 0.000 0.200 0.002 /data/fact/current/libs/framework/DGEAttribute.py:58(getEditHTML) 121 0.001 0.000 0.193 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 121 0.001 0.000 0.192 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 357/174 0.006 0.000 0.188 0.001 {built-in method builtins.exec} 200/127 0.001 0.000 0.186 0.001 :1165(_find_and_load) 200/127 0.001 0.000 0.183 0.001 :1120(_find_and_load_unlocked) 297 0.002 0.000 0.178 0.001 /data/fact/current/libs/framework/DTWrapper.py:47(__call__) 219/146 0.001 0.000 0.178 0.001 :666(_load_unlocked) 297 0.011 0.000 0.176 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 220/149 0.001 0.000 0.170 0.001 :934(exec_module) 121 0.000 0.000 0.163 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 121 0.163 0.001 0.163 0.001 {function Connection.query at 0xff094e2c1c60} 1 0.004 0.004 0.161 0.161 /data/fact/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 2 0.000 0.000 0.153 0.076 /usr/lib/python3.11/http/client.py:1351(getresponse) 2 0.000 0.000 0.153 0.076 /usr/lib/python3.11/http/client.py:318(begin) 79 0.000 0.000 0.152 0.002 {method 'readline' of '_io.BufferedReader' objects} 14 0.000 0.000 0.152 0.011 /usr/lib/python3.11/socket.py:704(readinto) 2 0.000 0.000 0.152 0.076 /usr/lib/python3.11/http/client.py:285(_read_status) 2 0.001 0.000 0.152 0.076 /data/fact/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 447/271 0.000 0.000 0.150 0.001 :233(_call_with_frames_removed) 8 0.011 0.001 0.148 0.019 /data/fact/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 2/1 0.000 0.000 0.148 0.148 /usr/lib/python3.11/urllib/request.py:628(http_response) 1 0.000 0.000 0.148 0.148 /usr/lib/python3.11/urllib/request.py:544(error) 1 0.000 0.000 0.148 0.148 /usr/lib/python3.11/urllib/request.py:691(http_error_302) 1 0.000 0.000 0.147 0.147 /usr/lib/python3.11/urllib/request.py:1390(https_open) 1 0.000 0.000 0.143 0.143 /usr/lib/python3.11/urllib/request.py:1376(http_open) 8 0.111 0.014 0.137 0.017 /data/fact/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 448 0.007 0.000 0.129 0.000 /data/fact/current/libs/framework/DGEAttribute.py:207(getValue) 393/297 0.001 0.000 0.116 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 93 0.001 0.000 0.114 0.001 /data/fact/current/libs/framework/DGEAttribute.py:45(massageDictForEditHTML) 1171/297 0.020 0.000 0.113 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 79 0.000 0.000 0.110 0.001 /data/fact/current/libs/framework/DGEInput.py:29(massageDictForEditHTML) 13 0.000 0.000 0.107 0.008 /usr/lib/python3.11/ssl.py:1299(recv_into) 13 0.000 0.000 0.107 0.008 /usr/lib/python3.11/ssl.py:1157(read) 13 0.107 0.008 0.107 0.008 {method 'read' of '_ssl._SSLSocket' objects} 2 0.000 0.000 0.107 0.053 /usr/lib/python3.11/http/client.py:1300(request) 2 0.000 0.000 0.107 0.053 /usr/lib/python3.11/http/client.py:1305(_send_request) 2 0.000 0.000 0.107 0.053 /usr/lib/python3.11/http/client.py:1287(endheaders) 2 0.000 0.000 0.107 0.053 /usr/lib/python3.11/http/client.py:1049(_send_output) 2 0.000 0.000 0.107 0.053 /usr/lib/python3.11/http/client.py:988(send) 55 0.000 0.000 0.105 0.002 /data/fact/current/libs/utils/htmlTools.py:100(cleanHTML) 1 0.000 0.000 0.104 0.104 /data/fact/current/libs/framework/DisplayGroup.py:311(initialize) 16147/15734 0.010 0.000 0.104 0.000 /data/fact/current/libs/framework/BaseHandler.py:1458(mxxImporter) 12 0.000 0.000 0.101 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 0.100 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 12 0.000 0.000 0.100 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 2 0.000 0.000 0.099 0.049 /usr/lib/python3.11/http/client.py:959(connect) 2 0.000 0.000 0.099 0.049 /usr/lib/python3.11/socket.py:821(create_connection) 12 0.000 0.000 0.098 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 12 0.000 0.000 0.098 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 12 0.004 0.000 0.098 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 2 0.000 0.000 0.097 0.048 /usr/lib/python3.11/socket.py:957(getaddrinfo) 2 0.097 0.048 0.097 0.048 {built-in method _socket.getaddrinfo} 108 0.001 0.000 0.093 0.001 /usr/lib/python3.11/re/__init__.py:272(_compile) 104 0.000 0.000 0.093 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 42 0.001 0.000 0.093 0.002 /data/fact/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 16170/15738 0.008 0.000 0.092 0.000 {built-in method builtins.__import__} 48 0.000 0.000 0.091 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 3 0.000 0.000 0.091 0.030 /data/fact/current/libs/framework/DGELongInput.py:14(massageDictForEditHTML) 1 0.000 0.000 0.086 0.086 /data/fact/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts) 392/314 0.001 0.000 0.083 0.000 /data/fact/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 32 0.000 0.000 0.082 0.003 /data/fact/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 8 0.000 0.000 0.082 0.010 /data/fact/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 1 0.000 0.000 0.081 0.081 /data/fact/current/libs/framework/WebManInterface.py:92(createBroker) 103/85 0.000 0.000 0.081 0.001 /data/fact/current/libs/PLayer/PersistentBroker.py:78(__new__) 14 0.000 0.000 0.078 0.006 /data/fact/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 14 0.000 0.000 0.078 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 14 0.000 0.000 0.078 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 1 0.016 0.016 0.077 0.077 /data/fact/current/libs/PLayer/PersistentBroker.py:442(retrieveClassMaps) 14 0.000 0.000 0.075 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 20 0.000 0.000 0.075 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 20 0.001 0.000 0.075 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 1 0.000 0.000 0.071 0.071 /data/fact/current/libs/framework/baseScrapeAndDrape.py:714(process) 2 0.000 0.000 0.071 0.035 /data/fact/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup) 48 0.000 0.000 0.069 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 8147/7815 0.005 0.000 0.066 0.000 {built-in method builtins.getattr} 41 0.001 0.000 0.059 0.001 /data/fact/current/libs/framework/BaseHandler.py:311(getTemplate) 112 0.056 0.000 0.057 0.001 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 3043 0.003 0.000 0.055 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match)

QM Series Module 6: Organizational Self-Assessments

Description:

Product Details:

Services

About

Help and Advice

Phone

Address

fact@factglobal.org