* Core Supplement 05-14-2009 Financial.

VARIABLE LABELS
EIN "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
DropFlag f15.0
IDnum f15.0
EIN a9
I_IrsForm a2
I_DateRec f15.0
PDFname a100
TaxPer a6
FisYr a4
FormYr a4
IRSstamp a100
Yr_endin a20
p0addchg a1
p0namchg a1
p0intrtn a1
p0fnlrtn a1
p0amdrtn a1
p0append a1
p0phone a20
website a100
p1contFund f15.0
p1dirsup f15.0
p1indSup f15.0
p1govGt f15.0
p1tCont f15.0
p1cash f15.0
p1noncsh f15.0
p1psRev f15.0
p1totRev f15.0
p1pExp f15.0
p1mExp f15.0
p1frExp f15.0
p1affil f15.0
p1totexp f15.0
p1NetInc f15.0
p1nAsBoy f15.0
p1chgAs f15.0
p1nAsEOY f15.0
p2tgrant f15.0
p2tgrnta f15.0
p2tgrntb f15.0
p2tasist f15.0
p2tmemb f15.0
p2tcomp f15.0
p2tcmpa f15.0
p2tcmpb f15.0
p2tcmpc f15.0
p2twages f15.0
p2tpensn f15.0
p2tembft f15.0
p2tpytax f15.0
p2tfrfee f15.0
p2tacfee f15.0
p2tlgfee f15.0
p2tsup f15.0
p2tphone f15.0
p2tpostg f15.0
p2toccup f15.0
p2tequip f15.0
p2tprint f15.0
p2ttravl f15.0
p2tmtgs f15.0
p2tint f15.0
p2tdeprc f15.0
p2tTot f15.0
p4e_cash f15.0
p4e_save f15.0
p4e_arec f15.0
p4e_prec f15.0
p4e_grec f15.0
p4e_irec f15.0
p4e_lrec f15.0
p4e_invt f15.0
p4e_pre f15.0
p4e_sec f15.0
p4b_iLnd f15.0
p4d_iLnd f15.0
p4e_iLnd f15.0
p4e_iOth f15.0
p4b_Land f15.0
p4d_Land f15.0
p4e_Land f15.0
p4e_oAst f15.0
p4b_asst f15.0
p4e_Asst f15.0
p4e_apay f15.0
p4e_gpay f15.0
p4e_defr f15.0
p4e_lpay f15.0
p4e_bond f15.0
p4e_mort f15.0
p4e_oLia f15.0
p4b_liab f15.0
p4e_liab f15.0
p4b_unre f15.0
p4e_unre f15.0
p4b_temp f15.0
p4e_temp f15.0
p4b_perm f15.0
p4e_perm f15.0
p4b_net f15.0
p4e_net f15.0
p4b_cap f15.0
p4e_cap f15.0
p4b_surp f15.0
p4e_surp f15.0
p4b_retn f15.0
p4e_retn f15.0
p6numEmp f15.0
p7medAmt f15.0
p7medXat f15.0
p7medRin f15.0
p7govAmt f15.0
p7govXat f15.0
p7govRin f15.0
a3lobby a20
a3LbyEx f15.0
a4fndtyp a3
a4suporg a3
batchid a40
IrsForm a6
SCsource a60
SCvars a4294967295
SCAddDate a8
Flag_Core04 f15.0
CoreScore04 f15.0
Flag_Core05 f15.0
CoreScore05 f15.0
Flag_Core06 f15.0
CoreScore06 f15.0
Flag_Core07 f15.0
CoreScore07 f15.0
FisYr_Best f15.0
LatestOne f15.0
Latest f15.0
p4e_net_old f15.0
p4e_net_temp f15.0
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.