* SOI 2011 990 Hospital Facilities.

VARIABLE LABELS
EIN "Employer identification number of Hospital (Page 1, Line D)"
FisYr "Fiscal year (ending year)"
NAME "Name of Organization filing Form 990 (Form 990, Page 1, Line C)"
STATE "Two-letter state abbreviation of Organization filing Form 990 (Form 990, Page 1, Line C(3))"
zip5 "First 5 digits of zip code of Organization filing Form 990 (Form 990, Page 1, Line C(4))"
SUBSECCD "Hospital IRS subsection code, e.g. 03=501(c)(3), etc. (Page 1, Line I)"
hospfclt_cnt "Number of hospital facilities (number of rows in Sch H - Part V sub-table)"
hrow "Row Identification Number"
fclt_num "Line Number of Hospital Facility (from Sched H, Part V, Section A)"
fclty_name "Name of facility"
fclty_zip "Zip code of facility"
type_of_fclty "Type of facility"
chna_cndct "Conduct a needs assessment? (Sch H, Part V, Line 1)"
chna_descr "What the needs assessment describes (Sch H, Part V, Line 1a-1j)"
nds_assmnt_cndct "Year needs assessment conducted (Sch H, Part V, Line 2)"
tk_into_acct "Take into account input from community? (Sch H, Part V, Line 3)"
oth_fclt "Conducted with other facilities? (Sch H, Part V, Line 4)"
chna_wdly_avlbl "Needs assessment widely available to public? (Sch H, Part V, Line 5)"
chna_public "How needs assessment was made available to public (Sch H, Part V, Line 5a-5c)"
nds_addrssd "Which needs raised by assessment were addressed? (Sch H, Part V, Line 6a-6i)"
all_nds_addrssd "All needs addressed? (Sch H, Part V, Line 7)"
elgbl_crtr_explnd "Explain eligibility crieria for assistance? (Sch H, Part V, Line 8)"
uss_fpg_fr "Used FPG for free care? (Sch H, Part V, Line 9)"
fpg_fr_pct "FPG fmaily income limit for free care (Sch H, Part V, Line 9(yes))"
uss_fpg_dscntd "Used FPG for discounted care? (Sch H, Part V, Line 10)"
fpg_dscnt_pct "FPG fmaily income limit for discounted care (Sch H, Part V, Line 10(yes))"
explns_bss "Explain basis for calculating charges? (Sch H, Part V, Line 11)"
bss_for_amts "Factors used to calculate charges (Sch H, Part V, Line 11a-11h)"
explns_applctn_mthd "Explain method for applying for assistance? (Sch H, Part V, Line 12)"
inclds_pblcty_msrs "Include measures to publicize assistance policy (Sch H, Part V, Line 13)"
how_msrs_pblczd "How assistance policy was publicized (Sch H, Part V, Line 13a-13g)"
actns_nnpymnt "Written policy regarding non-payment? (Sch H, Part V, Line 14)"
nnpymnt_actn_mthds "Nonpayment policy actions (Sch H, Part V, Line 15a-15e)"
coll_acty "Actions related to collection? (Sch H, Part V, Line 16)"
coll_acty_mthds "Which collection activities (Sch H, Part V, Line 16a-16e)"
pre_coll_acty "Efforts before collection activities (Sch H, Part V, Line 17a-17e)"
nndscrm_emrgncy_cr_plcy "Non-discriminatory emergency room policy? (Sch H, Part V, Line 18)"
rsn_no_nndscrm_plcy "Why no non-discriminatory ER policy (Sch H, Part V, Line 18a-18d)"
max_amt_dtrmnd "How maximum charge amounts determined (Sch H, Part V, Line 19a-19d)"
amt_gnrlly_blld "Did hospital charge more than amounts billed? (Sch H, Part V, Line 20)"
gr_chrg "Charge amounts equal to gross chrage? (Sch H, Part V, Line 21)"
SCPL "Service Center Cycle Page Line (unique identifier assigned by the IRS - used to match primary SOI record with related sub-table records)"
.

.
VALUE LABELS actns_nnpymnt
"Y" "Yes"
"N" "No"
.
VALUE LABELS all_nds_addrssd
"Y" "Yes"
"N" "No"
.
VALUE LABELS amt_gnrlly_blld
"Y" "Yes"
"N" "No"
.
VALUE LABELS chna_cndct
"Y" "Yes"
"N" "No"
.
VALUE LABELS chna_wdly_avlbl
"Y" "Yes"
"N" "No"
.
VALUE LABELS coll_acty
"Y" "Yes"
"N" "No"
.
VALUE LABELS elgbl_crtr_explnd
"Y" "Yes"
"N" "No"
.
VALUE LABELS explns_applctn_mthd
"Y" "Yes"
"N" "No"
.
VALUE LABELS explns_bss
"Y" "Yes"
"N" "No"
.
VALUE LABELS gr_chrg
"Y" "Yes"
"N" "No"
.
VALUE LABELS inclds_pblcty_msrs
"Y" "Yes"
"N" "No"
.
VALUE LABELS nndscrm_emrgncy_cr_plcy
"Y" "Yes"
"N" "No"
.
VALUE LABELS oth_fclt
"Y" "Yes"
"N" "No"
.
VALUE LABELS SUBSECCD
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"40" "40- Apostolic and religious orgs. - 501(d)"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"19" "19- Post or organization of war veterans."
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"20" "20- Trusts for prepaid group legal services, as part of a qual. group legal service plan or plans."
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"70" "70- Child Care Organization - 501(k)"
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"71" "71- Charitable Risk Pool"
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"22" "22- Multiemployer Pension Plan"
"81" "81- Qualified State-Sponsored Tuition Program"
"11" "11- Teachers retirement fund associations."
"23" "23- Veterans association formed prior to 1880"
"82" "82- 527 Political Organizations"
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"24" "24-Trust described in Section 4049 of ERISA"
"CO" "CO- Unspecified 501(c) Organization Other Than 501(c)(3)"
"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"
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"92" "92- 4947(a)(1) Private Foundations"
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"02" "02- Title holding corporation for a tax-exempt organization."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"27" "27- State-Sponsored Workers Compensation Reinsurance"
.
VALUE LABELS tk_into_acct
"Y" "Yes"
"N" "No"
.
VALUE LABELS uss_fpg_dscntd
"Y" "Yes"
"N" "No"
.
VALUE LABELS uss_fpg_fr
"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
EIN a9
scpl a12
hospfclt_cnt f15.0
ZIP5 a5
SubSecCd a2
FisYr a4
name a60
state a2
hrow a3
fclt_num a6
fclty_name a75
fclty_zip a5
type_of_fclty a9
chna_cndct a1
chna_descr a10
nds_assmnt_cndct a4
tk_into_acct a1
oth_fclt a1
chna_wdly_avlbl a1
chna_public a3
nds_addrssd a9
all_nds_addrssd a1
elgbl_crtr_explnd a1
uss_fpg_fr a1
fpg_fr_pct a4
uss_fpg_dscntd a1
fpg_dscnt_pct a4
explns_bss a1
bss_for_amts a8
explns_applctn_mthd a1
inclds_pblcty_msrs a1
how_msrs_pblczd a9
actns_nnpymnt a1
nnpymnt_actn_mthds a5
coll_acty a1
coll_acty_mthds a5
pre_coll_acty a5
nndscrm_emrgncy_cr_plcy a1
rsn_no_nndscrm_plcy a4
max_amt_dtrmnd a4
amt_gnrlly_blld a1
gr_chrg a1
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.