Variable pages · IRS 990 Master Concordance

SG_01_FUNDRAISER_ACT

Fundraising activity

Description
Fundraiser Activity Information - Activity
Table
SG-P01-T01-FUNDRAISERS-INFO (many)
Part
Part I - Fundraising Activities
Location
SCHED-G-PART-01-LINE-02B-COL-ii
Type
text
Scope
PZ – 990 and 990-EZ
Database
F990
Forms
SZ
2 / 3
xpaths observed / mapped
74k
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 truncationIRS990ScheduleG/FundraiserActivityInfoGrp/ActivityTxt: longest value is exactly 1000 characters

Flags

FlagSeverityXpathDetailReview
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleG/FundraiserActivityInfoGrp/ActivityTxtmany-to-one table, but 72% 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.5% of 61,969 filings, max 10/filing, TY2013-2024; repeat_root: ''=72% ; IRS990ScheduleG/FundraiserActivityInfoGrp=28%.
MANY_NOT_REPEATINGⓘ infoIRS990ScheduleG/FundraiserActivityInformation/Activitymany-to-one table, but 70% 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.9% of 12,232 filings, max 10/filing, TY2009-2012; repeat_root: ''=70% ; IRS990ScheduleG/FundraiserActivityInformation=30%.

Xpaths

Xpath (under /Return/ReturnData or /Return/ReturnHeader)FormYearsFilings% filersRepeats in
x1IRS990ScheduleG/FundraiserActivityInformation/ActivitySZ2009–201212,2321.52%29.9%
x2IRS990ScheduleG/FundraiserActivityInfoGrp/ActivityTxtSZ2013–202461,9690.946%27.5%
x3IRS990ScheduleG/Form990ScheduleGPartI/FundraiserActivityInformation/ActivitySZnot 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.3k3.0k3.7k4.2k
x24.4k4.7k4.9k4.9k5.4k5.2k5.2k5.1k5.6k6.0k6.2k4.3k
Fill rate: % of all filings of the return type (largest xpath)
9904222222222222222
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
99072,597221,000
990-EZ1,6041860

Most common values

ValueFilingsShare
FUNDRAISING2,87316.7%
CONSULTING2,83116.5%
GRANT WRITING2,57215.0%
DIRECT MAIL1,93111.2%
FUNDRAISING CONSULTANT1,4138.2%
FUNDRAISING CONSULTING1,1947.0%
TELEMARKETING1,1136.5%
CAPITAL CAMPAIGN7204.2%
Consulting6523.8%
Fundraising5993.5%
FUNDRAISING COUNSEL4712.7%
GRANT WRITER4642.7%
Grant Writing2111.2%
CONSULTANT950.6%
Telemarketing200.1%
Direct Mail190.1%

Example filings

Tax yearReturnXpathOrganizationValue
2024990x2Canajoharie Volunteer Firefighters IncGrant coordinatorXML
2012990x1United Methodist Foundation of Indiana …Coordinate and oversee fundraising eventsXML