* NCCS Form 990 RTF 2012.

VARIABLE LABELS
EIN "Employer identification number."
FisYr "Fiscal year (ending year)"
NAME "Organization name."
STATE "Two-letter state abbreviation."
ADDRESS "Address"
CITY "City"
ZIP "ZIP code."
SUBSECCD "IRS subsection code (03=501(c)(3), etc.)"
ACTIV1 "First activity code."
ACTIV2 "Second activity code."
ACTIV3 "Third activity code."
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"
CLASSCD "IRS Classification code"
DEDUCTCD "IRS Deductibility code"
NTEEIRS "NTEE code assigned by IRS (includes NTEE-CC & XP codes)"
ORGCD "Organization code: corporation, trust, association, etc."
ACCPER "Accounting period"
.

.
VALUE LABELS AFCD
"1" "Central organization (no group exemption)"
"0" "Unknown"
"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)"
.
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 FNDNCD
"14" "Governmental unit"
"13" "Organization operated for the benefit of a public (government owned or run) college or university"
"21" "Supporting Organization 509(a)(3) Type I"
"12" "Hospital or medical research organization"
"22" "Supporting Organization 509(a)(3) Type II"
"11" "School"
"23" "Supporting Organization 509(a)(3) Type III functionally integrated"
"10" "Church"
"24" "Supporting Organization 509(a)(3) Type III not functionally integrated"
"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)"
"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"
.
VALUE LABELS FRCD
"14" "Not required to file - State Instrumentality or Political Subdivision"
"04" "Required to file 990BL - Black Lung Trust"
"13" "Not required to file - Religious Organization"
"06" "Not required to file - Church"
"02" "Required to file 990N (gross receipts less than $25,000)"
"01" "Required to file 990 (all other) or 990EZ"
"07" "Required to file 990 - Government 501 ( c) (1)"
"03" "Required to file 990 - Group Return"
"00" "Not required to file (all other)"
.
VALUE LABELS ORGCD
"5" "Association"
"4" "Partnership"
"3" "Co-operative"
"2" "Trust"
"1" "Corporation"
"6" "Non-exempt charitable trust"
"0" "Unknown"
.
VALUE LABELS SUBSECCD
"90" "90- 4947(a)(2) Split Interest Trust"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"80" "80- Farmers' Cooperatives"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"92" "92- 4947(a)(1) Private Foundations"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"19" "19- Post or organization of war veterans."
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"11" "11- Teachers retirement fund associations."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"40" "40- Apostolic and religious orgs. - 501(d)"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"70" "70- Child Care Organization - 501(k)"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"71" "71- Charitable Risk Pool"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"81" "81- Qualified State-Sponsored Tuition Program"
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"22" "22- Multiemployer Pension Plan"
"23" "23- Veterans association formed prior to 1880"
"02" "02- Title holding corporation for a tax-exempt organization."
"24" "24-Trust described in Section 4049 of ERISA"
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"25" "25- Title Holding Company for Pensions, etc"
"82" "82- 527 Political Organizations"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
KeyID f15.0
EIN a9
NAME a70
SEC_NAME a100
ADDRESS a35
CITY a22
STATE a2
ZIP a10
CONTACT a35
NteeIRS a4
NteeCat12 a2
SUBSECCD a2
FNDNCD a2
RULEDATE a6
ORGCD a1
ACCPER a2
ACTIV1 a3
ACTIV2 a3
ACTIV3 a3
AFCD a1
CLASSCD a4
DEDUCTCD a1
EOSTATUS a2
FRCD a3
GEN a4
tax_pd a6
FisYr a4
subcd a2
unrelbusinccd a1
initiationfees f15.0
grsrcptspublicuse f15.0
grsincmembers f15.0
grsincother f15.0
totcntrbgfts f15.0
totprgmrevnue f15.0
invstmntinc f15.0
txexmptbndsproceeds f15.0
royaltsinc f15.0
grsrntsreal f15.0
grsrntsprsnl f15.0
rntlexpnsreal f15.0
rntlexpnsprsnl f15.0
rntlincreal f15.0
rntlincprsnl f15.0
netrntlinc f15.0
grsalesecur f15.0
grsalesothr f15.0
cstbasisecur f15.0
cstbasisothr f15.0
gnlsecur f15.0
gnlsothr f15.0
netgnls f15.0
grsincfndrsng f15.0
lessdirfndrsng f15.0
netincfndrsng f15.0
grsincgaming f15.0
lessdirgaming f15.0
netincgaming f15.0
grsalesinvent f15.0
lesscstofgoods f15.0
netincsales f15.0
miscrevtot11e f15.0
totrevenue f15.0
compnsatncurrofcr f15.0
othrsalwages f15.0
payrolltx f15.0
profndraising f15.0
totfuncexpns f15.0
totassetsend f15.0
txexmptbndsend f15.0
secrdmrtgsend f15.0
unsecurednotesend f15.0
totliabend f15.0
retainedearnend f15.0
totnetassetend f15.0
nonpfrea a2
gftgrntsrcvd170 f15.0
txrevnuelevied170 f15.0
srvcsval170 f15.0
grsinc170 f15.0
grsrcptsrelated170 f15.0
totgftgrntrcvd509 f15.0
grsrcptsadmissn509 f15.0
txrevnuelevied509 f15.0
srvcsval509 f15.0
subtotsuppinc509 f15.0
totsupp509 f15.0
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.