Variable pages · IRS 990 Master Concordance

SR_07_EXPLANATION_TEXT

Additional explanations

Description
Form990 Schedule RPart VII - Explanation
Table
SR-P07-T99-SUPPLEMENTAL-INFO (many)
Part
Part VII - Supplemental Information
Location
SCHED-R-PART-07
Type
text
Scope
PC – 990 only
Database
F990
Forms
SZ
2 / 2
xpaths observed / mapped
63k
filings with a value
2010–2024
tax years observed
0 + 2 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
✓ passValues are text, not numbers0% of values are numeric
ⓘ infoNo sign of truncationIRS990ScheduleR/Form990ScheduleRPartVII/Explanation: longest value is exactly 9000 characters; IRS990ScheduleR/SupplementalInformationDetail/ExplanationTxt: longest value is exactly 9000 characters

Flags

FlagSeverityXpathDetailReview
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleR/SupplementalInformationDetail/ExplanationTxtmany-to-one table, but 85% of values sit in no repeating element✓ accepted
noteTable made MANY or created in fixes 05/07/09: the group repeats (ONE_REPEATS evidence); most filings have one instance, so the value usually sits outside an indexed element.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleR/Form990ScheduleRPartVII/Explanationmany-to-one table, but 88% of values sit in no repeating element✓ accepted
noteTable made MANY or created in fixes 05/07/09: the group repeats (ONE_REPEATS evidence); most filings have one instance, so the value usually sits outside an indexed element.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleR/Form990ScheduleRPartVII/ExplanationSZ2010–20127,1191.67%11.9%
x2IRS990ScheduleR/SupplementalInformationDetail/ExplanationTxtSZ2013–202455,8841.2%14.8%

% filers: percent of in-scope filers whose return has the xpath, in its latest year. Repeats in: share of filings where the element occurs more than once.

Coverage by tax year

Filings’09’10’11’12’13’14’15’16’17’18’19’20’21’22’23’24
x11.6k2.6k3.0k
x23.5k3.9k4.2k4.5k4.7k4.9k4.9k5.4k5.4k5.5k5.5k3.3k
Fill rate: % of all filings of the return type (largest xpath)
990122222222222221

Filings with a value, by xpath (rows, numbered as in the xpath table) and tax year. A change of row from one year to the next is usually the IRS renaming the element (most were renamed in 2013). Hover a cell for the exact count.

Values

ReturnFilingsAverage lengthLongest
99063,0034939,000

Most common values

ValueFilingsShare
FOR THE PURPOSES OF SCHEDULE R, PART V, THE FOLLOWING APPLIES: RETIREMENT HOUSING FOUNDAT…1,06815.8%
THE RELATIONSHIP WITH PI BETA PHI FRATERNITY HOUSING CORPORATION IS DISCLOSED AT PART II …5578.2%
Part V, Line 2 includes the net current year amount resulting from continuous activity wi…5287.8%
AHEPA AFFORDABLE MANAGEMENT COMPANY, INC IS THE MANAGEMENT COMPANY AND EMPLOYS THE INDIVI…4416.5%
THE FILING ORGANIZATION IS A TAFT-HARTLEY MULTIEMPLOYER TRUST THAT PROVIDES HEALTH AND WE…4326.4%
IOWA HEALTH SYSTEM AND SUBSIDIARIES (D/B/A UNITYPOINT HEALTH) THIS ENTITY IS PART OF IOWA…3705.5%
IOWA HEALTH SYSTEM AND SUBSIDIARIES (D/B/A UNITYPOINT HEALTH) IOWA HEALTH SYSTEM IS AN IO…3094.6%
MERCY HOSPITALS EAST COMMUNITIES MERCY HOSPITALS EAST COMMUNITIES CONSISTS OF MERCY HOSPI…2563.8%
LAWSON ERP SOFTWARE IS THE PRIMARY ACCOUNTING SOFTWARE USED BY MERCY HEALTH SYSTEM, INC. …2303.4%
CONTINUATION OF PRIMARY ACTIVITY: CLEVELAND HEBREW SCHOOLS EDUCATIONAL FOUNDATION: SUPPOR…2213.3%
CONTINUATION OF PRIMARY ACTIVITY: LAURA & ALVIN SIEGAL COLLEGE OF JUDAIC STUDIES EDUCATIO…1892.8%
CONTINUATION OF PRIMARY ACTIVITY: THE HARRY RATNER HUMAN SERVICES FUND: SUPPORT CHARITABL…1832.7%
AHEPA AFFORDABLE MANAGEMENT COMPANY, INC. IS THE MANAGEMENT COMPANY AND EMPLOYS THE INDIV…1812.7%
The relationship with Pi Beta Phi Fraternity Housing Corporation is disclosed at Part II …1692.5%
TRANSACTIONS WITH RELATED ORGANIZATIONS: FOR THE PURPOSES OF SCHEDULE R, PART V, THE FOLL…1382.0%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x2PUGET SOUND BENEFITS TRUSTTHE FILING ORGANIZATION IS A TAFT-HARTLEY MULTI-EMPLOYER TRUST THAT PROVIDES HE…XML
2012990x1Essentia Health FoundationName: The following Essentia Health entities have a doing business as name. Leg…XML