Variable pages · IRS 990 Master Concordance

SN_03_EXPLANATION_TEXT

Additional explanations

Description
Explanatory text
Table
SN-P03-T99-SUPPLEMENTAL-INFO (many)
Part
Part III - Supplemental Information
Location
SCHED-N-PART-03
Type
text
Scope
PZ – 990 and 990-EZ
Database
F990
Forms
SZ
2 / 4
xpaths observed / mapped
17k
filings with a value
2009–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 truncationIRS990ScheduleN/SupplementalInformationDetail/ExplanationTxt: longest value is exactly 9000 characters

Flags

FlagSeverityXpathDetailReview
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleN/SupplementalInformationDetail/ExplanationTxtmany-to-one table, but 65% 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ⓘ infoIRS990ScheduleN/Form990ScheduleNPartIII/Explanationmany-to-one table, but 64% 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
x1IRS990ScheduleN/Form990ScheduleNPartIII/ExplanationSZ2009–20122,3740.294%36.1%
x2IRS990ScheduleN/SupplementalInformationDetail/ExplanationTxtSZ2013–202415,1110.279%35.0%
x3IRS990ScheduleN/ExplanatoryTextSZnot observed0
x4IRS990ScheduleN/Form990ScheduleNPartIII/ExplanatoryTextSZnot observed0

% 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
x1184617770803
x29911.0k1.0k1.2k1.2k1.3k1.3k1.4k1.4k1.6k1.5k1.3k
Fill rate: % of all filings of the return type (largest xpath)
990<1<1<1<1<1<1<1<1<1<1<1<1<1<1<1<1
990-EZ<1<1<1<1<1<1<1<1<1<1<1<1<1<1<1<1

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
99011,9662519,000
990-EZ5,5191978,810

Most common values

ValueFilingsShare
THE CHAPTER CEASED OPERATIONS UNDER ITS PRIOR EIN, AND ALL ASSETS AND LIABILITIES WERE TR…475.1%
Texas Health Resources (THR) is the parent company of a network of hospitals and affiliat…424.5%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x2ECORITYTHE ORGANIZATION DID NOT HAVE ANY ASSETS TO DISTRIBUTE. FUNDING WAS OBTAINED TO…XML
2012990x1MCKENNA MEMORIAL HOSPITALWES STUDDARD - CHAIRMAN BILL VAN KLEEF - VICE CHAIRMAN RANDY VANSTORY - SECRETA…XML