Core Supplement 02-10-2009 Financial
| Number of variables | 65 |
|---|---|
| Number of records | 0 |
| Field Name Field Type | Description and Values |
|---|---|
| Basic Info | |
| EIN Character (9) | Employer Identification Number Employer identification number. |
| FisYr Character (4) | Fiscal year Fiscal year (ending year) |
| p0phone Character (20) | 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 Character (100) | 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 Character (1) | 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). |
| p0namchg Character (1) | 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). |
| p0intrtn Character (1) | 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). |
| p0fnlrtn Character (1) | 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). |
| p0amdrtn Character (1) | 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). |
| p0append Character (1) | 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). |
| Part I: Revenue, Expenses, and Changes in Net Assets or Fund Balances | |
| p1contFund Numeric (1) | 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). |
| p1dirsup Numeric (1) | 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). |
| p1indsup Numeric (1) | 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). |
| p1govgt Numeric (1) | 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). |
| p1noncsh Numeric (1) | 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). |
| p1cash Numeric (1) | 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). |
| p1tcont Numeric (1) | 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). |
| p1psrev Numeric (1) | 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). |
| p1totrev Numeric (1) | 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). |
| p1mExp Numeric (1) | 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). |
| p1pExp Numeric (1) | 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). |
| p1frexp Numeric (1) | 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). |
| p1affil Numeric (1) | 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). |
| p1totexp Numeric (1) | 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). |
| p1netInc Numeric (1) | 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). |
| p1nasboy Numeric (1) | 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). |
| p1chgas Numeric (1) | 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). |
| p1naseoy Numeric (1) | 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 IV: Balance Sheets | |
| p4b_ilnd Numeric (1) | 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). |
| p4d_ilnd Numeric (1) | 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). |
| p4e_ilnd Numeric (1) | 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). |
| p4b_land Numeric (1) | 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). |
| p4d_land Numeric (1) | 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). |
| p4e_land Numeric (1) | 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). |
| p4e_asst Numeric (1) | 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). |
| p4b_unre Numeric (1) | 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). |
| p4e_unre Numeric (1) | 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). |
| p4b_temp Numeric (1) | 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). |
| p4e_temp Numeric (1) | 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). |
| p4b_perm Numeric (1) | 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). |
| p4e_perm Numeric (1) | 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). |
| p4b_net Numeric (1) | 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). |
| p4e_net Numeric (1) | 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 VI: Other Information | |
| p6numEmp Character (20) | 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 VII: Analysis of Income-Producing Activities | |
| p7govamt Numeric (20) | 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). |
| p7medamt Numeric (20) | 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). |
| p7govrin Numeric (20) | 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). |
| p7govxat Numeric (20) | 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). |
| p7medxat Numeric (20) | 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). |
| p7medrin Numeric (20) | 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). |
| Schedule A, Part III: Statement About Activities | |
| a3lobby Character (20) | 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). |
| a3lbyex Numeric (20) | 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). |
| Schedule A, Part IV: Reason for Non-Private Foundation Status | |
| a4fndtyp Character (3) | 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). |
| a4suporg Character (3) | 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). |
| Miscellaneous | |
| PDFName Character (30) | 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 Character (2) | Image Form 990 Type Keypunch Return Image Form Type |
| I_DateRec Character (9) | Image Form Date Received Keypunch Return Image Date Received by IRS |
| FormYr Character (4) | Image Form Year Keypunch Return Image Form Year |
| Flag_Core04 Numeric (4) | 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) |
| Flag_Core05 Numeric (4) | 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) |
| Flag_Core06 Numeric (4) | 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) |
| FisYr_Best Numeric (4) | 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) |
| LatestOne Numeric (4) | 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) |
| SCvars Character (4) | 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). |
| SCsource Character (40) | Project Data Source Source of supplemental data (project data file name) |