Core Supplement 02-10-2009 Financial
| EIN | Employer Identification Number | Employer identification number. | |
| FisYr | Fiscal year | Fiscal year (ending year) | |
| p0phone | Phone Number | Phone 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). | |
| Website | Website | Website 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). | |
| p0addchg | Address change | Address 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 |
| p0namchg | Name change | Name 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 |
| p0intrtn | Initial return | Initial 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 |
| p0fnlrtn | Final return / Termination | Final 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 |
| p0amdrtn | Amended return | Amended 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 |
| p0append | Application pending | Application 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 |
| p1contFund | Donor Advised Contributions | Contributions 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 |
| p1dirsup | Direct public support | Direct 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 |
| p1indsup | Indirect public support | Indirect 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 |
| p1govgt | Government grants | Government 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 |
| p1noncsh | Noncash contributions | Noncash 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 |
| p1cash | Cash contributions | Cash 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 |
| p1tcont | Total contributions | Total 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 |
| p1psrev | Program service revenue | Program 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 |
| p1totrev | Total Revenue | Total 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 |
| p1mExp | Management & general expenses | Management & 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 |
| p1pExp | Program service expenses | Program 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 |
| p1frexp | Fund-raising expenses | Fund-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 |
| p1affil | Payments to affiliates | Payments 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 |
| p1totexp | Total Expenses | Total 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 |
| p1netInc | Net income | Net 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 |
| p1nasboy | Net assets or fund balance-beg | Net 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 |
| p1chgas | Other changes in net assets | Other 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 |
| p1naseoy | Net assets or fund balance-end | Net 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_ilnd | Investments - 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_ilnd | Accum depreciation Invest Land | Accumulated 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_ilnd | Net Invest-land, bldg, equip | Net 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_land | Land, 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_land | Accum depreciation Land Bldg Equip | Accumulated 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_land | Net 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_asst | Total assets- end of year | Total 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_unre | Unrestr. 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_unre | Unrestr. 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_temp | Temp. 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_temp | Temp. 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_perm | Perm. 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_perm | Perm. 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_net | Total 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_net | Total 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 |
| p6numEmp | Number of employees | Number 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 |
| p7govamt | Gvt 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 |
| p7medamt | Medicare/Medicaid payts-amt | Medicare/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 |
| p7govrin | Gvt 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 |
| p7govxat | Gvt 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 |
| p7medxat | Medicare/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 |
| p7medrin | Medicare/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 |
| a3lobby | Influence 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 |
| a3lbyex | Total lobbying expenses | Total 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 |
| a4fndtyp | Reason for Public Charity Status | The 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 |
| a4suporg | Supporting Organization | Type 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 |
| PDFName | Image PDF Name | Form 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_IrsForm | Image Form 990 Type | Keypunch Return Image Form Type | |
| I_DateRec | Image Form Date Received | Keypunch Return Image Date Received by IRS | |
| FormYr | Image Form Year | Keypunch Return Image Form Year | Beginning, sec.A |
| Flag_Core04 | Matched Core 2004 pc | Flag_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_Core05 | Matched Core 2005 pc | Flag_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_Core06 | Matched Core 2006 pc | Flag_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_Best | Unique Fiscal Year Return | FisYr_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 |
| LatestOne | Most Recent Return | LatestOne=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 |
| SCvars | Supplemental Variables | A 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 |
| SCsource | Project Data Source | Source of supplemental data (project data file name) | Beginning, sec.A |