* SOI 2010 990EZ c3.

VARIABLE LABELS
EIN "Employer identification number."
GRP_EXMPT_NUM "Group exemption number"
FisYr "Fiscal year (ending year)"
NAME "Name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
E010 "Accounting Period (year and month)"
SUBSECCD "IRS subsection code, e.g. 03=501(c)(3), etc. (Page 1, Line I)"
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)"
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)"
NTEEconf "NTEE classification confidence rating (A/B/C)"
NAICS "North American Industrial Classification System"
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 code assigned by IRS SOI Division (identified as 'ntee' in original SOI documentation)"
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"
R199 "Gross revenue from gaming, (EZ) line 6a"
R200 "Gross revenue from special fundraising events, (EZ) line 6b"
R210 "Direct expenses other than fundraising for gaming and special events, (EZ) line 6c"
R220 "Net income/loss from gaming and special events, (EZ) line 6d"
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"
A023 "Land, buildings, & equipment at beginning-of-year, (EZ) Column A - line 23"
AZ201 "Other Assets at beginning-of-year, (EZ) Column A - line 24"
A030 "Total assets at beginning-of-year, (EZ) Column A - line 25"
L010 "Total liabilities at beginning-of-year, (EZ) Column A - line 26"
B010 "Total fund balances or net assets at beginning-of-year, (EZ) Column A - line 27"
AZ100 "Cash, savings, and investments at end-of-year, (EZ) Column B - line 22"
A160 "Land, buildings, & equipment at end-of-year, (EZ) Column B - line 23"
AZ200 "Other Assets at end-of-year, (EZ) Column B - line 24"
A180 "Total assets at end-of-year, (EZ) Column B - line 25"
L090 "Total liabilities at end-of-year, (EZ) Column B - line 26"
B020 "Total fund balances or net assets at end-of-year, (EZ) Column B - line 27"
C020_SUM "Compensation - sum of column (c) rows in compensation sub-table (EZ)"
C030_SUM "Contributions to employee benefit plans - sum of column (d) rows in compensation sub-table (EZ)"
C040_SUM "Expense account and other allowances - sum of column (e) rows in compensation sub-table (EZ)"
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"
Q222 "The organization was a party to a prohibited tax shelter transaction, (EZ) line 40e"
Q300 "Did the organization engage in direct or indirect political campaign activities on behalf of or in opposition to candidates for public office? If 'Yes,' complete Schedule C, Part I (EZ - PART VI, Line 46)"
Q310 "Did the organization engage in lobbying activities? (EZ - PART VI, Line 47)"
H100 "Employee compensation (1 of 5) (EZ - PART VI, Line 50c(1))"
H200 "Employee compensation (2 of 5) (EZ - PART VI, Line 50c(2))"
H300 "Employee compensation (3 of 5) (EZ - PART VI, Line 50c(3))"
H400 "Employee compensation (4 of 5) (EZ - PART VI, Line 50c(4))"
H500 "Employee compensation (5 of 5) (EZ - PART VI, Line 50c(5))"
H110 "Employee benefits (1 of 5) (EZ - PART VI, Line 50d(1))"
H210 "Employee benefits (2 of 5) (EZ - PART VI, Line 50d(2))"
H310 "Employee benefits (3 of 5) (EZ - PART VI, Line 50d(3))"
H410 "Employee benefits (4 of 5) (EZ - PART VI, Line 50d(4))"
H510 "Employee benefits (5 of 5) (EZ - PART VI, Line 50d(5))"
H120 "Employee exense account (1 of 5) (EZ - PART VI, Line 50e(1))"
H220 "Employee exense account (2 of 5) (EZ - PART VI, Line 50e(2))"
H320 "Employee exense account (3 of 5) (EZ - PART VI, Line 50e(3))"
H420 "Employee exense account (4 of 5) (EZ - PART VI, Line 50e(4))"
H520 "Employee exense account (5 of 5) (EZ - PART VI, Line 50e(5))"
H600 "Total number of other employees paid over $100,000 (EZ - PART VI, Line 50b)"
NON_PF_STATUS_CD "Reason for non-private foundation status code (Sch A - PART I, Lines 1-11)"
TYPE_SUPRTNG_ORG "Type of supporting organization (Sch A - PART I, Line 11)"
CERT_CHKBX "Organization not controlled by disqualified persons... (Sch A - PART I, Line 11e)"
WRTTN_IRS_DETERM "Written determination (Type I, Type II or Type III)? (Sch A - PART I, Line 11f)"
CONTRI_BY_CNTRL_INDIV "Controls governing body of the supported organization? (Sch A - PART I, Line 11g(i))"
CONTRI_BY_RLTD_PRTY "A family member of a party described above? (Sch A - PART I, Line 11g(ii))"
CONTRI_BY_35_CNTRL_ENT "A 35% controlled entity of a person above? (Sch A - PART I, Line 11g(iii))"
SUM_OF_SUPRTD_AMTS "Sum of amounts of support (Sch A - PART I, Line 11h(vii))"
PLTCL_EXPEND "Political expenditures (Sch C - PART I-A, Line 1)"
VLNTR_HRS "Volunteer hours (Sch C - PART I-A, Line 2)"
AMT_4955_TX "Enter the amount of any excise tax incurred under section 4955 (Sch C - PART I-B, Line 1)"
AMT_4955_TX_ON_MGRS "Amount of excise tax incurred by managers under section 4955 (Sch C - PART I-B, Line 2)"
FRM_4720_FILED_4955_TX "File Form 4720 for 4955 tax this year? (Sch C - PART I-B, Line 3)"
CORR_MADE "Was a correction made to Form 4720? (Sch C - PART I-B, Line 4a)"
AMT_EXPEND_FOR_527_ACTVS "Amount expended for section 527 exempt function activities (Sch C - PART I-C, Line 1)"
AMT_INTRNL_FNDS_CONTRI "Amount contributed to other organizations for 527 activities (Sch C - PART I-C, Line 2)"
TOT_EXMPT_FUNC_EXPEND "Direct and indirect exempt function expenditures. (Sch C - PART I-C, Line 3)"
FRM_1120_POL_FILED "Did the filing organization file Form 1120-POL for this year? (Sch C - PART I-C, Line 4)"
ORG_BELONGS_AFFLTD_GRP "Does the organization belong to an affiliated group? (Sch C - PART II-A, Line A)"
LTD_CNTRL_PRVSNS_APPLY "Do limited control provisions apply? (Sch C - PART II-A, Line B)"
GRSSRTS_LBBYNG_FILG_ORG_TOT "Grassroots lobbying -- Filing organization (Sch C - PART II-A, Line 1a(a))"
DRCT_LBBYNG_FILG_ORG_TOT "Direct lobbying -- Filing organization (Sch C - PART II-A, Line 1b(a))"
TOT_LBBY_EXPEND_FILG_ORG_TOT "Total lobbying -- Filing organization (Sch C - PART II-A, Line 1c(a))"
OTH_EXMPT_PRPS_FILG_ORG_TOT "Other exempt expenditures -- Filing organization (Sch C - PART II-A, Line 1d(a))"
TOT_EXMPT_PRPS_FILG_ORG_TOT "Total exempt purpose -- Filing organization (Sch C - PART II-A, Line 1e(a))"
LBBY_NTX_AMT_FILG_ORG_TOT "Lobbying nontaxable amount -- Filing organization (Sch C - PART II-A, Line 1f(a))"
GRSSRTS_NTX_AMT_FILG_ORG_TOT "Grassroots nontaxable amount -- Filing org (Sch C - PART II-A, Line 1g(a))"
LBBY_GR_MNS_NTX_FILG_ORG_TOT "Grassroots subtotal -- Filing organization (Sch C - PART II-A, Line 1h(a))"
EX_MNS_LBBY_NTX_FILG_ORG_TOT "Lobbying subtotal -- Filing organization (Sch C - PART II-A, Line 1i(a))"
GRSSRTS_LBBYNG_AFFLTD_GRP_TOT "Grassroots lobbying -- Affiliated group (Sch C - PART II-A, Line 1a(b))"
DRCT_LBBYNG_AFFLTD_GRP_TOT "Direct lobbying -- Affiliated group (Sch C - PART II-A, Line 1b(b))"
TOT_LBBY_EXPEND_AFFLTD_GRP_TOT "Total lobbying -- Affiliated group (Sch C - PART II-A, Line 1c(b))"
OTH_EXMPT_PRPS_AFFLTD_GRP_TOT "Other exempt expenditures -- Affiliated group (Sch C - PART II-A, Line 1d(b))"
TOT_EXMPT_PRPS_AFFLTD_GRP_TOT "Total exempt purpose -- Affiliated group (Sch C - PART II-A, Line 1e(b))"
LBBY_NTX_AMT_AFFLTD_GRP_TOT "Lobbying nontaxable amount -- Affiliated group (Sch C - PART II-A, Line 1f(b))"
GRSSRTS_NTX_AMT_AFFLTD_GRP_TOT "Grassroots nontaxable amount -- Affiliated group (Sch C - PART II-A, Line 1g(b))"
LBBY_GR_MNS_NTX_AFFLTD_GRP_TOT "Grassroots subtotal -- Affiliated group (Sch C - PART II-A, Line 1h(b))"
EX_MNS_LBBY_NTX_AFFLTD_GRP_TOT "Lobbying subtotal -- Affiliated group (Sch C - PART II-A, Line 1i(b))"
FRM_4720_FILED "Did the organization file Form 4720 (4911 tax) for this year? (Sch C - PART II-A, Line i)"
C_VLNTRS "Volunteers? (Sch C - PART II-B, Line 1a(a))"
PD_STAFF_OR_MGMT "Paid staff or management? (Sch C - PART II-B, Line 1b(a))"
MEDIA_ADS_AMT "Media advertisements amount (Sch C - PART II-B, Line 1c(b))"
MAILING_MEMS_AMT "Media to members amount (Sch C - PART II-B, Line 1d(b))"
PUB_OR_BROADCST_AMT "Publications, or published or broadcast statements (Sch C - PART II-B, Line 1e(b))"
GRNTS_OTH_ORGS_AMT "Grants to other organizations for lobbying (Sch C - PART II-B, Line 1f(b))"
DRCT_CNTCT_LEGIS_AMT "Direct contact with legislators, etc (Sch C - PART II-B, Line 1g(b))"
RALLIES_DEMOS_AMT "Rallies, demonstrations, seminars, conventions, etc (Sch C - PART II-B, Line 1h(b))"
C_OTH_ACTVS_AMT "Other lobbying activities (Sch C - PART II-B, Line 1i(b))"
TOT_LBBY_EXPEND_II_B "Total lobbying expenditures (Sch C - PART II-B, Line 1j(b))"
NOT_DESCRBD_IN_501C3 "Activities not described in 501(c)(3) (Sch C - PART II-B, Line 2a(a))"
AMT_OF_4912_TX "Amount of 4912 tax (Sch C - PART II-B, Line 2b(b))"
AMT_OF_MGRS_4912_TX "Amount of 4912 tax by managers (Sch C - PART II-B, Line 2c(b))"
FRM_4720_FILED_4912_TX "File Form 4720 for section 4912 tax? (Sch C - PART II-B, Line 2d(a))"
SUBST_ALL_DUES_NONDED "Were dues received nondeductible by members? (Sch C - PART III-A, Line 1)"
ONLY_IN_HSE_LBBYNG "Make only in-house lobbying expenditures of $2,000 or less? (Sch C - PART III-A, Line 2)"
AGREE_TO_CYOV_PY "Carryover lobbying/political expenditures from prior year? (Sch C - PART III-A, Line 3)"
C_DUES_ASSMNTS "Dues, assessments and similar amounts from members (Sch C - PART III-B, Line 1)"
NONDED_LBBY_PLTCL_CURR "Current year 162(e) expenditures (Sch C - PART III-B, Line 2a)"
NONDED_LBBY_PLTCL_CYOV "Carryover of 162(e) expenditures from last year (Sch C - PART III-B, Line 2b)"
NONDED_LBBY_PLTCL_TOT "Total 162(e) expenditures (Sch C - PART III-B, Line 2c)"
AGGR_AMT_RPTD_DUES_NTC "Amount of nondeductible section 162(e) dues (Sch C - PART III-B, Line 3)"
AMT_TO_BE_CYOV "Amount of carryover of nonddctbl lobbying/political expenditure (Sch C - PART III-B, Line 4)"
C_TXBL_AMT "Taxable lobbying/political expenditures (Sch C - PART III-B, Line 5)"
G_FNDRSNG_ACTVS "Fundraising activities - Indicate whether the organization raised funds through any of the following activities. Check all that apply. Because an organization may use multiple fundraising methods, this field may be a single digit or some combination of digits (e.g. '12' = Mail and email solicitations). (Sch G - PART I, Line 1):
1 - Mail solicitations
2 - Email solicitations
3 - Phone solicitations
4 - In-person solicitations
5 - Solicitations of non-government grants
6 - Solicitations of government grants
7 - Special fundraising events"
AGR_REF_FNDRSNG "Agreement with any individual/entity for fundraising activities? (Sch G - PART I, Line 2a)"
ROWS_HGHST_PD_FNDRSRS "Number of highly-paid fundraisers reported (Sch G - PART I, Line 2b)"
EVNTS_INFO_GRO_RCPT_TOT "Fundraising Events - Gross receipts, total - Schedule G (Sch G - PART II, Line 1(d))"
EVNTS_INFO_CHRTBL_CONTRI_TOT "Fundraising Events - LESS: Charitable contributions, total - Schedule G (Sch G - PART II, Line 2(d))"
EVNTS_INFO_GRO_REV_TOT "Fundraising Events - Gross revenue, total (Sch G - PART II, Line 3(d))"
EVNTS_INFO_CSH_PRZ_TOT "Fundraising Events - Cash prizes, total (Sch G - PART II, Line 4(d))"
EVNTS_INFO_NCSH_PRZ_TOT "Fundraising Events - Non-cash prizes, total (Sch G - PART II, Line 5(d))"
EVNTS_INFO_RNT_FCLTY_CST_TOT "Fundraising Events - Rent or facility costs, total (Sch G - PART II, Line 6(d))"
EVNTS_INFO_EVNT_FD_BEV_TOT "Fundraising Events - Food and beverage expenses (Sch G - PART II, Line 7(d))"
EVNTS_INFO_ENT_ENTRTN_TOT "Fundraising Events - Entertainment expenses (Sch G - PART II, Line 8(d))"
EVNTS_INFO_OTH_DRCT_EXP_TOT "Fundraising Events - Other direct expenses, total (Sch G - PART II, Line 9(d))"
EVNTS_INFO_DRCT_EXP_SUM "Fundraising Events - Direct expense summary (Sch G - PART II, Line 10(d))"
EVNTS_INFO_NET_INCM_SUM "Fundraising Events - Net income summary (Sch G - PART II, Line 11(d))"
GAM_INFO_GRO_REV_TOT "Gaming - Gross revenue, total (Sch G - PART III, Line 1(d))"
GAM_INFO_CSH_PRZ_TOT "Gaming - Cash prizes, total (Sch G - PART III, Line 2(d))"
GAM_INFO_NCSH_PRZ_TOT "Gaming - Non-cash prizes, total (Sch G - PART III, Line 3(d))"
GAM_INFO_RNT_FCLT_CST_TOT "Gaming - Rent or facility costs, total (Sch G - PART III, Line 4(d))"
GAM_INFO_OTH_DRCT_EXP_TOT "Gaming - Other direct expenses, total (Sch G - PART III, Line 5(d))"
GAM_INFO_DRCT_EXP_SUM "Gaming - Direct expense summary (Sch G - PART III, Line 7(d))"
GAM_INFO_NET_GAM_INCM_SUM "Gaming - Net gaming income summary (Sch G - PART III, Line 8(d))"
ROWS_LQDTN_TRMNTN_DSLTN "Number of rows reported --liquidation, etc. (Sch N - PART I, Line 1)"
DIR_OF_SUCSR "Become a director of successor/transferee organization? (Sch N - PART I, Line 2a)"
EMPL_OF_SUCSR "Become an employee of successor/transferee organization? (Sch N - PART I, Line 2b)"
OWNR_OF_SUCSR "Become an owner of successor/transferee organization? (Sch N - PART I, Line 2c)"
RCV_COMP "Receive compensation as a result of the organization liquidation? (Sch N - PART I, Line 2d)"
ASSTS_DISTRI "Distribute its assets in accordance with its governing instruments? (Sch N - PART I, Line 3)"
RQRD_TO_NTFY_AG "Required to notify the attorney general of its intent to dissolve? (Sch N - PART I, Line 5a)"
AG_NOTIF "Notify the attorney general of its intent to dissolve? (Sch N - PART I, Line 5b)"
LIAB_PD "Discharge or pay all liabilities in accordance with state laws? (Sch N - PART I, Line 6)"
BNDS_OUTSTD "Have any tax-exempt bonds outstanding? (Sch N - PART I, Line 7a)"
BND_LIAB_DISCHRGD "Did the organization discharge tax-exempt bond liabilities? (Sch N - PART I, Line 7b)"
ROWS_SALE_XCHG_DSPSTN "Number of rows reported -- sale, exchange, etc. (Sch N - PART II, Line 1)"
DIR_SUCSR2 "Become a director of successor/ transferee organization? (Sch N - PART II, Line 2a)"
EMPL_OF_SUCSR2 "Become an employee of transferee organization? (Sch N - PART II, Line 2b)"
OWNR_OF_SUCSR2 "Become owner of a successor/transferee organization? (Sch N - PART II, Line 2c)"
RCV_COMP2 "Receivecompensation as a result of a disposition of assets? (Sch N - PART II, Line 2d)"
DLN "Document Locator Number used by the IRS"
SAMP_CD "Sample code"
WEIGHT "Weight"
SAM_CNT "Sample count"
POP_CNT "Population count"
COMP_CNT "Number of rows in compensation sub-table"
SUPORG_CNT "Number of rows in supported org sub-table"
SCPL "Service Center Cycle Page Line (unique identifier assigned by the IRS - used to match primary SOI record with related sub-table records)"
COND "Condition Code"
randnum "Random number between 0 and 1 used for creating samples"
.

.
VALUE LABELS AGREE_TO_CYOV_PY
"N" "No"
"Y" "Yes"
.
VALUE LABELS AGR_REF_FNDRSNG
"N" "No"
"Y" "Yes"
.
VALUE LABELS AG_NOTIF
"Y" "Yes"
"N" "No"
.
VALUE LABELS ASSTS_DISTRI
"Y" "Yes"
"N" "No"
.
VALUE LABELS BNDS_OUTSTD
"Y" "Yes"
"N" "No"
.
VALUE LABELS BND_LIAB_DISCHRGD
"Y" "Yes"
"N" "No"
.
VALUE LABELS CERT_CHKBX
"Y" "Yes"
"N" "No"
.
VALUE LABELS COND
"A" "Amended return"
"F" "Final return"
"G" "Group return"
"S" "Separate return "
.
VALUE LABELS CONTRI_BY_35_CNTRL_ENT
"Y" "Yes"
"N" "No"
.
VALUE LABELS CONTRI_BY_CNTRL_INDIV
"Y" "Yes"
"N" "No"
.
VALUE LABELS CONTRI_BY_RLTD_PRTY
"Y" "Yes"
"N" "No"
.
VALUE LABELS CORR_MADE
"N" "No"
"Y" "Yes"
.
VALUE LABELS C_VLNTRS
"N" "No"
"Y" "Yes"
.
VALUE LABELS DIR_OF_SUCSR
"N" "No"
"Y" "Yes"
.
VALUE LABELS DIR_SUCSR2
"N" "No"
"Y" "Yes"
.
VALUE LABELS EMPL_OF_SUCSR
"N" "No"
"Y" "Yes"
.
VALUE LABELS EMPL_OF_SUCSR2
"N" "No"
"Y" "Yes"
.
VALUE LABELS FRM_1120_POL_FILED
"N" "No"
"Y" "Yes"
.
VALUE LABELS FRM_4720_FILED
"N" "No"
"Y" "Yes"
.
VALUE LABELS FRM_4720_FILED_4912_TX
"Y" "Yes"
"N" "No"
.
VALUE LABELS FRM_4720_FILED_4955_TX
"Y" "Yes"
"N" "No"
.
VALUE LABELS LEVEL1
"U" "Unknown"
"PF" "Private Foundation"
"PC" "Public Charity"
"O" "Other Nonprofits"
.
VALUE LABELS LEVEL2
"M" "Mutual Benefit Public Charity"
"S" "Supporting Public Charity"
"O" "Operating Public Charity"
.
VALUE LABELS level3
"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"
"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"
.
VALUE LABELS level4
"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"
"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"
"" "Unknown"
"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"
.
VALUE LABELS LIAB_PD
"Y" "Yes"
"N" "No"
.
VALUE LABELS LTD_CNTRL_PRVSNS_APPLY
"Y" "Yes"
"N" "No"
.
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 NON_PF_STATUS_CD
"05" "Line 05, Operated FBO public college or university"
"06" "Line 06, Government or governmental unit"
"07" "Line 07, Organization with substantial public or governmental support"
"08" "Line 08, Community trust"
"09" "Line 09, Organization income is > 1/3 charitable, and <= 1/3 investment/unrelated business"
"10" "Line 10, Organized and operated to test for public safety"
"11" "Line 11, Supporting organization"
"00" "No box checked"
"88" "blank or unable to be determined"
"99" "blank or unable to be determined"
"01" "Line 01, Church, or convention/association of churches"
"02" "Line 02, School"
"03" "Line 03, Hospital or cooperative hospital service org."
"04" "Line 04, Medical research organization"
.
VALUE LABELS NOT_DESCRBD_IN_501C3
"Y" "Yes"
"N" "No"
.
VALUE LABELS NTEE1
"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"
"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"
"" "Unknown"
"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"
.
VALUE LABELS NTEESRC
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"CORE02" "Core 2002 codes (04/02/04)"
"DS" "David Stevenson's rulings (confidence=A)"
"JCC" "Jill Capitani's clean up of the nteelu file"
"bahrz1" "NCCS - No information found in web search"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"ALM" "Almanac 2000 edits (confidence=A)"
"FC" "Foundation Center reclassification"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"$src" "Dig.data auto-coded 3/2005"
"ZD" "David Stevenson's reclass. of unclassified"
"MD" "Classifcation of Maryland State Attorney General's file"
"$src" "Auto-generated codes (confidence=C)"
"ZT" "Temp's review of unclassified, Feb. 97"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"DD200511" "Digitized data auto-codes"
"T3" "Temps review and corrections to initial review of RTF95 file(T2)."
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"" "Unknown source (confidence= ?)"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"KCS" "Classification done for Kansas City newspaper layout"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"T" "Temps review in Fall 1996 (confidence=B)"
"SM" "Classification done by ShoShauna Mccoy"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"IV" "Independent verifiers (1996) (confidence=A)"
"SOI" "Classification completed during reconciliation of SOI94"
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"3YR" "Classification review completed during the data development of the three-year financial project"
"RTF" "Classification of I.R.S. Return Transaction Files"
"ZZ" "NCCS expert verified records"
"Core2004co" "2006 NTEE rules"
"SMP" "Classification review from sampling (confidence=B)"
"auto" "Automatically coded by NCCS (confidence=C)"
"DD200304-C" "Dig.data auto-coded 4/2003"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"DD200304-B" "Dig.data verified 4/2003"
.
VALUE LABELS ntmaj10
"HU" "Human services"
"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"
.
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
"HU" "Human services"
"OT" "Other"
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
.
VALUE LABELS ONLY_IN_HSE_LBBYNG
"Y" "Yes"
"N" "No"
.
VALUE LABELS ORG_BELONGS_AFFLTD_GRP
"Y" "Yes"
"N" "No"
.
VALUE LABELS OUTREAS
"4" "4- Not a 501(c)(3)"
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"G" "G- Government Entity"
"F" "F- Foreign organization"
"T" "T- U.S. Territory or armed forces overseas"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
"" "No value"
.
VALUE LABELS OWNR_OF_SUCSR
"Y" "Yes"
"N" "No"
.
VALUE LABELS OWNR_OF_SUCSR2
"N" "No"
"Y" "Yes"
.
VALUE LABELS PD_STAFF_OR_MGMT
"N" "No"
"Y" "Yes"
.
VALUE LABELS Q020
"N" "No"
"Y" "Yes"
.
VALUE LABELS Q030
"N" "No"
"Y" "Yes"
.
VALUE LABELS Q060
"N" "No"
"Y" "Yes"
.
VALUE LABELS Q200
"N" "No"
"Y" "Yes"
.
VALUE LABELS Q222
"N" "No"
"Y" "Yes"
.
VALUE LABELS Q300
"N" "No"
"Y" "Yes"
.
VALUE LABELS Q310
"Y" "Yes"
"N" "No"
.
VALUE LABELS RCV_COMP
"Y" "Yes"
"N" "No"
.
VALUE LABELS RCV_COMP2
"Y" "Yes"
"N" "No"
.
VALUE LABELS RQRD_TO_NTFY_AG
"Y" "Yes"
"N" "No"
.
VALUE LABELS SAMP_CD
"33" "501(c)(3) Public Charity: Assets $1,000,000 under $2,500,000"
"13" "501(c)(3) Private Foundation: Assets $400,000 under $1,000,000"
"34" "501(c)(3) Public Charity: Assets $2,500,000 under $5,000,000"
"14" "501(c)(3) Private Foundation: Assets $1,000,000 under $2,500,000"
"35" "501(c)(3) Public Charity: Assets $5,000,000 under $20,000,000"
"15" "501(c)(3) Private Foundation: Assets $2,500,000 under $10,000,000"
"36" "501(c)(3) Public Charity: Assets $20,000,000 under $50,000,000"
"16" "501(c)(3) Private Foundation: Assets $10,000,000 under $25,000,000"
"37" "501(c)(3) Public Charity: Assets $50,000,000 or more"
"17" "501(c)(3) Private Foundation: Assets $25,000,000 or more"
"41" "501(c)(4)-(9): Assets under $150,000"
"42" "501(c)(4)-(9): Assets $150,000 under $300,000"
"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"
"38" "501(c)(3) All E-Filed 990 hospital returns (SOI 2009 and later)"
"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"
"31" "501(c)(3) Public Charity: Assets under $500,000"
"11" "501(c)(3) Private Foundation: Assets under $125,000"
"32" "501(c)(3) Public Charity: Assets $500,000 under $1,000,000"
"12" "501(c)(3) Private Foundation: Assets $125,000 under $400,000"
.
VALUE LABELS SUBSECCD
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"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)"
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"70" "70- Child Care Organization - 501(k)"
"22" "22- Multiemployer Pension Plan"
"11" "11- Teachers retirement fund associations."
"71" "71- Charitable Risk Pool"
"23" "23- Veterans association formed prior to 1880"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"81" "81- Qualified State-Sponsored Tuition Program"
"24" "24-Trust described in Section 4049 of ERISA"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"25" "25- Title Holding Company for Pensions, etc"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"90" "90- 4947(a)(2) Split Interest Trust"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"80" "80- Farmers' Cooperatives"
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"92" "92- 4947(a)(1) Private Foundations"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"82" "82- 527 Political Organizations"
"19" "19- Post or organization of war veterans."
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"02" "02- Title holding corporation for a tax-exempt organization."
.
VALUE LABELS SUBST_ALL_DUES_NONDED
"Y" "Yes"
"N" "No"
.
VALUE LABELS TYPE_SUPRTNG_ORG
"1" "Type I"
"2" "Type II"
"3" "Type III Functionally Integrated"
"0" "No Box Checked"
"4" "Type III Other"
.
VALUE LABELS WRTTN_IRS_DETERM
"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
scpl a12
EIN a9
E010 a4
COND a1
NAME a60
STATE a2
ZIP5 a5
GRP_EXMPT_NUM a4
SUBSECCD a2
FisYr a4
R040 f15.0
R050 f15.0
R060 f15.0
RZ100 f15.0
RZ200 f15.0
RZ300 f15.0
R190 f15.0
R199 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
XZ100 f15.0
F020 f15.0
XZ200 f15.0
XZ300 f15.0
XZ400 f15.0
XZ500 f15.0
XZ600 f15.0
X050 f15.0
N010 f15.0
N020 f15.0
N030 f15.0
N040 f15.0
AZ101 f15.0
A023 f15.0
AZ201 f15.0
A030 f15.0
L010 f15.0
B010 f15.0
AZ100 f15.0
A160 f15.0
AZ200 f15.0
A180 f15.0
L090 f15.0
B020 f15.0
C020_SUM f15.0
C030_SUM f15.0
C040_SUM 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
Q222 a1
Q300 a1
Q310 a1
H100 f15.0
H110 f15.0
H120 f15.0
H200 f15.0
H210 f15.0
H220 f15.0
H300 f15.0
H310 f15.0
H320 f15.0
H400 f15.0
H410 f15.0
H420 f15.0
H500 f15.0
H510 f15.0
H520 f15.0
H600 f15.0
NON_PF_STATUS_CD a2
TYPE_SUPRTNG_ORG a1
CERT_CHKBX a1
WRTTN_IRS_DETERM a1
CONTRI_BY_CNTRL_INDIV a1
CONTRI_BY_RLTD_PRTY a1
CONTRI_BY_35_CNTRL_ENT a1
SUM_OF_SUPRTD_AMTS f15.0
PLTCL_EXPEND f15.0
VLNTR_HRS f15.0
AMT_4955_TX f15.0
AMT_4955_TX_ON_MGRS f15.0
FRM_4720_FILED_4955_TX a1
CORR_MADE a1
AMT_EXPEND_FOR_527_ACTVS f15.0
AMT_INTRNL_FNDS_CONTRI f15.0
TOT_EXMPT_FUNC_EXPEND f15.0
FRM_1120_POL_FILED a1
ORG_BELONGS_AFFLTD_GRP a1
LTD_CNTRL_PRVSNS_APPLY a1
GRSSRTS_LBBYNG_FILG_ORG_TOT f15.0
DRCT_LBBYNG_FILG_ORG_TOT f15.0
TOT_LBBY_EXPEND_FILG_ORG_TOT f15.0
OTH_EXMPT_PRPS_FILG_ORG_TOT f15.0
TOT_EXMPT_PRPS_FILG_ORG_TOT f15.0
LBBY_NTX_AMT_FILG_ORG_TOT f15.0
GRSSRTS_NTX_AMT_FILG_ORG_TOT f15.0
LBBY_GR_MNS_NTX_FILG_ORG_TOT f15.0
EX_MNS_LBBY_NTX_FILG_ORG_TOT f15.0
GRSSRTS_LBBYNG_AFFLTD_GRP_TOT f15.0
DRCT_LBBYNG_AFFLTD_GRP_TOT f15.0
TOT_LBBY_EXPEND_AFFLTD_GRP_TOT f15.0
OTH_EXMPT_PRPS_AFFLTD_GRP_TOT f15.0
TOT_EXMPT_PRPS_AFFLTD_GRP_TOT f15.0
LBBY_NTX_AMT_AFFLTD_GRP_TOT f15.0
GRSSRTS_NTX_AMT_AFFLTD_GRP_TOT f15.0
LBBY_GR_MNS_NTX_AFFLTD_GRP_TOT f15.0
EX_MNS_LBBY_NTX_AFFLTD_GRP_TOT f15.0
FRM_4720_FILED a1
C_VLNTRS a1
PD_STAFF_OR_MGMT a1
MEDIA_ADS_AMT f15.0
MAILING_MEMS_AMT f15.0
PUB_OR_BROADCST_AMT f15.0
GRNTS_OTH_ORGS_AMT f15.0
DRCT_CNTCT_LEGIS_AMT f15.0
RALLIES_DEMOS_AMT f15.0
C_OTH_ACTVS_AMT f15.0
TOT_LBBY_EXPEND_II_B f15.0
NOT_DESCRBD_IN_501C3 a1
AMT_OF_4912_TX f15.0
AMT_OF_MGRS_4912_TX f15.0
FRM_4720_FILED_4912_TX a1
SUBST_ALL_DUES_NONDED a1
ONLY_IN_HSE_LBBYNG a1
AGREE_TO_CYOV_PY a1
C_DUES_ASSMNTS f15.0
NONDED_LBBY_PLTCL_CURR f15.0
NONDED_LBBY_PLTCL_CYOV f15.0
NONDED_LBBY_PLTCL_TOT f15.0
AGGR_AMT_RPTD_DUES_NTC f15.0
AMT_TO_BE_CYOV f15.0
C_TXBL_AMT f15.0
G_FNDRSNG_ACTVS a7
AGR_REF_FNDRSNG a1
ROWS_HGHST_PD_FNDRSRS f15.0
EVNTS_INFO_GRO_RCPT_TOT f15.0
EVNTS_INFO_CHRTBL_CONTRI_TOT f15.0
EVNTS_INFO_GRO_REV_TOT f15.0
EVNTS_INFO_CSH_PRZ_TOT f15.0
EVNTS_INFO_NCSH_PRZ_TOT f15.0
EVNTS_INFO_RNT_FCLTY_CST_TOT f15.0
EVNTS_INFO_EVNT_FD_BEV_TOT f15.0
EVNTS_INFO_ENT_ENTRTN_TOT f15.0
EVNTS_INFO_OTH_DRCT_EXP_TOT f15.0
EVNTS_INFO_DRCT_EXP_SUM f15.0
EVNTS_INFO_NET_INCM_SUM f15.0
GAM_INFO_GRO_REV_TOT f15.0
GAM_INFO_CSH_PRZ_TOT f15.0
GAM_INFO_NCSH_PRZ_TOT f15.0
GAM_INFO_RNT_FCLT_CST_TOT f15.0
GAM_INFO_OTH_DRCT_EXP_TOT f15.0
GAM_INFO_DRCT_EXP_SUM f15.0
GAM_INFO_NET_GAM_INCM_SUM f15.0
ROWS_LQDTN_TRMNTN_DSLTN f15.0
DIR_OF_SUCSR a1
EMPL_OF_SUCSR a1
OWNR_OF_SUCSR a1
RCV_COMP a1
ASSTS_DISTRI a1
RQRD_TO_NTFY_AG a1
AG_NOTIF a1
LIAB_PD a1
BNDS_OUTSTD a1
BND_LIAB_DISCHRGD a1
ROWS_SALE_XCHG_DSPSTN f15.0
DIR_SUCSR2 a1
EMPL_OF_SUCSR2 a1
OWNR_OF_SUCSR2 a1
RCV_COMP2 a1
DLN a14
NTEESOI a4
SAMP_CD a2
weight f15.0
SAM_CNT f15.0
POP_CNT f15.0
SUPORG_CNT f15.0
COMP_CNT f15.0
NTEECC a4
NTEE1 a1
LEVEL1 a2
LEVEL2 a2
LEVEL3 a2
LEVEL4 a2
MAJGRPB a2
OUTNCCS a3
OUTREAS a1
NTEESRC a1
ntmaj10 a2
ntmaj12 a2
ntmaj5 a2
RandNum f15.0
nteeConf a1
FIPS a5
MSA_NECH a4
NAICS a11
NteeFinal a5
NteeFinal1 a1
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.