* NCCS Form 990EZ RTF 2013.

VARIABLE LABELS
EIN "Employer identification number."
NAME "Organization name."
SEC_NAME "Secondary organization name"
ADDRESS "Address"
CITY "City"
STATE "Two-letter state abbreviation."
ZIP "ZIP code."
NteeCat12 "12 NTEE major groups: higher education (BH) separate from other education (ED); and hospitals (EH) separate from other health (HE)"
SUBSECCD "IRS subsection code (03=501(c)(3), etc.)"
FNDNCD "Reason for & type of 501(c)(3) exempt status including codes for operating and grantmaking foundations, and broad type of public charity"
RULEDATE "Ruling date: year and month of IRS ruling or determination letter recognizing orgs exempt status (YYYYMM)"
ORGCD "Form of organization: corporation, trust, assoc, etc."
ACCPER "Accounting period"
AFCD "Affiliation code"
CLASSCD "Combination of subsection code and classification code reflects a further breakdown of the Internal Revenue Code subsections"
DEDUCTCD "IRS Deductibility code"
EOSTATUS "Exempt Organization Status Code defines the type of exemption held by the organization"
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."
GEN "Group Exemption Number"
tax_pd "Tax period (ending year/month, YYYYMM)"
FisYr "Fiscal year (ending year, YYYY)"
subcd "Subsection code"
totcntrbs "Contributions, gifts, grants, etc received"
prgmservrev "Program service revenue"
duesassesmnts "Membership dues and assessments"
othrinvstinc "Investment income"
grsamtsalesastothr "Gross amount from sale of assets "
basisalesexpnsothr "Cost or other basis and sales expenses"
gnsaleofastothr "Gain or (loss) from sale of assets"
grsincgaming "Gross income from gaming"
grsrevnuefndrsng "Special events gross revenue"
direxpns "Special events direct expenses"
netincfndrsng "Special events net income (or loss)"
grsalesminusret "Gross sales of inventory"
costgoodsold "Less: cost of goods sold"
grsprft "Gross profit (or loss) from sales of inventory"
othrevnue "Other revenue - total"
totrevnue "Total revenue"
totexpns "Total expenses"
totexcessyr "Excess or deficit"
othrchgsnetassetfnd "Other changes in net assets"
networthend "Net assets - eoy"
totassetsend "Total assets - eoy"
totliabend "Total liabilities - eoy"
totnetassetsend "Total net worth - eoy"
actvtynotprevrptcd "Activity not previously reported?"
chngsinorgcd "Significant changes to governing docs?"
unrelbusincd "UBI over $1,000?"
filedf990tcd "Organization Filed 990T"
contractioncd "Liquidation, dissolution, termination, or contraction"
politicalexpend "Direct or indirect political expenditures."
filedf1120polcd "File Form 1120-POL?"
loanstoofficerscd "Loans to/from officers, directors or trustees?"
loanstoofficers "Amount of loans to/from officers"
initiationfee "Initiation fees and capital contributions"
grspublicrcpts "Gross receipts for public use of club facilities"
s4958excessbenefcd "Section 4958 excess benefit transactions?"
prohibtdtxshltrcd "Party to a prohibited tax shelter transaction?"
nonpfrea "Reason for non-PF status"
totnooforgscnt "Number of organizations supported"
totsupport "Sum of amounts of support"
gftgrntsrcvd170 "Gifts grants membership fees received (170)"
txrevnuelevied170 "Tax revenues levied (170)"
srvcsval170 "Services or facilities furnished by gov (170)"
pubsuppsubtot170 "Public support subtotal (170)"
exceeds2pct170 "Amount support exceeds total (170)"
pubsupplesspct170 "Public support (170)"
samepubsuppsubtot170 "Public support from line 4 (170)"
grsinc170 "Gross income from interest etc (170)"
netincunreltd170 "Net UBI (170)"
othrinc170 "Other income (170)"
totsupp170 "Total support (170)"
grsrcptsrelated170 "Gross receipts from related activities (170)"
totgftgrntrcvd509 "Gifts grants membership fees received (509)"
grsrcptsadmissn509 "Receipts from admissions merchandise etc (509)"
grsrcptsactivities509 "Gross receipts from related activities (509)"
txrevnuelevied509 "Tax revenues levied (509)"
srvcsval509 "Services or facilities furnished by gov (509)"
pubsuppsubtot509 "Public support subtotal (509)"
rcvdfrmdisqualsub509 "Amounts from disqualified persons (509)"
exceeds1pct509 "Amount support exceeds total (509)"
subtotpub509 "Public support subtotal (509)"
pubsupplesub509 "Public support (509)"
samepubsuppsubtot509 "Public support from line 6 (509)"
grsinc509 "Gross income from interest etc (509)"
unreltxincls511tx509 "Net UBI (509)"
subtotsuppinc509 "Subtotal total support (509)"
netincunrelatd509 "Net income from UBI not in 10b (509)"
othrinc509 "Other income (509)"
totsupp509 "Total support (509)"
.

.
VALUE LABELS actvtynotprevrptcd
"N" "No"
"Y" "Yes"
.
VALUE LABELS AFCD
"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)"
"1" "Central organization (no group exemption)"
.
VALUE LABELS chngsinorgcd
"N" "No"
"Y" "Yes"
.
VALUE LABELS contractioncd
"N" "No"
"Y" "Yes"
.
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 EOSTATUS
"01" "Unconditional Exemption"
"02" "Conditional Exemption"
"12" "Trust described in section 4947(a)(2) of the Code"
"25" "Organization terminating its private foundation status under section 507(b)(1)(B) of the Code"
"32" "Did not respond to an IRS CP 140 notice requesting information on its continued exempt status"
.
VALUE LABELS filedf1120polcd
"N" "No"
"Y" "Yes"
.
VALUE LABELS filedf990tcd
"Y" "Yes"
"N" "No"
.
VALUE LABELS FNDNCD
"23" "Supporting Organization 509(a)(3) Type III functionally integrated"
"04" "Private non-operating foundation"
"24" "Supporting Organization 509(a)(3) Type III not functionally integrated"
"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"
"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"
"21" "Supporting Organization 509(a)(3) Type I"
"10" "Church"
"22" "Supporting Organization 509(a)(3) Type II"
"09" "Suspense"
.
VALUE LABELS FRCD
"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)"
"000" "990 - Not required to file (all other)"
"140" "990 - Not required to file (instrumentalities of states or political subdivisions)"
"001" "990PF Required - 990 not required to file (all other)"
"141" "990PF Required - Not required to file (instrumentalities of states or political subdivisions)"
"010" "990 (all other) or 990EZ return"
"011" "990PF Required (all other)"
.
VALUE LABELS loanstoofficerscd
"Y" "Yes"
"N" "No"
.
VALUE LABELS NteeCat12
"MU" "Mutual benefit"
"EN" "Environment"
"EH" "Hospitals"
"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"
.
VALUE LABELS ORGCD
"5" "Association"
"4" "Partnership"
"6" "Non-exempt charitable trust"
"3" "Co-operative"
"0" "Unknown"
"2" "Trust"
"1" "Corporation"
.
VALUE LABELS prohibtdtxshltrcd
"Y" "Yes"
"N" "No"
.
VALUE LABELS s4958excessbenefcd
"Y" "Yes"
"N" "No"
.
VALUE LABELS SUBSECCD
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"40" "40- Apostolic and religious orgs. - 501(d)"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"70" "70- Child Care Organization - 501(k)"
"82" "82- 527 Political Organizations"
"11" "11- Teachers retirement fund associations."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"71" "71- Charitable Risk Pool"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"22" "22- Multiemployer Pension Plan"
"81" "81- Qualified State-Sponsored Tuition Program"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"23" "23- Veterans association formed prior to 1880"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"24" "24-Trust described in Section 4049 of ERISA"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"25" "25- Title Holding Company for Pensions, etc"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"90" "90- 4947(a)(2) Split Interest Trust"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"80" "80- Farmers' Cooperatives"
"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)"
"19" "19- Post or organization of war veterans."
"92" "92- 4947(a)(1) Private Foundations"
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"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"
"02" "02- Title holding corporation for a tax-exempt organization."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
.
VALUE LABELS unrelbusincd
"Y" "Yes"
"N" "No"
.

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.
.