drop table fy_con_res;
drop sequence fy_con_res_id_seq;
create table fy_con_res (
	ID serial,
	FID integer,
	dob date,
	doe date,
	dot date,
	sex character (1),
	race character (30),
	ssn character (11),
	status character (8),
	PRIMARY KEY (ID)
);

drop table fy_con_res_diagcodes;
drop sequence fy_con_res_diagcodes_id_seq;
create table fy_con_res_diagcodes (
	ID serial,
	FID integer,
	code character (6),
	PRIMARY KEY (ID)
);

drop table fy_con_res_mbpayors;
drop sequence fy_con_res_mbpayors_id_seq;
create table fy_con_res_mbpayors (
	ID serial,
	FID integer,
	payor_type character (10),
	service_type character (10),
	mc_ucid character (7),
	mc_medicaidnum character (12),
	status character (8),
	effectivedate date,
	PRIMARY KEY (ID)
);

drop table fy_con_res_mbpayor_types;
drop sequence fy_con_res_mbpayor_types_id_seq;
create table fy_con_res_mbpayor_types (
	ID serial,
	payor_type character (10),
	PRIMARY KEY (ID)
);

