* SOI 2012 990 Hospital Facilities.
VARIABLE LABELSEIN "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)"
org_incr_exc_tx "Incur 4959 excise tax for failure to conduct 501(r)(3) CHNA? (Sch H, Part V, Line 8a)"
fil_4720_rprt_exc_tx "If Yes to line 8a, File 4720 for excise tax? (Sch H, Part V, Line 8b)"
exc_rprt_4720_all_amt "If Yes to line 8b, Amount of excise tax (Sch H, Part V, Line 8c)"
elgbl_crtr_explnd "Explain eligibility crieria for assistance? (Sch H, Part V, Line 9)"
uss_fpg_fr "Used FPG for free care? (Sch H, Part V, Line 10)"
fpg_fr_pct "FPG fmaily income limit for free care (Sch H, Part V, Line 10(yes))"
uss_fpg_dscntd "Used FPG for discounted care? (Sch H, Part V, Line 11)"
fpg_dscnt_pct "FPG fmaily income limit for discounted care (Sch H, Part V, Line 11(yes))"
explns_bss "Explain basis for calculating charges? (Sch H, Part V, Line 12)"
bss_for_amts "Factors used to calculate charges (Sch H, Part V, Line 12a-12h)"
explns_applctn_mthd "Explain method for applying for assistance? (Sch H, Part V, Line 13)"
inclds_pblcty_msrs "Include measures to publicize assistance policy (Sch H, Part V, Line 14)"
how_msrs_pblczd "How assistance policy was publicized (Sch H, Part V, Line 14a-14g)"
actns_nnpymnt "Written policy regarding non-payment? (Sch H, Part V, Line 15)"
nnpymnt_actn_mthds "Nonpayment policy actions (Sch H, Part V, Line 16a-16e)"
coll_acty "Actions related to collection? (Sch H, Part V, Line 17)"
coll_acty_mthds "Which collection activities (Sch H, Part V, Line 17a-17e)"
pre_coll_acty "Efforts before collection activities (Sch H, Part V, Line 18a-18e)"
nndscrm_emrgncy_cr_plcy "Non-discriminatory emergency room policy? (Sch H, Part V, Line 19)"
rsn_no_nndscrm_plcy "Why no non-discriminatory ER policy (Sch H, Part V, Line 19a-19d)"
max_amt_dtrmnd "How maximum charge amounts determined (Sch H, Part V, Line 20a-20d)"
amt_gnrlly_blld "Did hospital charge more than amounts billed? (Sch H, Part V, Line 21)"
gr_chrg "Charge amounts equal to gross chrage? (Sch H, Part V, Line 22)"
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
"N" "No"
"Y" "Yes"
.
VALUE LABELS chna_cndct
"N" "No"
"Y" "Yes"
.
VALUE LABELS chna_wdly_avlbl
"Y" "Yes"
"N" "No"
.
VALUE LABELS coll_acty
"Y" "Yes"
"N" "No"
.
VALUE LABELS elgbl_crtr_explnd
"N" "No"
"Y" "Yes"
.
VALUE LABELS explns_applctn_mthd
"N" "No"
"Y" "Yes"
.
VALUE LABELS explns_bss
"N" "No"
"Y" "Yes"
.
VALUE LABELS fil_4720_rprt_exc_tx
"N" "No"
"Y" "Yes"
.
VALUE LABELS gr_chrg
"Y" "Yes"
"N" "No"
.
VALUE LABELS inclds_pblcty_msrs
"Y" "Yes"
"N" "No"
.
VALUE LABELS nndscrm_emrgncy_cr_plcy
"N" "No"
"Y" "Yes"
.
VALUE LABELS org_incr_exc_tx
"Y" "Yes"
"N" "No"
.
VALUE LABELS oth_fclt
"Y" "Yes"
"N" "No"
.
VALUE LABELS SUBSECCD
"23" "23- Veterans association formed prior to 1880"
"22" "22- Multiemployer Pension Plan"
"04" "04- Civic leagues, social welfare organizations, and local associations of employees"
"21" "21- Black lung trusts, satisfying claims for compensation under Black Lung Acts."
"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."
"27" "27- State-Sponsored Workers Compensation Reinsurance"
"16" "16- Cooperative organizations to finance crop operations, in conjunction with activities ..."
"82" "82- 527 Political Organizations"
"81" "81- Qualified State-Sponsored Tuition Program"
"71" "71- Charitable Risk Pool"
"70" "70- Child Care Organization - 501(k)"
"60" "60- Cooperative Service Org. of Operating Educ. Org.- 501(f)"
"50" "50- Cooperative Hospital Service Organization - 501(e)"
"40" "40- Apostolic and religious orgs. - 501(d)"
"24" "24-Trust described in Section 4049 of ERISA"
"26" "26- State-Sponsored High Risk Health Insurance Organizations"
"93" "93- 1381(a)(2) Taxable Farmers Cooperative"
"92" "92- 4947(a)(1) Private Foundations"
"91" "91- 4947(a)(1) Public Charity (Files 990/990-EZ)"
"80" "80- Farmers' Cooperatives"
"90" "90- 4947(a)(2) Split Interest Trust"
"25" "25- Title Holding Company for Pensions, etc"
"18" "18- Employee funded pension trusts, providing benefits under a pension plan funded by employees..."
"15" "15- Mutual insurance cos. ar associations, providing insurance to members substantially at cost..."
"14" "14- State-chartered credit unions, mutual reserve funds, offering loans to members..."
"13" "13- Cemetery companies, providing burial and incidental activities for members."
"12" "12- Benevolent life insurance associations, mutual ditch or irrigation companies, mutual or coop..."
"11" "11- Teachers retirement fund associations."
"10" "10- Domestic fraternal societies and assoc's-lodges devoting their net earnings to charitable..."
"09" "09- Voluntary employees' beneficiary ass'ns (including fed. employees' voluntary beneficiary..."
"08" "08- Fraternal beneficiary societies and associations, with lodges providing for payment of life..."
"07" "07- Social and recreational clubs which provide pleasure, recreation, and social activities."
"06" "06- Business leagues, chambers of commerce, real estate boards, etc. formed to improve conditions..."
"05" "05- Labor, agricultural, horticultural organizations. These are eduactional or instruct. grps..."
"03" "03- Religious, educational, charitable, scientific, and literary organizations..."
"02" "02- Title holding corporation for a tax-exempt organization."
"01" "01- Corporations originated under Act of Congress, including Federal Credit Unions"
"17" "17- Supplemental unemployment benefit trusts, providing payments of suppl. unemployment comp..."
"19" "19- Post or organization of war veterans."
.
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
. CACHE.
EXECUTE.
DATASET NAME temp WINDOW=FRONT.
.