* NCCS Form 990EZ RTF 2013.
VARIABLE LABELSEIN "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
"Y" "Yes"
"N" "No"
.
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 chngsinorgcd
"Y" "Yes"
"N" "No"
.
VALUE LABELS contractioncd
"Y" "Yes"
"N" "No"
.
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
"Y" "Yes"
"N" "No"
.
VALUE LABELS filedf990tcd
"Y" "Yes"
"N" "No"
.
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 loanstoofficerscd
"Y" "Yes"
"N" "No"
.
VALUE LABELS NteeCat12
"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 ORGCD
"5" "Association"
"4" "Partnership"
"3" "Co-operative"
"2" "Trust"
"1" "Corporation"
"6" "Non-exempt charitable trust"
"0" "Unknown"
.
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 ..."
"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 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.
.