Table cms.mbsf_ab_2011

Overview for cms.mbsf_ab_2011

Primary Key: FILE, RECORD

SQL/DDL Statement

CREATE TABLE  cms.mbsf_ab_2011 (
	BENE_ID VARCHAR(15),
	RFRNC_YR INT,
	FIVEPCT VARCHAR(1),
	EFIVEPCT VARCHAR(1),
	COVSTART DATE,
	CRNT_BIC VARCHAR(2),
	STATE_CD VARCHAR(2),
	CNTY_CD VARCHAR(3),
	BENE_ZIP VARCHAR(9),
	AGE INT,
	BENE_DOB DATE,
	V_DOD_SW VARCHAR(1),
	DEATH_DT DATE,
	NDI_DEATH_DT DATE,
	SEX VARCHAR(1),
	RACE VARCHAR(1),
	RTI_RACE_CD VARCHAR(1),
	OREC VARCHAR(1),
	CREC VARCHAR(1),
	ESRD_IND VARCHAR(1),
	MS_CD VARCHAR(2),
	A_TRM_CD VARCHAR(1),
	B_TRM_CD VARCHAR(1),
	A_MO_CNT INT,
	B_MO_CNT INT,
	BUYIN_MO INT,
	HMO_MO INT,
	BUYIN01 VARCHAR(1),
	BUYIN02 VARCHAR(1),
	BUYIN03 VARCHAR(1),
	BUYIN04 VARCHAR(1),
	BUYIN05 VARCHAR(1),
	BUYIN06 VARCHAR(1),
	BUYIN07 VARCHAR(1),
	BUYIN08 VARCHAR(1),
	BUYIN09 VARCHAR(1),
	BUYIN10 VARCHAR(1),
	BUYIN11 VARCHAR(1),
	BUYIN12 VARCHAR(1),
	HMOIND01 VARCHAR(1),
	HMOIND02 VARCHAR(1),
	HMOIND03 VARCHAR(1),
	HMOIND04 VARCHAR(1),
	HMOIND05 VARCHAR(1),
	HMOIND06 VARCHAR(1),
	HMOIND07 VARCHAR(1),
	HMOIND08 VARCHAR(1),
	HMOIND09 VARCHAR(1),
	HMOIND10 VARCHAR(1),
	HMOIND11 VARCHAR(1),
	HMOIND12 VARCHAR(1),
	FILE VARCHAR(128),
	RECORD BIGSERIAL,
	STATE VARCHAR(2) GENERATED ALWAYS AS (STATE_CD) STORED,
	YEAR INT GENERATED ALWAYS AS (RFRNC_YR) STORED,
	ZIP VARCHAR(9) GENERATED ALWAYS AS (BENE_ZIP) STORED,
	PRIMARY KEY (FILE, RECORD)
);
CREATE INDEX  mbsf_ab_2011_FILE_idx ON cms.mbsf_ab_2011 USING BTREE (FILE) ;
COMMENT ON table cms.mbsf_ab_2011 IS 'CREATED BY Dorieh: {"version": "0.2.3", "url": "https://github.com/NSAPH-Data-Platform/dorieh", "commit": "bf4644403297aaf478f6a42717508dde55da409a"}. Created at 2024-08-12 13:31:09.194103';

---

Columns:

Column Name	Column Type	Datatype
a_mo_cnt		INT
a_trm_cd		VARCHAR(1)
age		INT
b_mo_cnt		INT
b_trm_cd		VARCHAR(1)
bene_dob		DATE
bene_id		VARCHAR(15)
bene_zip		VARCHAR(9)
buyin01		VARCHAR(1)
buyin02		VARCHAR(1)
buyin03		VARCHAR(1)
buyin04		VARCHAR(1)
buyin05		VARCHAR(1)
buyin06		VARCHAR(1)
buyin07		VARCHAR(1)
buyin08		VARCHAR(1)
buyin09		VARCHAR(1)
buyin10		VARCHAR(1)
buyin11		VARCHAR(1)
buyin12		VARCHAR(1)
buyin_mo		INT
cnty_cd		VARCHAR(3)
covstart		DATE
crec		VARCHAR(1)
crnt_bic		VARCHAR(2)
death_dt		DATE
efivepct		VARCHAR(1)
esrd_ind		VARCHAR(1)
file	file	VARCHAR(128)
fivepct		VARCHAR(1)
hmo_mo		INT
hmoind01		VARCHAR(1)
hmoind02		VARCHAR(1)
hmoind03		VARCHAR(1)
hmoind04		VARCHAR(1)
hmoind05		VARCHAR(1)
hmoind06		VARCHAR(1)
hmoind07		VARCHAR(1)
hmoind08		VARCHAR(1)
hmoind09		VARCHAR(1)
hmoind10		VARCHAR(1)
hmoind11		VARCHAR(1)
hmoind12		VARCHAR(1)
ms_cd		VARCHAR(2)
ndi_death_dt		DATE
orec		VARCHAR(1)
race		VARCHAR(1)
record		BIGSERIAL
rfrnc_yr		INT
rti_race_cd		VARCHAR(1)
sex		VARCHAR(1)
state	generated	VARCHAR(2)
state_cd		VARCHAR(2)
v_dod_sw		VARCHAR(1)
year	generated	INT
zip	generated	VARCHAR(9)