_dta: 1. by Jean Roth , jroth@nber.org , 17 Jul 2015 2. Source: imppuf07_apr2007.xls workbook imppuf07_apr2007 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. FY 2007 had one wageadj505 for the first part of the fiscal year and another for the second half 2. 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. FY 2007 had one sec505elig for the first part of the fiscal year and another for the second half 2. 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 wageindex: 1. FY 2007 had one wageindex for the first part of the fiscal year and another for the second half 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. FY 2007 had one postreclma for the first part of the fiscal year and another for the second half 2. post Reclassification CBSA for FY prwageindex: 1. FY 2007 had one prwageindex for the first part of the fiscal year and another for the second half 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. FY 2007 had one reclass for the first part of the fiscal year and another for the second half 2. 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 gaf: 1. FY 2007 had one gaf for the first part of the fiscal year and another for the second half prgaf: 1. FY 2007 had one prgaf for the first part of the fiscal year and another for the second half 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,677 vars: 72 17 Jul 2015 17:00 size: 1,695,097 (_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) sec508lma str7 %9s Section 508 Labor Market Area if applicable speclma str5 %9s Special Exception Labor Market Area if applicable sec508prov str3 %9s Section 508 Provider wageadj505 double %10.0g * Wage adjustment for providers who are eligible wageadj505a double %10.0g Wage adjustment for providers who are eligible 1st 1/2 FY wageadj505b str5 %9s Wage adjustment for providers who are eligible 2nd 1/2 FY sec505elig str3 %9s * Section 505 eligible 'YES' = eligible to receive a wage index adjustment sec505eliga str3 %9s Section 505 eligible 'YES' = eligible to receive a wage index adjustment 1st 1/2 sec505eligb str3 %9s Section 505 eligible 'YES' = eligible to receive a wage index adjustment 2nd 1/2 sec401hosp str3 %9s * Section 401 hospital - urban providers redesignated as rural wageindex float %9.0g * Wage Index for FY wageindexa double %10.0g Post Reclass Wage Index_a wageindexb double %10.0g Post Reclass Wage Index_b 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 hsp_mdh double %10.0g HSP_MDH 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 postreclmaa str5 %9s Finalized Post Reclassification CBSA for 1st 1/2 FY postreclmab str5 %9s Finalized Post Reclassification CBSA for 2nd 1/2 FY prwageindex float %9.0g * Puerto Rico Specific Wage Index for FY prwageindexa double %10.0g Puerto Rico Specific Wage Index for 1st 1/2 FY prwageindexb double %10.0g Puerto Rico Specific Wage Index for 2nd 1/2 FY ptype int %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 reclass1 str1 %9s Finalized Reclass Status for 1st 1/2 FY reclass2 str1 %9s Finalized Reclass Status for 2nd 1/2 FY bills long %10.0g Total number of Medicare cases for the provider from the FY N-2 MEDPAR caseta23 double %10.0g Transfer Adjusted Cases under Grouper V23 and FY N-1 Post Acute Transfer Policy tacmiv23 double %10.0g Transfer adjusted Case Mix Index under Grouper V23 cmiv23 double %10.0g Case Mix Index under Grouper V23 for SCH/ former MDH providers caseta double %10.0g Transfer Adjusted Cases casetagroup byte %10.0g DRG Grouper Version for caseta caseta24 double %10.0g Transfer Adjusted Cases under Grouper V24 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 tacmiv24 double %10.0g Transfer adjusted Case Mix Index under Grouper V24 cmiv double %10.0g Case Mix Index cmivgroup byte %10.0g DRG Grouper Version for cmiv cmiv24 double %10.0g Case Mix Index under Grouper V24 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 float %9.0g * Post Reclass Geographic adjustment factor (GAF) for Capital FY gafa double %10.0g Post Reclass Geographic adjustment factor (GAF) for Capital for 1st 1/2 FY gafb double %10.0g Post Reclass Geographic adjustment factor (GAF) for Capital for 2nd 1/2 FY prgaf float %9.0g * Post Reclass GAF for Capital for Puerto Rico Providers FY prgafa double %10.0g Post Reclass GAF for Capital for Puerto Rico Providers FY for 1st 1/2 FY prgafb double %10.0g Post Reclass GAF for Capital for Puerto Rico Providers FY for 2nd 1/2 FY 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 float %9.0g Fiscal Year * indicated variables have notes ------------------------------------------------------------------------------------------------------------------------------------ Sorted by: provider