Events

Annual Meeting 2014

Tuesday, October 21 (7:30am) - Wednesday, October 22, 2014 (4pm US/Pacific)
Hyatt Place Dublin/Pleasanton
4950 Hacienda Drive
London 94568
United Kingdom

Add to Calendar

My Meetings

The registration period for this meeting has ended.

Schedule

Topics covered:
Understanding how MDS Data is used for resident centered care, surveys, payment and CDPH enforcement efforts
Tracking and Trending MDS data for facility QAA use
Understanding the new Care Area Triggers (CATs)
Tips and techniques for conducting required resident interviews
MDS 3.0 data elements including admission screening for geriatric syndromes that are often missed,
Quarterly and Discharge and correction assessments
How to avoid common errors in MDS Coding
Hands on practice in completing select sections of the MDS

Registration Includes:

Continental breakfast available both days from 7:30-8:00

Who Should Attend:

Nurses and other IDT members new to their position or those who have not attended a formal MDS 3.0 coding class. Administrators and DONs who wish to gain understanding of how MDS data impacts payment and 5-Star Ratings and how MDS assessments can support culture change efforts and promote life quality for residents.

General Hotel Information:

Hyatt Place Dublin/Pleasanton
4950 Hacienda Drive, Dublin, CA 94568
(925) 828-9006

For more information please contact:

Mr. Adrian Carter
Dakota Minnesota & Eastern Railroad
Phone: (605) 555-5555
Fax: (605) 555-5555
Email: acarter-example.com@maxx.matrixgroup.net

Total Time

Count

Avg Time

Query

0.008

5 calls
1 row

0.002

SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration, Invoice) WHERE ((((((`Registration`.`InvoiceId`=`Invoice`.`InvoiceId` AND IFNULL(`Invoice`.`_SABalance`, 0)>0) AND `Registration`.`MeetingId`=0x2FAA00000067) AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2025-08-21 19:34:24')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0x2FAA00000067)

0.006

1 call
0 rows

0.006

SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Meeting, Website) WHERE `Website`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2FAA00000067

0.006

4 calls
244 rows

0.001

SELECT * FROM Country ORDER BY orderindex, id

0.005

1 call
0 rows

0.005

COMMIT

0.004

2 calls
1 row

0.002

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`signedPriorAuthLetter`, `Company`.`priorAuthLetterExpDate`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`isMergeProtected` FROM (BranchAffiliationHistory, Company, Branch, Individual) WHERE (((`BranchAffiliationHistory`.`active`='Y' AND `BranchAffiliationHistory`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x23100002F93) AND `BranchAffiliationHistory`.`BranchId`=`Branch`.`BranchId`) AND `Branch`.`CompanyId`=`Company`.`CompanyId`) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Meeting, File) WHERE `File`.`parentId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2FAA00000067

0.003

2 calls
1 row

0.001

select max(returnOrder) from Stack where sessionId = 357144759705872295

0.003

6 calls
1 row

0.000

SELECT version from databasemap;

0.003

1 call
0 rows

0.003

START TRANSACTION

0.002

1 call
0 rows

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`=0x2FAA00000067

0.002

2 calls
1 row

0.001

select mxxCreated, mxxUpdated from Meeting where MeetingId=0x2FAA00000067;

0.002

1 call
1 row

0.002

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`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`ceus`, `Individual`.`mailChimpMergeCache`, `Individual`.`training`, `Individual`.`dateOfBirth`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`specialNeeds`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Meeting, Individual) WHERE `Meeting`.`MeetingId`=0x2FAA00000067 AND `Meeting`.`contactIndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.002

1 call
1 row

0.002

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x231000000A6 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='meetings_WWWreg_noRegMsg_reg_ended' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='personalProfile_editPhoto' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.001

4 calls
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

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`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`ceus`, `Individual`.`mailChimpMergeCache`, `Individual`.`training`, `Individual`.`dateOfBirth`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`specialNeeds`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (User, Individual) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0x14D00000000 ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

1 call
1 row

0.001

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`.`CEU_frac`, `Meeting`.`showSponsorLogos`, `Meeting`.`confSponsorText`, `Meeting`.`isArchived` FROM (Meeting) WHERE `Meeting`.`MeetingId`=0x2FAA00000067

0.001

2 calls
1 row

0.000

select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Meeting where MeetingId=0x2FAA00000067

0.001

1 call
1 row

0.001

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`=0x2FAA00000067 ORDER BY `CalendarItem`.`startDate`

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Category, Meeting, Meeting2Category) WHERE (0x2FAA00000067=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=`Meeting2Category`.`MeetingId` AND `Meeting2Category`.`CategoryId`=`Category`.`CategoryId`) ORDER BY `Category`.`description`

0.001

1 call
1 row

0.001

SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration, Invoice) WHERE ((((((`Registration`.`InvoiceId`=`Invoice`.`InvoiceId` AND IFNULL(`Invoice`.`_SABalance`, 0)<=0) AND `Registration`.`MeetingId`=0x2FAA00000067) AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2025-08-21 19:34:24')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0x2FAA00000067)

0.001

1 call
155 rows

0.001

SELECT * FROM webselect

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`FeeDateRange`.`FeeDateRangeId`) AS `FeeDateRangeId`, `FeeDateRange`.`name`, `FeeDateRange`.`startDate`, `FeeDateRange`.`endDate` FROM (Meeting, FeeDateRange) WHERE `FeeDateRange`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2FAA00000067

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Event`.`EventId`) AS `EventId`, `Event`.`name`, `Event`.`description`, `Event`.`date`, `Event`.`price`, `Event`.`accountingCode`, `Event`.`selectOnRegForm`, `Event`.`maximumNumAttendees`, `Event`.`location`, `Event`.`startTime`, `Event`.`endTime`, `Event`.`notes`, `Event`.`useSignups`, `Event`.`showOnMeetingView`, `Event`.`publishToCalendar`, `Event`.`publishToSchedule` FROM (Event, Meeting) WHERE `Event`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2FAA00000067 ORDER BY `Event`.`startTime`, `Event`.`name`

0.000

1 call
2 rows

0.000

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 (Meeting, Fee) WHERE `Fee`.`itemId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2FAA00000067

0.000

1 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`=0x2FAA00000067 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

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`=0x14D00000000

0.000

1 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`=0x2FAA00000072 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.000

1 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`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`ceus`, `Individual`.`mailChimpMergeCache`, `Individual`.`training`, `Individual`.`dateOfBirth`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`specialNeeds`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Address, Individual) WHERE `Address`.`AddressId`=0x2FAA00000074 AND `Address`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.000

1 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 (Meeting, File) WHERE `Meeting`.`logoFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x2FAA00000067

0.000

1 call
4 rows

0.000

SELECT * FROM MaleOrFemale ORDER BY orderindex, id

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`alphaSort`, `Company`.`yearEstablished`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`matchString`, `Company`.`recordOrigin`, `Company`.`minorityOwned`, `Company`.`womanOwned`, `Company`.`companyStruct`, `Company`.`howHeardAboutOther`, `Company`.`silent`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`createdOnWWW`, `Company`.`mxxCreated`, `Company`.`signedPriorAuthLetter`, `Company`.`priorAuthLetterExpDate`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`isMergeProtected` FROM (Company, Branch) WHERE `Branch`.`BranchId`=0x231000000A5 AND `Branch`.`CompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Meeting, File) WHERE `Meeting`.`inSiteBannerFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x2FAA00000067

0.000

1 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 (Address, Branch) WHERE `Address`.`AddressId`=0x2FAA00000074 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-21 19:34:24',`mxxCreatedBy`=NULL, `PageRequestId`=0x1F4E9500000000, `path`='forms/meeting/MeetingFormPublic/view', `formName`='MeetingFormPublic', `site`='www', `clientAcronym`='DEMO', `pid`='2981084', `requestNum`='1', `pageDictSize`=NULL, `objectId`='2FAA00000067', `templateMethod`=NULL, `growth`=NULL, `server`='www.demo.maxx.matrixdev.net', `dbThreadId`='645743', `startTime`='2025-08-21 19:34:24', `sessionId`=0x4F4D54447A927A7, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'2FAA00000067\\'}', `clientIPAddr`='216.73.216.122'

0.000

1 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 (Address, Individual) WHERE `Individual`.`IndividualId`=0x23100002F93 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
9 rows

0.000

SELECT * FROM MemberCommunicationType ORDER BY orderindex, id

0.000

1 call
5 rows

0.000

SELECT * FROM JobLevel ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Meeting, File) WHERE `Meeting`.`bannerFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x2FAA00000067

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

937111 function calls (927797 primitive calls) in 1.510 seconds Ordered by: cumulative time List reduced from 2564 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.511 1.511 /data/demo/current/libs/framework/WebManager.py:136(_newRequest) 1 0.000 0.000 1.046 1.046 /data/demo/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 1.003 1.003 /data/demo/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.003 1.003 /data/demo/current/libs/webform/meeting/baseMeetingForm.py:317(view) 1 0.000 0.000 1.003 1.003 /data/demo/current/libs/webform/PhatForm.py:420(view) 1 0.000 0.000 1.003 1.003 /data/demo/current/libs/framework/WebForm.py:190(view) 1 0.000 0.000 0.736 0.736 /data/demo/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.733 0.733 /data/demo/current/libs/framework/WebApp.py:213(wrapHTML) 1 0.000 0.000 0.593 0.593 /data/demo/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.592 0.592 /data/demo/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 0.442 0.442 /data/demo/current/libs/framework/WebManager.py:90(createNewHandler) 1 0.000 0.000 0.442 0.442 /data/demo/current/libs/framework/WebSite.py:92(__init__) 12 0.000 0.000 0.348 0.029 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 0.345 0.029 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 12 0.000 0.000 0.345 0.029 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 12 0.000 0.000 0.338 0.028 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 12 0.000 0.000 0.338 0.028 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 12 0.011 0.001 0.337 0.028 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 325/147 0.008 0.000 0.273 0.002 {built-in method builtins.exec} 191/122 0.001 0.000 0.267 0.002 :1165(_find_and_load) 1 0.006 0.006 0.265 0.265 /data/demo/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 191/122 0.001 0.000 0.261 0.002 :1120(_find_and_load_unlocked) 192/122 0.001 0.000 0.247 0.002 :666(_load_unlocked) 194/126 0.000 0.000 0.246 0.002 :934(exec_module) 1 0.000 0.000 0.230 0.230 /data/demo/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts) 410/242 0.000 0.000 0.225 0.001 :233(_call_with_frames_removed) 2 0.000 0.000 0.196 0.098 /data/demo/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup) 15 0.000 0.000 0.191 0.013 /data/demo/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 15 0.000 0.000 0.191 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 15 0.000 0.000 0.190 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 15 0.000 0.000 0.187 0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 24 0.000 0.000 0.187 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 24 0.004 0.000 0.186 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 1 0.000 0.000 0.186 0.186 /data/demo/current/generic/sites/www/forms/meeting/MeetingFormPublic.py:114(massageDictionary) 1 0.000 0.000 0.173 0.173 /data/demo/current/libs/webform/meeting/baseMeetingForm.py:63(massageDictionary) 26020/25635 0.017 0.000 0.166 0.000 /data/demo/current/libs/framework/BaseHandler.py:1458(mxxImporter) 1 0.000 0.000 0.161 0.161 /data/demo/current/libs/utils/meetingHeader.py:44(AddMeetingHeader) 1 0.000 0.000 0.161 0.161 /data/demo/current/libs/utils/meetingHeader.py:15(getMeetingHeader) 12 0.000 0.000 0.156 0.013 /data/demo/current/libs/utils/htmlTools.py:100(cleanHTML) 1 0.000 0.000 0.153 0.153 /data/demo/current/libs/framework/DisplayGroup.py:311(initialize) 3547 0.018 0.000 0.148 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 1 0.000 0.000 0.145 0.145 /data/demo/current/libs/framework/baseScrapeAndDrape.py:494(_includeMaxxJavascript) 3 0.000 0.000 0.145 0.048 /data/demo/current/libs/PLayer/PersistentObject.py:2693(getCleanAttr) 26042/25639 0.020 0.000 0.145 0.000 {built-in method builtins.__import__} 5256 0.005 0.000 0.141 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 1 0.000 0.000 0.140 0.140 /data/demo/current/libs/framework/baseScrapeAndDrape.py:714(process) 2 0.003 0.001 0.134 0.067 /data/demo/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 81 0.002 0.000 0.133 0.002 /usr/lib/python3.11/re/__init__.py:272(_compile) 74 0.000 0.000 0.133 0.002 /usr/lib/python3.11/re/__init__.py:225(compile) 8 0.005 0.001 0.130 0.016 /data/demo/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 46 0.000 0.000 0.130 0.003 /usr/lib/python3.11/re/_compiler.py:740(compile) 8 0.102 0.013 0.126 0.016 /data/demo/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 5256 0.014 0.000 0.103 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 5082 0.095 0.000 0.100 0.000 /data/demo/current/libs/framework/LazyDict.py:71(__setitem__) 46 0.000 0.000 0.097 0.002 /usr/lib/python3.11/re/_compiler.py:573(_code) 1 0.000 0.000 0.093 0.093 /usr/lib/python3.11/urllib/request.py:139(urlopen) 1024/940 0.002 0.000 0.093 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 1 0.000 0.000 0.093 0.093 /usr/lib/python3.11/urllib/request.py:500(open) 1 0.000 0.000 0.093 0.093 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 0.093 0.046 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 1 0.000 0.000 0.093 0.093 /usr/lib/python3.11/urllib/request.py:1390(https_open) 1 0.000 0.000 0.093 0.093 /usr/lib/python3.11/urllib/request.py:1307(do_open) 76 0.002 0.000 0.092 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 76 0.000 0.000 0.090 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 1059 0.003 0.000 0.085 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 1 0.000 0.000 0.085 0.085 /data/demo/current/libs/framework/baseScrapeAndDrape.py:473(_includeMaxxCSS) 113 0.080 0.001 0.082 0.001 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 5256 0.006 0.000 0.080 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 76 0.000 0.000 0.079 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 76 0.079 0.001 0.079 0.001 {function Connection.query at 0xe1163306f100} 1 0.000 0.000 0.072 0.072 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 1 0.000 0.000 0.071 0.071 /data/demo/current/libs/framework/DGEEmail.py:1() 1 0.000 0.000 0.071 0.071 /data/demo/current/libs/framework/MakoTemplate.py:48(__call__) 1 0.000 0.000 0.071 0.071 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:461(render) 1 0.000 0.000 0.071 0.071 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:860(_render) 1 0.000 0.000 0.071 0.071 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:912(_render_context) 1 0.000 0.000 0.071 0.071 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:927(_exec_template) 1 0.000 0.000 0.070 0.070 /tmp/mako_modules_1011/demo/www/25.1.2/data/demo/current/generic/themes/www/mako/meetings/viewMeeting.html.py:28(render_body) 530/470 0.001 0.000 0.068 0.000 :1207(_handle_fromlist) 1 0.000 0.000 0.067 0.067 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/__init__.py:1() 1 0.000 0.000 0.066 0.066 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/validate_email.py:1() 1 0.000 0.000 0.066 0.066 /usr/lib/python3.11/http/client.py:1426(__init__) 1 0.000 0.000 0.066 0.066 /usr/lib/python3.11/ssl.py:745(create_default_context) 1 0.000 0.000 0.066 0.066 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/syntax.py:1() 1 0.000 0.000 0.065 0.065 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/rfc_constants.py:1() 1 0.000 0.000 0.063 0.063 /usr/lib/python3.11/ssl.py:591(load_default_certs) 1 0.063 0.063 0.063 0.063 {method 'set_default_verify_paths' of '_ssl._SSLContext' objects} 4 0.000 0.000 0.062 0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 1430/4 0.011 0.000 0.062 0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 1430/4 0.006 0.000 0.062 0.015 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 1 0.000 0.000 0.060 0.060 /data/demo/current/libs/framework/baseScrapeAndDrape.py:659(addMetaTags) 800/46 0.006 0.000 0.059 0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile) 2543 0.013 0.000 0.059 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:273(appendChild) 1 0.000 0.000 0.059 0.059 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 1421 0.002 0.000 0.055 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:349(insertText) 1421 0.005 0.000 0.054 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:354(insertText) 5256 0.007 0.000 0.052 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname) 9 0.000 0.000 0.049 0.005 /data/demo/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS) 21 0.049 0.002 0.049 0.002 /data/demo/current/libs/utils/htmlTools.py:53(init) 194 0.006 0.000 0.047 0.000 :1007(get_code)