* Core 2011 PC.

VARIABLE LABELS
EIN "Employer identification number."
NCCSKEY "Unique key: ein + return date"
FisYr "Fiscal year (ending year)"
NAME "Organization name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
ADDRESS "Address"
CITY "City"
ZIP "ZIP code."
zip5 "First 5 digits of zip code"
FIPS "2-digit State + 3-digit County FIPS code (Federal Information Processing Standard). See also U.S. Census Bureau State & County QuickFacts."
MSA_NECH "Metropolitan Statistical Area (NCCS file) (list)"
PMSA "Primary Metropolitan Statistical Area - the component areas that comprise a CMSA (76 PMSAs as of 1995). (list)"
styear "Starting year (yyyy when fiscal year began, which is also the tax form year)"
TAXPER "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 (IN/OUT) (see OUTREAS doc. for details)"
OUTREAS "Reason why out of scope"
SUBSECCD "IRS subsection code (03=501(c)(3), etc.)"
ntmaj5 "Major subsector (5)"
ntmaj10 "10 NTEE major groups"
ntmaj12 "12 NTEE major groups: ntmaj10 plus higher education (BH) and hospitals (EH)"
MAJGRPB "Major NTEE group plus hospitals and higher education"
NTEEconf "NTEE classification confidence rating (A/B/C)"
ACTIV1 "First activity code."
ACTIV2 "Second activity code."
ACTIV3 "Third activity code."
LEVEL2 "Reporting public charity groups."
CONT "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"
PROGREV "Program service revenue
Old 990 (DocCD=90): Part I, Line 2
New 990 (DocCD=93): Part VIII Line 2g (A) - includes amounts reported as DUES in Part I, Line 3 of Form 990 prior to 2008
990EZ (DocCD=09 and 92): Part I, Line 2

IMPORTANT NOTE: Amounts reported as DUES in Part I, Line 3 of Form 990 prior to tax year 2008 are reported as Program Service Revenue in Part VIII, Line 2g (PROGREV) of Form 990 beginning in tax year 2008. For this reason, DUES is not available in Core PC and CO files circa 2011 and newer. For this reason, the following adjustment will be necessary for comparison of PROGREV and DUES revenue components in Core files prior to 2011: [PROGREV+DUES in Core files prior to 2011] = [PROGREV in Core files 2011 and later]. Due to Form 990 revisions in tax year 2008: NCCS strongly recommends combining DUES and PROGREV revenue components for all analysis involving Core files containing both Old 990 (DocCD=90) and New 990 (DocCD=93) return data (Core files 2008-2010), and for all time-series analysis spanning Core file years 2008 and newer."
INVINC "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"
txexmptbndsproceeds "Income from investment of tax-exempt bond proceeds
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 4A"
royaltsinc "Royalty income
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 5A"
grsrntsreal "Gross rents, Real Estate
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 6a (i)"
grsrntsprsnl "Gross rents, Personal
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 6a (ii)"
RENTINC "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"
rntlexpnsreal "Rental expenses, Real Estate
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 6b (i)"
rntlexpnsprsnl "Rental expenses, Personal
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 6b (ii)"
RENTEXP "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"
rntlincreal "Net Rental Income (loss), Real Estate
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 6c (i)"
rntlincprsnl "Net Rental Income (loss), Personal
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 6c (ii)"
NETRENT "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"
SECUR "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 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 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 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 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 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"
grsincfndrsng "Gross income from fundraising events
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 8a"
lessdirfndrsng "Fundraising events direct expenses
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 8b"
netincfndrsng "Net income (loss) from fundraising events
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 8c"
grsincgaming "Gross income from gaming activities
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 9a"
lessdirgaming "Gaming activities direct expenses
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 9b"
netincgaming "Net income (loss) from gaming activities
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part VIII Line 9c"
SPEVTG "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 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 "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"
INVENTG "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
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 "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"
OTHINC "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"
TOTREV2 "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 "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)"
GRREC "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"
EXPS "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"
NETINC "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"
OTHCHGS "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"
FUNDBAL "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)"
COMPENS "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 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
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
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 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 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 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 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 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 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"
unsecurednotesend "Unsecured mortgages and notes payable at end of year
Old 990 and 990EZ (DocCD=90, 09 and 92): Not Available
New 990 (DocCD=93): Part X Line 24 (B)"
LIAB_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 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 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 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 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 "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"
INITFEES "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 "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 "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 "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 "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"
gftgrntsrcvd170 "Total gifts grants membership fees received: 170(b)(1)(A)(iv) and 170(b)(1)(A)(vi)
Old 990 and Old 990EZ (DocCD=90 and 09): Not Available
New 990 and New 990EZ (DocCD=93 and 92): Schedule A, Part II-A Public Support, Line 1(f)"
txrevnuelevied170 "Total tax revenues levied: 170(b)(1)(A)(iv) and 170(b)(1)(A)(vi)
Old 990 and Old 990EZ (DocCD=90 and 09): Not Available
New 990 and New 990EZ (DocCD=93 and 92): Schedule A, Part II-A Public Support, Line 2(f)"
srvcsval170 "Total value of services or facilities furnished by a governmental unit without charge: 170(b)(1)(A)(iv) and 170(b)(1)(A)(vi)
Old 990 and Old 990EZ (DocCD=90 and 09): Not Available
New 990 and New 990EZ (DocCD=93 and 92): Schedule A, Part II-A Public Support, Line 3(f)"
grsinc170 "Total gross income from interest, etc.: 170(b)(1)(A)(iv) and 170(b)(1)(A)(vi)
Old 990 and Old 990EZ (DocCD=90 and 09): Not Available
New 990 and New 990EZ (DocCD=93 and 92): Schedule A, Part II-B Total Support, Line 8(f)"
grsrcptsrelated170 "Total gross receipts from related activities, etc.: 170(b)(1)(A)(iv) and 170(b)(1)(A)(vi)
Old 990 and Old 990EZ (DocCD=90 and 09): Not Available
New 990 and New 990EZ (DocCD=93 and 92): Schedule A, Part II-B Total Support, Line 12"
totgftgrntrcvd509 "Total gifts, grants, contributions, and membership fees received: 509(a)(2)
Old 990 and Old 990EZ (DocCD=90 and 09): Not Available
New 990 and New 990EZ (DocCD=93 and 92): Schedule A, Part III-A Public Support, Line 1(f)"
grsrcptsadmissn509 "Total receipts from admissions, merchandise, etc.: 509(a)(2)
Old 990 and Old 990EZ (DocCD=90 and 09): Not Available
New 990 and New 990EZ (DocCD=93 and 92): Schedule A, Part III-A Public Support, Line 2(f)"
txrevnuelevied509 "Total Tax revenues levied: 509(a)(2)
Old 990 and Old 990EZ (DocCD=90 and 09): Not Available
New 990 and New 990EZ (DocCD=93 and 92): Schedule A, Part III-A Public Support, Line 4(f)"
srvcsval509 "Total value of services or facilities furnished by a governmental unit without charge: 509(a)(2)
Old 990 and Old 990EZ (DocCD=90 and 09): Not Available
New 990 and New 990EZ (DocCD=93 and 92): Schedule A, Part III-A Public Support, Line 5(f)"
subtotsuppinc509 "Subtotal total support (lines 10a + 10b): 509(a)(2)
Old 990 and Old 990EZ (DocCD=90 and 09): Not Available
New 990 and New 990EZ (DocCD=93 and 92): Schedule A, Part III-B Total Support, Line 10c(f)"
totsupp509 "Total support (lines 9 + 10c + 11 + 12): 509(a)(2)
Old 990 and Old 990EZ (DocCD=90 and 09): Not Available
New 990 and New 990EZ (DocCD=93 and 92): Schedule A, Part III-B Total Support, Line 13(f)"
RULEDATE "Ruling date: year and month of IRS ruling or determination letter recognizing orgs exempt status (YYYYMM)"
FNDNCD "Reason for & type of 501(c)(3) exempt status including codes for operating and grantmaking foundations, and broad type of public charity"
FRCD "Filing requirements code. The 1st 2 characters indicate the requirements for 990/990-EZ forms. The 3rd character = 1 if a 990-PF is required or 0 if not."
AFCD "Affiliation code"
CONTACT "Contact person (from IRS files)"
SEC_NAME "Secondary organization name"
GEN "Group Exemption Number"
LEVEL1 "Public charity or private foundation?"
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
CLASSCD "IRS Classification code"
DEDUCTCD "IRS Deductibility code"
NTEEIRS "NTEE code assigned by IRS (includes NTEE-CC & XP codes)"
NAICS "North American Industrial Classification System"
ORGCD "Organization code: corporation, trust, association, etc."
NCCSKEY2 "Unique key: ein + fiscal year"
VERIFY "Financials have been verified"
DocCD "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."
ACCPER "Accounting period"
LONGITUDE "Longitude"
randnum "Random number between 0 and 1 used for creating samples"
LATITUDE "Latitude"
SOIYR "Starting year for org's fiscal year."
DirSupCode "Code for Estimated Direct public support"
DirSupEstimate "Estimated Direct public support"
DirSupYr "Year of Estimated Direct public support"
GovGtCode "Code for Estimated Contributions from government grants"
GovGtEstimate "Estimated Contributions from government grants "
GovGtYr "Year of Estimated Contributions from government grants"
IndSupCode "Code for Estimated Indirect public support"
IndSupEstimate "Estimated Indirect public support"
IndSupYr "Year of Estimated Indirect public support"
.

.
VALUE LABELS AFCD
"9" "Subordinate in a group ruling."
"8" "Central - parent (group ruling) and is a church or 501 (c)(1)"
"7" "Intermediate- group exempt intermediate organization of a national, regional or geog. group"
"6" "Central - parent (group ruling) and is not a church or 501(c)(1)"
"3" "Independent org. or independent auxiliary unaffil. w. national, regional or geogr. grouping"
"2" "Intermediate organization (no group exemption)"
"1" "Central organization (no group exemption)"
"0" "Unknown"
.
VALUE LABELS DEDUCTCD
"1" "Contributions are deductible"
"2" "Contributions are not deductible"
"4" "Contributions are deductible by treaty (foreign organizations)"
"0" "Description unknown at this time"
.
VALUE LABELS DirSupCode
"2" "Data from Super Core - the following fiscal year"
"1" "Data from the latest SOI file"
"8" "Keypunched data - from the Super Core matching on fiscal year"
"3" "Data from Super Core - previous fiscal year"
"4" "Data from Super Core - the latest fiscal year available"
"5" "Data from Super Core - the closest fiscal year available"
"6" "Data from the Digitized Data set"
"u" "No data available from Super Core, SOI, or Digitized Data"
"7" "No data available from Super Core, SOI, or Digitized Data"
"9" "Keypunched data - new Form 990"
.
VALUE LABELS DocCD
"91" "Form 990-PF"
"92" "Form 990-EZ revision 2008 and later"
"90" "Form 990 revision 2007 and earlier"
"93" "Form 990 revision 2008 and later"
"09" "Form 990-EZ revision 2007 and earlier"
.
VALUE LABELS FNDNCD
"18" "Organization organized and operated to test for public safety"
"17" "Supporting Organization 509(a)(3) for benefit and in conjunction with organization(s) coded 10-16"
"16" "Organization income is <=1/3 investment or unrelated business and >1/3 donated or related to purpose"
"15" "Organization with a substantial portion of support from a governmental unit or the general public"
"14" "Governmental unit"
"13" "Organization operated for the benefit of a public (government owned or run) college or university"
"12" "Hospital or medical research organization"
"11" "School"
"10" "Church"
"09" "Suspense"
"04" "Private non-operating foundation"
"03" "Private operating foundation (other)"
"02" "Private operating foundation exempt from paying excise taxes on investment income"
"00" "All organizations except 501(c)(3)"
"21" "Supporting Organization 509(a)(3) Type I"
"22" "Supporting Organization 509(a)(3) Type II"
"23" "Supporting Organization 509(a)(3) Type III functionally integrated"
"24" "Supporting Organization 509(a)(3) Type III not functionally integrated"
.
VALUE LABELS FRCD
"000" "990 - Not required to file (all other)"
"001" "990PF Required - 990 not required to file (all other)"
"010" "990 (all other) or 990EZ return"
"011" "990PF Required (all other)"
"020" "990 - Required to file Form 990-N (Income less than $25,000 per year)"
"021" "990PF Required - 990 Required to file Form 990-N (Income less than $25,000 per year)"
"030" "990 - Group return"
"031" "990PF Required - Group return"
"040" "990 - Required to file Form 990-BL, Black Lung Trusts"
"041" "990PF Required - 990 Required to file Form 990-BL, Black Lung Trusts"
"060" "990 - Not required to file (church)"
"061" "990PF Required - Not required to file (church)"
"070" "990 - Government 501(c)(1)"
"071" "990PF Required - Government 501(c)(1)"
"130" "990 - Not required to file (religious organization)"
"131" "990PF Required - Not required to file (religious organization)"
"140" "990 - Not required to file (instrumentalities of states or political subdivisions)"
"141" "990PF Required - Not required to file (instrumentalities of states or political subdivisions)"
.
VALUE LABELS GovGtCode
"2" "Data from Super Core - the following fiscal year"
"1" "Data from the latest SOI file"
"8" "Keypunched data - from the Super Core matching on fiscal year"
"3" "Data from Super Core - previous fiscal year"
"4" "Data from Super Core - the latest fiscal year available"
"5" "Data from Super Core - the closest fiscal year available"
"6" "Data from the Digitized Data set"
"u" "No data available from Super Core, SOI, or Digitized Data"
"7" "No data available from Super Core, SOI, or Digitized Data"
"9" "Keypunched data - new Form 990"
.
VALUE LABELS IndSupCode
"2" "Data from Super Core - the following fiscal year"
"1" "Data from the latest SOI file"
"8" "Keypunched data - from the Super Core matching on fiscal year"
"3" "Data from Super Core - previous fiscal year"
"4" "Data from Super Core - the latest fiscal year available"
"5" "Data from Super Core - the closest fiscal year available"
"6" "Data from the Digitized Data set"
"u" "No data available from Super Core, SOI, or Digitized Data"
"7" "No data available from Super Core, SOI, or Digitized Data"
"9" "Keypunched data - new Form 990"
.
VALUE LABELS LEVEL1
"PF" "Private Foundation"
"PC" "Public Charity"
"O" "Other Nonprofits"
"U" "Unknown"
.
VALUE LABELS LEVEL2
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
.
VALUE LABELS level3
"ZF" "Other Supporting Public Benefit"
"ZE" "General fundraising"
"ZD" "Public foundations"
"ZC" "Private grantmaking foundations"
"ZB" "Fundraising within NTEE major group"
"ZA" "Single organization support"
"MO" "Other mutual benefit"
"MR" "Pension and retirement funds"
"UN" "Unknown, unclassified"
"RE" "Religion related"
"PB" "Public, societal benefit"
"IN" "International, foreign affairs"
"HS" "Human Services"
"HE" "Health"
"EN" "Environment/animals"
"ED" "Education"
"AR" "Arts, culture and humanities"
.
VALUE LABELS level4
"A" "Arts, Culture, and Humanities"
"B" "Education"
"C" "Environmental Quality, Protection, and Beautification"
"D" "Animal-Related"
"E" "Health"
"F" "Mental Health, Crisis Intervention"
"G" "Diseases, Disorders, Medical Disciplines"
"H" "Medical Research"
"I" "Crime, Legal Related"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"L" "Housing, Shelter"
"M" "Public Safety"
"N" "Recreation, Sports, Leisure, Athletics"
"O" "Youth Development"
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"R" "Civil Rights, Social Action, Advocacy"
"S" "Community Improvement, Capacity Building"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"U" "Science and Technology Research Institutes, Services"
"V" "Social Science Research Institutes, Services"
"W" "Public, Society Benefit - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS MAJGRPB
"A" "A-Arts, Culture & Humanities"
"B" "B-Education"
"BH" "BH-Higher educ."
"C" "C-Environment"
"D" "D-Animal Related"
"E" "E-Health - General"
"EH" "EH-Hospitals"
"F" "F-Mental Health"
"G" "G-Health - Disease Specific (general)"
"H" "H-Health - Disease Specific (research)"
"I" "I-Crime, Legal Related"
"J" "J-Employment, Job Related"
"K" "K-Food, Agriculture, Nutrition"
"L" "L-Housing, Shelter"
"M" "M-Public Safety, Disaster Preparedness"
"N" "N-Recreation and Sports"
"O" "O-Youth Development"
"P" "P-Human Services, Multipurpose and Other"
"Q" "Q-International, Foreign Affairs"
"R" "R-Civil Rights/Advocacy"
"S" "S-Community Improvement"
"T" "T-Philanthropy, Voluntarism"
"U" "U-Science and Technology"
"V" "V-Social Science"
"W" "W-Public, Society Benefit"
"X" "X-Religion Related"
"Y" "Y-Mutual/Membership Benefit"
"Z" "Z-Unknown, Unclassified"
.
VALUE LABELS NTEE1
"A" "Arts, Culture, and Humanities"
"B" "Education"
"C" "Environmental Quality, Protection, and Beautification"
"D" "Animal-Related"
"E" "Health"
"F" "Mental Health, Crisis Intervention"
"G" "Diseases, Disorders, Medical Disciplines"
"H" "Medical Research"
"I" "Crime, Legal Related"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"L" "Housing, Shelter"
"M" "Public Safety"
"N" "Recreation, Sports, Leisure, Athletics"
"O" "Youth Development"
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"R" "Civil Rights, Social Action, Advocacy"
"S" "Community Improvement, Capacity Building"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"U" "Science and Technology Research Institutes, Services"
"V" "Social Science Research Institutes, Services"
"W" "Public, Society Benefit - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS nteeFinal1
"A" "Arts, Culture, and Humanities"
"B" "Education"
"C" "Environmental Quality, Protection, and Beautification"
"D" "Animal-Related"
"E" "Health"
"F" "Mental Health, Crisis Intervention"
"G" "Diseases, Disorders, Medical Disciplines"
"H" "Medical Research"
"I" "Crime, Legal Related"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"L" "Housing, Shelter"
"M" "Public Safety"
"N" "Recreation, Sports, Leisure, Athletics"
"O" "Youth Development"
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"R" "Civil Rights, Social Action, Advocacy"
"S" "Community Improvement, Capacity Building"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"U" "Science and Technology Research Institutes, Services"
"V" "Social Science Research Institutes, Services"
"W" "Public, Society Benefit - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS NTEESRC
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"RTF" "Classification of I.R.S. Return Transaction Files"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"JCC" "Jill Capitani's clean up of the nteelu file"
"CORE02" "Core 2002 codes (04/02/04)"
"bahrz1" "NCCS - No information found in web search"
"FC" "Foundation Center reclassification"
"ZD" "David Stevenson's reclass. of unclassified"
"ZT" "Temp's review of unclassified, Feb. 97"
"T3" "Temps review and corrections to initial review of RTF95 file(T2)."
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"T" "Temps review in Fall 1996 (confidence=B)"
"IV" "Independent verifiers (1996) (confidence=A)"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"DS" "David Stevenson's rulings (confidence=A)"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"MD" "Classifcation of Maryland State Attorney General's file"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"KCS" "Classification done for Kansas City newspaper layout"
"SM" "Classification done by ShoShauna Mccoy"
"SOI" "Classification completed during reconciliation of SOI94"
"3YR" "Classification review completed during the data development of the three-year financial project"
"SMP" "Classification review from sampling (confidence=B)"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"ALM" "Almanac 2000 edits (confidence=A)"
"auto" "Automatically coded by NCCS (confidence=C)"
"" "Unknown source (confidence= ?)"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"ZZ" "NCCS expert verified records"
"DD200304-C" "Dig.data auto-coded 4/2003"
"DD200304-B" "Dig.data verified 4/2003"
"$src" "Dig.data auto-coded 3/2005"
"$src" "Auto-generated codes (confidence=C)"
"DD200511" "Digitized data auto-codes"
"Core2004co" "2006 NTEE rules"
.
VALUE LABELS ntmaj10
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
.
VALUE LABELS ntmaj12
"BH" "Education, higher"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"EH" "Hospitals"
.
VALUE LABELS ntmaj5
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"OT" "Other"
.
VALUE LABELS ORGCD
"5" "Association"
"4" "Partnership"
"3" "Co-operative"
"2" "Trust"
"1" "Corporation"
"6" "Non-exempt charitable trust"
"0" "Unknown"
.
VALUE LABELS OUTREAS
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"4" "4- Not a 501(c)(3)"
"" "No value"
"T" "T- U.S. Territory or armed forces overseas"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
.
VALUE LABELS Q78A
"Y" "Yes"
"N" "No"
.
VALUE LABELS REASON
"01" "Church"
"02" "School"
"03" "Hospital"
"04" "Governmental Unit"
"05" "Medical Research"
"06" "Operated for benefit of college or university owned or operated by governmental unit."
"07" "Receives substantial part of support from government unit or general public"
"08" "Community Trust"
"09" "Receives more than 33 1/3% of support from contributions, membership fees"
"10" "Supporting organizations for other exempt orgs"
"11" "Organized and operated to test for public safety"
"00" "Default value for those who fail to check a box or those that do not file Schedule A."
.
VALUE LABELS SOURCE
"SAG" "NTEE Classification based on agreement of 2 or 3 of codes from NCCS, FC or SOI."
"SOK" "NTEE Classification based on information from directory, web search or phone call."
"SQU" "NTEE Classification based on current IRS information or on previous classifications-chosen without c"
"I" "IRS Return Transaction Files"
"A" "Unified Database of Arts Organizations"
"C" "American Churches List"
"G" "Knight Foundation Grant Applicant Files"
"P" "Phone CD"
"U" "United Way"
"D" "Dun & Bradstreet Data Source"
.
VALUE LABELS SUBSECCD
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"11" "11- Teachers retirement fund associations."
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"02" "02- Title holding corporation for a tax-exempt organization."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"19" "19- Post or organization of war veterans."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"22" "22- Multiemployer Pension Plan"
"23" "23- Veterans association formed prior to 1880"
"24" "24-Trust described in Section 4049 of ERISA"
"25" "25- Title Holding Company for Pensions, etc"
"90" "90- 4947(a)(2) Split Interest Trust"
"80" "80- Farmers' Cooperatives"
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"92" "92- 4947(a)(1) Private Foundations"
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"40" "40- Apostolic and religious orgs. - 501(d)"
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"70" "70- Child Care Organization - 501(k)"
"71" "71- Charitable Risk Pool"
"81" "81- Qualified State-Sponsored Tuition Program"
"82" "82- 527 Political Organizations"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
.
VALUE LABELS VERIFY
"S" "Financial fields have been verified by SOI edited return."
"T" "Current financial fields have been multiplied by 1000 because return reported in thousands."
"L" "Financial fields were multiplied by 1000 because return reported in the thousands but inspection rev"
"" "No code"
"M" "Financial fields have been verified by staff."
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.