* SOI 2004 990EZ c3.

VARIABLE LABELS
EIN "Employer identification number."
NAME "Name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
NAICS "NAICS Code"
E010 "Accounting Period (year and month)"
E050 "Organization type - IRS subsection code number"
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"
OutNCCS "Flag for out-of-scope organizations"
OutReas "Reason why out of scope"
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"
level1 "Public charity or private foundation?"
level2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
NTEESOI "NTEE assigned by IRS SOI Division"
R040 "Total contributions, (EZ) line 1"
R050 "Program service revenue, (EZ) line 2"
R060 "Membership dues and assessments,line 3. (Includes only portion of dues for which member directly benefits. "Dues" to public charities are often more accurately reported as Contributions.)"
RZ100 "Investment income, (EZ) line 4"
RZ200 "Gross Amt From Sale of Assets, (EZ) line 5a"
RZ300 "Cost or Other Basis, (EZ) line 5b"
R190 "Total gain (or loss), sale of assets other than inventory, (EZ) line 5c"
R200 "Gross revenue from special events, (EZ) line 6a"
R210 "Direct expenses other than fundraising for special events, (EZ) line 6b"
R220 "Net income/loss from special events, (EZ) line 6c"
R230 "Gross sales of inventory less returns and allowances, line (EZ) 7a"
R240 "Cost of goods sold, line (EZ) 7b"
R250 "Gross profit/loss from sales of inventory, (EZ) line 7c"
R260 "Other revenue, (EZ) line 8"
R270 "Total revenue, (EZ) line 9"
XZ100 "Grants and Similar Amounts Paid, (EZ) line 10"
F020 "Benefits paid to or for members, (EZ) line 11"
XZ200 "Salaries, Compensation and Employee Benefits, (EZ) line 12"
XZ300 "Professional fees and other payments, (EZ) line 13"
XZ400 "Occupancy, Rent, Utilitites, Maintenance, (EZ) line 14"
XZ500 "Printing, Publications, Postage, Shipping, (EZ) line 15"
XZ600 "Total Other Expenses, (EZ) line 16"
X050 "Total expenses, (EZ) line 17"
N010 "Net income (excess or deficit) for the year, (EZ) line 18"
N020 "Net assets or fund balance at beginning of year, (EZ) line 19"
N030 "Other changes in net assets or fund balances, (EZ) line 20"
N040 "Net assets or fund balance at end-of-year, (EZ) line 21"
AZ101 "Cash, savings, and investments at beginning-of-year, (EZ) Column A - line 22"
AZ100 "Cash, savings, and investments at end-of-year, (EZ) Column B - line 22"
A023 "Land, buildings, & equipment at beginning-of-year, (EZ) Column A - line 23"
A160 "Land, buildings, & equipment at end-of-year, (EZ) Column B - line 23"
AZ201 "Other Assets at beginning-of-year, (EZ) Column A - line 24"
AZ200 "Other Assets at end-of-year, (EZ) Column B - line 24"
A030 "Total assets at beginning-of-year, (EZ) Column A - line 25"
A180 "Total assets at end-of-year, (EZ) Column B - line 25"
L010 "Total liabilities at beginning-of-year, (EZ) Column A - line 26"
L090 "Total liabilities at end-of-year, (EZ) Column B - line 26"
B010 "Total fund balances or net assets at beginning-of-year, (EZ) Column A - line 27"
B020 "Total fund balances or net assets at end-of-year, (EZ) Column B - line 27"
C100 "Number of uncompensated officers, etc. (EZ Part IV, see compensation sub-table)"
Q020 "Filed Form 990-T, (EZ) line 35(b)"
Q030 "Liquidation, dissolution, termination, or substantial contraction during the year, (EZ) line 36"
Q050 "Amount of direct and indirect political expenditures, (EZ) line 37a"
Q060 "Filed Form 1120-POL, (EZ) line 37b"
Q150 "501(c)(7): initiation fees and capital contributions, (EZ) line 39a"
Q160 "501(c)(7): gross receipts from public use of facilities, (EZ) line 39b"
Q170 "501(c)(3): tax paid under section 4911, (EZ) line 40a(1)"
Q180 "501(c)(3): tax paid under section 4912, (EZ) line 40a(2)"
Q190 "501(c)(3): tax paid under section 4955, (EZ) line 40a(3)"
Q200 "501(c)(3) or (4): engage in section 4958 excess benefit transaction, (EZ) line 40b"
Q210 "501(c)(3) or (4): tax imposed on managers or disqualified persons under section 4912, 4955, & 4958, (EZ) line 40c"
Q220 "501(c)(3) or (4): amount of 4912, 4955, or 4958 tax reimbursed by organization, (EZ) line 40d"
S001 "Compensation (Sch A, Part I), Column C - line a"
S002 "Contributions to employee benefit plans (Sch A, Part I), Column D - line a"
S003 "Expense account and other allowances (Sch A, Part I), Column E - line a"
S011 "Compensation (Sch A, Part I), Column C - line b"
S012 "Contributions to employee benefit plans (Sch A, Part I), Column D - line b"
S013 "Expense account and other allowances (Sch A, Part I), Column E - line b"
S021 "Compensation (Sch A, Part I), Column C - line c"
S022 "Contributions to employee benefit plans (Sch A, Part I), Column D - line c"
S023 "Expense account and other allowances (Sch A, Part I), Column E - line c"
S031 "Compensation (Sch A, Part I), Column C - line d"
S032 "Contributions to employee benefit plans (Sch A, Part I), Column D - line d"
S033 "Expense account and other allowances (Sch A, Part I), Column E - line d"
S041 "Compensation (Sch A, Part I), Column C - line e"
S042 "Contributions to employee benefit plans (Sch A, Part I), Column D - line e"
S043 "Expense account and other allowances (Sch A, Part I), Column E - line e"
S050 "Number of other employees paid > $30,000 (Sch A, Part I), Column B"
S070 "Expenses paid for legislative activities (Sch A, Part III), line 1"
S100 "Reason for non-private foundation status (Sch A, Part IV)"
S200 "Gifts, grants, and contributions received (Sch A, Part IV-A), Column A - line 15"
S205 "Gifts, grants, and contributions received (Sch A, Part IV-A), Column E - line 15"
S210 "Membership fees received (Sch A, Part IV-A), Column A - line 16"
S215 "Membership fees received (Sch A, Part IV-A), Column E - line 16"
S220 "Gross receipts related to exempt purpose (Sch A, Part IV-A), Column A - line 17"
S225 "Gross receipts related to exempt purpose (Sch A, Part IV-A), Column E - line 17"
S230 "Gross investment, rent, royalty, and UBIT income (Sch A, Part IV-A), Column A - line 18"
S235 "Gross investment, rent, royalty, and UBIT income (Sch A, Part IV-A), Column E - line 18"
S240 "Net income from unrelated business activities (Sch A, Part IV-A), Column A - line 19"
S245 "Net income from unrelated business activities (Sch A, Part IV-A), Column E - line 19"
S250 "Tax revenues (Sch A, Part IV-A), Column A - line 20"
S255 "Tax revenues (Sch A, Part IV-A), Column E - line 20"
S260 "Value of services furnished by government (Sch A, Part IV-A), Column A - line 21"
S265 "Value of services furnished by government (Sch A, Part IV-A), Column E - line 21"
S270 "Other income (Sch A, Part IV-A), Column A - line 22"
S275 "Other income (Sch A, Part IV-A), Column E - line 22"
S280 "Total (Sch A, Part IV-A), Column A - line 23"
S285 "Total (Sch A, Part IV-A), Column E - line 23"
S290 "Total minus gross receipts (Sch A, Part IV-A), Column A - line 24"
S295 "Total minus gross receipts (Sch A, Part IV-A), Column E - line 24"
S300 "1% of line 24 (Sch A, Part IV-A), Column A - line 25"
S510 "Lobbying to influence public opinion (Sch A, Part VI-A), line 36b"
S520 "Lobbying to influence legislative body (Sch A, Part VI-A), line 37b"
S530 "Total lobbying (Sch A, Part VI-A), line 38b"
S540 "Other exempt purpose expenditures (Sch A, Part VI-A), line 39b"
S550 "Total exempt purpose expenditures (Sch A, Part VI-A), line 40b"
S560 "Lobbying nontaxable amount (Sch A, Part VI-A), line 41b"
S570 "Grassroots nontaxable amount (Sch A, Part VI-A), line 42b"
S580 "Excess grass roots expenditures: line 36b less line 42b (Sch A, Part VI-A), line 43b"
S590 "Excess lobbying expenditures: line 38b less line 41b (Sch A, Part VI-A), line 44b"
EZ_IND "Form 990-EZ Indicator (Y=EZ)"
SCPL "S.C./Cycle/Page/L.C."
SAMP_CD "Sample code"
DLN "Document Locator Number used by the IRS"
COND "Condition Code"
SAM_CNT "Sample count"
COMP_CNT "Number of rows in compensation sub-table"
POP_CNT "Population count"
WEIGHT "Weight"
RandNum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS COND
"A" "Amended return"
"F" "Final return"
"G" "Group return"
"S" "Separate return "
.
VALUE LABELS EZ_IND
"Y" "Yes"
"N" "No"
.
VALUE LABELS level1
"PF" "Private Foundation"
"PC" "Public Charity"
"O" "Other Nonprofits"
"U" "Unknown"
.
VALUE LABELS level2
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
"M" "Mutual Benefit Public Charity"
.
VALUE LABELS level3
"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"
"ZF" "Other Supporting Public Benefit"
"ZE" "General fundraising"
"ZD" "Public foundations"
"ZC" "Private grantmaking foundations"
"ED" "Education"
"ZB" "Fundraising within NTEE major group"
"AR" "Arts, culture and humanities"
"ZA" "Single organization support"
.
VALUE LABELS level4
"E" "Health"
"M" "Public Safety"
"U" "Science and Technology Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"N" "Recreation, Sports, Leisure, Athletics"
"V" "Social Science Research Institutes, Services"
"G" "Diseases, Disorders, Medical Disciplines"
"O" "Youth Development"
"W" "Public, Society Benefit - Multipurpose and Other"
"H" "Medical Research"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"B" "Education"
"J" "Employment, Job Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"C" "Environmental Quality, Protection, and Beautification"
"K" "Food, Agriculture, and Nutrition"
"S" "Community Improvement, Capacity Building"
"" "Unknown"
"D" "Animal-Related"
"L" "Housing, Shelter"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
.
VALUE LABELS MajGrpB
"B" "B-Education"
"P" "P-Human Services, Multipurpose and Other"
"BH" "BH-Higher educ."
"Q" "Q-International, Foreign Affairs"
"C" "C-Environment"
"R" "R-Civil Rights/Advocacy"
"D" "D-Animal Related"
"S" "S-Community Improvement"
"E" "E-Health - General"
"T" "T-Philanthropy, Voluntarism"
"EH" "EH-Hospitals"
"U" "U-Science and Technology"
"F" "F-Mental Health"
"V" "V-Social Science"
"G" "G-Health - Disease Specific (general)"
"W" "W-Public, Society Benefit"
"H" "H-Health - Disease Specific (research)"
"X" "X-Religion Related"
"I" "I-Crime, Legal Related"
"Y" "Y-Mutual/Membership Benefit"
"J" "J-Employment, Job Related"
"Z" "Z-Unknown, Unclassified"
"K" "K-Food, Agriculture, Nutrition"
"L" "L-Housing, Shelter"
"M" "M-Public Safety, Disaster Preparedness"
"N" "N-Recreation and Sports"
"A" "A-Arts, Culture & Humanities"
"O" "O-Youth Development"
.
VALUE LABELS NTEE1
"" "Unknown"
"D" "Animal-Related"
"L" "Housing, Shelter"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"E" "Health"
"M" "Public Safety"
"U" "Science and Technology Research Institutes, Services"
"F" "Mental Health, Crisis Intervention"
"N" "Recreation, Sports, Leisure, Athletics"
"V" "Social Science Research Institutes, Services"
"G" "Diseases, Disorders, Medical Disciplines"
"O" "Youth Development"
"W" "Public, Society Benefit - Multipurpose and Other"
"H" "Medical Research"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"A" "Arts, Culture, and Humanities"
"I" "Crime, Legal Related"
"Q" "International, Foreign Affairs, and National Security"
"Y" "Mutual/Membership Benefit Organizations, Other"
"B" "Education"
"J" "Employment, Job Related"
"R" "Civil Rights, Social Action, Advocacy"
"Z" "Unknown"
"C" "Environmental Quality, Protection, and Beautification"
"K" "Food, Agriculture, and Nutrition"
"S" "Community Improvement, Capacity Building"
.
VALUE LABELS ntmaj10
"RE" "Religion"
"IN" "International"
"PU" "Public and societal benefit"
"UN" "Unknown"
"MU" "Mutual benefit"
"EN" "Environment"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
.
VALUE LABELS ntmaj12
"UN" "Unknown"
"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"
.
VALUE LABELS ntmaj5
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"OT" "Other"
.
VALUE LABELS OutReas
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"T" "T- U.S. Territory or armed forces overseas"
"F" "F- Foreign organization"
"4" "4- Not a 501(c)(3)"
"" "No value"
.
VALUE LABELS Q020
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q030
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q060
"Y" "Yes"
"N" "No"
.
VALUE LABELS Q200
"Y" "Yes"
"N" "No"
.
VALUE LABELS SAMP_CD
"42" "501(c)(4)-(9): Assets $150,000 under $300,000"
"38" "501(c)(3) All E-Filed 990 hospital returns (SOI 2009 and later)"
"43" "501(c)(4)-(9): Assets $300,000 under $1,000,000"
"44" "501(c)(4)-(9): Assets $1,000,000 under $4,000,000"
"45" "501(c)(4)-(9): Assets $4,000,000 under $10,000,000"
"46" "501(c)(4)-(9): Assets $10,000,000 or more"
"21" "Charitable Trust: Assets under $100,000"
"22" "Charitable Trust: Assets $100,000 under $1,000,000"
"23" "Charitable Trust: Assets $1,000,000 or more"
"11" "501(c)(3) Private Foundation: Assets under $125,000"
"31" "501(c)(3) Public Charity: Assets under $500,000"
"12" "501(c)(3) Private Foundation: Assets $125,000 under $400,000"
"32" "501(c)(3) Public Charity: Assets $500,000 under $1,000,000"
"13" "501(c)(3) Private Foundation: Assets $400,000 under $1,000,000"
"33" "501(c)(3) Public Charity: Assets $1,000,000 under $2,500,000"
"14" "501(c)(3) Private Foundation: Assets $1,000,000 under $2,500,000"
"34" "501(c)(3) Public Charity: Assets $2,500,000 under $5,000,000"
"15" "501(c)(3) Private Foundation: Assets $2,500,000 under $10,000,000"
"35" "501(c)(3) Public Charity: Assets $5,000,000 under $20,000,000"
"16" "501(c)(3) Private Foundation: Assets $10,000,000 under $25,000,000"
"36" "501(c)(3) Public Charity: Assets $20,000,000 under $50,000,000"
"17" "501(c)(3) Private Foundation: Assets $25,000,000 or more"
"37" "501(c)(3) Public Charity: Assets $50,000,000 or more"
"41" "501(c)(4)-(9): Assets under $150,000"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
SCPL a12
EIN a9
EZ_IND a1
NAME a60
SAMP_CD a2
COND a1
E010 a4
STATE a2
ZIP5 a5
E050 a2
R040 f15.0
R050 f15.0
R060 f15.0
R190 f15.0
R200 f15.0
R210 f15.0
R220 f15.0
R230 f15.0
R240 f15.0
R250 f15.0
R260 f15.0
R270 f15.0
RZ100 f15.0
RZ200 f15.0
RZ300 f15.0
X050 f15.0
XZ100 f15.0
XZ200 f15.0
XZ300 f15.0
XZ400 f15.0
XZ500 f15.0
XZ600 f15.0
N010 f15.0
N020 f15.0
N030 f15.0
N040 f15.0
F020 f15.0
A023 f15.0
A030 f15.0
L010 f15.0
B010 f15.0
A160 f15.0
A180 f15.0
AZ101 f15.0
AZ201 f15.0
AZ100 f15.0
AZ200 f15.0
L090 f15.0
B020 f15.0
C100 f15.0
Q020 a1
Q030 a1
Q050 f15.0
Q060 a1
Q150 f15.0
Q160 f15.0
Q170 f15.0
Q180 f15.0
Q190 f15.0
Q200 a1
Q210 f15.0
Q220 f15.0
T340 f15.0
S001 f15.0
S002 f15.0
S003 f15.0
S011 f15.0
S012 f15.0
S013 f15.0
S021 f15.0
S022 f15.0
S023 f15.0
S031 f15.0
S032 f15.0
S033 f15.0
S041 f15.0
S042 f15.0
S043 f15.0
S050 f15.0
S070 f15.0
S100 a3
S200 f15.0
S205 f15.0
S210 f15.0
S215 f15.0
S220 f15.0
S225 f15.0
S230 f15.0
S235 f15.0
S240 f15.0
S245 f15.0
S250 f15.0
S255 f15.0
S260 f15.0
S265 f15.0
S270 f15.0
S275 f15.0
S280 f15.0
S285 f15.0
S290 f15.0
S295 f15.0
S300 f15.0
S510 f15.0
S520 f15.0
S530 f15.0
S540 f15.0
S550 f15.0
S560 f15.0
S570 f15.0
S580 f15.0
S590 f15.0
DLN a14
NTEESOI a4
COMP_CNT f15.0
SAM_CNT f15.0
POP_CNT f15.0
WEIGHT f15.0
FIPS a5
MSA_NECH a4
PMSA a4
NteeOldB a5
NTEECC a5
NTEECC4d a2
NTEEconf a1
NTEE1 a1
MajGrpB a2
NtMaj10 a2
NtMaj5 a2
NtMaj12 a2
OutNCCS a3
OutReas a1
Level1 a2
Level2 a1
Level3 a2
Level4 a1
RandNum f15.0
WEIGHTold f15.0
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.