Core FY 2007 PC
| EIN | Employer Identification Number | Employer identification number. | Beginning, sec.D |
| NCCSKEY | Unique key: ein + return date | Unique key: ein + return date | Beginning |
| FisYr | Fiscal year | Fiscal year (ending year) | |
| NAME | Name of organization | Organization name. | Beginning, sec.C1 |
| STATE | State | Two-letter state abbreviation. | Beginning, sec.C3 |
| NTEE1 | NTEE major group | NTEE major group (A-Z) | |
| NTEECC | NTEECC primary purpose | NTEECC classification | Beginning |
| ADDRESS | Address | Address | Beginning, sec.C2 |
| CITY | City | City | Beginning, sec.C3 |
| zip5 | Zip code, 5 digits | First 5 digits of zip code | Beginning, sec.C3 |
| FIPS | State + County FIPS code | 2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts. | |
| TAXPER | Ending date for tax period | Ending date for tax period of financial data. Core files for 1997 on are in "yyyymm" format (199412=Dec. 1994). Earlier years use 2-digit year ("9412"). | |
| outnccs | Out of Scope flag | Out-of-scope (IN/OUT) (see OUTREAS doc. for details) | Beginning |
| OUTREAS | Reason why out of scope | Reason why out of scope | |
| SUBSECCD | Subsection code | IRS subsection code (03=501(c)(3), etc.) | |
| ntmaj5 | Major subsector | Major subsector (5) | |
| ntmaj10 | NTEE major group (10) | 10 NTEE major groups | |
| ntmaj12 | NTEE major group (12) | 12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH) | |
| MAJGRPB | Major NTEE group | Major NTEE group plus hospitals and higher education | |
| NTEEconf | NTEE confidence rating | NTEE classification confidence rating (A/B/C) | |
| ACTIV1 | IRS Activity Code 1 | First activity code. | |
| CONT | Total Contributions | Total contributions, gifts, and grants Old 990 (DocCD=90): Part I, Line 1e New 990 (DocCD=93): Part VIII Line 1h 990EZ (DocCD=09 and 92): Part I, Line 1 | Part 1, line 01d |
| PROGREV | Program Service Revenue | Program service revenue Old 990 (DocCD=90): Part I, Line 2 New 990 (DocCD=93): Part VIII Line 2g (A) 990EZ (DocCD=09 and 92): Part I, Line 2 | Part 1, line 02 |
| DUES | Dues | Membership dues and assessments Old 990 (DocCD=90): Part I, Line 3 Old 990EZ (DocCD=09): Part I, Line 3 New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | Part 1, line 03 |
| INVINC | Total Investment Income | Total investment income Old 990 (DocCD=90): Sum of Part I, Lines 4, 5, & 7 New 990 (DocCD=93): Part VIII Line 3A 990EZ (DocCD=09 and 92): Part I, Line 4 | |
| SAVINT | Interest Revenue | Interest on savings and temporary cash investments Old 990 (DocCD=90): Part I, Line 4 New 990 (DocCD=93) and 990EZ (DocCD=09 and 92): Not available | |
| SECINC | Dividends | Dividends and interest from securities Old 990 (DocCD=90): Part I, Line 5 New 990 (DocCD=93) and 990EZ (DocCD=09 and 92): Not available | |
| RENTINC | Gross Rents | Gross rents Old 990 (DocCD=90): Part I, Line 6a New 990 (DocCD=93): Sum of Part VIII Line 6a (i) and 6a (ii) 990EZ (DocCD=09 and 92): Not Available | |
| RENTEXP | Rental Expenses | Rental expenses Old 990 (DocCD=90): Part I, Line 6b New 990 (DocCD=93): Sum of Part VIII Lines 6b(i) and 6b(ii) 990EZ (DocCD=09 and 92): Not Available | |
| NETRENT | Net Rental Income | Net rental income Old 990 (DocCD=90): Part I, Line 6c New 990 (DocCD=93): Part VIII Line 6d (A) 990EZ (DocCD=09 and 92): Not Available | Part 1, line 06c |
| OTHINVST | Other Investment Income | Other investment income Old 990 (DocCD=90): Part I, Line 7 Old 990EZ (DocCD=09): Part I, Line 4 New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| SECUR | Gross Sales of Securities | Gross receipts from sales of securities Old 990 (DocCD=90): Part I, Line 8a (A) New 990 (DocCD=93): Part VIII Line 7a(i) 990EZ (DocCD=09 and 92): Not Available | |
| SALESEXP | Cost Basis: Sale of Securities | Cost or other basis and sales expenses: securities Old 990 (DocCD=90): Part I, Line 8b (A) New 990 (DocCD=93): Part VIII Line 7b(i) 990EZ (DocCD=09 and 92): Not Available | |
| SALESECN | Net Gain/Loss: Sale of Securities | Net gain/loss from sales of securities Old 990 (DocCD=90): Part I, Line 8c (A) New 990 (DocCD=93): Part VIII Line 7c (i) 990EZ (DocCD=09 and 92): Not Available | |
| SALEOTHG | Gross Sales of Other Assets | Gross receipts from sales of other assets Old 990 (DocCD=90): Part I, Line 8a (B) New 990 (DocCD=93): Part VIII Line 7a (ii) 990EZ (DocCD=09 and 92): Part I, Line 5a | |
| SALEOTHE | Cost Basis: Sale of Other Assets | Cost or other basis and sales expenses: other assets Old 990 (DocCD=90): Part I, Line 8b (B) New 990 (DocCD=93): Part VIII Line 7b (ii) 990EZ (DocCD=09 and 92): Part I, Line 5b | |
| SALEOTHN | Net Gain/Loss: Sale of Other Assets | Net gain/loss from sales of other assets Old 990 (DocCD=90): Part I, Line 8c (B) New 990 (DocCD=93): Part VIII Line 7c (ii) 990EZ (DocCD=09 and 92): Part I, Line 5c | |
| SPEVTG | Special Events Gross Revenue | Gross revenue from special events and activities Old 990 (DocCD=90): Part I, Line 9a (right) New 990 (DocCD=93): Sum of Part VIII Line 8a and 9a 990EZ (DocCD=09 and 92): Part I, Line 6a | |
| DIREXP | Special Events Expenses | Special events direct expenses Old 990 (DocCD=90): Part I, Line 9b New 990 (DocCD=93): Sum of Part VIII Lines 8b and 9b 990EZ (DocCD=09 and 92): Part I, Line 6b | |
| FUNDINC | Special Events Net Income | Net income from special events and activities Old 990 (DocCD=90): Part I, Line 9c New 990 (DocCD=93): Sum of Part VIII Line 8c (A) and 9c (A) 990EZ (DocCD=09 and 92): Part I, Line 6c | Part 1, line 09c |
| INVENTG | Inventory Gross Sales | Gross sales of inventory, less returns and allowances Old 990 (DocCD=90): Part I, Line 10a New 990 (DocCD=93): Part VIII Line 10a 990EZ (DocCD=09 and 92): Part I, Line 7a | |
| GOODS | Inventory Cost of Goods Sold | Inventory cost of goods sold Old 990 (DocCD=90): Part I, Line 10b New 990 (DocCD=93): Part VIII Line 10b 990EZ (DocCD=09 and 92): Part I, Line 7b | |
| GRPROF | Inventory Gross Profit | Gross profit/loss from sales of inventory Old 990 (DocCD=90): Part I, Line 10c New 990 (DocCD=93): Part VIII Line 10c (A) 990EZ (DocCD=09 and 92): Part I, Line 7c | Part 1, line 10c |
| OTHINC | Other Income | Other income Old 990 (DocCD=90): Part I, Line 11 New 990 (DocCD=93): Part VIII Line 11e (A) 990EZ (DocCD=09 and 92): Part I, Line 8 | Part 1, line 11 |
| TOTREV2 | Total Revenue | Total revenue Old 990 (DocCD=90): Part I, Line 12 New 990 (DocCD=93): Part VIII Line 12 (A) 990EZ (DocCD=09 and 92): Part I, Line 9 | |
| TOTREV | Total Revenue (calculated) | Calculation of total revenue is based on version of Form 990/990EZ (see DocCD) Old 990 (DocCD=90) and Old 990EZ (DocCD=09): calculated as (CONT + PROGREV + DUES + INVINC + NETRENT + SALESECN + SALEOTHN + FUNDINC + GRPROF + OTHINC) New 990 (DocCD=93) and New 990EZ (DocCD=92): calculated as (EXPS + NETINC) | Part 1, line 12 |
| GRREC | Total Gross Receipts (calculated) | Calculation of total gross receipts is based on version of Form 990/990EZ (see DocCD) Old 990 (DocCD=90): Part I, Line 8b(A), plus Line 8b(B), plus Line 6b, plus Line 9b, plus Line 10b, plus Line 12 New 990 (DocCD=93): Part VIII, Line 12, plus Line 6b(i), plus Line 6b(ii), plus Line 7b(i), plus Line 7b(ii), plus Line 8b, plus Line 9b, plus Line 10b 990EZ (DocCD=09 and 92): Part I, Line 5b, plus Line 6b, plus Line 7b, plus Line 9 | |
| SOLICIT | Fundraising Expenses | Total fundraising expenses Old 990 (DocCD=90): Part I, Line 15 New 990 (DocCD=93) and 990EZ (DocCD=09 and 92): Not available | Part 1, line 15 |
| EXPS | Total Expenses | Total expenses Old 990 (DocCD=90): Part I, Line 17 New 990 (DocCD=93): Part IX Line 25 (A) 990EZ (DocCD=09 and 92): Part I, Line 17 | Part 1, line 17 |
| NETINC | Net Income/Deficit | Net income (loss) for the year Old 990 (DocCD=90): Part I, Line 18 New 990 (DocCD=93): Part I Line 19 (Current Year) 990EZ (DocCD=09 and 92): Part I, Line 18 | Part 1, line 18 |
| OTHCHGS | Other Changes in Net Assets | Other changes in net assets or fund balances Old 990 (DocCD=90): Part I, Line 20 Old 990EZ (DocCD=09): Part I, Line 20 New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | Part 1, line 20 |
| FUNDBAL | Net Assets - EOY | Net assets or fund balances at end of year Old 990 (DocCD=90): Part I, Line 21 New 990 (DocCD=93): Part I Line 22 (End of Year) 990EZ (DocCD=09 and 92): Part II, Line 27, Col (B) | Part 1, line 21 |
| COMPENS | Compensation of Officers | Compensation of officers Old 990 (DocCD=90): Part II, Line 25a, Col (A) New 990 (DocCD=93): Part IX Line 5 (A) 990EZ (DocCD=09 and 92): Not Available | |
| OTHSAL | Other Salaries | Other salaries and wages of employees Old 990 (DocCD=90): Part II, Line 26, Col (A) New 990 (DocCD=93): Part IX Line 7 (A) 990EZ (DocCD=09 and 92): Not Available | |
| PAYTAX | Payroll Taxes | Payroll taxes Old 990 (DocCD=90): Part II, Line 29, Col (A) New 990 (DocCD=93): Part IX Line 10 (A) 990EZ (DocCD=09 and 92): Not Available | |
| FUNDFEES | Professional Fundraising Fees | Professional fundraising fees Old 990 (DocCD=90): Part II, Line 30, Col (A) or (D) New 990 (DocCD=93): Part IX Line 11e (A) 990EZ (DocCD=09 and 92): Not Available | |
| ASS_BOY | Total Assets - BOY | Total assets at beginning of year Old 990 (DocCD=90): Part IV, Line 59, Col (A) New 990 (DocCD=93): Part X Line 16 (A) 990EZ (DocCD=09 and 92): Part II, Line 25, Col (A) | |
| ASS_EOY | Total Assets - EOY | Total assets at end of year Old 990 (DocCD=90): Part IV, Line 59, Col (B) New 990 (DocCD=93): Part X Line 16 (B) 990EZ (DocCD=09 and 92): Part II, Line 25, Col (B) | |
| BOND_BOY | Tax Exempt Bonds - BOY | Tax exempt bonds at beginning of year Old 990 (DocCD=90): Part IV, Line 64a, Col (A) New 990 (DocCD=93) and 990EZ (DocCD=09 and 92): Not available | |
| BOND_EOY | Tax Exempt Bonds - EOY | Tax exempt bonds at end of year Old 990 (DocCD=90): Part IV, Line 64a, Col (B) New 990 (DocCD=93): Part X Line 20 (B) 990EZ (DocCD=09 and 92): Not Available | |
| MRTG_BOY | Mortgages and Notes Payable - BOY | Mortgages and other notes payable at beginning of year Old 990 (DocCD=90): Part IV, Line 64b, Col (A) New 990 (DocCD=93) and 990EZ (DocCD=09 and 92): Not available | |
| MRTG_EOY | Mortgages and Notes Payable - EOY | Mortgages and other notes payable at end of year Old 990 (DocCD=90): Part IV, Line 64b, Col (B) New 990 (DocCD=93): Part X Line 23 (B) 990EZ (DocCD=09 and 92): Not Available | |
| LIAB_BOY | Total Liabilities - BOY | Total liabilities at beginning of year Old 990 (DocCD=90): Part IV, Line 66, Col (A) New 990 (DocCD=93): Part X Line 26 (A) 990EZ (DocCD=09 and 92): Part II, Line 26, Col (A) | |
| LIAB_EOY | Total Liabilities - EOY | Total liabilities at end of year Old 990 (DocCD=90): Part IV, Line 66, Col (B) New 990 (DocCD=93): Part X Line 26 (B) 990EZ (DocCD=09 and 92): Part II, Line 26, Col (B) | |
| RETE_BOY | Retained Earnings - BOY | Retained earnings at beginning of year Old 990 (DocCD=90): Part IV, Line 72, Col (A) New 990 (DocCD=93) and 990EZ (DocCD=09 and 92): Not available | |
| RETEARN | Retained Earnings - EOY | Retained earnings at end of year Old 990 (DocCD=90): Part IV, Line 72, Col (B) New 990 (DocCD=93): Part X Line 32 (B) 990EZ (DocCD=09 and 92): Not Available | |
| NETA_BOY | Net Assets - BOY | Net assets or fund balances at beginning of year Old 990 (DocCD=90): Part IV, Line 73, Col (A) New 990 (DocCD=93): Part X line 33 (A) 990EZ (DocCD=09 and 92): Part II, Line 27, Col (A) | |
| Q78A | UBI Indicator | Unrelated business gross income (UBI) of $1,000 or more during the year Old 990 (DocCD=90): Part VI, Question 78a New 990 (DocCD=93): Part V Line 3a 990EZ (DocCD=09 and 92): Part V, Question 35a | |
| POLPURP | Political Expenditures | Direct and indirect political expenditures Old 990 (DocCD=90): Part VI, Line 81a Old 990EZ (DocCD=09): Part V, Line 37a New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| INITFEES | Initiation Fees | 501(c)(7) orgs - Initiation fees and capital contributions Old 990 (DocCD=90): Part VI, Line 86a New 990 (DocCD=93): Part V Line 10a 990EZ (DocCD=09 and 92): Part V, Line 39a | |
| GRRECPUB | Income Public Use of Facilities | 501(c)(7) orgs - Gross receipts for public use of club facilities Old 990 (DocCD=90): Part VI, Line 86b New 990 (DocCD=93): Part V Line 10b 990EZ (DocCD=09 and 92): Part V, Line 39b | |
| GRRECMEM | Gross Income - Members | 501(c)(12) orgs - Gross income from members or shareholders Old 990 (DocCD=90): Part VI, Line 87a New 990 (DocCD=93): Part V Line 11a 990EZ (DocCD=09 and 92): Not Available | |
| GRRECOTH | Gross Income - Other | 501(c)(12) orgs - Gross income from other sources Old 990 (DocCD=90): Part VI, Line 87b New 990 (DocCD=93): Part V Line 11b 990EZ (DocCD=09 and 92): Not Available | |
| REASON | Non-Private Foundation Reason Code | Reason for non-private foundation status Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part IV, Left Margin New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| LEGEXP | Legislative Expenses | Total expenses paid or incurred in connection with the lobbying activities Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part III, Line 1 New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| CONT4 | Total Gifts and Grants | Total gifts, grants, and contributions received Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part IV-A, Line 15, Col (e) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| DUES4 | Total Membership Fees | Total membership fees received Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part IV-A, Line 16, Col (e) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| GRREC4 | Total Admissions, Sales, etc. Related to Purpose | Total gross receipts from admissions, merchandise or services, etc. related to charitable purpose Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part IV-A, Line 17, Col (e) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| INVINC4 | Total Interest and Dividends | Gross income from interest, dividends, payments on securities loans, etc. Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part IV-A, Line 18, Col (e) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| TAXREV4 | Total Tax Levies | Tax revenues levied for organization benefit Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part IV-A, Line 20, Col (e) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| GVTSRV4 | Total Govt Services/Facilities | Services or facilities furnished by a governmental unit Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part IV-A, Line 21, Col (e) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| OTHINC4 | Total Support | Total support - sum of lines 15 through 22 Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part IV-A, Line 23, Col (e) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| INCPURP4 | Total Support Less Sales, etc. | Total support less admissions, merchandise, etc. - line 23 less line 17 Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part IV-A, Line 24, Col (e) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| GRROOT | Grass Roots Expenses | Total lobbying expenditures to influence public opinion (grassroots lobbying) Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part VI-A, Line 36, Col (b) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| INFLEXP | Direct Lobbying Expenses | Total lobbying expenditures to influence a legislative body (direct lobbying) Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part VI-A, Line 37, Col (b) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| LOBOTH | Other Exempt Expenses | Other exempt purpose expenditures Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part VI-A, Line 39, Col (b) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| LOBNOTAX | Lobbying Nontaxable Amt | Lobbying nontaxable amount Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part VI-A, Line 41, Col (b) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| GRTNONTX | Grass Roots Nontaxable Amt | Grassroots nontaxable amount (enter 25% of line 41) Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part VI-A, Line 42, Col (b) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| EXGRROOT | Excess Grass Roots Exp | Excess grass roots expenditures - subtract line 42 from line 36. Enter -0- if line 42 is more than line 36 Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part VI-A, Line 43, Col (b) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| EXLOBEXP | Excess Lobbying Exp | Excess lobbying expenditures - subtract line 41 from line 38. Enter -0- if line 41 is more than line 38 Old 990 (DocCD=90) and Old 990EZ (DocCD=09): Sch A, Part VI-A, Line 44, Col (b) New 990 (DocCD=93) and New 990EZ (DocCD=92): Not available | |
| RULEDATE | Ruling date (YYYYMM) from IRS | Ruling date: year and month of IRS ruling or determination letter recognizing orgs exempt status (YYYYMM) | |
| FNDNCD | Reason for 501(c)(3) status | Reason for & type of 501(c)(3) exempt status including codes for operating and grantmaking foundations, and broad type of public charity | |
| NAICS | NAICS Code | North American Industrial Classification System | |
| NTEEIRS | NTEE assigned by IRS | NTEE code assigned by IRS (includes NTEE-CC & XP codes) | |
| NCCSKEY2 | Unique key: ein + fiscal year | Unique key: ein + fiscal year | Beginning |
| DLN | Document locator number | Document Locator Number used by the IRS | |
| DocCd | 990 Document Type Code | A 2-digit code identifying type of Form 990 (990, 990-EZ, or 990-PF), and form revision (form revision 2007 and earlier vs. 2008 and later). Document Code is the 4th and 5th digits of the DLN assigned by the IRS. | |
| randnum | Random number between 0 and 1 | Random number between 0 and 1 used for creating samples |