STRATEGY STUDIO / NONPROFIT PEOPLE SEARCH

LAULIMA DATA ALLIANCE: Form 990, tax year 2022

View the entire original 990 at ProPublica ↗

Organization
LAULIMA DATA ALLIANCE (EIN 82-1726643)
Tax period
2022-07-01 to 2023-06-30
Filed
2024-04-10
IRS object ID
202441019349300204
Schema version
2022v5.0
Source
Download XML · Original 990 at ProPublica

Every field in the e-filed return. Faint text is the IRS element name, for citing.

Return header ReturnHeader

FieldValueIRS element (for citing)
Return2024-04-10T02:41:33-05:00ReturnTs
Tax Period End2023-06-30TaxPeriodEndDt

Preparer Firm PreparerFirmGrp

FieldValueIRS element (for citing)
Preparer Firm EIN261659234PreparerFirmEIN

Preparer Firm Name PreparerFirmName

FieldValueIRS element (for citing)
Business Name Line1CW ASSOCIATES CPASBusinessNameLine1Txt

Preparer US Address PreparerUSAddress

FieldValueIRS element (for citing)
Address Line1700 BISHOP STREET SUITE 1040AddressLine1Txt
CityHONOLULUCityNm
State AbbreviationHIStateAbbreviationCd
ZIP96813ZIPCd
FieldValueIRS element (for citing)
Return Type990ReturnTypeCd
Tax Period Begin2022-07-01TaxPeriodBeginDt

Filer Filer

FieldValueIRS element (for citing)
EIN821726643EIN

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1LAULIMA DATA ALLIANCEBusinessNameLine1Txt
FieldValueIRS element (for citing)
Business Name ControlLAULBusinessNameControlTxt
Phone8085218961PhoneNum

US Address USAddress

FieldValueIRS element (for citing)
Address Line1707 RICHARDS STREET PH2AddressLine1Txt
CityHONOLULUCityNm
State AbbreviationHIStateAbbreviationCd
ZIP96813ZIPCd

Business Officer BusinessOfficerGrp

FieldValueIRS element (for citing)
PersonHILTON R RAETHELPersonNm
Person TitlePRESIDENT & CEOPersonTitleTxt
Phone8085218961PhoneNum
Signature2024-04-10SignatureDt
Discuss With Paid PreparerYes (1)DiscussWithPaidPreparerInd

Signing Officer SigningOfficerGrp

Person Full Name PersonFullName

FieldValueIRS element (for citing)
Person FirstHILTONPersonFirstNm
Person LastRAETHELPersonLastNm
FieldValueIRS element (for citing)
SSN999009999SSN
FieldValueIRS element (for citing)
IRS Responsible Prty Info Curr0IRSResponsiblePrtyInfoCurrInd

Preparer Person PreparerPersonGrp

FieldValueIRS element (for citing)
Preparer PersonRODNEY M HARANOPreparerPersonNm
PTINP00389596PTIN
Phone8085311040PhoneNum
Preparation2024-04-08PreparationDt

Additional Filer Information AdditionalFilerInformation

Trusted Customer TrustedCustomerGrp

FieldValueIRS element (for citing)
Trusted Customer2TrustedCustomerCd
Authentication Assurance LevelAAL1AuthenticationAssuranceLevelCd
Identity Assurance LevelIAL1IdentityAssuranceLevelCd
FieldValueIRS element (for citing)
Tax2022TaxYr
Build TS2023-04-26 12:10:37ZBuildTS

Form 990 IRS990

FieldValueIRS element (for citing)
Principal OfficerHILTON R RAETHELPrincipalOfficerNm

US Address USAddress

FieldValueIRS element (for citing)
Address Line1707 RICHARDS STREET PH2AddressLine1Txt
CityHONOLULUCityNm
State AbbreviationHIStateAbbreviationCd
ZIP96813ZIPCd
FieldValueIRS element (for citing)
Gross Receipts$981,366GrossReceiptsAmt
Group Return For Affiliates0GroupReturnForAffiliatesInd
Organization501c3Yes (X)Organization501c3Ind
Website AddressN/AWebsiteAddressTxt
Type Of Organization CorpYes (X)TypeOfOrganizationCorpInd
Formation2018FormationYr
Legal Domicile StateHILegalDomicileStateCd
Activity Or MissionTO PROVIDE A COMPREHENSIVE DATA ANALYTICS AND REPORTING PLATFORM THAT HOSPITALS, HEALTHCARE LEADERS, POLICYMAKERS, RESEARCHERS, AND COMMUNITY LEADERS CAN ACCESS TO SUPPORT DECISION MAKING AND POLICY IN CREATING SUSTAINABLE HEALTHCARE SOLUTIONS FOR HAWAII'S COMMUNITIES.ActivityOrMissionDesc
Voting Members Governing Body13VotingMembersGoverningBodyCnt
Voting Members Independent11VotingMembersIndependentCnt
Total Employee2TotalEmployeeCnt
Total Volunteers11TotalVolunteersCnt
Total Gross UBI$0TotalGrossUBIAmt
Net Unrelated Bus Txbl Incm$0NetUnrelatedBusTxblIncmAmt
PY Contributions Grants$0PYContributionsGrantsAmt
CY Contributions Grants$0CYContributionsGrantsAmt
PY Program Service Revenue$910,479PYProgramServiceRevenueAmt
CY Program Service Revenue$981,116CYProgramServiceRevenueAmt
PY Investment Income$0PYInvestmentIncomeAmt
CY Investment Income$13CYInvestmentIncomeAmt
PY Other Revenue$7,421PYOtherRevenueAmt
CY Other Revenue$237CYOtherRevenueAmt
PY Total Revenue$917,900PYTotalRevenueAmt
CY Total Revenue$981,366CYTotalRevenueAmt
PY Grants And Similar Paid$0PYGrantsAndSimilarPaidAmt
CY Grants And Similar Paid$0CYGrantsAndSimilarPaidAmt
PY Benefits Paid To Members$0PYBenefitsPaidToMembersAmt
CY Benefits Paid To Members$0CYBenefitsPaidToMembersAmt
PY Salaries Comp Emp Bnft Paid$452,157PYSalariesCompEmpBnftPaidAmt
CY Salaries Comp Emp Bnft Paid$503,533CYSalariesCompEmpBnftPaidAmt
PY Total Prof Fndrsng Expns$0PYTotalProfFndrsngExpnsAmt
CY Total Prof Fndrsng Expns$0CYTotalProfFndrsngExpnsAmt
CY Total Fundraising Expense$0CYTotalFundraisingExpenseAmt
PY Other Expenses$356,530PYOtherExpensesAmt
CY Other Expenses$395,431CYOtherExpensesAmt
PY Total Expenses$808,687PYTotalExpensesAmt
CY Total Expenses$898,964CYTotalExpensesAmt
PY Revenues Less Expenses$109,213PYRevenuesLessExpensesAmt
CY Revenues Less Expenses$82,402CYRevenuesLessExpensesAmt
Total Assets BOY$636,215TotalAssetsBOYAmt
Total Assets EOY$806,081TotalAssetsEOYAmt
Total Liabilities BOY$104,880TotalLiabilitiesBOYAmt
Total Liabilities EOY$188,261TotalLiabilitiesEOYAmt
Net Assets Or Fund Balances BOY$531,335NetAssetsOrFundBalancesBOYAmt
Net Assets Or Fund Balances EOY$617,820NetAssetsOrFundBalancesEOYAmt
MissionTO PROVIDE A COMPREHENSIVE DATA ANALYTICS AND REPORTING PLATFORM THAT HOSPITALS, HEALTHCARE LEADERS, POLICYMAKERS, RESEARCHERS, AND COMMUNITY LEADERS CAN ACCESS TO SUPPORT DECISION MAKING AND POLICY IN CREATING SUSTAINABLE HEALTHCARE SOLUTIONS FOR HAWAII'S COMMUNITIES.MissionDesc
Significant New Program Srvc0SignificantNewProgramSrvcInd
Significant Change0SignificantChangeInd
Expense$501,981ExpenseAmt
Revenue$981,353RevenueAmt
DescDATA ANALYTICS AND REPORTING PLATFORM.Desc
Total Program Service Expenses$501,981TotalProgramServiceExpensesAmt
Described In Section501c3Yes (1)DescribedInSection501c3Ind
Schedule B Required0ScheduleBRequiredInd
Political Campaign Acty0PoliticalCampaignActyInd
Lobbying Activities0LobbyingActivitiesInd
Subject To Proxy Tax0SubjectToProxyTaxInd
Donor Advised Fund0DonorAdvisedFundInd
Conservation Easements0ConservationEasementsInd
Collections Of Art0CollectionsOfArtInd
Credit Counseling0CreditCounselingInd
Donor Rstr Or Quasi Endowments0DonorRstrOrQuasiEndowmentsInd
Report Land Building EquipmentYes (1)ReportLandBuildingEquipmentInd
Report Investments Other Sec0ReportInvestmentsOtherSecInd
Report Program Related Invst0ReportProgramRelatedInvstInd
Report Other Assets0ReportOtherAssetsInd
Report Other LiabilitiesYes (1)ReportOtherLiabilitiesInd
Include FIN48 FootnoteYes (1)IncludeFIN48FootnoteInd
Independent Audit Fincl Stmt0IndependentAuditFinclStmtInd
Consolidated Audit Fincl StmtYes (1)ConsolidatedAuditFinclStmtInd
School Operating0SchoolOperatingInd
Foreign Office0ForeignOfficeInd
Foreign Activities0ForeignActivitiesInd
More Than5000 K To Org0MoreThan5000KToOrgInd
More Than5000 K To Individuals0MoreThan5000KToIndividualsInd
Professional Fundraising0ProfessionalFundraisingInd
Fundraising Activities0FundraisingActivitiesInd
Gaming Activities0GamingActivitiesInd
Operate Hospital0OperateHospitalInd
Grants To Organizations0GrantsToOrganizationsInd
Grants To Individuals0GrantsToIndividualsInd
Schedule J RequiredYes (1)ScheduleJRequiredInd
Tax Exempt Bonds0TaxExemptBondsInd
Engaged In Excess Benefit Trans0EngagedInExcessBenefitTransInd
PY Excess Benefit Trans0PYExcessBenefitTransInd
Loan Outstanding0LoanOutstandingInd
Grant To Related Person0GrantToRelatedPersonInd
Business Rln With Org Mem0BusinessRlnWithOrgMemInd
Business Rln With Fam Mem0BusinessRlnWithFamMemInd
Business Rln With35 Ctrl Ent0BusinessRlnWith35CtrlEntInd
Deductible Non Cash Contri0DeductibleNonCashContriInd
Deductible Art Contribution0DeductibleArtContributionInd
Terminate Operations0TerminateOperationsInd
Partial Liquidation0PartialLiquidationInd
Disregarded Entity0DisregardedEntityInd
Related EntityYes (1)RelatedEntityInd
Related Organization Ctrl Ent0RelatedOrganizationCtrlEntInd
Trnsfr Exmpt Non Chrtbl Rltd Org0TrnsfrExmptNonChrtblRltdOrgInd
Activities Conducted Prtshp0ActivitiesConductedPrtshpInd
Schedule O RequiredYes (1)ScheduleORequiredInd
IRP Document3IRPDocumentCnt
IRP Document W2 G0IRPDocumentW2GCnt
Employee2EmployeeCnt
Employment Tax Returns FiledYes (1)EmploymentTaxReturnsFiledInd
Unrelated Bus Incm Over Limit0UnrelatedBusIncmOverLimitInd
Foreign Financial Account0ForeignFinancialAccountInd
Prohibited Tax Shelter Trans0ProhibitedTaxShelterTransInd
Taxable Party Notification0TaxablePartyNotificationInd
Nondeductible Contributions0NondeductibleContributionsInd
Quid Pro Quo Contributions0QuidProQuoContributionsInd
Form8282 Property Disposed Of0Form8282PropertyDisposedOfInd
Rcv Fnds To Pay Prsnl Bnft Cntrct0RcvFndsToPayPrsnlBnftCntrctInd
Pay Premiums Prsnl Bnft Cntrct0PayPremiumsPrsnlBnftCntrctInd
Indoor Tanning Services0IndoorTanningServicesInd
Subj To Tax Rmnrtn Ex Prcht Pymt0SubjToTaxRmnrtnExPrchtPymtInd
Subject To Excs Tax Net Invst Inc0SubjectToExcsTaxNetInvstIncInd
Info In Schedule O Part VIYes (X)InfoInScheduleOPartVIInd
Governing Body Voting Members13GoverningBodyVotingMembersCnt
Independent Voting Member11IndependentVotingMemberCnt
Family Or Business Rln0FamilyOrBusinessRlnInd
Delegation Of Mgmt Duties0DelegationOfMgmtDutiesInd
Change To Org Documents0ChangeToOrgDocumentsInd
Material Diversion Or Misuse0MaterialDiversionOrMisuseInd
Members Or StockholdersYes (1)MembersOrStockholdersInd
Election Of Board MembersYes (1)ElectionOfBoardMembersInd
Decisions Subject To Approva0DecisionsSubjectToApprovaInd
Minutes Of Governing BodyYes (1)MinutesOfGoverningBodyInd
Minutes Of CommitteesYes (1)MinutesOfCommitteesInd
Officer Mailing Address0OfficerMailingAddressInd
Local Chapters0LocalChaptersInd
Form990 Provided To Gvrn Body0Form990ProvidedToGvrnBodyInd
Conflict Of Interest PolicyYes (1)ConflictOfInterestPolicyInd
Annual Disclosure Covered PrsnYes (1)AnnualDisclosureCoveredPrsnInd
Regular Monitoring EnfrcYes (1)RegularMonitoringEnfrcInd
Whistleblower PolicyYes (1)WhistleblowerPolicyInd
Document Retention PolicyYes (1)DocumentRetentionPolicyInd
Compensation Process CEOYes (1)CompensationProcessCEOInd
Compensation Process Other0CompensationProcessOtherInd
Investment In Joint Venture0InvestmentInJointVentureInd
Upon RequestYes (X)UponRequestInd

Books In Care Of Detail BooksInCareOfDetail

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1WENDY ODOBusinessNameLine1Txt
FieldValueIRS element (for citing)
Phone8085218961PhoneNum

US Address USAddress

FieldValueIRS element (for citing)
Address Line1707 RICHARDS STREET PH2AddressLine1Txt
CityHONOLULUCityNm
State AbbreviationHIStateAbbreviationCd
ZIP96813ZIPCd

Form990 Part VII Section A Form990PartVIISectionAGrp (15 entries)

TitleTitleTxtAverage Hours Per WeekAverageHoursPerWeekRtIndividual Trustee Or DirectorIndividualTrusteeOrDirectorIndOfficerOfficerIndReportable Comp From OrgReportableCompFromOrgAmtReportable Comp From Rltd OrgReportableCompFromRltdOrgAmtOther CompensationOtherCompensationAmtAverage Hours Per Week Rltd OrgAverageHoursPerWeekRltdOrgRtHighest Compensated EmployeeHighestCompensatedEmployeeInd
HALEY HSIEH
EXECUTIVE DIRECTOR40.00Yes (X)Yes (X)$239,346$0$33,474
HILTON RAETHEL
PRESIDENT & CEO3.00Yes (X)Yes (X)$0$553,007$29,18437.00
GREG CARLSON
SECRETARY1.00Yes (X)$0$0$0
STEVE ROBERTSON
DIRECTOR1.00Yes (X)$0$0$0
GARY KAJIWARA
DIRECTOR1.00Yes (X)$0$0$0
TIFFANY LEMMEN
DIRECTOR1.00Yes (X)$0$0$0
DEREK VALE
DIRECTOR1.00Yes (X)$0$0$0
KENNY FINK
DIRECTOR1.00Yes (X)$0$0$0
MARK LINSCOTT
DIRECTOR1.00Yes (X)$0$0$0
KRIS WILSON
DIRECTOR1.00Yes (X)$0$0$0
JOHN CHEN
DIRECTOR1.00Yes (X)$0$0$0
VINCE HU
DIRECTOR1.00Yes (X)$0$0$0
DAVID DOBBS
DIRECTOR1.00Yes (X)$0$0$0
WENDY ODO
CHIEF FINANCIAL OFFICER4.00Yes (X)$0$271,876$27,44636.00
TANG SONG
SENIOR DATA ANALYST40.00$133,069$0$27,158Yes (X)
FieldValueIRS element (for citing)
Total Reportable Comp From Org$372,415TotalReportableCompFromOrgAmt
Tot Reportable Comp Rltd Org$824,883TotReportableCompRltdOrgAmt
Total Other Compensation$117,262TotalOtherCompensationAmt
Indiv Rcvd Greater Than100 K2IndivRcvdGreaterThan100KCnt
Former Ofcr Employees Listed0FormerOfcrEmployeesListedInd
Total Comp Greater Than150 KYes (1)TotalCompGreaterThan150KInd
Compensation From Other Srcs0CompensationFromOtherSrcsInd

Contractor Compensation ContractorCompensationGrp

Contractor Name ContractorName

Business Name BusinessName

FieldValueIRS element (for citing)
Business Name Line1IOWA HOSPITAL ASSOCIATIONBusinessNameLine1Txt

Contractor Address ContractorAddress

US Address USAddress

FieldValueIRS element (for citing)
Address Line1100 E GRAND AVE STE 100AddressLine1Txt
CityDES MOINESCityNm
State AbbreviationIAStateAbbreviationCd
ZIP50309ZIPCd
FieldValueIRS element (for citing)
ServicesDATA COLLECTION SERVICESServicesDesc
Compensation$195,762CompensationAmt
FieldValueIRS element (for citing)
Cntrct Rcvd Greater Than100 K1CntrctRcvdGreaterThan100KCnt

Program Service Revenue ProgramServiceRevenueGrp (2 entries)

DescDescBusinessBusinessCdTotal Revenue ColumnTotalRevenueColumnAmtRelated Or Exempt Func IncomeRelatedOrExemptFuncIncomeAmt
MEMBERSHIP DUES900099$893,026$893,026
ALL OTHER PROGRAMS900099$88,090$88,090
FieldValueIRS element (for citing)
Total Program Service Revenue$981,116TotalProgramServiceRevenueAmt

Investment Income InvestmentIncomeGrp

FieldValueIRS element (for citing)
Total Revenue Column$13TotalRevenueColumnAmt
Exclusion$13ExclusionAmt

Other Revenue Misc OtherRevenueMiscGrp

FieldValueIRS element (for citing)
DescOTHER INCOMEDesc
Business900099BusinessCd
Total Revenue Column$237TotalRevenueColumnAmt
Related Or Exempt Func Income$237RelatedOrExemptFuncIncomeAmt
FieldValueIRS element (for citing)
Other Revenue Total$237OtherRevenueTotalAmt

Total Revenue TotalRevenueGrp

FieldValueIRS element (for citing)
Total Revenue Column$981,366TotalRevenueColumnAmt
Related Or Exempt Func Income$981,353RelatedOrExemptFuncIncomeAmt
Unrelated Business Revenue$0UnrelatedBusinessRevenueAmt
Exclusion$13ExclusionAmt
FieldValueIRS element (for citing)
Info In Schedule O Part IXYes (X)InfoInScheduleOPartIXInd

Comp Current Ofcr Directors CompCurrentOfcrDirectorsGrp

FieldValueIRS element (for citing)
Total$293,514TotalAmt
Program Services$29,351ProgramServicesAmt
Management And General$264,163ManagementAndGeneralAmt

Other Salaries And Wages OtherSalariesAndWagesGrp

FieldValueIRS element (for citing)
Total$143,740TotalAmt
Program Services$114,992ProgramServicesAmt
Management And General$28,748ManagementAndGeneralAmt

Pension Plan Contributions PensionPlanContributionsGrp

FieldValueIRS element (for citing)
Total$7,924TotalAmt
Program Services$6,339ProgramServicesAmt
Management And General$1,585ManagementAndGeneralAmt

Other Employee Benefits OtherEmployeeBenefitsGrp

FieldValueIRS element (for citing)
Total$21,396TotalAmt
Program Services$17,117ProgramServicesAmt
Management And General$4,279ManagementAndGeneralAmt

Payroll Taxes PayrollTaxesGrp

FieldValueIRS element (for citing)
Total$36,959TotalAmt
Program Services$29,567ProgramServicesAmt
Management And General$7,392ManagementAndGeneralAmt

Fees For Services Legal FeesForServicesLegalGrp

FieldValueIRS element (for citing)
Total$2,897TotalAmt
Management And General$2,897ManagementAndGeneralAmt

Fees For Services Accounting FeesForServicesAccountingGrp

FieldValueIRS element (for citing)
Total$11,765TotalAmt
Management And General$11,765ManagementAndGeneralAmt

Fees For Services Other FeesForServicesOtherGrp

FieldValueIRS element (for citing)
Total$259,169TotalAmt
Program Services$207,335ProgramServicesAmt
Management And General$51,834ManagementAndGeneralAmt

Office Expenses OfficeExpensesGrp

FieldValueIRS element (for citing)
Total$738TotalAmt
Program Services$590ProgramServicesAmt
Management And General$148ManagementAndGeneralAmt

Information Technology InformationTechnologyGrp

FieldValueIRS element (for citing)
Total$3,576TotalAmt
Program Services$2,861ProgramServicesAmt
Management And General$715ManagementAndGeneralAmt

Occupancy OccupancyGrp

FieldValueIRS element (for citing)
Total$14,682TotalAmt
Program Services$11,746ProgramServicesAmt
Management And General$2,936ManagementAndGeneralAmt

Travel TravelGrp

FieldValueIRS element (for citing)
Total$8,020TotalAmt
Program Services$6,416ProgramServicesAmt
Management And General$1,604ManagementAndGeneralAmt

Conferences Meetings ConferencesMeetingsGrp

FieldValueIRS element (for citing)
Total$3,380TotalAmt
Program Services$2,704ProgramServicesAmt
Management And General$676ManagementAndGeneralAmt

Depreciation Depletion DepreciationDepletionGrp

FieldValueIRS element (for citing)
Total$11,526TotalAmt
Program Services$9,221ProgramServicesAmt
Management And General$2,305ManagementAndGeneralAmt

Insurance InsuranceGrp

FieldValueIRS element (for citing)
Total$25,998TotalAmt
Program Services$20,798ProgramServicesAmt
Management And General$5,200ManagementAndGeneralAmt

Other Expenses OtherExpensesGrp (4 entries)

DescDescTotalTotalAmtProgram ServicesProgramServicesAmtManagement And GeneralManagementAndGeneralAmt
PROGRAMS$34,404$27,523$6,881
TAXES$13,666$10,933$2,733
AUTOMOBILE AND PARKING$3,836$3,069$767
PUBLIC RELATIONS$1,750$1,400$350

All Other Expenses AllOtherExpensesGrp

FieldValueIRS element (for citing)
Total$24TotalAmt
Program Services$19ProgramServicesAmt
Management And General$5ManagementAndGeneralAmt

Total Functional Expenses TotalFunctionalExpensesGrp

FieldValueIRS element (for citing)
Total$898,964TotalAmt
Program Services$501,981ProgramServicesAmt
Management And General$396,983ManagementAndGeneralAmt
Fundraising$0FundraisingAmt

Cash Non Interest Bearing CashNonInterestBearingGrp

FieldValueIRS element (for citing)
BOY$487,286BOYAmt
EOY$252,831EOYAmt

Savings And Temp Cash Invst SavingsAndTempCashInvstGrp

FieldValueIRS element (for citing)
EOY$3,028EOYAmt

Accounts Receivable AccountsReceivableGrp

FieldValueIRS element (for citing)
BOY$3,000BOYAmt
EOY$7,500EOYAmt

Prepaid Expenses Defrd Charges PrepaidExpensesDefrdChargesGrp

FieldValueIRS element (for citing)
BOY$134,407BOYAmt
EOY$179,078EOYAmt
FieldValueIRS element (for citing)
Land Bldg Equip Cost Or Other Bss$248,879LandBldgEquipCostOrOtherBssAmt
Land Bldg Equip Accum Deprec$211,383LandBldgEquipAccumDeprecAmt

Land Bldg Equip Basis Net LandBldgEquipBasisNetGrp

FieldValueIRS element (for citing)
BOY$11,522BOYAmt
EOY$37,496EOYAmt

Investments Pub Traded Sec InvestmentsPubTradedSecGrp

FieldValueIRS element (for citing)
EOY$300,855EOYAmt

Other Assets Total OtherAssetsTotalGrp

FieldValueIRS element (for citing)
BOY$0BOYAmt
EOY$25,293EOYAmt

Total Assets TotalAssetsGrp

FieldValueIRS element (for citing)
BOY$636,215BOYAmt
EOY$806,081EOYAmt

Accounts Payable Accr Expnss AccountsPayableAccrExpnssGrp

FieldValueIRS element (for citing)
BOY$91,634BOYAmt
EOY$110,576EOYAmt

Deferred Revenue DeferredRevenueGrp

FieldValueIRS element (for citing)
BOY$6,666BOYAmt
EOY$51,666EOYAmt

Other Liabilities OtherLiabilitiesGrp

FieldValueIRS element (for citing)
BOY$6,580BOYAmt
EOY$26,019EOYAmt

Total Liabilities TotalLiabilitiesGrp

FieldValueIRS element (for citing)
BOY$104,880BOYAmt
EOY$188,261EOYAmt
FieldValueIRS element (for citing)
Organization Follows FASB117Yes (X)OrganizationFollowsFASB117Ind

No Donor Restriction Net Assets NoDonorRestrictionNetAssetsGrp

FieldValueIRS element (for citing)
BOY$531,335BOYAmt
EOY$617,820EOYAmt

Total Net Assets Fund Balance TotalNetAssetsFundBalanceGrp

FieldValueIRS element (for citing)
BOY$531,335BOYAmt
EOY$617,820EOYAmt

Tot Liab Net Assets Fund Balance TotLiabNetAssetsFundBalanceGrp

FieldValueIRS element (for citing)
BOY$636,215BOYAmt
EOY$806,081EOYAmt
FieldValueIRS element (for citing)
Reconcilation Revenue Expnss$82,402ReconcilationRevenueExpnssAmt
Net Unrlzd Gains Losses Invst$4,083NetUnrlzdGainsLossesInvstAmt
Other Changes In Net Assets$0OtherChangesInNetAssetsAmt
Method Of Accounting AccrualYes (X)MethodOfAccountingAccrualInd
Accountant Compile Or Review0AccountantCompileOrReviewInd
FS AuditedYes (1)FSAuditedInd

FS Audited Basis FSAuditedBasisGrp

FieldValueIRS element (for citing)
Consolidated Basis Fincl StmtYes (X)ConsolidatedBasisFinclStmtInd
FieldValueIRS element (for citing)
Audit CommitteeYes (1)AuditCommitteeInd
Federal Grant Audit RequiredYes (1)FederalGrantAuditRequiredInd
Federal Grant Audit PerformedYes (1)FederalGrantAuditPerformedInd

Schedule A IRS990ScheduleA

FieldValueIRS element (for citing)
Publicly Supported Org509a2Yes (X)PubliclySupportedOrg509a2Ind

Gifts Grants Contris Rcvd509 GiftsGrantsContrisRcvd509Grp

FieldValueIRS element (for citing)
Current Tax Year Minus2 Years$59,200CurrentTaxYearMinus2YearsAmt
Total$59,200TotalAmt

Gross Receipts Admissions GrossReceiptsAdmissionsGrp

FieldValueIRS element (for citing)
Current Tax Year Minus4 Years$830,657CurrentTaxYearMinus4YearsAmt
Current Tax Year Minus3 Years$828,978CurrentTaxYearMinus3YearsAmt
Current Tax Year Minus2 Years$778,753CurrentTaxYearMinus2YearsAmt
Current Tax Year Minus1 Year$910,479CurrentTaxYearMinus1YearAmt
Current Tax Year$981,116CurrentTaxYearAmt
Total$4,329,983TotalAmt

Total509 Total509Grp

FieldValueIRS element (for citing)
Current Tax Year Minus4 Years$830,657CurrentTaxYearMinus4YearsAmt
Current Tax Year Minus3 Years$828,978CurrentTaxYearMinus3YearsAmt
Current Tax Year Minus2 Years$837,953CurrentTaxYearMinus2YearsAmt
Current Tax Year Minus1 Year$910,479CurrentTaxYearMinus1YearAmt
Current Tax Year$981,116CurrentTaxYearAmt
Total$4,389,183TotalAmt

Amounts Rcvd Dsqlfy Person AmountsRcvdDsqlfyPersonGrp

FieldValueIRS element (for citing)
Total$0TotalAmt

Substantial Contributors Amt SubstantialContributorsAmtGrp

FieldValueIRS element (for citing)
Total$0TotalAmt

Subst And Dsqlfy Prsns Tot SubstAndDsqlfyPrsnsTotGrp

FieldValueIRS element (for citing)
Total$0TotalAmt
FieldValueIRS element (for citing)
Public Support Total509$4,389,183PublicSupportTotal509Amt

Gross Investment Income509 GrossInvestmentIncome509Grp

FieldValueIRS element (for citing)
Current Tax Year Minus2 Years$28CurrentTaxYearMinus2YearsAmt
Current Tax Year$13CurrentTaxYearAmt
Total$41TotalAmt

Investment Income And UBTI InvestmentIncomeAndUBTIGrp

FieldValueIRS element (for citing)
Current Tax Year Minus2 Years$28CurrentTaxYearMinus2YearsAmt
Current Tax Year$13CurrentTaxYearAmt
Total$41TotalAmt

Other Income509 OtherIncome509Grp

FieldValueIRS element (for citing)
Current Tax Year Minus3 Years$792CurrentTaxYearMinus3YearsAmt
Current Tax Year Minus2 Years$74CurrentTaxYearMinus2YearsAmt
Current Tax Year Minus1 Year$7,421CurrentTaxYearMinus1YearAmt
Current Tax Year$237CurrentTaxYearAmt
Total$8,524TotalAmt

Total Support Calendar Year TotalSupportCalendarYearGrp

FieldValueIRS element (for citing)
Current Tax Year Minus4 Years$830,657CurrentTaxYearMinus4YearsAmt
Current Tax Year Minus3 Years$829,770CurrentTaxYearMinus3YearsAmt
Current Tax Year Minus2 Years$838,055CurrentTaxYearMinus2YearsAmt
Current Tax Year Minus1 Year$917,900CurrentTaxYearMinus1YearAmt
Current Tax Year$981,366CurrentTaxYearAmt
Total$4,397,748TotalAmt
FieldValueIRS element (for citing)
Public Support CY5090.99810PublicSupportCY509Pct
Investment Income CY0.00000InvestmentIncomeCYPct
Thirty Thr Pct Suprt Tests CY509Yes (X)ThirtyThrPctSuprtTestsCY509Ind

Form990 Schedule A Part VI Form990ScheduleAPartVIGrp

FieldValueIRS element (for citing)
Form And Line ReferenceSCHEDULE A, PART III, LINE 12, EXPLANATION OF OTHER INCOME:FormAndLineReferenceDesc
ExplanationFEDERAL INCOME TAX REFUND - 2019 AMOUNT: $ 792. MISCELLANEOUS INCOME - 2020 AMOUNT: $ 74. 2021 AMOUNT: $ 7,421. 2022 AMOUNT: $ 237.ExplanationTxt

Schedule D IRS990ScheduleD

Equipment EquipmentGrp

FieldValueIRS element (for citing)
Other Cost Or Other Basis$248,316OtherCostOrOtherBasisAmt
Depreciation$210,820DepreciationAmt
Book Value$37,496BookValueAmt

Other Land Buildings OtherLandBuildingsGrp

FieldValueIRS element (for citing)
Other Cost Or Other Basis$563OtherCostOrOtherBasisAmt
Depreciation$563DepreciationAmt
Book Value$0BookValueAmt
FieldValueIRS element (for citing)
Total Book Value Land Buildings$37,496TotalBookValueLandBuildingsAmt

Other Liabilities Org OtherLiabilitiesOrgGrp (2 entries)

DescDescAmtAmt
DUE TO HAH$345
OPERATING LEASE LIABILITY$25,674
FieldValueIRS element (for citing)
Total Liability$26,019TotalLiabilityAmt
Footnote TextYes (X)FootnoteTextInd

Supplemental Information Detail SupplementalInformationDetail

FieldValueIRS element (for citing)
Form And Line ReferencePART X, LINE 2:FormAndLineReferenceDesc
ExplanationU.S. GAAP REQUIRES UNCERTAIN TAX POSITIONS TO BE RECOGNIZED IN THE CONSOLIDATED FINANCIAL STATEMENTS IF THEY ARE MORE LIKELY THAN NOT TO FAIL UPON REGULATORY EXAMINATION. MANAGEMENT EVALUATED HAH'S, HHERF'S, AND LAULIMA'S TAX POSITIONS AS OF AND FOR THE YEARS ENDED JUNE 30, 2023 AND 2022, AND DETERMINED THAT THEY HAD NO UNCERTAIN TAX POSITIONS REQUIRED TO BE REPORTED IN ACCORDANCE WITH U.S. GAAP. HAH, HHERF, AND LAULIMA ARE SUBJECT TO ROUTINE AUDITS BY TAXING JURISDICTIONS; HOWEVER, THERE ARE CURRENTLY NO AUDITS IN PROGRESS FOR ANY OPEN TAX PERIODS.ExplanationTxt

Schedule J IRS990ScheduleJ

FieldValueIRS element (for citing)
Independent ConsultantYes (X)IndependentConsultantInd
Compensation SurveyYes (X)CompensationSurveyInd
Board Or Committee ApprovalYes (X)BoardOrCommitteeApprovalInd
Severance Payment0SeverancePaymentInd
Supplemental Nonqual Rtr Plan0SupplementalNonqualRtrPlanInd
Equity Based Comp Arrngm0EquityBasedCompArrngmInd
Comp Based On Revenue Of Flng Org0CompBasedOnRevenueOfFlngOrgInd
Comp Bsd On Rev Related Orgs0CompBsdOnRevRelatedOrgsInd
Comp Bsd Net Earns Flng Org0CompBsdNetEarnsFlngOrgInd
Comp Bsd Net Earns Rltd Orgs0CompBsdNetEarnsRltdOrgsInd
Any Non Fixed Payments0AnyNonFixedPaymentsInd
Initial Contract Exception0InitialContractExceptionInd

Rltd Org Officer Trst Key Empl RltdOrgOfficerTrstKeyEmplGrp (4 entries)

TitleTitleTxtBase Compensation Filing OrgBaseCompensationFilingOrgAmtCompensation Based On Rltd OrgsCompensationBasedOnRltdOrgsAmtBonus Filing OrganizationBonusFilingOrganizationAmountBonus Related OrganizationsBonusRelatedOrganizationsAmtOther Compensation Filing OrgOtherCompensationFilingOrgAmtOther Compensation Rltd OrgsOtherCompensationRltdOrgsAmtDeferred Compensation Flng OrgDeferredCompensationFlngOrgAmtDeferred Comp Rltd OrgsDeferredCompRltdOrgsAmtNontaxable Benefits Filing OrgNontaxableBenefitsFilingOrgAmtNontaxable Benefits Rltd OrgsNontaxableBenefitsRltdOrgsAmtTotal Compensation Filing OrgTotalCompensationFilingOrgAmtTotal Compensation Rltd OrgsTotalCompensationRltdOrgsAmtComp Report Prior990 Filing OrgCompReportPrior990FilingOrgAmtComp Report Prior990 Rltd OrgsCompReportPrior990RltdOrgsAmt
HILTON RAETHEL
PRESIDENT & CEO$0$470,140$0$68,400$0$14,467$0$17,400$0$11,784$0$582,191$0$0
WENDY ODO
CHIEF FINANCIAL OFFICER$0$235,126$0$30,115$0$6,635$0$15,662$0$11,784$0$299,322$0$0
HALEY HSIEH
EXECUTIVE DIRECTOR$216,842$0$20,161$0$2,343$0$13,509$0$19,965$0$272,820$0$0$0
TANG SONG
SENIOR DATA ANALYST$129,195$0$1,000$0$2,874$0$7,250$0$19,908$0$160,227$0$0$0

Supplemental Information Detail SupplementalInformationDetail

FieldValueIRS element (for citing)
Form And Line ReferencePART I, LINE 3FormAndLineReferenceDesc
ExplanationTHE PRESIDENT/CEO AND CFO ARE COMPENSATED BY A RELATED ORGANIZATION. A SALARY REVIEW OF THE PRESIDENT/CEO AND CFO IS PERFORMED BIANNUALLY BY AN INDEPENDENT CONSULTANT. PERIODICALLY, THE EXECUTIVE DIRECTOR IS ALSO INCLUDED. THE LAST REVIEW WAS CONDUCTED IN SUMMER 2023 AND THE EXECUTIVE DIRECTOR WAS INCLUDED IN THE REVIEW. THE COMPENSATION COMMITTEE UTILIZES THE REVIEW AS A BASIS TO DETERMINE THE COMPENSATION FOR THE PRESIDENT/CEO. THIS IS DOCUMENTED IN A MEMORANDUM FROM THE COMPENSATION COMMITTEE CHAIR.ExplanationTxt

Schedule O IRS990ScheduleO

Supplemental Information Detail SupplementalInformationDetail (7 entries)

Form And Line ReferenceFormAndLineReferenceDescExplanationExplanationTxt
FORM 990, PART VI, SECTION A, LINE 6THE HEALTHCARE ASSOCIATION OF HAWAII IS THE SOLE INITIAL MEMBER.
FORM 990, PART VI, SECTION A, LINE 7ATHE GOVERNING BODY IS MADE UP OF REPRESENTATIVES OF SIX DESIGNATED HOSPITALS OR HOSPITAL SYSTEMS, ONE ROTATING HOSPITAL NOT PART OF THE FIRST SIX, STATE OF HAWAII DEPARTMENT OF HEALTH, HAWAII MEDICAL SERVICE ASSOCIATION, THE JOHN A. BURNS SCHOOL OF MEDICINE/UNIVERSITY OF HAWAII, THE PRESIDENT AND CEO OF THE HEALTHCARE ASSOCIATION OF HAWAII AND THE EXECUTIVE DIRECTOR OF LAULIMA DATA ALLIANCE.
FORM 990, PART VI, SECTION B, LINE 11BALL 990 REPORTING WAS REVIEWED INTERNALLY BY SENIOR MANAGEMENT. ALL QUESTIONS AND CHANGES WERE ADDRESSED PRIOR TO FILING OF THE 990.
FORM 990, PART VI, SECTION B, LINE 12CLAULIMA DATA ALLIANCE ADOPTED A CONFLICT OF INTEREST POLICY IN FYE 6/30/19. THE POLICY IS SENT OUT ON AN ANNUAL BASIS TO THE CURRENT BOARD OF DIRECTORS, OFFICERS AND KEY EMPLOYEES. THE RESPONSES ARE SUMMARIZED, REVIEWED AND ANALYZED FOR REPORTING. A CONFLICTING INTEREST WITH A PARTY OR A TRANSACTION SHALL BE FULLY DISCLOSED AS SOON AS RECOGNIZED. THE BOARD SHALL DETERMINE WHETHER A CONFLICT EXISTS. IF SO, THE CONFLICTED PARTY IS EXCLUDED FROM THE DISCUSSION AND/OR APPROVAL OF A TRANSACTION.
FORM 990, PART VI, SECTION B, LINE 15ATHE EXECUTIVE DIRECTOR'S COMPENSATION IS REVIEWED AND APPROVED BY THE PRESIDENT/CEO. COMPARABLE DATA, SUCH AS A SALARY REVIEW BY AN INDEPENDENT CONSULTANT, IS USED, AND COMPENSATION FOR A SIMILAR POSITION IN A COMPARABLE ORGANIZATION IS ALSO CONSIDERED. THE EXECUTIVE DIRECTOR'S SALARY REVIEW WAS LAST CONDUCTED IN SUMMER 2023. THIS IS DOCUMENTED IN THE PERSONNEL FILES.
FORM 990, PART VI, SECTION C, LINE 19LAULIMA DATA ALLIANCE DOES NOT MAKE ITS GOVERNING DOCUMENTS, CONFLICT OF INTEREST POLICY, AND FINANCIAL STATEMENTS AVAILABLE TO THE PUBLIC.
FORM 990, PART IX, LINE 11GOTHER PROFESSIONAL FEES: PROGRAM SERVICE EXPENSES 207,335. MANAGEMENT AND GENERAL EXPENSES 51,834. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 259,169.

Schedule R IRS990ScheduleR

Id Related Tax Exempt Org IdRelatedTaxExemptOrgGrp (2 entries)

Address Line1USAddress/AddressLine1TxtCityUSAddress/CityNmState AbbreviationUSAddress/StateAbbreviationCdZIPUSAddress/ZIPCdEINEINPrimary ActivitiesPrimaryActivitiesTxtLegal Domicile StateLegalDomicileStateCdExempt Code SectionExemptCodeSectionTxtPublic Charity StatusPublicCharityStatusTxtDirect Controlling NADirectControllingNACdControlled OrganizationControlledOrganizationInd
HEALTHCARE ASSOCIATION OF HAWAII
707 RICHARDS ST PH2HONOLULUHI96813990105817ADVOCACYHI501(C)(6)N/AN/A0
HAWAII HOSPITAL EDUCATION & RESEARCH FOUNDATION
707 RICHARDS ST PH2HONOLULUHI96813510172774EDUCATIONHI501(C)(3)LINE 10N/A0
FieldValueIRS element (for citing)
Receipt Of Int Annts Rnts Rylts0ReceiptOfIntAnntsRntsRyltsInd
Gift Grnt Or Cap Contri To Oth Org0GiftGrntOrCapContriToOthOrgInd
Gift Grnt Cap Contri From Oth Org0GiftGrntCapContriFromOthOrgInd
Loans Or Guarantees To Other Org0LoansOrGuaranteesToOtherOrgInd
Loans Or Guarantees From Oth Org0LoansOrGuaranteesFromOthOrgInd
Div Related Organization0DivRelatedOrganizationInd
Asset Sale To Other Org0AssetSaleToOtherOrgInd
Asset Purchase From Other Org0AssetPurchaseFromOtherOrgInd
Asset Exchange0AssetExchangeInd
Rental Of Facilities To Oth Org0RentalOfFacilitiesToOthOrgInd
Rental Of Fclts From Oth Org0RentalOfFcltsFromOthOrgInd
Perform Of Services For Oth OrgYes (1)PerformOfServicesForOthOrgInd
Perform Of Services By Other Org0PerformOfServicesByOtherOrgInd
Sharing Of Facilities0SharingOfFacilitiesInd
Paid Employees SharingYes (1)PaidEmployeesSharingInd
Reimbursement Paid To Other OrgYes (1)ReimbursementPaidToOtherOrgInd
Reimbursement Paid By Other Org0ReimbursementPaidByOtherOrgInd
Transfer To Other Org0TransferToOtherOrgInd
Transfer From Other Org0TransferFromOtherOrgInd