Table cms.mbsf_d_2011

Overview for cms.mbsf_d_2011

Primary Key: FILE, RECORD

SQL/DDL Statement

CREATE TABLE  cms.mbsf_d_2011 (
	BENE_ID VARCHAR(15),
	RFRNC_YR INT,
	CRDCOVSW VARCHAR(1),
	PLNCOVMO VARCHAR(2),
	RDSCOVMO VARCHAR(2),
	DUAL_MO VARCHAR(2),
	CNTRCT01 VARCHAR(5),
	CNTRCT02 VARCHAR(5),
	CNTRCT03 VARCHAR(5),
	CNTRCT04 VARCHAR(5),
	CNTRCT05 VARCHAR(5),
	CNTRCT06 VARCHAR(5),
	CNTRCT07 VARCHAR(5),
	CNTRCT08 VARCHAR(5),
	CNTRCT09 VARCHAR(5),
	CNTRCT10 VARCHAR(5),
	CNTRCT11 VARCHAR(5),
	CNTRCT12 VARCHAR(5),
	PBPID01 VARCHAR(3),
	PBPID02 VARCHAR(3),
	PBPID03 VARCHAR(3),
	PBPID04 VARCHAR(3),
	PBPID05 VARCHAR(3),
	PBPID06 VARCHAR(3),
	PBPID07 VARCHAR(3),
	PBPID08 VARCHAR(3),
	PBPID09 VARCHAR(3),
	PBPID10 VARCHAR(3),
	PBPID11 VARCHAR(3),
	PBPID12 VARCHAR(3),
	SGMTID01 VARCHAR(3),
	SGMTID02 VARCHAR(3),
	SGMTID03 VARCHAR(3),
	SGMTID04 VARCHAR(3),
	SGMTID05 VARCHAR(3),
	SGMTID06 VARCHAR(3),
	SGMTID07 VARCHAR(3),
	SGMTID08 VARCHAR(3),
	SGMTID09 VARCHAR(3),
	SGMTID10 VARCHAR(3),
	SGMTID11 VARCHAR(3),
	SGMTID12 VARCHAR(3),
	CSTSHR01 VARCHAR(2),
	CSTSHR02 VARCHAR(2),
	CSTSHR03 VARCHAR(2),
	CSTSHR04 VARCHAR(2),
	CSTSHR05 VARCHAR(2),
	CSTSHR06 VARCHAR(2),
	CSTSHR07 VARCHAR(2),
	CSTSHR08 VARCHAR(2),
	CSTSHR09 VARCHAR(2),
	CSTSHR10 VARCHAR(2),
	CSTSHR11 VARCHAR(2),
	CSTSHR12 VARCHAR(2),
	RDSIND01 VARCHAR(1),
	RDSIND02 VARCHAR(1),
	RDSIND03 VARCHAR(1),
	RDSIND04 VARCHAR(1),
	RDSIND05 VARCHAR(1),
	RDSIND06 VARCHAR(1),
	RDSIND07 VARCHAR(1),
	RDSIND08 VARCHAR(1),
	RDSIND09 VARCHAR(1),
	RDSIND10 VARCHAR(1),
	RDSIND11 VARCHAR(1),
	RDSIND12 VARCHAR(1),
	DUAL_01 VARCHAR(2),
	DUAL_02 VARCHAR(2),
	DUAL_03 VARCHAR(2),
	DUAL_04 VARCHAR(2),
	DUAL_05 VARCHAR(2),
	DUAL_06 VARCHAR(2),
	DUAL_07 VARCHAR(2),
	DUAL_08 VARCHAR(2),
	DUAL_09 VARCHAR(2),
	DUAL_10 VARCHAR(2),
	DUAL_11 VARCHAR(2),
	DUAL_12 VARCHAR(2),
	FILE VARCHAR(128),
	RECORD BIGSERIAL,
	YEAR INT GENERATED ALWAYS AS (RFRNC_YR) STORED,
	PRIMARY KEY (FILE, RECORD)
);
CREATE INDEX  mbsf_d_2011_FILE_idx ON cms.mbsf_d_2011 USING BTREE (FILE) ;
COMMENT ON table cms.mbsf_d_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.336820';

---

Columns:

Column Name	Column Type	Datatype
bene_id		VARCHAR(15)
cntrct01		VARCHAR(5)
cntrct02		VARCHAR(5)
cntrct03		VARCHAR(5)
cntrct04		VARCHAR(5)
cntrct05		VARCHAR(5)
cntrct06		VARCHAR(5)
cntrct07		VARCHAR(5)
cntrct08		VARCHAR(5)
cntrct09		VARCHAR(5)
cntrct10		VARCHAR(5)
cntrct11		VARCHAR(5)
cntrct12		VARCHAR(5)
crdcovsw		VARCHAR(1)
cstshr01		VARCHAR(2)
cstshr02		VARCHAR(2)
cstshr03		VARCHAR(2)
cstshr04		VARCHAR(2)
cstshr05		VARCHAR(2)
cstshr06		VARCHAR(2)
cstshr07		VARCHAR(2)
cstshr08		VARCHAR(2)
cstshr09		VARCHAR(2)
cstshr10		VARCHAR(2)
cstshr11		VARCHAR(2)
cstshr12		VARCHAR(2)
dual_01		VARCHAR(2)
dual_02		VARCHAR(2)
dual_03		VARCHAR(2)
dual_04		VARCHAR(2)
dual_05		VARCHAR(2)
dual_06		VARCHAR(2)
dual_07		VARCHAR(2)
dual_08		VARCHAR(2)
dual_09		VARCHAR(2)
dual_10		VARCHAR(2)
dual_11		VARCHAR(2)
dual_12		VARCHAR(2)
dual_mo		VARCHAR(2)
file	file	VARCHAR(128)
pbpid01		VARCHAR(3)
pbpid02		VARCHAR(3)
pbpid03		VARCHAR(3)
pbpid04		VARCHAR(3)
pbpid05		VARCHAR(3)
pbpid06		VARCHAR(3)
pbpid07		VARCHAR(3)
pbpid08		VARCHAR(3)
pbpid09		VARCHAR(3)
pbpid10		VARCHAR(3)
pbpid11		VARCHAR(3)
pbpid12		VARCHAR(3)
plncovmo		VARCHAR(2)
rdscovmo		VARCHAR(2)
rdsind01		VARCHAR(1)
rdsind02		VARCHAR(1)
rdsind03		VARCHAR(1)
rdsind04		VARCHAR(1)
rdsind05		VARCHAR(1)
rdsind06		VARCHAR(1)
rdsind07		VARCHAR(1)
rdsind08		VARCHAR(1)
rdsind09		VARCHAR(1)
rdsind10		VARCHAR(1)
rdsind11		VARCHAR(1)
rdsind12		VARCHAR(1)
record		BIGSERIAL
rfrnc_yr		INT
sgmtid01		VARCHAR(3)
sgmtid02		VARCHAR(3)
sgmtid03		VARCHAR(3)
sgmtid04		VARCHAR(3)
sgmtid05		VARCHAR(3)
sgmtid06		VARCHAR(3)
sgmtid07		VARCHAR(3)
sgmtid08		VARCHAR(3)
sgmtid09		VARCHAR(3)
sgmtid10		VARCHAR(3)
sgmtid11		VARCHAR(3)
sgmtid12		VARCHAR(3)
year	generated	INT