Table cms.medpar_2017

Overview for cms.medpar_2017

Primary Key: FILE, RECORD

SQL/DDL Statement

CREATE TABLE  cms.medpar_2017 (
	BENE_ID VARCHAR(15),
	MEDPARID VARCHAR(15),
	MEDPAR_YR_NUM VARCHAR(4),
	CLM_TYPE VARCHAR(2),
	BIC VARCHAR(2),
	EQ_BIC VARCHAR(2),
	AGE_CNT INT,
	SEX VARCHAR(1),
	RACE VARCHAR(1),
	MS_CD VARCHAR(2),
	STATE_CD VARCHAR(2),
	CNTY_CD VARCHAR(3),
	BENE_ZIP VARCHAR(5),
	DSCHRGCD VARCHAR(1),
	FICARR VARCHAR(5),
	WRNGCD VARCHAR(18),
	GHOPDCD VARCHAR(1),
	PPS_IND VARCHAR(1),
	ORGNPINM VARCHAR(10),
	PRVDRNUM VARCHAR(10),
	SPCLUNIT VARCHAR(1),
	SSLSSNF VARCHAR(1),
	ACTV_XREF_IND VARCHAR(1),
	SLCT_RSN_CD VARCHAR(1),
	FACLMCNT INT,
	ACRTNDT DATE,
	EXHST_DT DATE,
	QLFYFROM DATE,
	QLFYTHRU DATE,
	SRC_ADMS VARCHAR(1),
	TYPE_ADM VARCHAR(1),
	ADMSNDAY VARCHAR(1),
	ADMSNDT DATE,
	DSCHRGDT DATE,
	DSTNTNCD VARCHAR(2),
	CVRLVLDT DATE,
	DEATHDT DATE,
	DEATHCD VARCHAR(1),
	DEATHDAY INT,
	SSICD VARCHAR(1),
	SSIDAY INT,
	INTRNL_USE_SSI_DATA VARCHAR(1),
	IPSBCD VARCHAR(3),
	FILDTCD VARCHAR(1),
	SMPLSIZE VARCHAR(1),
	LOSCNT INT,
	OUTLRDAY INT,
	UTIL_DAY INT,
	COIN_DAY INT,
	LRD_USE INT,
	COIN_AMT INT,
	DED_AMT INT,
	BLDDEDAM INT,
	PRPAY_CD VARCHAR(1),
	PRPAYAMT INT,
	DRG_CD VARCHAR(3),
	OUTLR_CD VARCHAR(1),
	OUTLRAMT INT,
	DRGPRICE INT,
	DISP_SHR INT,
	IME_AMT INT,
	PASSTHRU INT,
	PPS_CPTL INT,
	IP_LOW_VOL_PYMT_AMT INT,
	TOTCHRG INT,
	CVRCHRG INT,
	PMT_AMT INT,
	ACMDTNS INT,
	DPRTMNTL INT,
	PRVTDAY INT,
	SPRVTDAY INT,
	WARDDAY INT,
	ICARECNT INT,
	CRNRYDAY INT,
	PRVTAMT INT,
	SPRVTAMT INT,
	WARDAMT INT,
	ICAREAMT INT,
	CRNRYAMT INT,
	OTHRAMT INT,
	PHRMCAMT INT,
	SUPLYAMT INT,
	DME_AMT INT,
	UDME_AMT INT,
	PHYTHAMT INT,
	OCPTLAMT INT,
	SPCH_AMT INT,
	INHLTAMT INT,
	BLOODAMT INT,
	BLDADMIN INT,
	BLDFRNSH INT,
	OROOMAMT INT,
	LTHTRPSY INT,
	CRDLGY INT,
	ANSTHSA INT,
	LAB_AMT INT,
	RDLGYAMT INT,
	MRI_AMT INT,
	OPSRVC INT,
	ER_AMT INT,
	AMBLNC INT,
	PROFFEES INT,
	ORGNAMT INT,
	ESRDSETG INT,
	CLNC_AMT INT,
	ICUINDCD VARCHAR(1),
	CRNRY_CD VARCHAR(1),
	PHRMCYCD VARCHAR(1),
	TRNSPLNT VARCHAR(1),
	ONCLGYSW VARCHAR(1),
	DGNSTCSW VARCHAR(1),
	THRPTCSW VARCHAR(1),
	NUCLR_SW VARCHAR(1),
	CTSCANSW VARCHAR(1),
	IMGNG_SW VARCHAR(1),
	OPSRVCCD VARCHAR(1),
	ORGNCD VARCHAR(2),
	ESRD_CD VARCHAR(2),
	ESRDSTG1 VARCHAR(2),
	ESRDSTG2 VARCHAR(2),
	ESRDSTG3 VARCHAR(2),
	ESRDSTG4 VARCHAR(2),
	ESRDSTG5 VARCHAR(2),
	AD_DGNS VARCHAR(7),
	ADMTG_DGNS_VRSN_CD VARCHAR(1),
	DGNSCNT INT,
	DGNS_VRSN_CD VARCHAR(1),
	DGNS_VRSN_CD_1 VARCHAR(1),
	DGNS_VRSN_CD_2 VARCHAR(1),
	DGNS_VRSN_CD_3 VARCHAR(1),
	DGNS_VRSN_CD_4 VARCHAR(1),
	DGNS_VRSN_CD_5 VARCHAR(1),
	DGNS_VRSN_CD_6 VARCHAR(1),
	DGNS_VRSN_CD_7 VARCHAR(1),
	DGNS_VRSN_CD_8 VARCHAR(1),
	DGNS_VRSN_CD_9 VARCHAR(1),
	DGNS_VRSN_CD_10 VARCHAR(1),
	DGNS_VRSN_CD_11 VARCHAR(1),
	DGNS_VRSN_CD_12 VARCHAR(1),
	DGNS_VRSN_CD_13 VARCHAR(1),
	DGNS_VRSN_CD_14 VARCHAR(1),
	DGNS_VRSN_CD_15 VARCHAR(1),
	DGNS_VRSN_CD_16 VARCHAR(1),
	DGNS_VRSN_CD_17 VARCHAR(1),
	DGNS_VRSN_CD_18 VARCHAR(1),
	DGNS_VRSN_CD_19 VARCHAR(1),
	DGNS_VRSN_CD_20 VARCHAR(1),
	DGNS_VRSN_CD_21 VARCHAR(1),
	DGNS_VRSN_CD_22 VARCHAR(1),
	DGNS_VRSN_CD_23 VARCHAR(1),
	DGNS_VRSN_CD_24 VARCHAR(1),
	DGNS_VRSN_CD_25 VARCHAR(1),
	DGNSCD1 VARCHAR(7),
	DGNSCD2 VARCHAR(7),
	DGNSCD3 VARCHAR(7),
	DGNSCD4 VARCHAR(7),
	DGNSCD5 VARCHAR(7),
	DGNSCD6 VARCHAR(7),
	DGNSCD7 VARCHAR(7),
	DGNSCD8 VARCHAR(7),
	DGNSCD9 VARCHAR(7),
	DGNSCD10 VARCHAR(7),
	DGNSCD11 VARCHAR(7),
	DGNSCD12 VARCHAR(7),
	DGNSCD13 VARCHAR(7),
	DGNSCD14 VARCHAR(7),
	DGNSCD15 VARCHAR(7),
	DGNSCD16 VARCHAR(7),
	DGNSCD17 VARCHAR(7),
	DGNSCD18 VARCHAR(7),
	DGNSCD19 VARCHAR(7),
	DGNSCD20 VARCHAR(7),
	DGNSCD21 VARCHAR(7),
	DGNSCD22 VARCHAR(7),
	DGNSCD23 VARCHAR(7),
	DGNSCD24 VARCHAR(7),
	DGNSCD25 VARCHAR(7),
	DGNS_POA VARCHAR(10),
	POA_DGNS_CD_CNT INT,
	POA_DGNS_1_IND_CD VARCHAR(1),
	POA_DGNS_2_IND_CD VARCHAR(1),
	POA_DGNS_3_IND_CD VARCHAR(1),
	POA_DGNS_4_IND_CD VARCHAR(1),
	POA_DGNS_5_IND_CD VARCHAR(1),
	POA_DGNS_6_IND_CD VARCHAR(1),
	POA_DGNS_7_IND_CD VARCHAR(1),
	POA_DGNS_8_IND_CD VARCHAR(1),
	POA_DGNS_9_IND_CD VARCHAR(1),
	POA_DGNS_10_IND_CD VARCHAR(1),
	POA_DGNS_11_IND_CD VARCHAR(1),
	POA_DGNS_12_IND_CD VARCHAR(1),
	POA_DGNS_13_IND_CD VARCHAR(1),
	POA_DGNS_14_IND_CD VARCHAR(1),
	POA_DGNS_15_IND_CD VARCHAR(1),
	POA_DGNS_16_IND_CD VARCHAR(1),
	POA_DGNS_17_IND_CD VARCHAR(1),
	POA_DGNS_18_IND_CD VARCHAR(1),
	POA_DGNS_19_IND_CD VARCHAR(1),
	POA_DGNS_20_IND_CD VARCHAR(1),
	POA_DGNS_21_IND_CD VARCHAR(1),
	POA_DGNS_22_IND_CD VARCHAR(1),
	POA_DGNS_23_IND_CD VARCHAR(1),
	POA_DGNS_24_IND_CD VARCHAR(1),
	POA_DGNS_25_IND_CD VARCHAR(1),
	DGNS_E_CD_CNT INT,
	DGNS_E_VRSN_CD VARCHAR(1),
	DGNS_E_VRSN_CD_1 VARCHAR(1),
	DGNS_E_VRSN_CD_2 VARCHAR(1),
	DGNS_E_VRSN_CD_3 VARCHAR(1),
	DGNS_E_VRSN_CD_4 VARCHAR(1),
	DGNS_E_VRSN_CD_5 VARCHAR(1),
	DGNS_E_VRSN_CD_6 VARCHAR(1),
	DGNS_E_VRSN_CD_7 VARCHAR(1),
	DGNS_E_VRSN_CD_8 VARCHAR(1),
	DGNS_E_VRSN_CD_9 VARCHAR(1),
	DGNS_E_VRSN_CD_10 VARCHAR(1),
	DGNS_E_VRSN_CD_11 VARCHAR(1),
	DGNS_E_VRSN_CD_12 VARCHAR(1),
	DGNS_E_1_CD VARCHAR(7),
	DGNS_E_2_CD VARCHAR(7),
	DGNS_E_3_CD VARCHAR(7),
	DGNS_E_4_CD VARCHAR(7),
	DGNS_E_5_CD VARCHAR(7),
	DGNS_E_6_CD VARCHAR(7),
	DGNS_E_7_CD VARCHAR(7),
	DGNS_E_8_CD VARCHAR(7),
	DGNS_E_9_CD VARCHAR(7),
	DGNS_E_10_CD VARCHAR(7),
	DGNS_E_11_CD VARCHAR(7),
	DGNS_E_12_CD VARCHAR(7),
	POA_DGNS_E_CD_CNT INT,
	POA_DGNS_E_1_IND_CD VARCHAR(1),
	POA_DGNS_E_2_IND_CD VARCHAR(1),
	POA_DGNS_E_3_IND_CD VARCHAR(1),
	POA_DGNS_E_4_IND_CD VARCHAR(1),
	POA_DGNS_E_5_IND_CD VARCHAR(1),
	POA_DGNS_E_6_IND_CD VARCHAR(1),
	POA_DGNS_E_7_IND_CD VARCHAR(1),
	POA_DGNS_E_8_IND_CD VARCHAR(1),
	POA_DGNS_E_9_IND_CD VARCHAR(1),
	POA_DGNS_E_10_IND_CD VARCHAR(1),
	POA_DGNS_E_11_IND_CD VARCHAR(1),
	POA_DGNS_E_12_IND_CD VARCHAR(1),
	PRCDRSW VARCHAR(1),
	PRCDRCNT INT,
	SRGCL_PRCDR_VRSN_CD VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_1 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_2 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_3 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_4 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_5 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_6 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_7 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_8 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_9 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_10 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_11 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_12 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_13 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_14 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_15 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_16 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_17 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_18 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_19 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_20 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_21 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_22 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_23 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_24 VARCHAR(1),
	SRGCL_PRCDR_VRSN_CD_25 VARCHAR(1),
	PRCDRCD1 VARCHAR(7),
	PRCDRCD2 VARCHAR(7),
	PRCDRCD3 VARCHAR(7),
	PRCDRCD4 VARCHAR(7),
	PRCDRCD5 VARCHAR(7),
	PRCDRCD6 VARCHAR(7),
	PRCDRCD7 VARCHAR(7),
	PRCDRCD8 VARCHAR(7),
	PRCDRCD9 VARCHAR(7),
	PRCDRCD10 VARCHAR(7),
	PRCDRCD11 VARCHAR(7),
	PRCDRCD12 VARCHAR(7),
	PRCDRCD13 VARCHAR(7),
	PRCDRCD14 VARCHAR(7),
	PRCDRCD15 VARCHAR(7),
	PRCDRCD16 VARCHAR(7),
	PRCDRCD17 VARCHAR(7),
	PRCDRCD18 VARCHAR(7),
	PRCDRCD19 VARCHAR(7),
	PRCDRCD20 VARCHAR(7),
	PRCDRCD21 VARCHAR(7),
	PRCDRCD22 VARCHAR(7),
	PRCDRCD23 VARCHAR(7),
	PRCDRCD24 VARCHAR(7),
	PRCDRCD25 VARCHAR(7),
	PRCDTCNT INT,
	PRCDRDT1 DATE,
	PRCDRDT2 DATE,
	PRCDRDT3 DATE,
	PRCDRDT4 DATE,
	PRCDRDT5 DATE,
	PRCDRDT6 DATE,
	PRCDRDT7 DATE,
	PRCDRDT8 DATE,
	PRCDRDT9 DATE,
	PRCDRDT10 DATE,
	PRCDRDT11 DATE,
	PRCDRDT12 DATE,
	PRCDRDT13 DATE,
	PRCDRDT14 DATE,
	PRCDRDT15 DATE,
	PRCDRDT16 DATE,
	PRCDRDT17 DATE,
	PRCDRDT18 DATE,
	PRCDRDT19 DATE,
	PRCDRDT20 DATE,
	PRCDRDT21 DATE,
	PRCDRDT22 DATE,
	PRCDRDT23 DATE,
	PRCDRDT24 DATE,
	PRCDRDT25 DATE,
	CLM_PTNT_RLTNSHP_CD VARCHAR(2),
	CARE_IMPRVMT_MODEL_1_CD VARCHAR(2),
	CARE_IMPRVMT_MODEL_2_CD VARCHAR(2),
	CARE_IMPRVMT_MODEL_3_CD VARCHAR(2),
	CARE_IMPRVMT_MODEL_4_CD VARCHAR(2),
	VBP_PRTCPNT_IND_CD VARCHAR(1),
	HRR_PRTCPNT_IND_CD VARCHAR(1),
	BNDLD_MODEL_DSCNT_PCT NUMERIC(7,4),
	VBP_ADJSTMT_PCT NUMERIC(15,12),
	HRR_ADJSTMT_PCT NUMERIC(8,5),
	INFRMTL_ENCTR_IND_SW VARCHAR(1),
	MA_TCHNG_IND_SW VARCHAR(1),
	PROD_RPLCMT_LIFECYC_SW VARCHAR(1),
	PROD_RPLCMT_RCLL_SW VARCHAR(1),
	CRED_RCVD_RPLCD_DVC_SW VARCHAR(1),
	OBSRVTN_SW VARCHAR(1),
	NEW_TCHNLGY_ADD_ON_AMT INT,
	BASE_OPRTG_DRG_AMT INT,
	OPRTG_HSP_AMT INT,
	MDCL_SRGCL_GNRL_AMT INT,
	MDCL_SRGCL_NSTRL_AMT INT,
	MDCL_SRGCL_STRL_AMT INT,
	TAKE_HOME_AMT INT,
	PRSTHTC_ORTHTC_AMT INT,
	MDCL_SRGCL_PCMKR_AMT INT,
	INTRAOCULAR_LENS_AMT INT,
	OXYGN_TAKE_HOME_AMT INT,
	OTHR_IMPLANTS_AMT INT,
	OTHR_SUPLIES_DVC_AMT INT,
	INCDNT_RDLGY_AMT INT,
	INCDNT_DGNSTC_SRVCS_AMT INT,
	MDCL_SRGCL_DRSNG_AMT INT,
	INVSTGTNL_DVC_AMT INT,
	MDCL_SRGCL_MISC_AMT INT,
	RDLGY_ONCOLOGY_AMT INT,
	RDLGY_DGNSTC_AMT INT,
	RDLGY_THRPTC_AMT INT,
	RDLGY_NUCLR_MDCN_AMT INT,
	RDLGY_CT_SCAN_AMT INT,
	RDLGY_OTHR_IMGNG_AMT INT,
	OPRTG_ROOM_AMT INT,
	OR_LABOR_DLVRY_AMT INT,
	CRDC_CATHRZTN_AMT INT,
	SQSTRTN_RDCTN_AMT INT,
	UNCOMPD_CARE_PYMT_AMT INT,
	BNDLD_ADJSTMT_AMT INT,
	VBP_ADJSTMT_AMT INT,
	HRR_ADJSTMT_AMT INT,
	EHR_PYMT_ADJSTMT_AMT INT,
	PPS_STD_VAL_PYMT_AMT INT,
	FINL_STD_AMT INT,
	HAC_RDCTN_PMT_AMT INT,
	IPPS_FLEX_PYMT_7_AMT INT,
	PTNT_ADD_ON_PYMT_AMT INT,
	HAC_PGM_RDCTN_IND_SW VARCHAR(1),
	PGM_RDCTN_IND_SW VARCHAR(1),
	PA_IND_CD VARCHAR(4),
	UNIQ_TRKNG_NUM VARCHAR(14),
	STAY_2_IND_SW VARCHAR(1),
	CLM_SITE_NTRL_PYMT_CST_AMT INT,
	CLM_SITE_NTRL_PYMT_IPPS_AMT INT,
	CLM_FULL_STD_PYMT_AMT INT,
	CLM_SS_OUTLIER_STD_PYMT_AMT INT,
	CLM_NGACO_IND_1_CD VARCHAR(1),
	CLM_NGACO_IND_2_CD VARCHAR(1),
	CLM_NGACO_IND_3_CD VARCHAR(1),
	CLM_NGACO_IND_4_CD VARCHAR(1),
	CLM_NGACO_IND_5_CD VARCHAR(1),
	CLM_RSDL_PYMT_IND_CD VARCHAR(1),
	CLM_RP_IND_CD VARCHAR(1),
	RC_RP_IND_CD VARCHAR(1),
	ACO_ID_NUM VARCHAR(10),
	RC_ALLOGENEIC_STEM_CELL_AMT INT,
	ISLET_ADD_ON_PYMT_AMT INT,
	CLM_IP_INITL_MS_DRG_CD VARCHAR(4),
	VAL_CD_Q1_PYMT_RDCTN_AMT INT,
	CLM_MODEL_REIMBRSMT_AMT INT,
	RC_MODEL_REIMBRSMT_AMT INT,
	VAL_CD_QB_OCM_PYMT_ADJSTMT_AMT INT,
	CELL_GENE_THRPY_PRCDRS_TOT_AMT INT,
	CELL_THRPY_DRUGS_TOT_AMT INT,
	GENE_THRPY_DRUGS_TOT_AMT INT,
	FILE VARCHAR(128),
	RECORD BIGSERIAL,
	STATE VARCHAR(2) GENERATED ALWAYS AS (STATE_CD) STORED,
	YEAR VARCHAR(4) GENERATED ALWAYS AS (MEDPAR_YR_NUM) STORED,
	ZIP VARCHAR(5) GENERATED ALWAYS AS (BENE_ZIP) STORED,
	PRIMARY KEY (FILE, RECORD)
);
CREATE INDEX  medpar_2017_FILE_idx ON cms.medpar_2017 USING BTREE (FILE) ;
COMMENT ON table cms.medpar_2017 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.377745';

---

Columns:

Column Name	Column Type	Datatype
acmdtns		INT
aco_id_num		VARCHAR(10)
acrtndt		DATE
actv_xref_ind		VARCHAR(1)
ad_dgns		VARCHAR(7)
admsnday		VARCHAR(1)
admsndt		DATE
admtg_dgns_vrsn_cd		VARCHAR(1)
age_cnt		INT
amblnc		INT
ansthsa		INT
base_oprtg_drg_amt		INT
bene_id		VARCHAR(15)
bene_zip		VARCHAR(5)
bic		VARCHAR(2)
bldadmin		INT
blddedam		INT
bldfrnsh		INT
bloodamt		INT
bndld_adjstmt_amt		INT
bndld_model_dscnt_pct		NUMERIC(7,4)
care_imprvmt_model_1_cd		VARCHAR(2)
care_imprvmt_model_2_cd		VARCHAR(2)
care_imprvmt_model_3_cd		VARCHAR(2)
care_imprvmt_model_4_cd		VARCHAR(2)
cell_gene_thrpy_prcdrs_tot_amt		INT
cell_thrpy_drugs_tot_amt		INT
clm_full_std_pymt_amt		INT
clm_ip_initl_ms_drg_cd		VARCHAR(4)
clm_model_reimbrsmt_amt		INT
clm_ngaco_ind_1_cd		VARCHAR(1)
clm_ngaco_ind_2_cd		VARCHAR(1)
clm_ngaco_ind_3_cd		VARCHAR(1)
clm_ngaco_ind_4_cd		VARCHAR(1)
clm_ngaco_ind_5_cd		VARCHAR(1)
clm_ptnt_rltnshp_cd		VARCHAR(2)
clm_rp_ind_cd		VARCHAR(1)
clm_rsdl_pymt_ind_cd		VARCHAR(1)
clm_site_ntrl_pymt_cst_amt		INT
clm_site_ntrl_pymt_ipps_amt		INT
clm_ss_outlier_std_pymt_amt		INT
clm_type		VARCHAR(2)
clnc_amt		INT
cnty_cd		VARCHAR(3)
coin_amt		INT
coin_day		INT
crdc_cathrztn_amt		INT
crdlgy		INT
cred_rcvd_rplcd_dvc_sw		VARCHAR(1)
crnry_cd		VARCHAR(1)
crnryamt		INT
crnryday		INT
ctscansw		VARCHAR(1)
cvrchrg		INT
cvrlvldt		DATE
deathcd		VARCHAR(1)
deathday		INT
deathdt		DATE
ded_amt		INT
dgns_e_10_cd		VARCHAR(7)
dgns_e_11_cd		VARCHAR(7)
dgns_e_12_cd		VARCHAR(7)
dgns_e_1_cd		VARCHAR(7)
dgns_e_2_cd		VARCHAR(7)
dgns_e_3_cd		VARCHAR(7)
dgns_e_4_cd		VARCHAR(7)
dgns_e_5_cd		VARCHAR(7)
dgns_e_6_cd		VARCHAR(7)
dgns_e_7_cd		VARCHAR(7)
dgns_e_8_cd		VARCHAR(7)
dgns_e_9_cd		VARCHAR(7)
dgns_e_cd_cnt		INT
dgns_e_vrsn_cd		VARCHAR(1)
dgns_e_vrsn_cd_1		VARCHAR(1)
dgns_e_vrsn_cd_10		VARCHAR(1)
dgns_e_vrsn_cd_11		VARCHAR(1)
dgns_e_vrsn_cd_12		VARCHAR(1)
dgns_e_vrsn_cd_2		VARCHAR(1)
dgns_e_vrsn_cd_3		VARCHAR(1)
dgns_e_vrsn_cd_4		VARCHAR(1)
dgns_e_vrsn_cd_5		VARCHAR(1)
dgns_e_vrsn_cd_6		VARCHAR(1)
dgns_e_vrsn_cd_7		VARCHAR(1)
dgns_e_vrsn_cd_8		VARCHAR(1)
dgns_e_vrsn_cd_9		VARCHAR(1)
dgns_poa		VARCHAR(10)
dgns_vrsn_cd		VARCHAR(1)
dgns_vrsn_cd_1		VARCHAR(1)
dgns_vrsn_cd_10		VARCHAR(1)
dgns_vrsn_cd_11		VARCHAR(1)
dgns_vrsn_cd_12		VARCHAR(1)
dgns_vrsn_cd_13		VARCHAR(1)
dgns_vrsn_cd_14		VARCHAR(1)
dgns_vrsn_cd_15		VARCHAR(1)
dgns_vrsn_cd_16		VARCHAR(1)
dgns_vrsn_cd_17		VARCHAR(1)
dgns_vrsn_cd_18		VARCHAR(1)
dgns_vrsn_cd_19		VARCHAR(1)
dgns_vrsn_cd_2		VARCHAR(1)
dgns_vrsn_cd_20		VARCHAR(1)
dgns_vrsn_cd_21		VARCHAR(1)
dgns_vrsn_cd_22		VARCHAR(1)
dgns_vrsn_cd_23		VARCHAR(1)
dgns_vrsn_cd_24		VARCHAR(1)
dgns_vrsn_cd_25		VARCHAR(1)
dgns_vrsn_cd_3		VARCHAR(1)
dgns_vrsn_cd_4		VARCHAR(1)
dgns_vrsn_cd_5		VARCHAR(1)
dgns_vrsn_cd_6		VARCHAR(1)
dgns_vrsn_cd_7		VARCHAR(1)
dgns_vrsn_cd_8		VARCHAR(1)
dgns_vrsn_cd_9		VARCHAR(1)
dgnscd1		VARCHAR(7)
dgnscd10		VARCHAR(7)
dgnscd11		VARCHAR(7)
dgnscd12		VARCHAR(7)
dgnscd13		VARCHAR(7)
dgnscd14		VARCHAR(7)
dgnscd15		VARCHAR(7)
dgnscd16		VARCHAR(7)
dgnscd17		VARCHAR(7)
dgnscd18		VARCHAR(7)
dgnscd19		VARCHAR(7)
dgnscd2		VARCHAR(7)
dgnscd20		VARCHAR(7)
dgnscd21		VARCHAR(7)
dgnscd22		VARCHAR(7)
dgnscd23		VARCHAR(7)
dgnscd24		VARCHAR(7)
dgnscd25		VARCHAR(7)
dgnscd3		VARCHAR(7)
dgnscd4		VARCHAR(7)
dgnscd5		VARCHAR(7)
dgnscd6		VARCHAR(7)
dgnscd7		VARCHAR(7)
dgnscd8		VARCHAR(7)
dgnscd9		VARCHAR(7)
dgnscnt		INT
dgnstcsw		VARCHAR(1)
disp_shr		INT
dme_amt		INT
dprtmntl		INT
drg_cd		VARCHAR(3)
drgprice		INT
dschrgcd		VARCHAR(1)
dschrgdt		DATE
dstntncd		VARCHAR(2)
ehr_pymt_adjstmt_amt		INT
eq_bic		VARCHAR(2)
er_amt		INT
esrd_cd		VARCHAR(2)
esrdsetg		INT
esrdstg1		VARCHAR(2)
esrdstg2		VARCHAR(2)
esrdstg3		VARCHAR(2)
esrdstg4		VARCHAR(2)
esrdstg5		VARCHAR(2)
exhst_dt		DATE
faclmcnt		INT
ficarr		VARCHAR(5)
fildtcd		VARCHAR(1)
file	file	VARCHAR(128)
finl_std_amt		INT
gene_thrpy_drugs_tot_amt		INT
ghopdcd		VARCHAR(1)
hac_pgm_rdctn_ind_sw		VARCHAR(1)
hac_rdctn_pmt_amt		INT
hrr_adjstmt_amt		INT
hrr_adjstmt_pct		NUMERIC(8,5)
hrr_prtcpnt_ind_cd		VARCHAR(1)
icareamt		INT
icarecnt		INT
icuindcd		VARCHAR(1)
ime_amt		INT
imgng_sw		VARCHAR(1)
incdnt_dgnstc_srvcs_amt		INT
incdnt_rdlgy_amt		INT
infrmtl_enctr_ind_sw		VARCHAR(1)
inhltamt		INT
intraocular_lens_amt		INT
intrnl_use_ssi_data		VARCHAR(1)
invstgtnl_dvc_amt		INT
ip_low_vol_pymt_amt		INT
ipps_flex_pymt_7_amt		INT
ipsbcd		VARCHAR(3)
islet_add_on_pymt_amt		INT
lab_amt		INT
loscnt		INT
lrd_use		INT
lthtrpsy		INT
ma_tchng_ind_sw		VARCHAR(1)
mdcl_srgcl_drsng_amt		INT
mdcl_srgcl_gnrl_amt		INT
mdcl_srgcl_misc_amt		INT
mdcl_srgcl_nstrl_amt		INT
mdcl_srgcl_pcmkr_amt		INT
mdcl_srgcl_strl_amt		INT
medpar_yr_num		VARCHAR(4)
medparid		VARCHAR(15)
mri_amt		INT
ms_cd		VARCHAR(2)
new_tchnlgy_add_on_amt		INT
nuclr_sw		VARCHAR(1)
obsrvtn_sw		VARCHAR(1)
ocptlamt		INT
onclgysw		VARCHAR(1)
oprtg_hsp_amt		INT
oprtg_room_amt		INT
opsrvc		INT
opsrvccd		VARCHAR(1)
or_labor_dlvry_amt		INT
orgnamt		INT
orgncd		VARCHAR(2)
orgnpinm		VARCHAR(10)
oroomamt		INT
othr_implants_amt		INT
othr_suplies_dvc_amt		INT
othramt		INT
outlr_cd		VARCHAR(1)
outlramt		INT
outlrday		INT
oxygn_take_home_amt		INT
pa_ind_cd		VARCHAR(4)
passthru		INT
pgm_rdctn_ind_sw		VARCHAR(1)
phrmcamt		INT
phrmcycd		VARCHAR(1)
phythamt		INT
pmt_amt		INT
poa_dgns_10_ind_cd		VARCHAR(1)
poa_dgns_11_ind_cd		VARCHAR(1)
poa_dgns_12_ind_cd		VARCHAR(1)
poa_dgns_13_ind_cd		VARCHAR(1)
poa_dgns_14_ind_cd		VARCHAR(1)
poa_dgns_15_ind_cd		VARCHAR(1)
poa_dgns_16_ind_cd		VARCHAR(1)
poa_dgns_17_ind_cd		VARCHAR(1)
poa_dgns_18_ind_cd		VARCHAR(1)
poa_dgns_19_ind_cd		VARCHAR(1)
poa_dgns_1_ind_cd		VARCHAR(1)
poa_dgns_20_ind_cd		VARCHAR(1)
poa_dgns_21_ind_cd		VARCHAR(1)
poa_dgns_22_ind_cd		VARCHAR(1)
poa_dgns_23_ind_cd		VARCHAR(1)
poa_dgns_24_ind_cd		VARCHAR(1)
poa_dgns_25_ind_cd		VARCHAR(1)
poa_dgns_2_ind_cd		VARCHAR(1)
poa_dgns_3_ind_cd		VARCHAR(1)
poa_dgns_4_ind_cd		VARCHAR(1)
poa_dgns_5_ind_cd		VARCHAR(1)
poa_dgns_6_ind_cd		VARCHAR(1)
poa_dgns_7_ind_cd		VARCHAR(1)
poa_dgns_8_ind_cd		VARCHAR(1)
poa_dgns_9_ind_cd		VARCHAR(1)
poa_dgns_cd_cnt		INT
poa_dgns_e_10_ind_cd		VARCHAR(1)
poa_dgns_e_11_ind_cd		VARCHAR(1)
poa_dgns_e_12_ind_cd		VARCHAR(1)
poa_dgns_e_1_ind_cd		VARCHAR(1)
poa_dgns_e_2_ind_cd		VARCHAR(1)
poa_dgns_e_3_ind_cd		VARCHAR(1)
poa_dgns_e_4_ind_cd		VARCHAR(1)
poa_dgns_e_5_ind_cd		VARCHAR(1)
poa_dgns_e_6_ind_cd		VARCHAR(1)
poa_dgns_e_7_ind_cd		VARCHAR(1)
poa_dgns_e_8_ind_cd		VARCHAR(1)
poa_dgns_e_9_ind_cd		VARCHAR(1)
poa_dgns_e_cd_cnt		INT
pps_cptl		INT
pps_ind		VARCHAR(1)
pps_std_val_pymt_amt		INT
prcdrcd1		VARCHAR(7)
prcdrcd10		VARCHAR(7)
prcdrcd11		VARCHAR(7)
prcdrcd12		VARCHAR(7)
prcdrcd13		VARCHAR(7)
prcdrcd14		VARCHAR(7)
prcdrcd15		VARCHAR(7)
prcdrcd16		VARCHAR(7)
prcdrcd17		VARCHAR(7)
prcdrcd18		VARCHAR(7)
prcdrcd19		VARCHAR(7)
prcdrcd2		VARCHAR(7)
prcdrcd20		VARCHAR(7)
prcdrcd21		VARCHAR(7)
prcdrcd22		VARCHAR(7)
prcdrcd23		VARCHAR(7)
prcdrcd24		VARCHAR(7)
prcdrcd25		VARCHAR(7)
prcdrcd3		VARCHAR(7)
prcdrcd4		VARCHAR(7)
prcdrcd5		VARCHAR(7)
prcdrcd6		VARCHAR(7)
prcdrcd7		VARCHAR(7)
prcdrcd8		VARCHAR(7)
prcdrcd9		VARCHAR(7)
prcdrcnt		INT
prcdrdt1		DATE
prcdrdt10		DATE
prcdrdt11		DATE
prcdrdt12		DATE
prcdrdt13		DATE
prcdrdt14		DATE
prcdrdt15		DATE
prcdrdt16		DATE
prcdrdt17		DATE
prcdrdt18		DATE
prcdrdt19		DATE
prcdrdt2		DATE
prcdrdt20		DATE
prcdrdt21		DATE
prcdrdt22		DATE
prcdrdt23		DATE
prcdrdt24		DATE
prcdrdt25		DATE
prcdrdt3		DATE
prcdrdt4		DATE
prcdrdt5		DATE
prcdrdt6		DATE
prcdrdt7		DATE
prcdrdt8		DATE
prcdrdt9		DATE
prcdrsw		VARCHAR(1)
prcdtcnt		INT
prod_rplcmt_lifecyc_sw		VARCHAR(1)
prod_rplcmt_rcll_sw		VARCHAR(1)
proffees		INT
prpay_cd		VARCHAR(1)
prpayamt		INT
prsthtc_orthtc_amt		INT
prvdrnum		VARCHAR(10)
prvtamt		INT
prvtday		INT
ptnt_add_on_pymt_amt		INT
qlfyfrom		DATE
qlfythru		DATE
race		VARCHAR(1)
rc_allogeneic_stem_cell_amt		INT
rc_model_reimbrsmt_amt		INT
rc_rp_ind_cd		VARCHAR(1)
rdlgy_ct_scan_amt		INT
rdlgy_dgnstc_amt		INT
rdlgy_nuclr_mdcn_amt		INT
rdlgy_oncology_amt		INT
rdlgy_othr_imgng_amt		INT
rdlgy_thrptc_amt		INT
rdlgyamt		INT
record		BIGSERIAL
sex		VARCHAR(1)
slct_rsn_cd		VARCHAR(1)
smplsize		VARCHAR(1)
spch_amt		INT
spclunit		VARCHAR(1)
sprvtamt		INT
sprvtday		INT
sqstrtn_rdctn_amt		INT
src_adms		VARCHAR(1)
srgcl_prcdr_vrsn_cd		VARCHAR(1)
srgcl_prcdr_vrsn_cd_1		VARCHAR(1)
srgcl_prcdr_vrsn_cd_10		VARCHAR(1)
srgcl_prcdr_vrsn_cd_11		VARCHAR(1)
srgcl_prcdr_vrsn_cd_12		VARCHAR(1)
srgcl_prcdr_vrsn_cd_13		VARCHAR(1)
srgcl_prcdr_vrsn_cd_14		VARCHAR(1)
srgcl_prcdr_vrsn_cd_15		VARCHAR(1)
srgcl_prcdr_vrsn_cd_16		VARCHAR(1)
srgcl_prcdr_vrsn_cd_17		VARCHAR(1)
srgcl_prcdr_vrsn_cd_18		VARCHAR(1)
srgcl_prcdr_vrsn_cd_19		VARCHAR(1)
srgcl_prcdr_vrsn_cd_2		VARCHAR(1)
srgcl_prcdr_vrsn_cd_20		VARCHAR(1)
srgcl_prcdr_vrsn_cd_21		VARCHAR(1)
srgcl_prcdr_vrsn_cd_22		VARCHAR(1)
srgcl_prcdr_vrsn_cd_23		VARCHAR(1)
srgcl_prcdr_vrsn_cd_24		VARCHAR(1)
srgcl_prcdr_vrsn_cd_25		VARCHAR(1)
srgcl_prcdr_vrsn_cd_3		VARCHAR(1)
srgcl_prcdr_vrsn_cd_4		VARCHAR(1)
srgcl_prcdr_vrsn_cd_5		VARCHAR(1)
srgcl_prcdr_vrsn_cd_6		VARCHAR(1)
srgcl_prcdr_vrsn_cd_7		VARCHAR(1)
srgcl_prcdr_vrsn_cd_8		VARCHAR(1)
srgcl_prcdr_vrsn_cd_9		VARCHAR(1)
ssicd		VARCHAR(1)
ssiday		INT
sslssnf		VARCHAR(1)
state	generated	VARCHAR(2)
state_cd		VARCHAR(2)
stay_2_ind_sw		VARCHAR(1)
suplyamt		INT
take_home_amt		INT
thrptcsw		VARCHAR(1)
totchrg		INT
trnsplnt		VARCHAR(1)
type_adm		VARCHAR(1)
udme_amt		INT
uncompd_care_pymt_amt		INT
uniq_trkng_num		VARCHAR(14)
util_day		INT
val_cd_q1_pymt_rdctn_amt		INT
val_cd_qb_ocm_pymt_adjstmt_amt		INT
vbp_adjstmt_amt		INT
vbp_adjstmt_pct		NUMERIC(15,12)
vbp_prtcpnt_ind_cd		VARCHAR(1)
wardamt		INT
wardday		INT
wrngcd		VARCHAR(18)
year	generated	VARCHAR(4)
zip	generated	VARCHAR(5)