Program Directory

Program Directory

Use this searchable directory to find ACSA member programs. With each program found in your search, you can click to go to the program's website or view details about the program's faculty. You may click here to view the full directory.


   
Program Search:
Searches university and school names
Membership Type:

Country:

State:
US State/Territory (Searches for organizations with any address in this state, not just their main address.)

Province:
If your search by province does not produce expected results, try using the province's official abbreviation.

ACSA Region:



   
Debugging Info
pagedictsize=0
sqltime = 0.022 s
cpu time = 1.460 s
real time = 2.023 s
memory increase = 22620 kB
fields =
templates =
/data/acsa/current/acsa_org/themes/www/webform/searchCompanyPublic1
/data/acsa/current/generic/themes/shared/dgelements/checkboxes
/data/acsa/current/generic/themes/shared/dgelements/group
/data/acsa/current/generic/themes/shared/dgelements/input
/data/acsa/current/generic/themes/shared/dgelements/phunkyFone
/data/acsa/current/generic/themes/shared/dgelements/radio
/data/acsa/current/generic/themes/shared/dgelements/select
/data/acsa/current/generic/themes/shared/dgelements/view
/data/acsa/current/generic/themes/shared/dgelements/viewphunkyFone
/data/acsa/current/generic/themes/shared/dgelements/zipradius
scrapeAndDrape FRESH stub: https://www.acsa.maxx.matrixdev.net/schools-faculty/find-a-school
dg = ['searchCompanyPublic', 'searchCompanyPublic'] | [194, 194]
extra debug info =
queries = 73 queries

Total TimeCountAvg TimeQuery
0.00412 calls
1 row
0.000 SELECT version from databasemap;
0.00312 calls
21 rows
0.000 SELECT * FROM MembershipType ORDER BY orderindex, id
0.0031 call
0 rows
0.003 COMMIT
0.0032 calls
244 rows
0.001 SELECT * FROM Country ORDER BY orderindex, id
0.0022 calls
244 rows
0.001 SELECT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country) ORDER BY orderindex
0.0012 calls
54 rows
0.001 SELECT * FROM StateProvince ORDER BY orderindex, id
0.0011 call
0 rows
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`.`practiceSpecialty`, `Individual`.`researchSpecialty`, `Individual`.`primaryProfessionalField`, `Individual`.`terminalDegree`, `Individual`.`terminalSchool`, `Individual`.`discipline`, `Individual`.`highestDegree`, `Individual`.`facultyRank`, `Individual`.`tenured`, `Individual`.`isAdminContact`, `Individual`.`timeCommitment`, `Individual`.`birthYear`, `Individual`.`pilotParticipant`, `Individual`.`naabUser`, `Individual`.`naabStaff`, `Individual`.`lesbigay`, `Individual`.`disability`, `Individual`.`topazLaureate`, `Individual`.`distinguishedProfessor`, `Individual`.`initialLicenseDate`, `Individual`.`isPartTime`, `Individual`.`congressParty`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`spokenLanguagesOther`, `Individual`.`teachingLoadPct`, `Individual`.`researchLoadPct`, `Individual`.`serviceLoadPct`, `Individual`.`secondaryInstitution`, `Individual`.`secondaryInstitutionTitle`, `Individual`.`tertiaryInstitutionTitle`, `Individual`.`tertiaryInstitution`, `Individual`.`isLicensed`, `Individual`.`baseSalary`, `Individual`.`degreeGrantingInst1`, `Individual`.`degreeGrantingInst2`, `Individual`.`degreeGrantingInst3`, `Individual`.`degreeGrantingInst4`, `Individual`.`degreeGrantingInst5`, `Individual`.`degree1`, `Individual`.`degree2`, `Individual`.`degree3`, `Individual`.`degree4`, `Individual`.`degree5`, `Individual`.`adminLoadPct`, `Individual`.`definedResearchArea`, `Individual`.`initialLicensureYear`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Company, Individual) WHERE `Company`.`CompanyId`=0x8C217B00000003 AND `Company`.`KeyContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0012 calls
0 rows
0.000 SELECT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service) ORDER BY orderindex
0.0011 call
0 rows
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`.`practiceSpecialty`, `Individual`.`researchSpecialty`, `Individual`.`primaryProfessionalField`, `Individual`.`terminalDegree`, `Individual`.`terminalSchool`, `Individual`.`discipline`, `Individual`.`highestDegree`, `Individual`.`facultyRank`, `Individual`.`tenured`, `Individual`.`isAdminContact`, `Individual`.`timeCommitment`, `Individual`.`birthYear`, `Individual`.`pilotParticipant`, `Individual`.`naabUser`, `Individual`.`naabStaff`, `Individual`.`lesbigay`, `Individual`.`disability`, `Individual`.`topazLaureate`, `Individual`.`distinguishedProfessor`, `Individual`.`initialLicenseDate`, `Individual`.`isPartTime`, `Individual`.`congressParty`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`spokenLanguagesOther`, `Individual`.`teachingLoadPct`, `Individual`.`researchLoadPct`, `Individual`.`serviceLoadPct`, `Individual`.`secondaryInstitution`, `Individual`.`secondaryInstitutionTitle`, `Individual`.`tertiaryInstitutionTitle`, `Individual`.`tertiaryInstitution`, `Individual`.`isLicensed`, `Individual`.`baseSalary`, `Individual`.`degreeGrantingInst1`, `Individual`.`degreeGrantingInst2`, `Individual`.`degreeGrantingInst3`, `Individual`.`degreeGrantingInst4`, `Individual`.`degreeGrantingInst5`, `Individual`.`degree1`, `Individual`.`degree2`, `Individual`.`degree3`, `Individual`.`degree4`, `Individual`.`degree5`, `Individual`.`adminLoadPct`, `Individual`.`definedResearchArea`, `Individual`.`initialLicensureYear`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Company, Individual) WHERE `Company`.`CompanyId`=0x8C217B00000003 AND `Company`.`BillingContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0011 call
0 rows
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`.`practiceSpecialty`, `Individual`.`researchSpecialty`, `Individual`.`primaryProfessionalField`, `Individual`.`terminalDegree`, `Individual`.`terminalSchool`, `Individual`.`discipline`, `Individual`.`highestDegree`, `Individual`.`facultyRank`, `Individual`.`tenured`, `Individual`.`isAdminContact`, `Individual`.`timeCommitment`, `Individual`.`birthYear`, `Individual`.`pilotParticipant`, `Individual`.`naabUser`, `Individual`.`naabStaff`, `Individual`.`lesbigay`, `Individual`.`disability`, `Individual`.`topazLaureate`, `Individual`.`distinguishedProfessor`, `Individual`.`initialLicenseDate`, `Individual`.`isPartTime`, `Individual`.`congressParty`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`spokenLanguagesOther`, `Individual`.`teachingLoadPct`, `Individual`.`researchLoadPct`, `Individual`.`serviceLoadPct`, `Individual`.`secondaryInstitution`, `Individual`.`secondaryInstitutionTitle`, `Individual`.`tertiaryInstitutionTitle`, `Individual`.`tertiaryInstitution`, `Individual`.`isLicensed`, `Individual`.`baseSalary`, `Individual`.`degreeGrantingInst1`, `Individual`.`degreeGrantingInst2`, `Individual`.`degreeGrantingInst3`, `Individual`.`degreeGrantingInst4`, `Individual`.`degreeGrantingInst5`, `Individual`.`degree1`, `Individual`.`degree2`, `Individual`.`degree3`, `Individual`.`degree4`, `Individual`.`degree5`, `Individual`.`adminLoadPct`, `Individual`.`definedResearchArea`, `Individual`.`initialLicensureYear`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Company, Individual) WHERE `Company`.`CompanyId`=0x8C217B00000003 AND `Company`.`DirectoryContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0011 call
0 rows
0.001 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`=0x8C217B00000005 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0011 call
0 rows
0.001 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`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x8C217B00000007 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 call
167 rows
0.001 SELECT * FROM webselect
0.0011 call
0 rows
0.001 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`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x8C217B00000014 ORDER BY `Address`.`zip`
0.0011 call
0 rows
0.001 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`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x8C217B00000022 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 call
0 rows
0.001 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`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Branch, Address) WHERE `Branch`.`directoryAddressId`=`Address`.`AddressId` AND `Branch`.`BranchId`=0x8C217B00000011 ORDER BY `Address`.`zip`
0.0011 call
2 rows
0.001 SELECT * FROM YesNo ORDER BY orderindex, id
0.0011 call
0 rows
0.001 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`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x8C217B0000001C AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 call
0 rows
0.001 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`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x8C217B00000025 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-03-30 12:02:13',`mxxCreatedBy`=NULL, `PageRequestId`=0x8C217B00000001, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='ACSA', `pid`='1983148', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='503761', `startTime`='2026-03-30 12:02:13', `sessionId`=0x130FA3968C9CE47A, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'target\\':\\'/members_only/FacultyDirectory\\'}', `clientIPAddr`='216.73.216.158'
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`=0x8C217B00000015 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2026-03-30 12:01:12',`mxxUpdatedBy`=NULL, `PageRequestId`=0x8C217B00000000, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1983148', `requestNum`='1', `growth`='0', `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='503761', `startTime`='2026-03-30 12:01:12', `sessionId`=0x1139FCDDE946DDF9, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.003922462463378906', `timeTaken`='0', `dictSize`='0', `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/schools-faculty/faculty-councilors/\\'}', `clientIPAddr`='216.73.216.158' WHERE `PageRequestId`=0x8C217B00000000
0.0001 call
0 rows
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`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x8C217B0000001F AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows
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`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x8C217B00000019 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
7 rows
0.000 SELECT * FROM Region ORDER BY orderindex, id
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2026-03-30 12:02:13',`mxxUpdatedBy`=NULL, `PageRequestId`=0x8C217B00000001, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='ACSA', `pid`='1983148', `requestNum`='2', `growth`='0', `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='503761', `startTime`='2026-03-30 12:02:13', `sessionId`=0x130FA3968C9CE47A, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.0004954338073730469', `timeTaken`='0', `dictSize`='0', `fields`='{\\'target\\':\\'/members_only/FacultyDirectory\\'}', `clientIPAddr`='216.73.216.158' WHERE `PageRequestId`=0x8C217B00000001
0.0001 call
3 rows
0.000 SELECT * FROM AddressType ORDER BY orderindex, id
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`=0x8C217B00000016 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
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`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x8C217B00000028 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
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`=0x8C217B00000026 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
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`=0x8C217B00000013 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
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`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x8C217B0000000A AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
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`=0x8C217B0000001D AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-03-30 12:02:14',`mxxCreatedBy`=NULL, `PageRequestId`=0x8C217B00000002, `path`='forms/CompanyFormPublic/search', `formName`='acsa_CompanyFormPublic', `site`='www', `clientAcronym`='ACSA', `pid`='1983148', `requestNum`='3', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='503761', `startTime`='2026-03-30 12:02:14', `sessionId`=0x130FA3968C9CE47A, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.158'
0.0001 call
0 rows
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`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0x8C217B0000000D AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-03-30 12:01:12',`mxxCreatedBy`=NULL, `PageRequestId`=0x8C217B00000000, `path`='forms/cas/logout', `formName`='cas', `site`='www', `clientAcronym`='ACSA', `pid`='1983148', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.acsa.maxx.matrixdev.net', `dbThreadId`='503761', `startTime`='2026-03-30 12:01:12', `sessionId`=0x1139FCDDE946DDF9, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'service\\':\\'https://www.acsa.maxx.matrixdev.net/schools-faculty/faculty-councilors/\\'}', `clientIPAddr`='216.73.216.158'
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`=0x8C217B00000023 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
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`=0x8C217B00000020 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
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`=0x8C217B00000029 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
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`=0x8C217B0000000B AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
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`=0x8C217B0000001A AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
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`=0x8C217B00000006 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
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`=0x8C217B00000008 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
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`=0x8C217B00000012 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
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`=0x8C217B0000000E 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