Variable pages · IRS 990 Master Concordance

SL_04_BIZTRANSAC_DESC

Description of transaction

Description
Description of transaction
Table
SL-P04-T01-BIZ-TRANSAC-INTERESTED-PERS (many)
Part
Part IV - Business Transactions Involving Interested Persons
Location
SCHED-L-PART-04-COL-D
Type
text
Scope
PZ – 990 and 990-EZ
Database
F990
Forms
SZ
2 / 2
xpaths observed / mapped
243k
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/BusTrInvolveInterestedPrsnGrp/TransactionDesc: longest value is exactly 1000 characters

Flags

FlagSeverityXpathDetailReview
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionDescmany-to-one table, but 64% 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 35.1% of 197,543 filings, max 74/filing, TY2013-2024; repeat_root: ''=64% ; IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp=36%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleL/Form990ScheduleLPartIV/DescriptionOfTransactionmany-to-one table, but 59% 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 39.6% of 45,840 filings, max 71/filing, TY2009-2012; repeat_root: ''=59% ; IRS990ScheduleL/Form990ScheduleLPartIV=41%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleL/Form990ScheduleLPartIV/DescriptionOfTransactionSZ2009–201245,8405.57%39.6%
x2IRS990ScheduleL/BusTrInvolveInterestedPrsnGrp/TransactionDescSZ2013–2024197,5432.68%35.1%

% 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
x14.7k12k14k15k
x216k16k17k17k17k17k17k17k17k17k17k12k
Fill rate: % of all filings of the return type (largest xpath)
99014998877776655554
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
990241,423511,000
990-EZ1,96024383

Most common values

ValueFilingsShare
EMPLOYMENT5,84419.5%
COMPENSATION4,89816.4%
RENT3,97413.3%
SEE PART V2,98910.0%
WAGES1,9956.7%
EMPLOYEE1,9496.5%
MANAGEMENT FEES1,9426.5%
LEGAL SERVICES1,7435.8%
Employment1,4784.9%
EMPLOYEE COMPENSATION1,3164.4%
Compensation8452.8%
CONSULTING4101.4%
SALARY2050.7%
CONSULTING SERVICES1030.3%
MANAGEMENT SERVICES750.3%
INDEPENDENT CONTRACTOR670.2%
SEE SCHEDULE O630.2%
See Schedule O310.1%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x2THE CLEVELAND CLINIC FOUNDATIONEMPLOYMENT AGREEMENT WITH CCFXML
2012990x1BOARD OF CONTROL FOR SOUTHERNPART-TIME WAGESXML