Variable pages · IRS 990 Master Concordance

SJ_02_COMP_DTK_NAME_ORG_L2

Compensated organization name line 2

Description
Name Business - BusinessNameLine2
Table
SJ-P02-T01-COMPENSATION-DTK (many)
Part
Part II - Officers, Directors, Trustees, Key Employees, and Highest Compensated Employees
Location
SCHED-J-PART-02-COL-A
Type
text
Scope
PC – 990 only
Database
F990
Forms
SZ
3 / 3
xpaths observed / mapped
154
filings with a value
2009–2024
tax years observed
0 + 3 reviewed
open flags

Checks

Value checks

ResultValue checkDetail
✓ passValues are text, not numbers0% of values are numeric
✓ passNo sign of truncationlongest values do not sit at a common field limit

Flags

FlagSeverityXpathDetailReview
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BusinessName/BusinessNameLine2Txtmany-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 5.9% of 85 filings, max 11/filing, TY2014-2024; repeat_root: ''=64% ; IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp=36%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleJ/Form990ScheduleJPartII/NameBusiness/BusinessNameLine2many-to-one table, but 69% 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 29.1% of 55 filings, max 17/filing, TY2009-2012; repeat_root: ''=69% ; IRS990ScheduleJ/Form990ScheduleJPartII=31%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BusinessName/BusinessNameLine2many-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 14.3% of 14 filings, max 4/filing, TY2013-2013; repeat_root: ''=64% ; IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp=36%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleJ/Form990ScheduleJPartII/NameBusiness/BusinessNameLine2SZ2009–2012550.00723%29.1%
x2IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BusinessName/BusinessNameLine2SZ2013–2013140.00704%14.3%
x3IRS990ScheduleJ/RltdOrgOfficerTrstKeyEmplGrp/BusinessName/BusinessNameLine2TxtSZ2014–2024850.00325%5.9%

% 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
x18142013
x214
x37875749105149
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

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
9901541936

Most common values

ValueFilingsShare
J MICHAEL HAEMMERLE117.7%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x3CENTRAL AND EASTERN EUROPEAN SCHOOLKATHRYN STETSONXML
2013990x2HAYWOOD VOCATIONALGEORGE MARSHALLXML
2012990x1LEXINGTON COUNTY SCHOOL DISTRICTLEXINGTON COUNTY SCHOOL DISTRICT ONEXML