Query
Template: /c/testquery.cfm:10
Execution Time: 1.55 ms
Record Count: 25
Cached: No
Datasource: ceulocker
Lazy: No
SQL:
SELECT *
FROM organizations
ORDER BY organization_name;
organization_identity_idorganization_activedemo_organizationorganization_devOnlyorganization_archivedorganization_categoryorganization_type_idorganization_nameorganization_name_sealuses_holder_subscriptions_paymentorganization_abbreviationorganization_state_idorganization_files_directoryorganization_domain_URLorganization_current_yearorganization_default_review_daysorganization_reviewer_completion_thresholdorganization_logo_tile_URLfinancial_cc_namefinancials_cc_emailoffice_contact_nameoffice_contact_emailoffice_contact_account_phoneoffice_contact_account_addressoffice_contact_account_cityoffice_contact_account_stateoffice_contact_account_zipcodepayment_processororganization_api_keyorganization_trans_keyuse_holder_moduleuse_provider_moduleuses_holder_subscriptionsuse_reviews_for_holdersholder_subscription_current_expirationholder_subscription_years_in_cycleorganization_backup_email_addressholder_subscription_new_renewal_expirationorganization_backup_email_passwordcw_assoc_provider_processing_feecw_assoc_holder_processing_feeorganization_review_scalenotesorganizationjsscoring_type_id_fkorganization_short_descorganization_expanded_descorg_email_addressorg_logo_graphicorg_provider_crib_sheetorg_provider_specific_email_textorg_holder_specific_email_textorg_holder_specific_email_addressorg_holder_crib_sheetorg_reviewer_intro_textorg_reviewer_specific_email_addressorg_reviewer_metrics_sheetorganization_application_statusorganization_approvedcreated_datelast_modified_dateisDeleteddefault_approval_periodcredit_term_namecredit_term_abbreviationbcc_emailuse_licensing_bucketscredit_namecredit_descriptionparent_org_idorg_ceulocker_page_urlorg_seal_styleorganization_sysfee_holders
1AZPTA-0e0db8af-670f-11e7-adf2-005056a04e37155551000PT1APTA ArizonaAPTA Arizona0APTA AZ4//aptaaz.org/20193065/c/files_organizations/tiles/15555.jpgChristachrista@aptaaz.org800/765-7848 x7113PO BOX 1450Tonto BasinAZ85553stripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01100{ts '2018-12-31 00:00:00'}0arizona-pt@ceulocker.net{ts '2099-01-01 00:00:00'}aptaaz*ceulocker150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
2COLO-PT-02ab-11e8-a0ff-005056a04e37177771000PT1APTA ColoradoAPTA Colorado0APTA CO7//coloradophysicaltherapists.org/20193066/c/files_organizations/tiles/17777.jpgJim Leahyleahy@libertysquaregroup.com303.351.53972851 S. Parker Road, Suite 1210AuroraCO80014stripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01100{ts '2020-12-31 00:00:00'}0colorado-pt@ceulocker.net{ts '2099-01-01 00:00:00'}colorado*ceulocker150numeric0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
3CT-ab1c11ab-83a2-RfZvc-9276-056a0MWqpCT299991000PT1APTA ConnecticutAPTA Connecticut0APTA CT8//ctpt.org/20223066/c/files_organizations/tiles/29999.jpgJames Leahyctapta@libertysquaregroup.comVictor Vaughan, Jim Leahyctapta@libertysquaregroup.com,leahy@libertysquaregroup.comCTstripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01100{ts '2018-12-31 00:00:00'}0{ts '2099-01-01 00:00:00'}150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
4af84b18e-6943-11e4-bad8-d49466421abc142511000PT1APTA KansasAPTA Kansas1APTA KS18//kpta.com/20251465/c/files_organizations/tiles/14251.jpgMarisa Snelceus@kpta.comstripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01111{ts '2026-12-31 23:59:59'}2kansas-pt@ceulocker.net{ts '2026-12-31 23:59:59'}kpta*ceulocker150numeric0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}0APT KS KNASS1<p>DEMO TEST&nbsp;</p> 6e430fac-a33a-11f0-bca5-aee0e2a00f0110
5KYapta-445HUY-2eJJIo-aQRR500-009IIt664441000PT1APTA KentuckyAPTA Kentucky0APTA KY19//aptaky.org20253050/c/files_organizations/tiles/66444.jpgParker Allen payments@aptaky.orgEmily Childersechilders@aptaky.orgstripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01101{ts '2035-12-31 00:00:00'}1kentucky-pt@ceulocker.net{ts '2099-01-01 00:00:00'}qQpEbrQU4$BZ#k!j150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
6MA-f2105f34-83a3-kwIaF-005056aRHMvma311111000PT1APTA MassachusettsAPTA Massachusetts0APTA MA23//aptaofma.org/20223066/c/files_organizations/tiles/31111.jpgJames Leahyaptama@libertysquaregroup.comVictor Vaughan, Jim Leahyaptama@libertysquaregroup.com,leahy@libertysquaregroup.comMAstripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01100{ts '2018-12-31 00:00:00'}0{ts '2099-01-01 00:00:00'}150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
7MPTA-28235db3-6bc3-11e6-b265-005056a04e37165121000PT1APTA MichiganAPTA Michigan0APTA MI24//aptami.org20203066/c/files_organizations/tiles/16512.jpgSamantha Negretesam@association-leader.comSavannahinfo@aptami.org,edwardmdpt@gmail.comstripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01100{ts '2020-12-31 23:59:59'}0michigan-pt@ceulocker.net{ts '2099-01-01 00:00:00'}mpta*ceulocker150numeric0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
8MT-c6f87a69-7b4b-11ea-8e73-005056a0a8e3244441000PT1APTA Montana APTA Montana0APTA MT28//mapta.com20203066/c/files_organizations/tiles/24444.jpgGail Ossjim@greatnorthernpt.com,MontanaPT@aptamt.com406-543-1823P.O. Box 8575MissoulaMT59807stripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ011000mapta@ceulocker.net{ts '2099-01-01 00:00:00'}mapta*ceulocker150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
9NPTA-622712c9-548d-11e9-925c-8943uja89u98u222221000PT1APTA NebraskaAPTA Nebraska0APTA NE29//npta.org20193066/c/files_organizations/tiles/22222.jpgErin IsenhartKellyNelson@creighton.edu,rmuller@Hillcresthealth.com,taylor.cech@orthonebraska.com,tessa.wells@unmc.edu844-249-8806PO Box 24133OmahaNE68124stripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ011000npta@ceulocker.net{ts '2099-01-01 00:00:00'}ne*ceulocker150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
10NH-12613921-wlp6-11ec-9276-005wk8a0ar9x277771000PT1APTA New HampshireAPTA New Hampshire0APTA NH31//nhapta.org/20223066/c/files_organizations/tiles/27777.jpgJames Leahynhapta@libertysquaregroup.comVictor Vaughan, Jim Leahyvgvaughan@gmail.com,leahy@libertysquaregroup.comNHstripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01100{ts '2018-12-31 00:00:00'}0{ts '2099-01-01 00:00:00'}150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
11RI-64fef5fb-8395-11ec-9276-005056a0a8e3255551000PT1APTA Rhode IslandAPTA Rhode Island0APTA RI42//riapta.com/20223066/c/files_organizations/tiles/25555.jpgJames Leahyriapta@libertysquaregroup.comVictor Vaughan, Jim Leahyvgvaughan@gmail.com,leahy@libertysquaregroup.comRIstripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01100{ts '2018-12-31 00:00:00'}0{ts '2099-01-01 00:00:00'}150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
12SCAPTAf5b-ded6-11e8-8873-005056a04e37211111000PT1APTA South CarolinaAPTA South Carolina0APTA SC43//scapta.org20193066/c/files_organizations/tiles/21111.jpgFinance Deptinfo@aptasc.orgStacie Franksinfo@aptasc.org,catherine.vanderwerker@gmail.com,vanderwe@musc.edu800-765-7848 x71221055 N Fairfax Street, Suite 205AlexandriaVA22314stripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ011000scapta@ceulocker.net{ts '2099-01-01 00:00:00'}scapta*ceulocker150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
13SD-44tfRGT-wert-11wROP-o0PO-12887KkIJ149001000PT1APTA South DakotaAPTA South Dakota0APTA SD44//aptasd.com/202530100/c/files_organizations/tiles/14900.jpgAPTA SD TreasurerCEU@sdapta.orgExecutive DirectorCEU@sdapta.org,aptasd@libertysquaregroup.comstripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01101{ts '2029-12-31 00:00:00'}1southdakota-pt@ceulocker.net{ts '2099-01-01 00:00:00'}7TuwuM2rC2hCt9&B150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
14UTAH-b9ef5d0b-43a0a795005056a04e37233331000PT1APTA UtahAPTA Utah0APTA UT47//uptaonline.org20203066/c/files_organizations/tiles/23333.jpgKatie Mansellkmansell@uptaonline.orgUTstripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ011011upta@ceulocker.net{ts '2099-01-01 00:00:00'}upta*ceulocker150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
15VT-d7eadbf5-a839-11e7-b0b4-005056a04e37188881000PT1APTA VermontAPTA Vermont0APTA VT48//vtapta.org/20193066/c/files_organizations/tiles/18888.jpgJenny Skolfieldjenny.skolfield@gmail.comJenny Skolfieldvtapta@gmail.comVTstripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01100{ts '2018-12-31 00:00:00'}0vermont-pt@ceulocker.net{ts '2099-01-01 00:00:00'}vt*ceulocker150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
16VPTA-7156bb59-6713-11e7-adf2-005056a04e37166661000PT1APTA VirginiaAPTA Virginia0APTA VA49//vpta.org/20193065/c/files_organizations/tiles/16666.jpgMarie Stravalosvpta@vpta.org866.364.VPTA (87825810 Kingstowne Center Dr. Ste 120-779AlexandriaVA22315stripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01100{ts '2018-12-31 00:00:00'}0virginia-pt@ceulocker.net{ts '2099-01-01 00:00:00'}vpta*ceulocker150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
17WPTA-b274e2b7-6a99-11e4-bad8-d49999421xyz142521000PT1APTA WisconsinAPTA Wisconsin0APTA WI52//aptawi.org/20203065/c/files_organizations/tiles/14252.jpgAmy Reiteraptawi@aptawi.org608.221.91913510 East Washington AvenueMadisonWI53704stripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01101{ts '2025-12-31 00:00:00'}1wisconsin-pt@ceulocker.net{ts '2099-01-01 00:00:00'}wpta*ceulocker150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
18WYAPTA-03435taf-6hgf-1jju6-aq22w-j56jdr45155661000PT1APTA WyomingAPTA Wyoming0APTA WY53//wypta.org/20253065/c/files_organizations/tiles/15566.jpgChrista Lombardoaptawyomingchapter@gmail.com800/765-7848 x7113PO BOX 1450Tonto BasinAZ85553stripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01100{ts '2018-12-31 00:00:00'}0wyoming-pt@ceulocker.net{ts '2099-01-01 00:00:00'}wU2zQ&T%UWxYnz4B150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
19caduceuswebs111110001PT1CEULocker LLCCEULocker0CEUL//CEULocker.com20193066/c/files_organizations/tiles/11111.jpgStephen Smithsupport@ceulocker.comJacksonvilleFL32222stripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ001000ceulocker@ceulocker.net{ts '2099-01-01 00:00:00'}150numeric0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
20af84b18e-6943-11e4-bad8-d49433213vvc142551110PT1Demo1 State Association ChapterDEMO Chapter0DEMO//caduceuswebs.net/201925066/c/files_organizations/tiles/14255.jpgJane P. Jones, CAEdptc@caduceussupport.netpk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01110{ts '2016-12-31 23:59:59'}2{ts '2099-01-01 00:00:00'}150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
21a8e411ba-abdf-11e4-8e9d-2f10c093a16f142560111PT1Demo2DEMO2 Chapter1DEMO2//caduceuswebs.net/201925065/c/files_organizations/tiles/14256.jpgpk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01110{ts '2016-12-31 23:59:59'}2{ts '2099-01-01 00:00:00'}150numeric0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
22MAOT-gewy634-nnyu-Dr3TT6-Mnqsi77322220000PT1Massachusetts Association for Occupational TherapyMA Assoc OT0MAOT23//aptaofma.org/20253066/c/files_organizations/tiles/32222.jpgCasey Morlé, OT, MS, OTRinfo@maot.orgBrij Maliya OT, OTD, OTRinfo@maot.orgMAstripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01101{ts '2099-12-31 00:00:00'}0mass-ot@ceulocker.net{ts '2099-01-01 00:00:00'}qM%&%!tF@!2d8150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
23e251deb9-f420-11e4-a30a-353879b72baf150010001PT1Tennessee Physical Therapy AssociationTennessee Chapter0TPTA45//tptatn.site-ym.com20153065/c/files_organizations/tiles/15001.jpgAmy Breedlovetpta@tptatn.com615.269.5312affinipaypk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01110{ts '2015-12-31 23:59:59'}1{ts '2099-01-01 00:00:00'}150numerictpta5219890{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
24WVBOPT-b6829814-a0bf-11e8-acc9-005056ed199991000PT1West Virginia Board of Physical TherapyWest Virginia0WVBOPT51//wvbopt.com20203066/c/files_organizations/tiles/19999.jpgNonnie RamseyNonnie.S.Holcomb@wv.gov304.558.03672 Players Club Drive Suite 102CharlestonWV25311wvstopk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01100{ts '2050-12-31 23:59:59'}1wvbopt@ceulocker.net{ts '2099-01-01 00:00:00'}wvbopt*ceulocker150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110
25world74578ge-kii129-0921jre95-456mm03339001000PT1World PhysiotherapyWorld Physiotherapy0World Physiotherapy//world.physio20243066/c/files_organizations/tiles/33900.jpgWorld Physiotherapy Financeaccounts@world.physioWorld Physiotherapy CPDcpd@world.physio4402081595130Unit 17, Empire SquareLondonUKSE1 4NAstripepk_test_DbfT7svvgkG0Iv0LexwCi8drsk_test_ppHwQBLp22RNvnx1Cq75KLJ01100{ts '2035-12-31 00:00:00'}1worldphysio@ceulocker.net{ts '2099-01-01 00:00:00'}p!sB$pjWYYNeEA58**MwQKAaGGNdyw150text0{ts '2026-01-23 09:41:17'}{ts '2026-01-23 09:41:17'}016e430fac-a33a-11f0-bca5-aee0e2a00f0110