* NCCS Form 990PF RTF 2014.

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
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"90" "90- 4947(a)(2) Split Interest Trust"
"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..."
"80" "80- Farmers' Cooperatives"
"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..."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"19" "19- Post or organization of war veterans."
"92" "92- 4947(a)(1) Private Foundations"
"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."
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"11" "11- Teachers retirement fund associations."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"40" "40- Apostolic and religious orgs. - 501(d)"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"70" "70- Child Care Organization - 501(k)"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"71" "71- Charitable Risk Pool"
"81" "81- Qualified State-Sponsored Tuition Program"
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"22" "22- Multiemployer Pension Plan"
"02" "02- Title holding corporation for a tax-exempt organization."
"23" "23- Veterans association formed prior to 1880"
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"24" "24-Trust described in Section 4049 of ERISA"
"82" "82- 527 Political Organizations"
"25" "25- Title Holding Company for Pensions, etc"
.

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
eostat a2
tax_yr a4
operatingcd a1
subcd a2
fairmrktvalamt f15.0
grscontrgifts f15.0
schedbind a1
intrstrvnue f15.0
dividndsamt f15.0
grsrents f15.0
grsslspramt f15.0
costsold f15.0
grsprofitbus f15.0
otherincamt f15.0
totrcptperbks f15.0
compofficers f15.0
pensplemplbenf f15.0
legalfeesamt f15.0
accountingfees f15.0
interestamt f15.0
depreciationamt f15.0
occupancyamt f15.0
travlconfmtngs f15.0
printingpubl f15.0
topradmnexpnsa f15.0
contrpdpbks f15.0
totexpnspbks f15.0
excessrcpts f15.0
totrcptnetinc f15.0
topradmnexpnsb f15.0
totexpnsnetinc f15.0
netinvstinc f15.0
trcptadjnetinc f15.0
totexpnsadjnet f15.0
adjnetinc f15.0
topradmnexpnsd f15.0
totexpnsexempt f15.0
othrcashamt f15.0
invstgovtoblig f15.0
invstcorpstk f15.0
invstcorpbnd f15.0
totinvstsec f15.0
mrtgloans f15.0
othrinvstend f15.0
othrassetseoy f15.0
totassetsend f15.0
mrtgnotespay f15.0
othrliabltseoy f15.0
totliabend f15.0
tfundnworth f15.0
fairmrktvaleoy f15.0
totexcapgnls f15.0
totexcapgn f15.0
totexcapls f15.0
invstexcisetx f15.0
sec4940notxcd a1
sec4940redtxcd a1
sect511tx f15.0
subtitleatx f15.0
totaxpyr f15.0
esttaxcr f15.0
txwithldsrc f15.0
txpaidf2758 f15.0
erronbkupwthld f15.0
estpnlty f15.0
taxdue f15.0
overpay f15.0
crelamt f15.0
infleg a1
actnotpr a1
chgnprvrptcd a1
filedf990tcd a1
contractncd a1
furnishcpycd a1
claimstatcd a1
cntrbtrstxyrcd a1
acqdrindrintcd a1
orgcmplypubcd a1
filedlf1041ind a1
propexchcd a1
brwlndmnycd a1
furngoodscd a1
paidcmpncd a1
transfercd a1
agremkpaycd a1
exceptactsind a1
prioractvcd a1
undistrinccd a1
applyprovind a1
dirindirintcd a1
excesshldcd a1
invstjexmptcd a1
prevjexmptcd a1
propgndacd a1
ipubelectcd a1
grntindivcd a1
nchrtygrntcd a1
nreligiouscd a1
excptransind a1
rfprsnlbnftind a1
pyprsnlbnftind a1
tfairmrktunuse f15.0
valncharitassets f15.0
cmpmininvstret f15.0
distribamt f15.0
undistribincyr f15.0
adjnetinccola f15.0
adjnetinccolb f15.0
adjnetinccolc f15.0
adjnetinccold f15.0
adjnetinctot f15.0
qlfydistriba f15.0
qlfydistribb f15.0
qlfydistribc f15.0
qlfydistribd f15.0
qlfydistribtot f15.0
valassetscola f15.0
valassetscolb f15.0
valassetscolc f15.0
valassetscold f15.0
valassetstot f15.0
qlfyasseta f15.0
qlfyassetb f15.0
qlfyassetc f15.0
qlfyassetd f15.0
qlfyassettot f15.0
endwmntscola f15.0
endwmntscolb f15.0
endwmntscolc f15.0
endwmntscold f15.0
endwmntstot f15.0
totsuprtcola f15.0
totsuprtcolb f15.0
totsuprtcolc f15.0
totsuprtcold f15.0
totsuprttot f15.0
pubsuprtcola f15.0
pubsuprtcolb f15.0
pubsuprtcolc f15.0
pubsuprtcold f15.0
pubsuprttot f15.0
grsinvstinca f15.0
grsinvstincb f15.0
grsinvstincc f15.0
grsinvstincd f15.0
grsinvstinctot f15.0
grntapprvfut f15.0
progsrvcacold f15.0
progsrvcacole f15.0
progsrvcbcold f15.0
progsrvcbcole f15.0
progsrvcccold f15.0
progsrvcccole f15.0
progsrvcdcold f15.0
progsrvcdcole f15.0
progsrvcecold f15.0
progsrvcecole f15.0
progsrvcfcold f15.0
progsrvcfcole f15.0
progsrvcgcold f15.0
progsrvcgcole f15.0
membershpduesd f15.0
membershpduese f15.0
intonsvngsd f15.0
intonsvngse f15.0
dvdndsintd f15.0
dvdndsinte f15.0
trnsfrcashcd a1
trnsothasstscd a1
salesasstscd a1
prchsasstscd a1
rentlsfacltscd a1
reimbrsmntscd a1
loansguarcd a1
perfservicescd a1
sharngasstscd a1
DLN a14
efile f15.0
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.