View medicare.ps

Overview for medicare.ps

Patient Summary view. Combines multiple patient summary (aka MBSF) files into a single view, transforming columns to the same type

---

Columns:

Column Name	Column Type	Datatype
age	transformed	INT
bene_id		string
buyin_cvg_count	transformed	INT
buyin_indicators	transformed	CHAR(1)[12]
curec	transformed	INT
dob	transformed	date
dod	transformed	date
dod_ndi	computed	DATE
file		string
fips2	computed	string
hmo_cvg_count	transformed	INT
hmo_indicators	transformed	CHAR(1)[12]
orec	transformed	INT
race	transformed	VARCHAR
race_rti	computed	string
record		string
sex	transformed	VARCHAR
ssa2	computed	string
ssa3		string
state	computed	string
year	computed	string
zip	transformed	INT
zip4	computed	INT