* Core 1999 Public Charities Sample.

VARIABLE LABELS
EIN "Employer identification number."
FisYr "Fiscal year (ending year)"
NAME "Organization name."
STATE "Two-letter state abbreviation."
NTEE1 "NTEE major group (A-Z)"
NTEECC "NTEECC classification"
ADDRESS "Address"
CITY "City"
ZIP "ZIP code."
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"
StYear "Starting year (yyyy when fiscal year began, which is also the tax form year)"
TAXPER "Ending date for tax period of financial data. Core files for 1997 on are in "yyyymm" format (199412=Dec. 1994). Earlier years use 2-digit year ("9412")."
outnccs "Out-of-scope (IN/OUT) (see OUTREAS doc. for details)"
OUTREAS "Reason why out of scope"
SUBSECCD "IRS subsection code (03=501(c)(3), etc.)"
ntmaj5 "Major subsector (5)"
ntmaj10 "10 NTEE major groups"
MAJGRPB "Major NTEE group plus hospitals and higher education"
ACTIV1 "First activity code."
ACTIV2 "Second activity code."
ACTIV3 "Third activity code."
PROGREV "Program service revenue including government fees and contracts (line 2)"
RENTEXP "Rental expenses (Line 6b; subtract from gross rents (line 6a) to calculate rental income (line 6c))"
NETRENT "Net rental income (line 6c)"
INVINC "Total investment income (Sum of lines 4,5, and 7)"
SECUR "Gross amount from sale of assets other than inventory. (line 8a A)"
SALESEXP "Cost or other basis and sales expenses from sale of securities. (Line 8b A; subtract from line 8a A to find gain or loss from sale of securities (line 8a C)"
SALEOTHE "Cost or other basis and sales expenses from sale of assets other than inventory and securities. (Line 8b B; subtract from line 8a B to find gain or loss from sale of other assets, line 8a B)"
SALEOTHG "Gross sales from other (line 8a(b))"
SALEOTHN "Gain (or loss) from sales of assets - other than securities (line 8c(b))"
SALESECN "Net gain (or loss) from securities"
SPEVTG "Gross revenue from special events and activities (line 9a)"
DIREXP "Direct expense from special events and activities, not fundraising expenses. (line 9b)"
FUNDINC "Net income or loss from special events. (line 9c: gross revenue (line 9a) minus line 9b)"
GOODS "Cost of goods sold. (line 10b)"
GRPROF "Gross profit or loss from sales of inventory. (line 10c; gross sales of inventory less returns and allowances (line 10a) minus line 10b)"
OTHINC "Other income. (line 11: from Part VII, line 103))"
GRREC "Gross receipts (Sum of lines 6b, 8b A, 8b B (Cost or other basis and sales expenses from sale of assets other than inventory or securities),9b,10b, and 12)"
TOTREV2 "Total revenue. (Line 12)"
INVENTG "Gross sales of inventory (Sch A, line 10a)"
TOTREV "Total revenue, Line 12 (calculated as CONT + PROGREV + DUES + INVINC + NETRENT + SALESECN + SALEOTHN + FUNDINC + GRPROF + OTHINC)"
EXPS "Total expenses. (Line 17: Sum of lines 16 and 44 A)"
SOLICIT "Fundraising expenses. (line 15: from line 44 D)"
FUNDBAL "Net assets or fund balances at end of year. (line 21: sum of lines 18,19, and 20)"
NETINC "Excess (or deficit) for the year (Net income) (line 18)"
OTHCHGS "Other changes in net assets of fund balances (line 20)"
CONT "Total public support (Line 1d: sum of direct public support (1a), indirect public support (1b), and government contributions and grants (1c))"
DUES "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.)"
COMPENS "Total compensation of officers,directors, etc. (Line 25 A)"
OTHSAL "Other salaries and wages (line 26)"
PAYTAX "Payroll taxes (line 29)"
FUNDFEES "Total professional fundraising fees. (line 30 A)"
ASS_BOY "Total assets, beginning of year. (line 59 A: sum of lines 45 A through 58 A)"
ASS_EOY "Total assets, end of year. (line 59 B: sum of lines 45 B through 58 B)"
BOND_BOY "Tax-exempt bond liabilities, beginning of year (line 64a(a))"
BOND_EOY "Tax-exempt bond liabilities, end of year (line 64a(a))"
MRTG_BOY "Mortgages and other notes payable, beginning of year (line 64a(a))"
MRTG_EOY "Mortgages and other notes payable, end of year (line 64a(a))"
LIAB_BOY "Liabilities, beginning of year. (line 66 A: sum of lines 60 A through 65 A)"
LIAB_EOY "Liabilities, end of year. (line 66 B: sum of lines 60 B through 65 B)"
RETE_BOY "Retained earnings, endowment, accumulated income, or other funds, beginning of year. (line 72 B)"
RETEARN "Retained earnings, endowment, accumulated income, or other funds, end of year. (line 72 B)"
NETA_BOY "Total net assets of fund balances (line 73)"
SAVINT "Interest on savings and temporary cash investment (line 95(d))"
SECINC "Dividends and interest from securities (line 96(d))"
RENTINC "Rental income from financed property (line 97b(d))"
OTHINVST "Other investment income (line 99d)"
CONT4 "Gifts, grants, and contributions received (total of last 4 years) (Sch A, line 15(e))"
DUES4 "Membership fees received (total of last 4 years) (Sch A, line 16(e))"
GRREC4 "Gross receipts from admissions, merchandise sold, or services performed (total of last 4 years) (Sch A, line 17(e))"
INVINC4 "Gross income from interest and dividends (total of last 4 years) (Sch A, line 18(e))"
TAXREV4 "Tax rev. levied for the organization benefit and either paid to it or expended on its behalf (total of last 4 years) (Sch A, line 20(e))"
GVTSRV4 "Value of services or facilities furnished to the organization by a governmental unit without charge (total of last 4 years) (Sch A, line 21(e))"
OTHINC4 "Other income (total of last 4 years) (Sch A, line 22(e))"
INCPURP4 "Income derived from activities related to org exempt purpose (total of last 4 years) (Sch A, line 24(e))"
LEGEXP "Total expenses paid or incurred in connection with lobbying activities to influence national, state, or local legislation, including any attempt to influence public opinion on a legislative matter or referendum. (Sch.A,Pt.III, line 1)"
GRROOT "Grass roots lobbying expenditures to influence public opinion. (line 36b)"
INFLEXP "Total lobbying expenditures to directly influence a legislative body. (line 37b)"
EXGRROOT "Excess grass roots expenditures. (line 43b: line 36b minus grassroots nontaxable amount(line 42b))"
EXLOBEXP "Excess lobbying expenditures. (line 44b: total lobbying expenditures (line 38b: sum of lines 36b and 37b) minus lobbying nontaxable amount (line 41b))"
LOBNOTAX "Lobbying nontaxable amount (Sch A, line 41(b))"
LOBOTH "Other exempt purchase lobbying expenses (Sch A, line 39(b))"
TOTLOB "Total lobbying expenditures, Sch.A, 38b"
GRTNONTX "Grass roots non-taxable amount (Sch A, line 42(b))"
RULEDATE "Ruling date: year and month of IRS ruling or determination letter recognizing orgs exempt status (YYYYMM)"
FNDNCD "Reason for & type of 501(c)(3) exempt status including codes for operating and grantmaking foundations, and broad type of public charity"
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."
REASON "Reason why org. not private foundation (Sched. A, Pt.IV)"
AFCD "Affiliation code"
ARED "Advance Ruling Expiration Date"
CONTACT "Contact person (from IRS files)"
SEC_NAME "Secondary organization name"
GEN "Group Exemption Number"
DISTRICT "IRS District Office"
LEVEL1 "Public charity or private foundation?"
LEVEL2 "Reporting public charity groups."
level3 "Major NTEE category"
level4 "NTEE-CC Major Group"
LEVEL5 "Level 5 Detailed NTEE classification (Almanac tables 5.6, 5.7)"
CLASSCD "IRS Classification code"
DEDUCTCD "IRS Deductibility code"
NTEECC4D "NTEE-CC code 4th & 5th characters used for supporting organizations"
NTEE_CAT "NTEE_CAT"
ORGCD "Organization code: corporation, trust, association, etc."
NCCSKEY2 "Unique key: ein + fiscal year"
VERIFY "Financials have been verified"
V_BoyAL "Beginning of year assets and liabilities verified"
V_CONT "Contributions < expenses?"
V_EoyAL "End-of-year assets and liabilities verified?"
v_errorCd "Code for possible error"
V_FB "Fund Balance verified?"
V_FREXP "Fundraising expense verification code"
V_GREC "Gross receipts verification code"
v_revExp "Total revenue and expenses verified in relation to net income"
ACCPER "Accounting period"
RandNum "Random number between 0 and 1 used for creating samples"
NteeDraft "Draft NTEE-CC code"
.

.
VALUE LABELS AFCD
"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"
"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"
.
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 FNDNCD
"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"
"21" "Supporting Organization 509(a)(3) Type I"
"00" "All organizations except 501(c)(3)"
"22" "Supporting Organization 509(a)(3) Type II"
"23" "Supporting Organization 509(a)(3) Type III functionally integrated"
"18" "Organization organized and operated to test for public safety"
"24" "Supporting Organization 509(a)(3) Type III not functionally integrated"
"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"
.
VALUE LABELS FRCD
"06" "Not required to file - Church"
"02" "Required to file 990N (gross receipts less than $25,000)"
"01" "Required to file 990 (all other) or 990EZ"
"07" "Required to file 990 - Government 501 ( c) (1)"
"03" "Required to file 990 - Group Return"
"04" "Required to file 990BL - Black Lung Trust"
"00" "Not required to file (all other)"
"14" "Not required to file - State Instrumentality or Political Subdivision"
"13" "Not required to file - Religious Organization"
.
VALUE LABELS LEVEL1
"O" "Other Nonprofits"
"U" "Unknown"
"PF" "Private Foundation"
"PC" "Public Charity"
.
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
"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"
"" "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"
"H" "Medical Research"
"P" "Human Services - Multipurpose and Other"
"X" "Religion Related, Spiritual Development"
.
VALUE LABELS LEVEL5
"E2" "Outpatient treatment facilities"
"Hb" "Services promoting independence"
"" "Unknown, unclassified"
"E3" "Nursing services"
"Hc" "Other human services"
"E4" "Mental health"
"Q" "International and foreign affairs"
"E5" "Disease specific"
"R" "Civil rights and advocacy"
"E6" "Medical research"
"S" "Community improvement"
"A2" "Museums and museum activities"
"E7" "Other, health services/treatment"
"T" "Philanthropy and voluntarism"
"A3" "Historical societies and related"
"H1" "Crime, legal related"
"U" "Science and technology"
"A4" "Performing arts organizations"
"H2" "Employment, job related"
"V" "Social science"
"A5" "Other, arts"
"H3" "Food, agriculture, & nutrition"
"W" "Other public & societal benefit"
"B1" "Elementary, secondary education"
"H4" "Housing and shelter"
"X" "Religion related"
"B2" "Higher education"
"H5" "Public safety, disaster prep."
"Z" "Unknown, unclassified"
"B3" "Student services & organizations"
"H6" "Recreation and sports"
"Z2" "Single organization support"
"B4" "Other education"
"H7" "Youth development"
"Z3" "Fundraising within NTEE category"
"C1" "Environment"
"H8" "Children and youth services"
"Z4" "Community and other public foundations"
"C2" "Animal related"
"H9" "Family services"
"Z5" "Trusts and other foundations"
"E1" "Hospitals & primary facilities"
"Ha" "Residential, custodial care"
"Z6" "General fundraising"
.
VALUE LABELS MAJGRPB
"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"
"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"
.
VALUE LABELS NTEE1
"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"
"" "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"
.
VALUE LABELS NTEESRC
"SMP" "Classification review from sampling (confidence=B)"
"DIT" "Digitized Data - Tom's Foxpro classification program (confidence=C)"
"NCCS200211-B" "NCCS verified records (medium confidence)"
"NCCS200211-C" "NCCS autocoded records (low confidence)"
"NSO" "Nick Stengel's clean up of the opera file (confidence=A)"
"CORE02" "Core 2002 codes (04/02/04)"
"ZZ" "NCCS expert verified records"
"JCC" "Jill Capitani's clean up of the nteelu file"
"ZA" "Review of organizations classified as Z in preparation for the 1997 ARNOVA conference (confidence=B)"
"auto" "Automatically coded by NCCS (confidence=C)"
"DD200304-C" "Dig.data auto-coded 4/2003"
"bahrz1" "NCCS - No information found in web search"
"RT" "Review of samples of organizations in construction of NTEE rating system (confidence=A)"
"DD200304-B" "Dig.data verified 4/2003"
"FC" "Foundation Center reclassification"
"DS" "David Stevenson's rulings (confidence=A)"
"ZD" "David Stevenson's reclass. of unclassified"
"FLR" "1992 classification of organizations using parts 3 and 8, stored in Filer92 (confidence=B)"
"ALM" "Almanac 2000 edits (confidence=A)"
"ZT" "Temp's review of unclassified, Feb. 97"
"IS" "Bank of classifications that were completed at Independent Sector (confidence=B)"
"T3" "Temps review and corrections to initial review of RTF95 file(T2)."
"MD" "Classifcation of Maryland State Attorney General's file"
"N95" "Classifcation of RTF 1995 completed by Nick Stengel"
"BMF" "Classification by I.R.S. EP/EO Division (confidence=C)"
"T2" "Temps classification of the unclassified orgs in RTF95 file (confidence=B)"
"NSS" "Classifcation of SOI completed by Nick Stengel (confidence=A)"
"RTF" "Classification of I.R.S. Return Transaction Files"
"T" "Temps review in Fall 1996 (confidence=B)"
"KCS" "Classification done for Kansas City newspaper layout"
"$src" "Dig.data auto-coded 3/2005"
"IV" "Independent verifiers (1996) (confidence=A)"
"SM" "Classification done by ShoShauna Mccoy"
"$src" "Auto-generated codes (confidence=C)"
"SOI" "Classification completed during reconciliation of SOI94"
"" "Unknown source (confidence= ?)"
"DD200511" "Digitized data auto-codes"
"3YR" "Classification review completed during the data development of the three-year financial project"
"bahr1" "NCCS thorough verification (Matt Bahr 2002) (confidence=A)"
"Core2004co" "2006 NTEE rules"
.
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 ntmaj5
"AR" "Arts, culture, and humanities"
"ED" "Education"
"HE" "Health"
"HU" "Human services"
"OT" "Other"
.
VALUE LABELS ORGCD
"6" "Non-exempt charitable trust"
"0" "Unknown"
"5" "Association"
"4" "Partnership"
"3" "Co-operative"
"2" "Trust"
"1" "Corporation"
.
VALUE LABELS OUTREAS
"T" "T- U.S. Territory or armed forces overseas"
"S" "S- Missing geographic information"
"I" "I- Coded out of scope by Independent Sector"
"" "No value"
"G" "G- Government Entity"
"4" "4- Not a 501(c)(3)"
"F" "F- Foreign organization"
"N" "N- Coded out of scope by NCCS (e.g. foreign address on Form 990)"
.
VALUE LABELS REASON
"00" "Default value for those who fail to check a box or those that do not file Schedule A."
"01" "Church"
"02" "School"
"03" "Hospital"
"04" "Governmental Unit"
"05" "Medical Research"
"06" "Operated for benefit of college or university owned or operated by governmental unit."
"07" "Receives substantial part of support from government unit or general public"
"08" "Community Trust"
"09" "Receives more than 33 1/3% of support from contributions, membership fees"
"10" "Supporting organizations for other exempt orgs"
"11" "Organized and operated to test for public safety"
.
VALUE LABELS SUBSECCD
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"92" "92- 4947(a)(1) Private Foundations"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"82" "82- 527 Political Organizations"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"40" "40- Apostolic and religious orgs. - 501(d)"
"11" "11- Teachers retirement fund associations."
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"70" "70- Child Care Organization - 501(k)"
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"71" "71- Charitable Risk Pool"
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"81" "81- Qualified State-Sponsored Tuition Program"
"22" "22- Multiemployer Pension Plan"
"23" "23- Veterans association formed prior to 1880"
"24" "24-Trust described in Section 4049 of ERISA"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"25" "25- Title Holding Company for Pensions, etc"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"90" "90- 4947(a)(2) Split Interest Trust"
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"80" "80- Farmers' Cooperatives"
"02" "02- Title holding corporation for a tax-exempt organization."
"19" "19- Post or organization of war veterans."
.
VALUE LABELS VERIFY
"S" "Financial fields have been verified by SOI edited return."
"" "No code"
"T" "Current financial fields have been multiplied by 1000 because return reported in thousands."
"M" "Financial fields have been verified by staff."
"L" "Financial fields were multiplied by 1000 because return reported in the thousands but inspection rev"
.

SPSS input statement lines

GET DATA
/TYPE=TXT
/FILE="c: emp.csv"
/DELCASE=LINE
/DELIMITERS=","
/ARRANGEMENT=DELIMITED
/FIRSTCASE=2
/IMPORTCASE=ALL
/VARIABLES
EIN a9
TAXPER a6
CONT f15.0
DUES f15.0
SECUR f15.0
SALESEXP f15.0
INVINC f15.0
SOLICIT f15.0
GOODS f15.0
GRPROF f15.0
SALES f15.0
GRINC f15.0
GRREC f15.0
EXPS f15.0
FUNDBAL f15.0
COMPENS f15.0
FUNDFEES f15.0
ASS_BOY f15.0
ASS_EOY f15.0
LIAB_BOY f15.0
LIAB_EOY f15.0
RETEARN f15.0
INITFEES f15.0
GRRECPUB f15.0
GRRECMEM f15.0
GRRECOTH f15.0
POLPURP f15.0
LEGEXP f15.0
GRROOT f15.0
INFLEXP f15.0
EXGRROOT f15.0
EXLOBEXP f15.0
RENTEXP f15.0
DIREXP f15.0
PROGREV f15.0
FUNDINC f15.0
OTHINC f15.0
SAVINT f15.0
SECINC f15.0
RENTINC f15.0
NETRENT f15.0
OTHINVST f15.0
SALESECN f15.0
SALEOTHG f15.0
SALEOTHE f15.0
SALEOTHN f15.0
SPEVTG f15.0
INVENTG f15.0
TOTREV2 f15.0
NETINC f15.0
OTHCHGS f15.0
OTHSAL f15.0
PAYTAX f15.0
BOND_BOY f15.0
BOND_EOY f15.0
MRTG_BOY f15.0
MRTG_EOY f15.0
RETE_BOY f15.0
NETA_BOY f15.0
CONT4 f15.0
DUES4 f15.0
GRREC4 f15.0
INVINC4 f15.0
TAXREV4 f15.0
GVTSRV4 f15.0
OTHINC4 f15.0
INCPURP4 f15.0
LOBOTH f15.0
LOBNOTAX f15.0
GRTNONTX f15.0
VERIFY a1
TOTREV f15.0
SUBSECCD a2
REASON a2
RASCD a1
RREVCD a1
RINCCD a1
REXPCD a1
FISYR a4
STYEAR a4
NAME a70
CONTACT a35
ADDRESS a35
CITY a22
STATE a2
ZIP a10
GEN a4
AFCD a1
CLASSCD a4
RULEDATE a6
DEDUCTCD a1
FNDNCD a2
ACTIV1 a3
ACTIV2 a3
ACTIV3 a3
ORGCD a1
DISTRICT a2
ARED a6
FRCD a3
ACCPER a2
SEC_NAME a35
NTEECC a3
NTEECC4D a1
LEVEL1 a2
V_FREXP f15.0
V_CONT f15.0
V_GREC f15.0
NTEE1 a3
OUTREAS a1
OUTNCCS a3
LEVEL2 a1
LEVEL3 a2
LEVEL4 a1
TOTLOB f15.0
V_BOYAL a1
V_EOYAL a1
V_FB a1
V_REVEXP a1
NTEE_CAT a1
LEVEL5 f15.0
zipOld a5
MSA_NECH a4
PMSA a4
FIPS a5
randnum f15.0
ZIP5 a5
MAJGRPB a2
NTEESRC a1
ntmaj10 a2
ntmaj5 a2
fipsold a5
v_errorCd a1
NCCSKEY2 a13
NteeDraft a4
stateOld1 a2
zip5Old1 a5
cityOld1 a22
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.