CREATE TABLE "VCS"."ABLBFY"  ( 
	"COMPANY_CODE"              	CHARACTER(3) NOT NULL,
	"MASTER_ID"                 	CHARACTER(15) NOT NULL,
	"BENEFIT_ID"                	DECIMAL(7,0) NOT NULL,
	"BENEFIT_TYPE"              	CHARACTER(1) NOT NULL DEFAULT ' ',
	"FUND_NUMBER"               	DECIMAL(8,0) NOT NULL DEFAULT 0.0,
	"FUND_TYPE"                 	CHARACTER(1) NOT NULL DEFAULT ' ',
	"PAYMENT_SERIES_CODE"       	CHARACTER(5) NOT NULL DEFAULT ' ',
	"BENEFIT_START_DATE"        	DATE,
	"BENEFIT_END_DATE"          	DATE,
	"NEXT_PAYMENT_DUE_DATE"     	DATE,
	"PAYMENT_MODE"              	CHARACTER(1) NOT NULL DEFAULT ' ',
	"NUMBER_OF_MODES"           	DECIMAL(3,0) NOT NULL DEFAULT 0.0,
	"MODAL_BENEFIT"             	DECIMAL(13,4) NOT NULL DEFAULT 0.0,
	"FUNDING_CODE"              	CHARACTER(1) NOT NULL DEFAULT ' ',
	"PAY_AFTER_ANNT_DEATH_SW"   	CHARACTER(1) NOT NULL DEFAULT ' ',
	"ANNUITANT_PERCENT"         	DECIMAL(5,2) NOT NULL DEFAULT 0.0,
	"PAY_AFTER_JT_ANNT_DEATH_SW"	CHARACTER(1) NOT NULL DEFAULT ' ',
	"JOINT_ANNUITANT_PERCENT"   	DECIMAL(5,2) NOT NULL DEFAULT 0.0,
	CONSTRAINT "SQL151216131342650" PRIMARY KEY("COMPANY_CODE","MASTER_ID","BENEFIT_ID")
)
GO
CREATE TABLE "VCS"."ABRT"  ( 
	"COMPANY_CODE"     	CHARACTER(3) NOT NULL DEFAULT ' ',
	"MASTER_ID"        	CHARACTER(15) NOT NULL DEFAULT ' ',
	"SEQUENCE_NUMBER"  	DECIMAL(7,0) NOT NULL DEFAULT 0.0,
	"PARENT_ID"        	CHARACTER(2) NOT NULL DEFAULT ' ',
	"PARENT_SEQUENCE"  	DECIMAL(7,0) NOT NULL DEFAULT 0.0,
	"PRODUCT_CODE"     	CHARACTER(2) NOT NULL DEFAULT ' ',
	"ABR_LIEN_IND"     	CHARACTER(1) NOT NULL DEFAULT ' ',
	"ABR_LN_REDUCT_IND"	CHARACTER(1) NOT NULL DEFAULT ' ',
	"ABR_METHOD_CD_IND"	CHARACTER(1) NOT NULL DEFAULT ' ',
	"ABR_TOT_LIEN_AMT" 	DECIMAL(11,2) NOT NULL DEFAULT 0.0,
	"ABR_CLAIM_CUR_OCC"	SMALLINT NOT NULL DEFAULT 0,
	"ABR_BANDING_CODE" 	CHARACTER(1) NOT NULL DEFAULT ' ',
	"ABR_CLAIM_DATA"   	VARCHAR(470) NOT NULL DEFAULT '' 
	)
GO