Variable pages · IRS 990 Master Concordance

F9_07_COMP_DTK_EXPL_TXT

Explanation of reason for compensation

Description
Explanation of compensation practices (F990-EZ-PART-04 old forms only)
Table
F9-P07-T01-COMPENSATION (many)
Part
Part VII - Compensation of Officers, Directors, Trustees, Key Employees, Highest Compensated Employees, and Independent Contractors
Location
F990-PC-PART-07-SECTION-A-LINE-01A-COL-X
Type
text
Scope
PZ – 990 and 990-EZ
Database
F990
Forms
EZ
4 / 4
xpaths observed / mapped
46k
filings with a value
2009–2024
tax years observed
0 + 4 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
✓ passValues are text, not numbers1% of values are numeric
ⓘ infoNo sign of truncationCompensationExplanation/Compensation/Explanation: longest value is exactly 1000 characters; CompensationExplanation/CompensationExplanationGrp/ShortExplanationTxt: longest value is exactly 1000 characters

Flags

FlagSeverityXpathDetailReview
MANY_NOT_REPEATINGⓘ infoCompensationExplanation/CompensationExplanationGrp/ShortExplanationTxtmany-to-one table, but 56% 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 43.9% of 25,017 filings, max 41/filing, TY2013-2024; repeat_root: ''=56% ; CompensationExplanation/CompensationExplanationGrp=40% ; CompensationExplanation=4%.
MANY_NOT_REPEATINGⓘ infoCompensationExplanation/Compensation/Explanationmany-to-one table, but 53% 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 44.6% of 3,216 filings, max 27/filing, TY2009-2012; repeat_root: ''=53% ; CompensationExplanation/Compensation=24% ; CompensationExplanation=22%.
MANY_NOT_REPEATINGⓘ infoEmployeeCompensationExpln/EmployeeCompExplanationGrp/ExplanationTxtmany-to-one table, but 60% of values sit in no repeating element✓ accepted
noteXpath remapped or added in fixes 03/07 into a repeating group (compensation explanations, hospital facilities, bond issues); most filings have one instance, so the value usually sits outside an indexed element.
MANY_NOT_REPEATINGⓘ infoEmployeeCompensationExpln/EmployeeCompExplanation/Explanationmany-to-one table, but 56% of values sit in no repeating element✓ accepted
noteXpath remapped or added in fixes 03/07 into a repeating group (compensation explanations, hospital facilities, bond issues); 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
x1CompensationExplanation/Compensation/ExplanationEZ2009–20123,8800.473%42.9%
x2EmployeeCompensationExpln/EmployeeCompExplanation/ExplanationEZ2009–2012350.00542%57.1%
x3CompensationExplanation/CompensationExplanationGrp/ShortExplanationTxtEZ2013–202441,4050.642%36.4%
x4EmployeeCompensationExpln/EmployeeCompExplanationGrp/ExplanationTxtEZ2013–20243870.00683%43.2%

% 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
x11181.1k1.2k1.5k
x2210617
x31.9k2.5k3.0k3.4k3.4k2.8k3.6k4.2k4.4k4.1k4.3k3.7k
x4151420142422355354544339
Fill rate: % of all filings of the return type (largest xpath)
990-EZ1111111111111111
990-PF1111122222221111

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
990-EZ28,34335924
990-PF17,364681,000

Most common values

ValueFilingsShare
SEE ATTACHED FOOTNOTE1,96713.7%

Example filings

Tax yearReturnXpathOrganizationValue
2024990EZx3FREED SPIRITS ANIMAL RESCUENO COMPENSATION TAKEN IN 2019XML
2024990EZx4METROPOLITAN NEW YORK COLLEGE CAREER PL…AS NEEDEDXML
2012990EZx1Churubusco Chamber of CommercestipendXML
2012990EZx2THE ALLEN LILIA AND ALEXANDER VINEnoneXML