* DD Balance Sheet v2005b.
VARIABLE LABELSEIN "Employer identification number."
NCCSKEY "Unique key: ein + return date"
FisYr "Fiscal year (ending year)"
NAME "Organization name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
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 - the component areas that comprise a CMSA (76 PMSAs as of 1995). (list)"
outnccs "Out-of-scope (IN/OUT) (see OUTREAS doc. for details)"
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"
p1totexp "Total expenses"
p4b_cash "Cash- beg. of year"
p4e_cash "Cash- end of year (Part 4, line 45_B)"
p4b_save "Savings- beg. of year"
p4e_save "Savings- end of year (Part 4, line 46_B)"
p4g_arec "Accounts receivable"
p4d_arec "Allowance for doubtful accounts"
p4b_arec "Accounts receivable - doubtful accts- beg. of year"
p4e_arec "Accounts receivable- end of year (Part 4, line 47c_B)"
p4b_prec "Pledges receivable - doubtful accts- beg. of year"
p4d_prec "Pledges receivable, allowance for doubtful accts"
p4e_prec "Pledges receivable- end of year (Part 4, line 48c_B)"
p4g_prec "Pledges receivable, gross"
p4b_grec "Grants receivable- beg. of year"
p4e_grec "Grants receivable- end of year (Part 4, line 49_B)"
p4b_irec "Receivables from officers, directors- beg. of year"
p4e_irec "Receivables due from offices, directors & trustees- end of year (Part 4, line 50_B)"
p4b_lrec "Other notes receivable less doubtful accts- beg. of year"
p4d_lrec "Allowance for doubtful accounts"
p4e_lrec "Other notes & loans receivable- end of year (Part 4, line 51c_B)"
p4g_lrec "Other notes & loans receivable"
P4B_INVT "Inventories for sale or use, beg. of year"
P4E_INVT "Inventories for sale or use, end of year"
p4b_pre "Prepaid expenses & deferred charges- beg. of year"
p4e_pre "Prepaid expenses- end of year (Part 4, line 53_B)"
p4b_sec "Investments- securities- beg. of year"
p4e_sec "Investments- securities- end of year (Part 4, line 54_B)"
p4b_ilnd "Investments- land, blg & eq minus accum. dep- beg. of year"
p4d_ilnd "Accumulated depreciation for land, blg & equip"
p4e_ilnd "Investments-land, buildings & equipment minus accum. dep- end of year (Part 4, line 55c_B)"
p4g_ilnd "Investments- land, blg & equip: basis"
p4b_iOth "Investments- other- beg. of year"
p4e_iOth "Investments-other- end of year (Part 4, line 56_B)"
p4b_land "Land, blg & equip - accum. deprec.- beg. of year"
p4d_land "Accumulated depreciation of land, blg & equip"
p4e_land "Land, building & equip. minus accum. deprec.- end of year (Part 4, line 57c_B)"
p4g_land "land, blg, equip: basis"
p4b_asst "Total assets- beg. of year"
p4b_oAst "Other assets- beg. of year"
p4e_asst "Total assets- end of year (Part 4, line 59_B)"
p4e_oAst "Other assets- end of year (Part 4, line 58_B)"
p4b_apay "Accounts payable & accrued expenses- beg. of year"
p4e_apay "Accounts payable- end of year (Part 4, line 60_B)"
p4b_gpay "Grants payable- beg. of year"
p4e_gpay "Grants payable- end of year (Part 4, line 61_B)"
p4b_defr "Deferred revenue- beg. of year"
p4e_defr "Revenue designated for future periods- end of year (Part 4, line 62_B)"
p4b_lpay "Loans from officers, directors,- beg. of year"
p4e_lpay "Loans from officers, directors & trustees- end of year (Part 4, line 63_B)"
p4b_bond "Tax-exempt bond liabilities- beg. of year"
p4e_bond "Tax-exempt bond liabilities- end of year (Part 4, line 64a_B)"
p4b_mort "Mortgages & other notes payable- beg. of year"
p4e_mort "Mortgages & other notes payable- end of year (Part 4, line 64b_B)"
p4b_oLia "Other liabilities- beg. of year"
p4e_oLia "Other liabilities- end of year (Part 4, line 65_B)"
p4b_liab "Total liabilities- beg. of year"
p4e_liab "Total liabilities- end of year (Part 4, line 66_B)"
p4b_unre "Unrestricted net assets or fund balances- beg.of year"
p4e_unre "Unrestricted net assets or fund balances- end of year (Part 4, line 67_B)"
p4b_temp "Temporarily restricted net asset- beg. of year"
p4e_temp "Temporarily restricted net assets- end of year (Part 4, line 68_B)"
p4b_perm "Permanently restricted net assets- beg. of year"
p4e_perm "Permanently restricted net assets- end of year (Part 4, line 69_B)"
p4b_cap "Capital stock, trust prncipl, or curnt fnds-beg. of year"
p4e_cap "Capital stock, trust prncipl, or curnt fnds-end of year (Part 4, line 70_B)"
p4b_surp "Paid-in or capital splus, or ld, blg & e fd- beg. of year"
p4e_surp "Paid-in or capital splus, or ld, blg & e fd- end of year (Part 4, line 71_B)"
p4b_retn "Retained earns, endowmts, accum. Income- beg. of year"
p4e_retn "Retained earns, endowmts, accum. Income- end of year (Part 4, line 72_B)"
p4b_net "Total fund balances or net worth- beg. of year"
p4e_net "Total fund balances or net worth- end of year (Part 4, line 73_B)"
p4b_lint "Total liabilities & net assets/fund balances- beg. of year"
p4e_lint "Total liabilities & net assets/fund balances- end of year (Part 4, line 74_B)"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
Latest "Is record the most recent one received from organization? (y)"
FIN_ID "Unique organization ID"
LAST_MOD "Date last modified (var 2)"
GRREC_SM "Gross receipts < $25k flag (Y/N)"
SET_ "Source data set"
formtype "990 or ez? (9/z)"
NCCSKEY2 "Unique key: ein + fiscal year"
RandNum "Random number between 0 and 1 used for creating samples"
.
.
VALUE LABELS LEVEL1
"PF" "Private Foundation"
"PC" "Public Charity"
"O" "Other Nonprofits"
"U" "Unknown"
.
VALUE LABELS LEVEL2
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
.
VALUE LABELS level3
"ZF" "Other Supporting Public Benefit"
"ZE" "General fundraising"
"ZD" "Public foundations"
"ZC" "Private grantmaking foundations"
"ZB" "Fundraising within NTEE major group"
"ZA" "Single organization support"
"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"
"ED" "Education"
"AR" "Arts, culture and humanities"
.
VALUE LABELS level4
"A" "Arts, Culture, and Humanities"
"B" "Education"
"C" "Environmental Quality, Protection, and Beautification"
"D" "Animal-Related"
"E" "Health"
"F" "Mental Health, Crisis Intervention"
"G" "Diseases, Disorders, Medical Disciplines"
"H" "Medical Research"
"I" "Crime, Legal Related"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"L" "Housing, Shelter"
"M" "Public Safety"
"N" "Recreation, Sports, Leisure, Athletics"
"O" "Youth Development"
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"R" "Civil Rights, Social Action, Advocacy"
"S" "Community Improvement, Capacity Building"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"U" "Science and Technology Research Institutes, Services"
"V" "Social Science Research Institutes, Services"
"W" "Public, Society Benefit - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS MAJGRPB
"A" "A-Arts, Culture & Humanities"
"B" "B-Education"
"BH" "BH-Higher educ."
"C" "C-Environment"
"D" "D-Animal Related"
"E" "E-Health - General"
"EH" "EH-Hospitals"
"F" "F-Mental Health"
"G" "G-Health - Disease Specific (general)"
"H" "H-Health - Disease Specific (research)"
"I" "I-Crime, Legal Related"
"J" "J-Employment, Job Related"
"K" "K-Food, Agriculture, Nutrition"
"L" "L-Housing, Shelter"
"M" "M-Public Safety, Disaster Preparedness"
"N" "N-Recreation and Sports"
"O" "O-Youth Development"
"P" "P-Human Services, Multipurpose and Other"
"Q" "Q-International, Foreign Affairs"
"R" "R-Civil Rights/Advocacy"
"S" "S-Community Improvement"
"T" "T-Philanthropy, Voluntarism"
"U" "U-Science and Technology"
"V" "V-Social Science"
"W" "W-Public, Society Benefit"
"X" "X-Religion Related"
"Y" "Y-Mutual/Membership Benefit"
"Z" "Z-Unknown, Unclassified"
.
VALUE LABELS NTEE1
"A" "Arts, Culture, and Humanities"
"B" "Education"
"C" "Environmental Quality, Protection, and Beautification"
"D" "Animal-Related"
"E" "Health"
"F" "Mental Health, Crisis Intervention"
"G" "Diseases, Disorders, Medical Disciplines"
"H" "Medical Research"
"I" "Crime, Legal Related"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"L" "Housing, Shelter"
"M" "Public Safety"
"N" "Recreation, Sports, Leisure, Athletics"
"O" "Youth Development"
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"R" "Civil Rights, Social Action, Advocacy"
"S" "Community Improvement, Capacity Building"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"U" "Science and Technology Research Institutes, Services"
"V" "Social Science Research Institutes, Services"
"W" "Public, Society Benefit - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS nteeFinal1
"A" "Arts, Culture, and Humanities"
"B" "Education"
"C" "Environmental Quality, Protection, and Beautification"
"D" "Animal-Related"
"E" "Health"
"F" "Mental Health, Crisis Intervention"
"G" "Diseases, Disorders, Medical Disciplines"
"H" "Medical Research"
"I" "Crime, Legal Related"
"J" "Employment, Job Related"
"K" "Food, Agriculture, and Nutrition"
"L" "Housing, Shelter"
"M" "Public Safety"
"N" "Recreation, Sports, Leisure, Athletics"
"O" "Youth Development"
"P" "Human Services - Multipurpose and Other"
"Q" "International, Foreign Affairs, and National Security"
"R" "Civil Rights, Social Action, Advocacy"
"S" "Community Improvement, Capacity Building"
"T" "Philanthropy, Voluntarism, and Grantmaking Foundations"
"U" "Science and Technology Research Institutes, Services"
"V" "Social Science Research Institutes, Services"
"W" "Public, Society Benefit - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
"Y" "Mutual/Membership Benefit Organizations, Other"
"Z" "Unknown"
"" "Unknown"
.
VALUE LABELS ntmaj10
"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"
.
VALUE LABELS ntmaj12
"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 ntmaj5
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"OT" "Other"
.
VALUE LABELS OUTREAS
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"4" "4- Not a 501(c)(3)"
"" "No value"
"T" "T- U.S. Territory or armed forces overseas"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
.
VALUE LABELS v4b_asst
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v4b_liab
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v4b_lint
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v4b_net
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v4e_arec
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v4e_asst
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v4e_ilnd
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v4e_land
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v4e_liab
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v4e_lint
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v4e_lrec
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v4e_net
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
VALUE LABELS v4e_prec
"1" "Arithmetic check perfect"
"2" "Within $20"
"3" "Within 1%"
"4" "Within 5%"
"5" "Within 10%"
"6" "Within 25%"
"7" "25% or more"
"8" "Both values are empty or zero"
"9" "One value is empty or zero"
"n" "1 or 2 negative values"
"b" "25%+ & error >$1 million"
"" "Unknown"
.
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.
.