Core Supplement 02-10-2009 Financial

EINEmployer Identification NumberEmployer identification number.Beginning, sec.D
FisYrFiscal yearFiscal year (ending year)
p0phonePhone NumberPhone number
NOTE: Only records with p0phone listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0phone%'] in filter criteria when using this field (see SCvars below).
WebsiteWebsiteWebsite URL
NOTE: Only records with Website listed in SCvars contain this data. Always include [AND SCvars LIKE '%Website%'] in filter criteria when using this field (see SCvars below).
p0addchgAddress changeAddress change (Line B checkbox)
NOTE: Only records with p0addchg listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0addchg%'] in filter criteria when using this field (see SCvars below).
Beginning, sec.B
p0namchgName changeName change (Line B checkbox)
NOTE: Only records with p0namchg listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0namchg%'] in filter criteria when using this field (see SCvars below).
Beginning, sec.B
p0intrtnInitial returnInitial return (Line B checkbox)
NOTE: Only records with p0intrtn listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0intrtn%'] in filter criteria when using this field (see SCvars below).
Beginning, sec.B
p0fnlrtnFinal return / TerminationFinal return / Termination (Line B checkbox)
NOTE: Only records with p0fnlrtn listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0fnlrtn%'] in filter criteria when using this field (see SCvars below).
Beginning, sec.B
p0amdrtnAmended returnAmended return (Line B checkbox)
NOTE: Only records with p0amdrtn listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0amdrtn%'] in filter criteria when using this field (see SCvars below).
Beginning, sec.B
p0appendApplication pendingApplication pending (Line B checkbox)
NOTE: Only records with p0append listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0append%'] in filter criteria when using this field (see SCvars below).
Beginning, sec.B
p1contFundDonor Advised ContributionsContributions to donor advised funds (added to IRS Form 990 beginning tax year 2006)
NOTE: Only records with p1contFund listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1contFund%'] in filter criteria when using this field (see SCvars below).
Part 1, line 01a
p1dirsupDirect public supportDirect public support
NOTE: Only records with p1dirsup listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1dirsup%'] in filter criteria when using this field (see SCvars below).
Part 1, line 01a
p1indsupIndirect public supportIndirect public support
NOTE: Only records with p1indsup listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1indsup%'] in filter criteria when using this field (see SCvars below).
Part 1, line 01b
p1govgtGovernment grantsGovernment grants
NOTE: Only records with p1govgt listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1govgt%'] in filter criteria when using this field (see SCvars below).
Part 1, line 01c
p1cashCash contributionsCash contributions
NOTE: Only records with p1cash listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1cash%'] in filter criteria when using this field (see SCvars below).
Part 1, line 01d(in
p1noncshNoncash contributionsNoncash contributions
NOTE: Only records with p1noncsh listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1noncsh%'] in filter criteria when using this field (see SCvars below).
Part 1, line 01d(in
p1tcontTotal contributionsTotal contributions, gifts, grants, etc.
NOTE: Only records with p1tcont listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1tcont%'] in filter criteria when using this field (see SCvars below).
Part 1, line 01d
p1psrevProgram service revenueProgram service revenue
NOTE: Only records with p1psrev listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1psrev%'] in filter criteria when using this field (see SCvars below).
Part 1, line 02
p1totrevTotal RevenueTotal revenue
NOTE: Only records with p1totrev listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1totrev%'] in filter criteria when using this field (see SCvars below).
Part 1, line 12
p1mExpManagement & general expensesManagement & general expenses
NOTE: Only records with p1mExp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1mExp%'] in filter criteria when using this field (see SCvars below).
Part 1, line 14
p1pExpProgram service expensesProgram service expenses
NOTE: Only records with p1pExp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1pExp%'] in filter criteria when using this field (see SCvars below).
Part 1, line 13
p1frexpFund-raising expensesFund-raising expenses
NOTE: Only records with p1frexp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1frexp%'] in filter criteria when using this field (see SCvars below).
Part 1, line 15
p1affilPayments to affiliatesPayments to affiliates
NOTE: Only records with p1affil listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1affil%'] in filter criteria when using this field (see SCvars below).
Part 1, line 16
p1totexpTotal ExpensesTotal expenses
NOTE: Only records with p1totexp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1totexp%'] in filter criteria when using this field (see SCvars below).
Part 1, line 17
p1netIncNet incomeNet income: excess (or deficit) for the year
NOTE: Only records with p1netInc listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1netInc%'] in filter criteria when using this field (see SCvars below).
Part 1, line 18
p1nasboyNet assets or fund balance-begNet assets or fund balance-beg. of year
NOTE: Only records with p1nasboy listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1nasboy%'] in filter criteria when using this field (see SCvars below).
Part 1, line 19
p1chgasOther changes in net assetsOther changes in net assets or fund balances
NOTE: Only records with p1chgas listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1chgas%'] in filter criteria when using this field (see SCvars below).
Part 1, line 20
p1naseoyNet assets or fund balance-endNet assets or fund balance-end of year
NOTE: Only records with p1naseoy listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1naseoy%'] in filter criteria when using this field (see SCvars below).
Part 1, line 21
p4b_ilndInvestments - Land, Bldg & Eq (Basis)Investments - Land, buildings & equipment (cost/basis before accumulated depreciation)
NOTE: Only records with p4b_ilnd listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_ilnd%'] in filter criteria when using this field (see SCvars below).
Part 4, line 55c_A
p4d_ilndAccum depreciation Invest LandAccumulated depreciation for Investments - Land, buildings & equipment
NOTE: Only records with p4d_ilnd listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4d_ilnd%'] in filter criteria when using this field (see SCvars below).
Part 4, line 55b
p4e_ilndNet Invest-land, bldg, equipNet Investments - Land, buildings & equipment (cost/basis minus accum. depreciation - end of year)
NOTE: Only records with p4e_ilnd listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_ilnd%'] in filter criteria when using this field (see SCvars below).
Part 4, line 55c_B
p4b_landLand, blg & equip (Basis)Land, buildings & equipment (cost/basis before accumulated depreciation)
NOTE: Only records with p4b_land listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_land%'] in filter criteria when using this field (see SCvars below).
Part 4, line 57c_A
p4d_landAccum depreciation Land Bldg EquipAccumulated depreciation for land, buildings & equipment
NOTE: Only records with p4d_land listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4d_land%'] in filter criteria when using this field (see SCvars below).
Part 4, line 57b
p4e_landNet Land, building & equip.Net Land, buildings & equipment (cost/basis minus accum. depreciation - end of year)
NOTE: Only records with p4e_land listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_land%'] in filter criteria when using this field (see SCvars below).
Part 4, line 57c_B
p4e_asstTotal assets- end of yearTotal assets- end of year
NOTE: Only records with p4e_asst listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_asst%'] in filter criteria when using this field (see SCvars below).
Part 4, line 59_B
p4b_unreUnrestr. net assets (BOY)Unrestricted net assets or fund balances- beginning of year
NOTE: Only records with p4b_unre listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_unre%'] in filter criteria when using this field (see SCvars below).
Part 4, line 67_A
p4e_unreUnrestr. net assets (EOY)Unrestricted net assets or fund balances- end of year
NOTE: Only records with p4e_unre listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_unre%'] in filter criteria when using this field (see SCvars below).
Part 4, line 67_B
p4b_tempTemp. restr. net assets (BOY)Temporarily restricted net assets- beginning of year
NOTE: Only records with p4b_temp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_temp%'] in filter criteria when using this field (see SCvars below).
Part 4, line 68_A
p4e_tempTemp. restr. net assets (EOY)Temporarily restricted net assets- end of year
NOTE: Only records with p4e_temp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_temp%'] in filter criteria when using this field (see SCvars below).
Part 4, line 68_B
p4b_permPerm. restr. net assets (BOY)Permanently restricted net assets- beginning of year
NOTE: Only records with p4b_perm listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_perm%'] in filter criteria when using this field (see SCvars below).
Part 4, line 69_A
p4e_permPerm. restr. net assets (EOY)Permanently restricted net assets- end of year
NOTE: Only records with p4e_perm listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_perm%'] in filter criteria when using this field (see SCvars below).
Part 4, line 69_B
p4b_netTotal fund balances (BOY)Total fund balances or net worth- beginning of year
NOTE: Only records with p4b_net listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_net%'] in filter criteria when using this field (see SCvars below).
Part 4, line 73_A
p4e_netTotal fund balances (EOY)Total fund balances or net worth- end of year
NOTE: Only records with p4e_net listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_net%'] in filter criteria when using this field (see SCvars below).
Part 4, line 73_B
p6numEmpNumber of employeesNumber of employees employed in pay period including 3/12/90306y
NOTE: Only records with p6numEmp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p6numEmp%'] in filter criteria when using this field (see SCvars below).
Part 6, line 90b
p7govamtGvt fees & contracts - amt (B)Fees & contracts from govt agencies (g)-col. B (unrelated business income, amount)
NOTE: Only records with p7govamt listed in SCvars contain this data. Always include [AND SCvars LIKE '%p7govamt%'] in filter criteria when using this field (see SCvars below).
Part 7, line 93g_B
p7medamtMedicare/Medicaid payts-amtMedicare/medicaid payments (f)- col. B (unrelated business income, amount)
NOTE: Only records with p7medamt listed in SCvars contain this data. Always include [AND SCvars LIKE '%p7medamt%'] in filter criteria when using this field (see SCvars below).
Part 7, line 93f_B
p7govrinGvt fees & contracts (E)Fees & contracts from govt agencies (g)-col. E (related or exempt function income)
NOTE: Only records with p7govrin listed in SCvars contain this data. Always include [AND SCvars LIKE '%p7govrin%'] in filter criteria when using this field (see SCvars below).
Part 7, line 93g_E
p7govxatGvt fees & contracts (D)Fees & contracts from govt agencies (g)-col. D (excl by s.512,513 or 514)
NOTE: Only records with p7govxat listed in SCvars contain this data. Always include [AND SCvars LIKE '%p7govxat%'] in filter criteria when using this field (see SCvars below).
Part 7, line 93g_D
p7medxatMedicare/medicaid payments (f)Medicare/medicaid payments (f)- col. D (excl by s.512,513 or 514, amount)
NOTE: Only records with p7medxat listed in SCvars contain this data. Always include [AND SCvars LIKE '%p7medxat%'] in filter criteria when using this field (see SCvars below).
Part 7, line 93f_D
p7medrinMedicare/medicaid payments (f)Medicare/medicaid payments (f)- col. E (related or exempt function income)
NOTE: Only records with p7medrin listed in SCvars contain this data. Always include [AND SCvars LIKE '%p7medrin%'] in filter criteria when using this field (see SCvars below).
Part 7, line 93f_E
a3lobbyInfluence legislation?Organization attempted to influence legislation (Sch. A, Part III, Line 1)
NOTE: Only records with a3lobby listed in SCvars contain this data. Always include [AND SCvars LIKE '%a3lobby%'] in filter criteria when using this field (see SCvars below).
Sch. A, Part 3, line
a3lbyexTotal lobbying expensesTotal lobbying expenses (Sch. A, Part III, Line 1)
NOTE: Only records with a3lbyex listed in SCvars contain this data. Always include [AND SCvars LIKE '%a3lbyex%'] in filter criteria when using this field (see SCvars below).
Sch. A, Part 3, line
a4fndtypReason for Public Charity StatusThe organization is not a private foundation because it is: (Line number of box checked in Schedule A)
NOTE: Only records with a4fndtyp listed in SCvars contain this data. Always include [AND SCvars LIKE '%a4fndtyp%'] in filter criteria when using this field (see SCvars below).
Sch. A, Part 3, line
a4suporgSupporting OrganizationType of Supporting Organization (Schedule A, Line 13 for forms prior to 2008)
NOTE: Only records with a4suporg listed in SCvars contain this data. Always include [AND SCvars LIKE '%a4suporg%'] in filter criteria when using this field (see SCvars below).
Sch. A, Part 4, line
PDFNameImage PDF NameForm 990 Return Image PDF File Name - unique identifier for Form 990 returns used to match Core Supplement Financial records to Part III (Purpose Program) and Part V (Key Contact) records
I_IrsFormImage Form 990 TypeKeypunch Return Image Form Type
I_DateRecImage Form Date ReceivedKeypunch Return Image Date Received by IRS
FormYrImage Form YearKeypunch Return Image Form YearBeginning, sec.A
Flag_Core04Matched Core 2004 pcFlag_Core04=1 indicates the best unique EIN and Fiscal Year match available to a record in Core 2004 PC (use Flag_Core04=1 filter when matching to Core 2004 PC file records on EIN and FisYr)Beginning, sec.A
Flag_Core05Matched Core 2005 pcFlag_Core05=1 indicates the best unique EIN and Fiscal Year match available to a record in Core 2005 PC (use Flag_Core05=1 filter when matching to Core 2005 PC file records on EIN and FisYr)Beginning, sec.A
Flag_Core06Matched Core 2006 pcFlag_Core06=1 indicates the best unique EIN and Fiscal Year match available to a record in Core 2006 PC (use Flag_Core06=1 filter when matching to Core 2006 PC file records on EIN and FisYr)Beginning, sec.A
FisYr_BestUnique Fiscal Year ReturnFisYr_Best=1 indicates the most recent return filed by an organization per Fiscal Year (e.g.: use FisYr_Best=1 and (FisYr='2005' or FisYr='2006') to filter out duplicate returns and select the most recent return filed in 2005 and in 2006 per EIN)Beginning, sec.A
LatestOneMost Recent ReturnLatestOne=1 indicates the most recent unique fiscal year return (use to filter out duplicates by selecting the one most recent return per EIN)Beginning, sec.A
SCvarsSupplemental VariablesA comma-separated list of the supplemental variables that were keypunched for each record (e.g. 'EIN,p0phone,website,p1contFund,p1dirsup,...').
NOTE: Not all fields were keypunched for every record, so always include SCvars in filter criteria to only select records that contain keypunched data (e.g. including [SCvars like '%a3lobby%'] in a filter will select records that contain keypunched data for a3lobby and exclude records that do not contain a3lobby).
Beginning, sec.A
SCsourceProject Data SourceSource of supplemental data (project data file name)Beginning, sec.A