* Core Supplement 05-14-2009 Financial.
VARIABLE LABELSEIN "Employer identification number."
FisYr "Fiscal year (ending year)"
p0phone "Phone number
NOTE: Only records with p0phone listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0phone%'] in filter criteria when using this field (see SCvars below)."
Website "Website URL
NOTE: Only records with Website listed in SCvars contain this data. Always include [AND SCvars LIKE '%Website%'] in filter criteria when using this field (see SCvars below)."
p0addchg "Address change (Line B checkbox)
NOTE: Only records with p0addchg listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0addchg%'] in filter criteria when using this field (see SCvars below)."
p0namchg "Name change (Line B checkbox)
NOTE: Only records with p0namchg listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0namchg%'] in filter criteria when using this field (see SCvars below)."
p0intrtn "Initial return (Line B checkbox)
NOTE: Only records with p0intrtn listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0intrtn%'] in filter criteria when using this field (see SCvars below)."
p0fnlrtn "Final return / Termination (Line B checkbox)
NOTE: Only records with p0fnlrtn listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0fnlrtn%'] in filter criteria when using this field (see SCvars below)."
p0amdrtn "Amended return (Line B checkbox)
NOTE: Only records with p0amdrtn listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0amdrtn%'] in filter criteria when using this field (see SCvars below)."
p0append "Application pending (Line B checkbox)
NOTE: Only records with p0append listed in SCvars contain this data. Always include [AND SCvars LIKE '%p0append%'] in filter criteria when using this field (see SCvars below)."
p1contFund "Contributions to donor advised funds (added to IRS Form 990 beginning tax year 2006)
NOTE: Only records with p1contFund listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1contFund%'] in filter criteria when using this field (see SCvars below)."
p1dirsup "Direct public support
NOTE: Only records with p1dirsup listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1dirsup%'] in filter criteria when using this field (see SCvars below)."
p1indsup "Indirect public support
NOTE: Only records with p1indsup listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1indsup%'] in filter criteria when using this field (see SCvars below)."
p1govgt "Government grants
NOTE: Only records with p1govgt listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1govgt%'] in filter criteria when using this field (see SCvars below)."
p1cash "Cash contributions
NOTE: Only records with p1cash listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1cash%'] in filter criteria when using this field (see SCvars below)."
p1noncsh "Noncash contributions
NOTE: Only records with p1noncsh listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1noncsh%'] in filter criteria when using this field (see SCvars below)."
p1tcont "Total contributions, gifts, grants, etc.
NOTE: Only records with p1tcont listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1tcont%'] in filter criteria when using this field (see SCvars below)."
p1psrev "Program service revenue
NOTE: Only records with p1psrev listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1psrev%'] in filter criteria when using this field (see SCvars below)."
p1totrev "Total revenue
NOTE: Only records with p1totrev listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1totrev%'] in filter criteria when using this field (see SCvars below)."
p1pExp "Program service expenses
NOTE: Only records with p1pExp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1pExp%'] in filter criteria when using this field (see SCvars below)."
p1mExp "Management & general expenses
NOTE: Only records with p1mExp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1mExp%'] in filter criteria when using this field (see SCvars below)."
p1frexp "Fund-raising expenses
NOTE: Only records with p1frexp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1frexp%'] in filter criteria when using this field (see SCvars below)."
p1affil "Payments to affiliates
NOTE: Only records with p1affil listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1affil%'] in filter criteria when using this field (see SCvars below)."
p1totexp "Total expenses
NOTE: Only records with p1totexp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1totexp%'] in filter criteria when using this field (see SCvars below)."
p1netInc "Net income: excess (or deficit) for the year
NOTE: Only records with p1netInc listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1netInc%'] in filter criteria when using this field (see SCvars below)."
p1nasboy "Net assets or fund balance-beg. of year
NOTE: Only records with p1nasboy listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1nasboy%'] in filter criteria when using this field (see SCvars below)."
p1chgas "Other changes in net assets or fund balances
NOTE: Only records with p1chgas listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1chgas%'] in filter criteria when using this field (see SCvars below)."
p1naseoy "Net assets or fund balance-end of year
NOTE: Only records with p1naseoy listed in SCvars contain this data. Always include [AND SCvars LIKE '%p1naseoy%'] in filter criteria when using this field (see SCvars below)."
p2tgrant "Grants & allocations - col. A (total)
NOTE: Only records with p2tgrant listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tgrant%'] in filter criteria when using this field (see SCvars below)."
p2tasist "Specific assistance to individuals- col. A (total)
NOTE: Only records with p2tasist listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tasist%'] in filter criteria when using this field (see SCvars below)."
p2tmemb "Benefits paid to or for members- col. A (total)
NOTE: Only records with p2tmemb listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tmemb%'] in filter criteria when using this field (see SCvars below)."
p2tcomp "Compensation of officers-col. A (total)
NOTE: Only records with p2tcomp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tcomp%'] in filter criteria when using this field (see SCvars below)."
p2twages "Other salaries & wages-col. A (total)
NOTE: Only records with p2twages listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2twages%'] in filter criteria when using this field (see SCvars below)."
p2tpensn "Pension plan contributions-col. A (total)
NOTE: Only records with p2tpensn listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tpensn%'] in filter criteria when using this field (see SCvars below)."
p2tembft "Other employee benefits-col. A (total)
NOTE: Only records with p2tembft listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tembft%'] in filter criteria when using this field (see SCvars below)."
p2tpytax "Payroll taxes-col. A (total)
NOTE: Only records with p2tpytax listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tpytax%'] in filter criteria when using this field (see SCvars below)."
p2tfrfee "Professional fundraising fees-total (col.A)
NOTE: Only records with p2tfrfee listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tfrfee%'] in filter criteria when using this field (see SCvars below)."
p2tacfee "Accounting fees-col. A (total)
NOTE: Only records with p2tacfee listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tacfee%'] in filter criteria when using this field (see SCvars below)."
p2tlgfee "Legal fees-col. A (total)
NOTE: Only records with p2tlgfee listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tlgfee%'] in filter criteria when using this field (see SCvars below)."
p2tsup "Supplies-col. A (total)
NOTE: Only records with p2tsup listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tsup%'] in filter criteria when using this field (see SCvars below)."
p2tphone "Telephone-col. A (total)
NOTE: Only records with p2tphone listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tphone%'] in filter criteria when using this field (see SCvars below)."
p2tpostg "Postage & shipping-col. A (total)
NOTE: Only records with p2tpostg listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tpostg%'] in filter criteria when using this field (see SCvars below)."
p2toccup "Occupancy-col. A (total)
NOTE: Only records with p2toccup listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2toccup%'] in filter criteria when using this field (see SCvars below)."
p2tequip "Equipment rental & exp.-col. A (total)
NOTE: Only records with p2tequip listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tequip%'] in filter criteria when using this field (see SCvars below)."
p2tprint "Printing & publications-col. A (total)
NOTE: Only records with p2tprint listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tprint%'] in filter criteria when using this field (see SCvars below)."
p2ttravl "Travel-col. A (total)
NOTE: Only records with p2ttravl listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2ttravl%'] in filter criteria when using this field (see SCvars below)."
p2tmtgs "Conferences, conventions & meetings-col. A (total)
NOTE: Only records with p2tmtgs listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tmtgs%'] in filter criteria when using this field (see SCvars below)."
p2tint "Interest-col. A (total)
NOTE: Only records with p2tint listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tint%'] in filter criteria when using this field (see SCvars below)."
p2tdeprc "Depreciation, depletion, etc.-col. A (total)
NOTE: Only records with p2tdeprc listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tdeprc%'] in filter criteria when using this field (see SCvars below)."
p2tTot "Total functional expenses-col. A (total)
NOTE: Only records with p2tTot listed in SCvars contain this data. Always include [AND SCvars LIKE '%p2tTot%'] in filter criteria when using this field (see SCvars below)."
p4e_cash "Cash- end of year
NOTE: Only records with p4e_cash listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_cash%'] in filter criteria when using this field (see SCvars below)."
p4e_save "Savings- end of year
NOTE: Only records with p4e_save listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_save%'] in filter criteria when using this field (see SCvars below)."
p4e_arec "Accounts receivable- end of year
NOTE: Only records with p4e_arec listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_arec%'] in filter criteria when using this field (see SCvars below)."
p4e_prec "Pledges receivable- end of year
NOTE: Only records with p4e_prec listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_prec%'] in filter criteria when using this field (see SCvars below)."
p4e_grec "Grants receivable- end of year
NOTE: Only records with p4e_grec listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_grec%'] in filter criteria when using this field (see SCvars below)."
p4e_irec "Receivables due from offices, directors & trustees- end of year
NOTE: Only records with p4e_irec listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_irec%'] in filter criteria when using this field (see SCvars below)."
p4e_lrec "Other notes & loans receivable- end of year
NOTE: Only records with p4e_lrec listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_lrec%'] in filter criteria when using this field (see SCvars below)."
P4E_INVT "Inventories for sale or use, end of year
NOTE: Only records with P4E_INVT listed in SCvars contain this data. Always include [AND SCvars LIKE '%P4E_INVT%'] in filter criteria when using this field (see SCvars below)."
p4e_pre "Prepaid expenses- end of year
NOTE: Only records with p4e_pre listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_pre%'] in filter criteria when using this field (see SCvars below)."
p4e_sec "Investments- securities- end of year
NOTE: Only records with p4e_sec listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_sec%'] in filter criteria when using this field (see SCvars below)."
p4b_ilnd "Investments - Land, buildings & equipment (cost/basis before accumulated depreciation)
NOTE: Only records with p4b_ilnd listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_ilnd%'] in filter criteria when using this field (see SCvars below)."
p4d_ilnd "Accumulated depreciation for Investments - Land, buildings & equipment
NOTE: Only records with p4d_ilnd listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4d_ilnd%'] in filter criteria when using this field (see SCvars below)."
p4e_ilnd "Net Investments - Land, buildings & equipment (cost/basis minus accum. depreciation - end of year)
NOTE: Only records with p4e_ilnd listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_ilnd%'] in filter criteria when using this field (see SCvars below)."
p4e_iOth "Investments-other- end of year
NOTE: Only records with p4e_iOth listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_iOth%'] in filter criteria when using this field (see SCvars below)."
p4b_land "Land, buildings & equipment (cost/basis before accumulated depreciation)
NOTE: Only records with p4b_land listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_land%'] in filter criteria when using this field (see SCvars below)."
p4d_land "Accumulated depreciation for land, buildings & equipment
NOTE: Only records with p4d_land listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4d_land%'] in filter criteria when using this field (see SCvars below)."
p4e_land "Net Land, buildings & equipment (cost/basis minus accum. depreciation - end of year)
NOTE: Only records with p4e_land listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_land%'] in filter criteria when using this field (see SCvars below)."
p4b_asst "Total assets- beg. of year
NOTE: Only records with p4b_asst listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_asst%'] in filter criteria when using this field (see SCvars below)."
p4e_asst "Total assets- end of year
NOTE: Only records with p4e_asst listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_asst%'] in filter criteria when using this field (see SCvars below)."
p4e_oAst "Other assets- end of year
NOTE: Only records with p4e_oAst listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_oAst%'] in filter criteria when using this field (see SCvars below)."
p4e_apay "Accounts payable- end of year
NOTE: Only records with p4e_apay listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_apay%'] in filter criteria when using this field (see SCvars below)."
p4e_gpay "Grants payable- end of year
NOTE: Only records with p4e_gpay listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_gpay%'] in filter criteria when using this field (see SCvars below)."
p4e_defr "Revenue designated for future periods- end of year
NOTE: Only records with p4e_defr listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_defr%'] in filter criteria when using this field (see SCvars below)."
p4e_lpay "Loans from officers, directors & trustees- end of year
NOTE: Only records with p4e_lpay listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_lpay%'] in filter criteria when using this field (see SCvars below)."
p4e_bond "Tax-exempt bond liabilities- end of year
NOTE: Only records with p4e_bond listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_bond%'] in filter criteria when using this field (see SCvars below)."
p4e_mort "Mortgages & other notes payable- end of year
NOTE: Only records with p4e_mort listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_mort%'] in filter criteria when using this field (see SCvars below)."
p4e_oLia "Other liabilities- end of year
NOTE: Only records with p4e_oLia listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_oLia%'] in filter criteria when using this field (see SCvars below)."
p4b_liab "Total liabilities- beg. of year
NOTE: Only records with p4b_liab listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_liab%'] in filter criteria when using this field (see SCvars below)."
p4e_liab "Total liabilities- end of year
NOTE: Only records with p4e_liab listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_liab%'] in filter criteria when using this field (see SCvars below)."
p4b_unre "Unrestricted net assets or fund balances- beginning of year
NOTE: Only records with p4b_unre listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_unre%'] in filter criteria when using this field (see SCvars below)."
p4e_unre "Unrestricted net assets or fund balances- end of year
NOTE: Only records with p4e_unre listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_unre%'] in filter criteria when using this field (see SCvars below)."
p4b_temp "Temporarily restricted net assets- beginning of year
NOTE: Only records with p4b_temp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_temp%'] in filter criteria when using this field (see SCvars below)."
p4e_temp "Temporarily restricted net assets- end of year
NOTE: Only records with p4e_temp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_temp%'] in filter criteria when using this field (see SCvars below)."
p4b_perm "Permanently restricted net assets- beginning of year
NOTE: Only records with p4b_perm listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_perm%'] in filter criteria when using this field (see SCvars below)."
p4e_perm "Permanently restricted net assets- end of year
NOTE: Only records with p4e_perm listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_perm%'] in filter criteria when using this field (see SCvars below)."
p4b_cap "Capital stock, trust prncipl, or curnt fnds-beg. of year
NOTE: Only records with p4b_cap listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_cap%'] in filter criteria when using this field (see SCvars below)."
p4e_cap "Capital stock, trust prncipl, or curnt fnds-end of year
NOTE: Only records with p4e_cap listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_cap%'] in filter criteria when using this field (see SCvars below)."
p4b_surp "Paid-in or capital splus, or ld, blg & e fd- beg. of year
NOTE: Only records with p4b_surp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_surp%'] in filter criteria when using this field (see SCvars below)."
p4e_surp "Paid-in or capital splus, or ld, blg & e fd- end of year
NOTE: Only records with p4e_surp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_surp%'] in filter criteria when using this field (see SCvars below)."
p4b_net "Total fund balances or net worth- beginning of year
NOTE: Only records with p4b_net listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_net%'] in filter criteria when using this field (see SCvars below)."
p4b_retn "Retained earns, endowmts, accum. Income- beg. of year
NOTE: Only records with p4b_retn listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4b_retn%'] in filter criteria when using this field (see SCvars below)."
p4e_retn "Retained earns, endowmts, accum. Income- end of year
NOTE: Only records with p4e_retn listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_retn%'] in filter criteria when using this field (see SCvars below)."
p4e_net "Total fund balances or net worth- end of year
NOTE: Only records with p4e_net listed in SCvars contain this data. Always include [AND SCvars LIKE '%p4e_net%'] in filter criteria when using this field (see SCvars below)."
p6numEmp "Number of employees employed in pay period including 3/12/90306y
NOTE: Only records with p6numEmp listed in SCvars contain this data. Always include [AND SCvars LIKE '%p6numEmp%'] in filter criteria when using this field (see SCvars below)."
p7govamt "Fees & contracts from govt agencies (g)-col. B (unrelated business income, amount)
NOTE: Only records with p7govamt listed in SCvars contain this data. Always include [AND SCvars LIKE '%p7govamt%'] in filter criteria when using this field (see SCvars below)."
p7medamt "Medicare/medicaid payments (f)- col. B (unrelated business income, amount)
NOTE: Only records with p7medamt listed in SCvars contain this data. Always include [AND SCvars LIKE '%p7medamt%'] in filter criteria when using this field (see SCvars below)."
p7govrin "Fees & contracts from govt agencies (g)-col. E (related or exempt function income)
NOTE: Only records with p7govrin listed in SCvars contain this data. Always include [AND SCvars LIKE '%p7govrin%'] in filter criteria when using this field (see SCvars below)."
p7govxat "Fees & contracts from govt agencies (g)-col. D (excl by s.512,513 or 514)
NOTE: Only records with p7govxat listed in SCvars contain this data. Always include [AND SCvars LIKE '%p7govxat%'] in filter criteria when using this field (see SCvars below)."
p7medxat "Medicare/medicaid payments (f)- col. D (excl by s.512,513 or 514, amount)
NOTE: Only records with p7medxat listed in SCvars contain this data. Always include [AND SCvars LIKE '%p7medxat%'] in filter criteria when using this field (see SCvars below)."
p7medrin "Medicare/medicaid payments (f)- col. E (related or exempt function income)
NOTE: Only records with p7medrin listed in SCvars contain this data. Always include [AND SCvars LIKE '%p7medrin%'] in filter criteria when using this field (see SCvars below)."
a3lobby "Organization attempted to influence legislation (Sch. A, Part III, Line 1)
NOTE: Only records with a3lobby listed in SCvars contain this data. Always include [AND SCvars LIKE '%a3lobby%'] in filter criteria when using this field (see SCvars below)."
a3lbyex "Total lobbying expenses (Sch. A, Part III, Line 1)
NOTE: Only records with a3lbyex listed in SCvars contain this data. Always include [AND SCvars LIKE '%a3lbyex%'] in filter criteria when using this field (see SCvars below)."
a4fndtyp "The organization is not a private foundation because it is: (Line number of box checked in Schedule A)
NOTE: Only records with a4fndtyp listed in SCvars contain this data. Always include [AND SCvars LIKE '%a4fndtyp%'] in filter criteria when using this field (see SCvars below)."
a4suporg "Type of Supporting Organization (Schedule A, Line 13 for forms prior to 2008)
NOTE: Only records with a4suporg listed in SCvars contain this data. Always include [AND SCvars LIKE '%a4suporg%'] in filter criteria when using this field (see SCvars below)."
PDFName "Form 990 Return Image PDF File Name - unique identifier for Form 990 returns used to match Core Supplement Financial records to Part III (Purpose Program) and Part V (Key Contact) records"
I_IrsForm "Keypunch Return Image Form Type"
I_DateRec "Keypunch Return Image Date Received by IRS"
FormYr "Keypunch Return Image Form Year"
Flag_Core04 "Flag_Core04=1 indicates the best unique EIN and Fiscal Year match available to a record in Core 2004 PC (use Flag_Core04=1 filter when matching to Core 2004 PC file records on EIN and FisYr)"
Flag_Core05 "Flag_Core05=1 indicates the best unique EIN and Fiscal Year match available to a record in Core 2005 PC (use Flag_Core05=1 filter when matching to Core 2005 PC file records on EIN and FisYr)"
Flag_Core06 "Flag_Core06=1 indicates the best unique EIN and Fiscal Year match available to a record in Core 2006 PC (use Flag_Core06=1 filter when matching to Core 2006 PC file records on EIN and FisYr)"
FisYr_Best "FisYr_Best=1 indicates the most recent return filed by an organization per Fiscal Year (e.g.: use FisYr_Best=1 and (FisYr='2005' or FisYr='2006') to filter out duplicate returns and select the most recent return filed in 2005 and in 2006 per EIN)"
LatestOne "LatestOne=1 indicates the most recent unique fiscal year return (use to filter out duplicates by selecting the one most recent return per EIN)"
SCvars "A comma-separated list of the supplemental variables that were keypunched for each record (e.g. 'EIN,p0phone,website,p1contFund,p1dirsup,...').
NOTE: Not all fields were keypunched for every record, so always include SCvars in filter criteria to only select records that contain keypunched data (e.g. including [SCvars like '%a3lobby%'] in a filter will select records that contain keypunched data for a3lobby and exclude records that do not contain a3lobby)."
SCsource "Source of supplemental data (project data file name)"
.
.
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.
.