_dta: 1. by Jean Roth , jroth@nber.org , 17 Jul 2015 2. Source: ipps_imppuf06_fr_ext.xls workbook nk_imppuf06_july05 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 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,824 vars: 58 17 Jul 2015 17:00 size: 1,499,008 (_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 str5 %9s Section 508 Labor Market Area if applicable cbsaex str5 %9s Contains the Reclassifed CBSA for Providers Reclassing flag508 str3 %9s Reclassifying under Section 508 outcomadj str5 %9s Outcommuting Adjustment Applied to the Wage Index of Eligible Providers per Sec 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 hsp8287 double %10.0g 82/87 Hospital Specific Rate updated to FY 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 cmiv22 double %10.0g Case Mix Index under Grouper V22 for SCH/ former MDH providers otacmiv22 double %10.0g Trans Adj CMI Grouper V22 applies FY 2005 PAC policy ocaseta22 double %14.2f Trans Adj case count under Grouper V22 applies FY 2005 PAC policy tacmiv22 double %10.0g Transfer adjusted Case Mix Index under Grouper V22 caseta22 double %14.2f Transfer Adjusted Cases under Grouper V22 and FY N-1 Post Acute Transfer Policy cmiv double %10.0g Case Mix Index cmivgroup byte %10.0g DRG Grouper Version for cmiv cmiv23 double %10.0g Case Mix Index under Grouper V23 for SCH/ former MDH providers tacmiv double %10.0g Transfer Adjusted Case Mix Index tacmivgroup byte %10.0g DRG Grouper Version for tacmiv tacmiv23 double %10.0g Transfer adjusted Case Mix Index under Grouper V23 caseta double %10.0g Transfer Adjusted Cases casetagroup byte %10.0g DRG Grouper Version for caseta caseta23 double %10.0g Transfer Adjusted Cases under Grouper V23 and FY N-1 Post Acute Transfer Policy 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 prgaf double %10.0g Post Reclass GAF for Capital for Puerto Rico Providers 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