View medicare.ip

Overview for medicare.ip

Inpatient Adminissions view. Combines multiple inpatient admissions files (aka MedPar) into a single view, transforming columns to the same type

---

Columns:

Column Name	Column Type	Datatype
adm_day_of_week	transformed	INT
admission_date	transformed	DATE
admission_date_raw	transformed	VARCHAR
admsn_type_cd	transformed	CHAR(1)
bene_blood_ddctbl_amt		NUMERIC
bene_id		string
bene_ip_ddctbl_amt		NUMERIC
bene_prmry_pyr_amt		NUMERIC
bene_pta_coinsrnc_amt		NUMERIC
diag1		varchar
diag10		varchar
diag11		varchar
diag12		varchar
diag13		varchar
diag14		varchar
diag15		varchar
diag16		varchar
diag17		varchar
diag18		varchar
diag19		varchar
diag2		varchar
diag20		varchar
diag21		varchar
diag22		varchar
diag23		varchar
diag24		varchar
diag25		varchar
diag3		varchar
diag4		varchar
diag5		varchar
diag6		varchar
diag7		varchar
diag8		varchar
diag9		varchar
discharge_date	transformed	DATE
discharge_date_raw	transformed	VARCHAR
drg_outlier_pmt_amt		NUMERIC
drg_price_amt		NUMERIC
dschrg_dstntn_cd	transformed	CHAR(2)
dschrgcd		CHAR(1)
file		string
fips2	computed	string
los_day_cnt	transformed	INT
mdcr_pmt_amt		NUMERIC
pass_thru_amt		NUMERIC
record		string
src_admsn_cd	transformed	CHAR(1)
ssa2	computed	string
state	computed	string
year	computed	INT
zip	transformed	INT
zip4	computed	INT