Variable pages · IRS 990 Master Concordance

SL_02_LOAN_INT_NAME_PERS

Interested person name

Description
Loan Table - Name - Person
Table
SL-P02-T01-LOANS-INTERESTED-PERS (many)
Part
Part II - Loans to and/or From Interested Persons
Location
SCHED-L-PART-02-COL-A
Type
text
Scope
PZ – 990 and 990-EZ
Database
F990
Forms
SZ
2 / 3
xpaths observed / mapped
134k
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 truncationIRS990ScheduleL/LoansBtwnOrgInterestedPrsnGrp/PersonNm: longest value is exactly 35 characters; IRS990ScheduleL/LoanTable/NamePerson: longest value is exactly 35 characters

Flags

FlagSeverityXpathDetailReview
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleL/LoansBtwnOrgInterestedPrsnGrp/PersonNmmany-to-one table, but 71% of values sit in no repeating element✓ accepted
noteGenuine repeating group: the group element is the repeat_root in filings with 2+ rows and '' in single-row filings, so the high unrepeated share just means most filers report one row. Evidence: repeats in 27.0% of 111,884 filings, max 303/filing, TY2013-2024; repeat_root: ''=71% ; IRS990ScheduleL/LoansBtwnOrgInterestedPrsnGrp=29%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleL/LoanTable/NamePersonmany-to-one table, but 68% of values sit in no repeating element✓ accepted
noteGenuine repeating group: the group element is the repeat_root in filings with 2+ rows and '' in single-row filings, so the high unrepeated share just means most filers report one row. Evidence: repeats in 30.2% of 22,372 filings, max 96/filing, TY2009-2012; repeat_root: ''=68% ; IRS990ScheduleL/LoanTable=32%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleL/LoanTable/NamePersonSZ2009–201222,3722.92%30.2%
x2IRS990ScheduleL/LoansBtwnOrgInterestedPrsnGrp/PersonNmSZ2013–2024111,8841.65%27.0%
x3IRS990ScheduleL/Form990ScheduleLPartII/LoanTable/NamePersonSZnot 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
x11.4k5.9k7.1k8.0k
x28.7k9.1k9.3k9.4k9.7k9.8k9.7k9.9k9.8k9.6k9.3k7.5k
Fill rate: % of all filings of the return type (largest xpath)
9904443333333322222
990-EZ1222222221111111

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
990104,1101435
990-EZ30,1461435

Most common values

ValueFilingsShare
Exempt - credit union23321.6%
ANONYMOUS11510.7%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x2Everyone's Counseling Center IncCasie PfeifferXML
2012990x1BATON ROUGE BASKETBALL & VOLLEYBALLJ M BERNHARD JRXML