STRATEGY STUDIO / NONPROFIT PEOPLE SEARCH

LAULIMA DATA ALLIANCE: Form 990, tax year 2021

View the entire original 990 at ProPublica ↗

Organization
LAULIMA DATA ALLIANCE (EIN 82-1726643)
Tax period
2021-07-01 to 2022-06-30
Filed
2023-05-15
IRS object ID
202341359349316744
Schema version
2021v4.2
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)
Return2023-05-15T20:09:37-05:00ReturnTs
Tax Period End2022-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 Begin2021-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)
PersonWENDY ODOPersonNm
Person TitleCHIEF FINANCIAL OFFICERPersonTitleTxt
Phone8085218961PhoneNum
Signature2023-05-15SignatureDt
Discuss With Paid PreparerYes (1)DiscussWithPaidPreparerInd

Signing Officer SigningOfficerGrp

Person Full Name PersonFullName

FieldValueIRS element (for citing)
Person FirstWENDYPersonFirstNm
Person LastODOPersonLastNm
FieldValueIRS element (for citing)
SSN999009999SSN

Preparer Person PreparerPersonGrp

FieldValueIRS element (for citing)
Preparer PersonMELANIE A KINGPreparerPersonNm
PTINP00220997PTIN
Phone8085311040PhoneNum
Preparation2023-05-15PreparationDt

Additional Filer Information AdditionalFilerInformation

Trusted Customer TrustedCustomerGrp

FieldValueIRS element (for citing)
Trusted Customer3TrustedCustomerCd
Authentication Assurance LevelAAL1AuthenticationAssuranceLevelCd
Identity Assurance LevelIAL1IdentityAssuranceLevelCd
FieldValueIRS element (for citing)
Tax2021TaxYr
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$917,900GrossReceiptsAmt
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 Body12VotingMembersGoverningBodyCnt
Voting Members Independent10VotingMembersIndependentCnt
Total Employee0TotalEmployeeCnt
Total Volunteers11TotalVolunteersCnt
Total Gross UBI$0TotalGrossUBIAmt
Net Unrelated Bus Txbl Incm$0NetUnrelatedBusTxblIncmAmt
PY Contributions Grants$59,200PYContributionsGrantsAmt
CY Contributions Grants$0CYContributionsGrantsAmt
PY Program Service Revenue$778,753PYProgramServiceRevenueAmt
CY Program Service Revenue$910,479CYProgramServiceRevenueAmt
PY Investment Income$28PYInvestmentIncomeAmt
CY Investment Income$0CYInvestmentIncomeAmt
PY Other Revenue$74PYOtherRevenueAmt
CY Other Revenue$7,421CYOtherRevenueAmt
PY Total Revenue$838,055PYTotalRevenueAmt
CY Total Revenue$917,900CYTotalRevenueAmt
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$437,846PYSalariesCompEmpBnftPaidAmt
CY Salaries Comp Emp Bnft Paid$452,157CYSalariesCompEmpBnftPaidAmt
PY Total Prof Fndrsng Expns$0PYTotalProfFndrsngExpnsAmt
CY Total Prof Fndrsng Expns$0CYTotalProfFndrsngExpnsAmt
CY Total Fundraising Expense$0CYTotalFundraisingExpenseAmt
PY Other Expenses$327,216PYOtherExpensesAmt
CY Other Expenses$356,530CYOtherExpensesAmt
PY Total Expenses$765,062PYTotalExpensesAmt
CY Total Expenses$808,687CYTotalExpensesAmt
PY Revenues Less Expenses$72,993PYRevenuesLessExpensesAmt
CY Revenues Less Expenses$109,213CYRevenuesLessExpensesAmt
Total Assets BOY$512,141TotalAssetsBOYAmt
Total Assets EOY$636,215TotalAssetsEOYAmt
Total Liabilities BOY$90,019TotalLiabilitiesBOYAmt
Total Liabilities EOY$104,880TotalLiabilitiesEOYAmt
Net Assets Or Fund Balances BOY$422,122NetAssetsOrFundBalancesBOYAmt
Net Assets Or Fund Balances EOY$531,335NetAssetsOrFundBalancesEOYAmt
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$346,892ExpenseAmt
Revenue$917,900RevenueAmt
DescDATA ANALYTICS AND REPORTING PLATFORM.Desc
Total Program Service Expenses$346,892TotalProgramServiceExpensesAmt
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
Employee0EmployeeCnt
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 Members12GoverningBodyVotingMembersCnt
Independent Voting Member10IndependentVotingMemberCnt
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 (13 entries)

TitleTitleTxtAverage Hours Per WeekAverageHoursPerWeekRtIndividual Trustee Or DirectorIndividualTrusteeOrDirectorIndOfficerOfficerIndReportable Comp From OrgReportableCompFromOrgAmtReportable Comp From Rltd OrgReportableCompFromRltdOrgAmtOther CompensationOtherCompensationAmtAverage Hours Per Week Rltd OrgAverageHoursPerWeekRltdOrgRt
HALEY HSIEH
EXECUTIVE DIRECTOR40.00Yes (X)Yes (X)$224,925$0$32,822
HILTON RAETHEL
PRESIDENT & CEO3.00Yes (X)Yes (X)$0$461,967$28,08537.00
GREG CARLSON
DIRECTOR1.00Yes (X)$0$0$0
LIBBY CHAR
DIRECTOR1.00Yes (X)$0$0$0
JOHN CHEN
SECRETARY1.00Yes (X)$0$0$0
DAVID DOBBS
DIRECTOR1.00Yes (X)$0$0$0
VINCE HU
DIRECTOR1.00Yes (X)$0$0$0
GARY KAJIWARA
DIRECTOR1.00Yes (X)$0$0$0
TIFFANY LEMMEN
DIRECTOR1.00Yes (X)$0$0$0
QUIN OGAWA
DIRECTOR1.00Yes (X)$0$0$0
STEVE ROBERTSON
DIRECTOR1.00Yes (X)$0$0$0
KRIS WILSON
DIRECTOR1.00Yes (X)$0$0$0
WENDY ODO
CHIEF FINANCIAL OFFICER4.00Yes (X)$0$261,990$25,74136.00
FieldValueIRS element (for citing)
Total Reportable Comp From Org$224,925TotalReportableCompFromOrgAmt
Tot Reportable Comp Rltd Org$723,957TotReportableCompRltdOrgAmt
Total Other Compensation$86,648TotalOtherCompensationAmt
Indiv Rcvd Greater Than100 K1IndivRcvdGreaterThan100KCnt
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$205,517CompensationAmt
FieldValueIRS element (for citing)
Cntrct Rcvd Greater Than100 K1CntrctRcvdGreaterThan100KCnt

Program Service Revenue ProgramServiceRevenueGrp (2 entries)

DescDescBusinessBusinessCdTotal Revenue ColumnTotalRevenueColumnAmtRelated Or Exempt Func IncomeRelatedOrExemptFuncIncomeAmt
MEMBERSHIP DUES900099$833,479$833,479
ALL OTHER PROGRAMS900099$77,000$77,000
FieldValueIRS element (for citing)
Total Program Service Revenue$910,479TotalProgramServiceRevenueAmt

Other Revenue Misc OtherRevenueMiscGrp

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

Total Revenue TotalRevenueGrp

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

Comp Current Ofcr Directors CompCurrentOfcrDirectorsGrp

FieldValueIRS element (for citing)
Total$246,946TotalAmt
Program Services$24,695ProgramServicesAmt
Management And General$222,251ManagementAndGeneralAmt

Other Salaries And Wages OtherSalariesAndWagesGrp

FieldValueIRS element (for citing)
Total$119,429TotalAmt
Program Services$11,943ProgramServicesAmt
Management And General$107,486ManagementAndGeneralAmt

Pension Plan Contributions PensionPlanContributionsGrp

FieldValueIRS element (for citing)
Total$2,273TotalAmt
Program Services$227ProgramServicesAmt
Management And General$2,046ManagementAndGeneralAmt

Other Employee Benefits OtherEmployeeBenefitsGrp

FieldValueIRS element (for citing)
Total$51,146TotalAmt
Program Services$5,115ProgramServicesAmt
Management And General$46,031ManagementAndGeneralAmt

Payroll Taxes PayrollTaxesGrp

FieldValueIRS element (for citing)
Total$32,363TotalAmt
Program Services$25,890ProgramServicesAmt
Management And General$6,473ManagementAndGeneralAmt

Fees For Services Legal FeesForServicesLegalGrp

FieldValueIRS element (for citing)
Total$157TotalAmt
Management And General$157ManagementAndGeneralAmt

Fees For Services Accounting FeesForServicesAccountingGrp

FieldValueIRS element (for citing)
Total$7,597TotalAmt
Management And General$7,597ManagementAndGeneralAmt

Fees For Services Other FeesForServicesOtherGrp

FieldValueIRS element (for citing)
Total$249,329TotalAmt
Program Services$199,463ProgramServicesAmt
Management And General$49,866ManagementAndGeneralAmt

Office Expenses OfficeExpensesGrp

FieldValueIRS element (for citing)
Total$1,590TotalAmt
Program Services$1,272ProgramServicesAmt
Management And General$318ManagementAndGeneralAmt

Information Technology InformationTechnologyGrp

FieldValueIRS element (for citing)
Total$3,432TotalAmt
Program Services$2,746ProgramServicesAmt
Management And General$686ManagementAndGeneralAmt

Occupancy OccupancyGrp

FieldValueIRS element (for citing)
Total$13,666TotalAmt
Program Services$10,933ProgramServicesAmt
Management And General$2,733ManagementAndGeneralAmt

Travel TravelGrp

FieldValueIRS element (for citing)
Total$4,666TotalAmt
Program Services$3,733ProgramServicesAmt
Management And General$933ManagementAndGeneralAmt

Conferences Meetings ConferencesMeetingsGrp

FieldValueIRS element (for citing)
Total$2,376TotalAmt
Program Services$1,901ProgramServicesAmt
Management And General$475ManagementAndGeneralAmt

Depreciation Depletion DepreciationDepletionGrp

FieldValueIRS element (for citing)
Total$8,249TotalAmt
Program Services$6,600ProgramServicesAmt
Management And General$1,649ManagementAndGeneralAmt

Insurance InsuranceGrp

FieldValueIRS element (for citing)
Total$22,215TotalAmt
Program Services$17,772ProgramServicesAmt
Management And General$4,443ManagementAndGeneralAmt

Other Expenses OtherExpensesGrp (4 entries)

DescDescTotalTotalAmtProgram ServicesProgramServicesAmtManagement And GeneralManagementAndGeneralAmt
PROGRAMS$29,645$23,716$5,929
TAXES$8,372$6,698$1,674
AUTOMOBILE AND PARKING$3,826$3,061$765
PUBLIC RELATIONS$1,356$1,085$271

All Other Expenses AllOtherExpensesGrp

FieldValueIRS element (for citing)
Total$54TotalAmt
Program Services$42ProgramServicesAmt
Management And General$12ManagementAndGeneralAmt

Total Functional Expenses TotalFunctionalExpensesGrp

FieldValueIRS element (for citing)
Total$808,687TotalAmt
Program Services$346,892ProgramServicesAmt
Management And General$461,795ManagementAndGeneralAmt
Fundraising$0FundraisingAmt

Cash Non Interest Bearing CashNonInterestBearingGrp

FieldValueIRS element (for citing)
BOY$349,161BOYAmt
EOY$487,286EOYAmt

Accounts Receivable AccountsReceivableGrp

FieldValueIRS element (for citing)
BOY$8,072BOYAmt
EOY$3,000EOYAmt

Prepaid Expenses Defrd Charges PrepaidExpensesDefrdChargesGrp

FieldValueIRS element (for citing)
BOY$140,566BOYAmt
EOY$134,407EOYAmt
FieldValueIRS element (for citing)
Land Bldg Equip Cost Or Other Bss$211,379LandBldgEquipCostOrOtherBssAmt
Land Bldg Equip Accum Deprec$199,857LandBldgEquipAccumDeprecAmt

Land Bldg Equip Basis Net LandBldgEquipBasisNetGrp

FieldValueIRS element (for citing)
BOY$14,342BOYAmt
EOY$11,522EOYAmt

Total Assets TotalAssetsGrp

FieldValueIRS element (for citing)
BOY$512,141BOYAmt
EOY$636,215EOYAmt

Accounts Payable Accr Expnss AccountsPayableAccrExpnssGrp

FieldValueIRS element (for citing)
BOY$79,927BOYAmt
EOY$91,634EOYAmt

Deferred Revenue DeferredRevenueGrp

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

Other Liabilities OtherLiabilitiesGrp

FieldValueIRS element (for citing)
BOY$3,425BOYAmt
EOY$6,580EOYAmt

Total Liabilities TotalLiabilitiesGrp

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

No Donor Restriction Net Assets NoDonorRestrictionNetAssetsGrp

FieldValueIRS element (for citing)
BOY$422,122BOYAmt
EOY$531,335EOYAmt

Total Net Assets Fund Balance TotalNetAssetsFundBalanceGrp

FieldValueIRS element (for citing)
BOY$422,122BOYAmt
EOY$531,335EOYAmt

Tot Liab Net Assets Fund Balance TotLiabNetAssetsFundBalanceGrp

FieldValueIRS element (for citing)
BOY$512,141BOYAmt
EOY$636,215EOYAmt
FieldValueIRS element (for citing)
Reconcilation Revenue Expnss$109,213ReconcilationRevenueExpnssAmt
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 Required0FederalGrantAuditRequiredInd

Schedule A IRS990ScheduleA

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

Gifts Grants Contris Rcvd509 GiftsGrantsContrisRcvd509Grp

FieldValueIRS element (for citing)
Current Tax Year Minus1 Year$59,200CurrentTaxYearMinus1YearAmt
Total$59,200TotalAmt

Gross Receipts Admissions GrossReceiptsAdmissionsGrp

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

Total509 Total509Grp

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

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,166,532PublicSupportTotal509Amt

Gross Investment Income509 GrossInvestmentIncome509Grp

FieldValueIRS element (for citing)
Current Tax Year Minus1 Year$28CurrentTaxYearMinus1YearAmt
Total$28TotalAmt

Investment Income And UBTI InvestmentIncomeAndUBTIGrp

FieldValueIRS element (for citing)
Current Tax Year Minus1 Year$28CurrentTaxYearMinus1YearAmt
Total$28TotalAmt

Other Income509 OtherIncome509Grp

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

Total Support Calendar Year TotalSupportCalendarYearGrp

FieldValueIRS element (for citing)
Current Tax Year Minus4 Years$758,465CurrentTaxYearMinus4YearsAmt
Current Tax Year Minus3 Years$830,657CurrentTaxYearMinus3YearsAmt
Current Tax Year Minus2 Years$829,770CurrentTaxYearMinus2YearsAmt
Current Tax Year Minus1 Year$838,055CurrentTaxYearMinus1YearAmt
Current Tax Year$917,900CurrentTaxYearAmt
Total$4,174,847TotalAmt
FieldValueIRS element (for citing)
First5 Years509Yes (X)First5Years509Ind

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.ExplanationTxt

Schedule D IRS990ScheduleD

Equipment EquipmentGrp

FieldValueIRS element (for citing)
Other Cost Or Other Basis$210,816OtherCostOrOtherBasisAmt
Depreciation$199,294DepreciationAmt
Book Value$11,522BookValueAmt

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$11,522TotalBookValueLandBuildingsAmt

Other Liabilities Org OtherLiabilitiesOrgGrp

FieldValueIRS element (for citing)
DescDUE TO HAHDesc
Amt$6,580Amt
FieldValueIRS element (for citing)
Total Liability$6,580TotalLiabilityAmt
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, 2022 AND 2021, AND DETERMINED THAT HAH, HHERF, AND LAULIMA 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 (3 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$395,890$0$50,367$0$15,710$0$17,100$0$10,985$0$490,052$0$0
WENDY ODO
CHIEF FINANCIAL OFFICER$0$225,495$0$29,380$0$7,115$0$13,605$0$12,136$0$287,731$0$0
HALEY HSIEH
EXECUTIVE DIRECTOR$202,932$0$19,669$0$2,324$0$13,129$0$19,693$0$257,747$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 SPRING 2021 AND THE EXECUTIVE DIRECTOR WAS NOT 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 SPRING 2019. 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 199,463. MANAGEMENT AND GENERAL EXPENSES 49,866. FUNDRAISING EXPENSES 0. TOTAL EXPENSES 249,329.

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 Org0PerformOfServicesForOthOrgInd
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