_dta: 1. by Jean Roth , jroth@nber.org , 17 Jul 2015 2. Source: imppuf08_103107.xls workbook imppuf08_103107 sheet provider: 1. 6 digit Medicare provider number; the first 2 digits are the state code provname: 1. Name of Medicare provider from OSCAR.("blank" = unknown) geolma: 1. The Geographic CBSA location based on OMB's Core Based Statistical Area (CBSA) designations. 2. The CBSA assignment is based on where the provider is physically located based on SSA state and county code information. 3. Rural areas are designated by 2-digit SSA state codes. prereclma: 1. Pre-reclassification CBSA paylma: 1. Payment CBSA ( urban vs rural) for purposes of determining capital & DSH payments wageadj505: 1. Wage adjustment for providers who are eligible to receive a wage index adjustment under Sec. 505 of P.L. 108-173 for FY sec505elig: 1. A 'YES' denotes providers eligible to receive a wage index adjustment under Sec. 505 of P.L. 108-173 for FY sec401hosp: 1. A 'YES' denotes urban providers redesignated as rural under CFR 412.103 - Sec 401 of BIPA cola: 1. Cost of Living Adjustment factor obtained from the U.S. Office of Personnel Management for IPPS providers located in Alaska or Hawaii for IPPS operating payments resbed: 1. Resident to Bed Ratio. Used to determine IME factor for operating PPS payments ssacounty: 1. SSA state county code. First two digits represent the state code and the last 4 digits represent the county code. 2. SSA system is used to Identify the county in which provider is geographically located 3. and this field be used in conjunction with the msa/cbsa crosswalk file. rday: 1. Resident to Average Daily Census (ADC) ratio. Used to calculate the IME adjustment for Capital PPS adc: 1. The number of total beds obtained from cost report data.** opccr: 1. Ratio of Medicare operating costs to Medicare covered charges from the March 2013 update of the Provider Specific File (PSF). 2. CCRs do not have the inflation factor applied. cpccr: 1. Ratio of Medicare capital costs to Medicare covered charges from the March 2013 update of the Provider Specific File (PSF). 2. CCRs do not have the inflation factor applied. dshpct: 1. Disproportionate Share Hospital Patient Percentage as determined from most recent cost report data & SSA data postreclma: 1. post Reclassification CBSA for FY ptype: 1. Type of provider - key: 0=IPPS; 7=RURAL REFERRAL CENTER (RRC); 8=INDIAN; 14=Medicare Dependent Hospital (MDH); 2. 15=MDH/RRC; 16=Sole Community Hospital (SCH); 17=SCH/RRC; 21=ESSENTIAL ACCESS CMTY HSP (EACH); 22=EACH/RRC; 3. Reflects expiration of Medicare Dependent Hospital payment status where providers have the provider type of 14 or 15 for FY reclass: 1. Reclass Status FY 2014: N -provider did not reclassify; W -provider reclassified for wage index ; L provider reclassified under 1886(d)(8)(B) of the SSA; S-provider redesignated as rural under Sec. 401 of BIPA. region: 1. 1=NEW ENGLAND; 2=MIDDLE ATLANTIC; 3=SOUTH ATLANTIC; 4=EAST NORTH CENTRAL; 5=EAST SOUTH CENTRAL; 6=WEST NORTH CENTRAL; 7=WEST SOUTH CENTRAL; 8-=MOUNTAIN; 9=PACIFIC; 40=PUERTO RICO urgeo: 1. Large urban, Other Urban or Rural designation of the providers geographic CBSA urspa: 1. Urban or Rural designation based on payment CBSA tchop: 1. IME adjustment factor for Operating PPS tchcp: 1. IME adjustment factor for Captial PPS dshopg: 1. Operating Disproportionate Share Hospital (DSH) adjustment. 2. Reflects a 75% reduction to the DSH adjustment required under Section 3133 of the Affordable Care Act dshcpg: 1. Capital Disproportionate Share (DSH) adjustment obs: 3,615 vars: 52 17 Jul 2015 17:05 size: 1,286,940 (_dta has notes) ------------------------------------------------------------------------------------------------------------------------------------ storage display value variable name type format label variable label ------------------------------------------------------------------------------------------------------------------------------------ provider str6 %9s * Provider Number provname str50 %50s * Provider Name geolma str5 %9s * Geographic Labor Market Area prereclma str5 %9s * Pre Reclass Labor Market Area - CBSA paylma str5 %9s * Payment Labor Market Area CBSA (for purposes of Capital and DSH) wageadj505 double %10.0g * Wage adjustment for providers who are eligible sec505elig str3 %9s * Section 505 eligible 'YES' = eligible to receive a wage index adjustment sec401hosp str3 %9s * Section 401 hospital - urban providers redesignated as rural wageindex double %10.0g Wage Index for FY cola double %10.0g * Cost of Living Adjustment resbed double %10.0g * Resident to Bed Ratio Resident to Bed Ratio. Used to determine IME factor for ssacounty str5 %9s * SSA State County Code hsprate double %10.0g Hospital Specific Payment (HSP) Rate for FY hsp2006 float %9.0g Hospital Specific Rate 2006 rday double %10.0g * Resident to Average Daily Census (ADC) ratio. Used to calculate the IME adj... beds int %10.0g The number of total beds obtained from cost report data-'zero' may mean missing adc int %10.0g * Average Daily Census - A 'zero' value may indicate unavailable or incomplete dat opccr double %10.0g * Ratio of Medicare operating costs to Medicare covered charges cpccr double %10.0g * Ratio of Medicare capital costs to Medicare covered charges dshpct double %10.0g * Disproportionate Share Hospital Patient percent postreclma str5 %9s * Finalized Post Reclassification CBSA for FY prwageindex double %10.0g Puerto Rico Specific Wage Index for FY ptype byte %10.0g * Provider Type lugar str5 %9s Provider is located in a Lugar County as defined in 1886(d)(8)(B) of the Act reclass str1 %9s * Finalized Reclass Status for FY bills long %10.0g Total number of Medicare cases for the provider from the FY N-2 MEDPAR caseta24 double %10.0g Transfer Adjusted Cases under Grouper V24 and FY N-1 Post Acute Transfer Policy tacmiv24 double %10.0g Transfer adjusted Case Mix Index under Grouper V24 cmiv24 double %10.0g Case Mix Index under Grouper V24 for SCH/ former MDH providers caseta double %10.0g Transfer Adjusted Cases casetagroup byte %10.0g DRG Grouper Version for caseta caseta25 double %10.0g Transfer Adjusted Cases under Grouper V25 and FY N-1 Post Acute Transfer Policy tacmiv double %10.0g Transfer Adjusted Case Mix Index tacmivgroup byte %10.0g DRG Grouper Version for tacmiv tacmiv25 double %10.0g Transfer adjusted Case Mix Index under Grouper V25 cmiv double %10.0g Case Mix Index cmivgroup byte %10.0g DRG Grouper Version for cmiv cmiv25 double %10.0g Case Mix Index under Grouper V25 for SCH/ former MDH providers region byte %10.0g * Region urgeo str6 %9s * Large Urban, Other Urban or Rural Designation of the Providers Geographic CBSA urspa str6 %9s * Urban or Rural designation based on payment CBSA tchop double %10.0g * IME adjustment factor for Operating PPS tchcp double %10.0g * IME adjustment factor for Captial PPS gaf double %10.0g Post Reclass Geographic adjustment factor (GAF) for Capital FY al double %10.0g Puerto Rico Specific Post Reclass GAF colacp double %10.0g Capital COLA factor for hospitals located in Alaska and Hawaii dshopg double %10.0g * Operating Disproportionate Share Hospital (DSH) adjustment dshcpg double %10.0g * Capital Disproportionate Share (DSH) adjustment outf double %10.0g Estimated operating outlier payments as a percentage of the provider's Federal o coutf double %10.0g Estimated capital outlier payments as a percentage of the provider's Federal cap mcr_pct double %10.0g Medicare days as a percent of total inpatient days (not available for all provid fyear int %9.0g Fiscal Year * indicated variables have notes ------------------------------------------------------------------------------------------------------------------------------------ Sorted by: provider