CREATE TABLE SRD_PRODUCT_VERSIONS(product CHAR(50), version CHAR(50));
CREATE TABLE SYS_SCHEMA (SCHEMA_CODE VARCHAR(50) NOT NULL, SCHEMA_VER VARCHAR(50) NOT NULL) ;
ALTER TABLE SYS_SCHEMA ADD CONSTRAINT SYS_SCHEMA_PK PRIMARY KEY(SCHEMA_CODE) ;
CREATE TABLE SYS_SEQUENCE (SEQUENCE_NAME VARCHAR(50) NOT NULL, NEXT_SEQUENCE BIGINT NOT NULL, CACHE_SIZE smallint NOT NULL, SCATTER CHAR(1) NOT NULL) ;
ALTER TABLE SYS_SEQUENCE ADD CONSTRAINT SYS_SEQUENCE_PK PRIMARY KEY(SEQUENCE_NAME) ;
INSERT INTO SYS_SEQUENCE (SEQUENCE_NAME,NEXT_SEQUENCE,CACHE_SIZE,SCATTER) VALUES ('ER_ID',1,1000,'N');
INSERT INTO SYS_SEQUENCE (SEQUENCE_NAME,NEXT_SEQUENCE,CACHE_SIZE,SCATTER) VALUES ('LIB_FEAT_ID',1,1000,'N');
INSERT INTO SYS_SEQUENCE (SEQUENCE_NAME,NEXT_SEQUENCE,CACHE_SIZE,SCATTER) VALUES ('LIB_FELEM_ID',1,1000,'N');
INSERT INTO SYS_SEQUENCE (SEQUENCE_NAME,NEXT_SEQUENCE,CACHE_SIZE,SCATTER) VALUES ('LIB_TOKEN_ID',1,1000,'N');
INSERT INTO SYS_SEQUENCE (SEQUENCE_NAME,NEXT_SEQUENCE,CACHE_SIZE,SCATTER) VALUES ('OBS_ENT_ID',1,1000,'N');
INSERT INTO SYS_SEQUENCE (SEQUENCE_NAME,NEXT_SEQUENCE,CACHE_SIZE,SCATTER) VALUES ('OBS_ID',1,1000,'N');
INSERT INTO SYS_SEQUENCE (SEQUENCE_NAME,NEXT_SEQUENCE,CACHE_SIZE,SCATTER) VALUES ('RES_REL_ID',1,1000,'N');
INSERT INTO SYS_SEQUENCE (SEQUENCE_NAME,NEXT_SEQUENCE,CACHE_SIZE,SCATTER) VALUES ('ING_CNT_ID',1,1,'N');
CREATE TABLE SYS_PARAM (PARAM_ID smallint NOT NULL, PARAM_GROUP VARCHAR(50) NOT NULL, PARAM_CODE VARCHAR(50) NOT NULL, CURRENT_VALUE VARCHAR(50), DEFAULT_VALUE VARCHAR(50), DATA_TYPE VARCHAR(50) NOT NULL, VALIDATION_TYPE VARCHAR(50), VALIDATION_ARG VARCHAR(50), HIDDEN_FLAG VARCHAR(50) NOT NULL) ;
ALTER TABLE SYS_PARAM ADD CONSTRAINT SYS_PARAM_PK PRIMARY KEY(PARAM_ID) ;
CREATE UNIQUE INDEX SYS_PARAM_SK ON SYS_PARAM(PARAM_GROUP, PARAM_CODE) ;
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (110,'ER','RELATIONSHIP_PLUGIN','DefaultRelationship','DefaultRelationship','STRING',NULL,NULL,'N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (112,'ER','GENERIC_THRESHOLD','20','20','INTEGER',NULL,NULL,'N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (113,'ER','ENABLE_GROUPER_KEY_CLUSTERING','1','1','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (114,'ER','ENABLE_RELATIONSHIPS','1','1','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (120,'LDR','ENTITY_INSERT_FIRST','0','0','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (121,'LDR','FEATURE_INSERT_FIRST','0','0','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (122,'LDR','EFEATURE_INSERT_FIRST','0','0','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (123,'LDR','CONFIGURATION_VERSION','1','1','INTEGER',NULL,NULL,'N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (130,'LOGGING','LOG_ER','1','1','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (131,'LOGGING','LOG_ER_CAND','1','1','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (132,'LOGGING','LOG_ER_CAND_DETAIL','0','0','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (133,'LOGGING','LOG_ER_COMP','1','1','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (134,'LOGGING','LOG_ER_RES','1','1','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (136,'LOGGING','LOG_ER_STEP','1','1','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (137,'LOGGING','LOG_OBS','1','1','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (138,'LOGGING','LOG_OBS_ENT','1','1','BOOLEAN','VALUE_SET','1,0','N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (150,'PIPELINE','CONCURRENCY','1','1','INTEGER',NULL,NULL,'N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (151,'PIPELINE','INIT_BUFFER_SIZE','4096','4096','INTEGER',NULL,NULL,'N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (152,'PIPELINE','G2SALT_CHECKSUM','','','STRING',NULL,NULL,'N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (161,'SQL','LAST_TOUCH_WAIT','10','10','INTEGER',NULL,NULL,'N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (181,'ER','REMEMBER_GPLAN_ID','1','1','INTEGER',NULL,NULL,'N');
INSERT INTO SYS_PARAM (PARAM_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (182,'ER','FORGET_GPLAN_ID','2','2','INTEGER',NULL,NULL,'N');
CREATE TABLE SYS_OOM (OOM_TYPE VARCHAR(25) NOT NULL, OOM_LEVEL VARCHAR(25) NOT NULL, LENS_ID smallint, FTYPE_ID smallint, LIB_FEAT_ID BIGINT, FELEM_ID smallint, LIB_FELEM_ID BIGINT, THRESH1_CNT int NOT NULL, THRESH1_OOM int NOT NULL, NEXT_THRESH int NOT NULL) ;
CREATE UNIQUE INDEX SYS_OOM_INDX ON SYS_OOM(OOM_TYPE, OOM_LEVEL, LENS_ID, LIB_FEAT_ID, FELEM_ID, LIB_FELEM_ID) ;
INSERT INTO SYS_OOM (OOM_TYPE,OOM_LEVEL,LENS_ID,FTYPE_ID,LIB_FEAT_ID,FELEM_ID,LIB_FELEM_ID,THRESH1_CNT,THRESH1_OOM,NEXT_THRESH) VALUES ('RF','SYSDEFAULT',0,0,0,0,0,100,10,1000);
CREATE TABLE EXAMPLE_DBTRANSPORT (LOAD_SEQ smallint NOT NULL, OWNER VARCHAR(255), LOCK_TIME BIGINT, MSG CLOB) ;
CREATE INDEX IX_EX_DBTRANS_LOAD ON EXAMPLE_DBTRANSPORT(LOAD_SEQ, OWNER, LOCK_TIME) ;
CREATE INDEX IX_EX_DBTRANS_OWNE ON EXAMPLE_DBTRANSPORT(OWNER, LOCK_TIME) ;
CREATE TABLE CFG_DSRC (DSRC_ID smallint NOT NULL, DSRC_CODE VARCHAR(25) NOT NULL, DSRC_DESC VARCHAR(50), DSRC_RELY smallint NOT NULL, RETENTION_LEVEL VARCHAR(25) NOT NULL, CONVERSATIONAL VARCHAR(25) NOT NULL) ;
ALTER TABLE CFG_DSRC ADD CONSTRAINT CFG_DSRC_PK PRIMARY KEY(DSRC_ID) ;
CREATE UNIQUE INDEX CFG_DSRC_SK ON CFG_DSRC(DSRC_CODE) ;
INSERT INTO CFG_DSRC (DSRC_ID,DSRC_CODE,DSRC_DESC,DSRC_RELY,RETENTION_LEVEL,CONVERSATIONAL) VALUES (1,'G2','G2',1,'Remember','No');
INSERT INTO CFG_DSRC (DSRC_ID,DSRC_CODE,DSRC_DESC,DSRC_RELY,RETENTION_LEVEL,CONVERSATIONAL) VALUES (2,'SEARCH','Search',1,'Forget','Yes');
INSERT INTO CFG_DSRC (DSRC_ID,DSRC_CODE,DSRC_DESC,DSRC_RELY,RETENTION_LEVEL,CONVERSATIONAL) VALUES (3,'TEST','Test',1,'Remember','No');
CREATE TABLE CFG_ECLASS (ECLASS_ID smallint NOT NULL, ECLASS_CODE VARCHAR(25) NOT NULL, ECLASS_DESC VARCHAR(50), RESOLVE VARCHAR(5) WITH DEFAULT 'Yes' NOT NULL) ;
ALTER TABLE CFG_ECLASS ADD CONSTRAINT CFG_ECLASS_PK PRIMARY KEY(ECLASS_ID) ;
CREATE UNIQUE INDEX CFG_ECLASS_SK ON CFG_ECLASS(ECLASS_CODE) ;
INSERT INTO CFG_ECLASS (ECLASS_ID,ECLASS_CODE,ECLASS_DESC,RESOLVE) VALUES (1,'ACTOR','Actor','Yes');
INSERT INTO CFG_ECLASS (ECLASS_ID,ECLASS_CODE,ECLASS_DESC,RESOLVE) VALUES (2,'OBJECT','Object','Yes');
INSERT INTO CFG_ECLASS (ECLASS_ID,ECLASS_CODE,ECLASS_DESC,RESOLVE) VALUES (3,'LOCATION','Location','Yes');
INSERT INTO CFG_ECLASS (ECLASS_ID,ECLASS_CODE,ECLASS_DESC,RESOLVE) VALUES (4,'EVENT','Event','No');
INSERT INTO CFG_ECLASS (ECLASS_ID,ECLASS_CODE,ECLASS_DESC,RESOLVE) VALUES (5,'TRAN','Transaction','No');
CREATE TABLE CFG_ETYPE (ETYPE_ID smallint NOT NULL, ETYPE_CODE VARCHAR(25) NOT NULL, ETYPE_DESC VARCHAR(50), ECLASS_ID smallint NOT NULL) ;
ALTER TABLE CFG_ETYPE ADD CONSTRAINT CFG_ETYPE_PK PRIMARY KEY(ETYPE_ID) ;
CREATE UNIQUE INDEX CFG_ETYPE_SK ON CFG_ETYPE(ETYPE_CODE) ;
INSERT INTO CFG_ETYPE (ETYPE_ID,ETYPE_CODE,ETYPE_DESC,ECLASS_ID) VALUES (1,'PERSON','Person',1);
INSERT INTO CFG_ETYPE (ETYPE_ID,ETYPE_CODE,ETYPE_DESC,ECLASS_ID) VALUES (2,'COMPANY','Company',1);
INSERT INTO CFG_ETYPE (ETYPE_ID,ETYPE_CODE,ETYPE_DESC,ECLASS_ID) VALUES (3,'PERSON_OR_COMPANY','Person or company',1);
INSERT INTO CFG_ETYPE (ETYPE_ID,ETYPE_CODE,ETYPE_DESC,ECLASS_ID) VALUES (4,'VEHICLE','Vehicle',2);
INSERT INTO CFG_ETYPE (ETYPE_ID,ETYPE_CODE,ETYPE_DESC,ECLASS_ID) VALUES (5,'VESSEL','Vessel',2);
CREATE TABLE CFG_FCLASS (FCLASS_ID smallint NOT NULL, FCLASS_CODE VARCHAR(25) NOT NULL, FCLASS_DESC VARCHAR(50)) ;
ALTER TABLE CFG_FCLASS ADD CONSTRAINT CFG_FCLASS_PK PRIMARY KEY(FCLASS_ID) ;
CREATE UNIQUE INDEX CFG_FCLASS_SK ON CFG_FCLASS(FCLASS_CODE) ;
INSERT INTO CFG_FCLASS (FCLASS_ID,FCLASS_CODE,FCLASS_DESC) VALUES (1,'NAME','Name');
INSERT INTO CFG_FCLASS (FCLASS_ID,FCLASS_CODE,FCLASS_DESC) VALUES (2,'BIO_DATE','Biographical date');
INSERT INTO CFG_FCLASS (FCLASS_ID,FCLASS_CODE,FCLASS_DESC) VALUES (3,'BIO_FEATURE','Biographical feature');
INSERT INTO CFG_FCLASS (FCLASS_ID,FCLASS_CODE,FCLASS_DESC) VALUES (4,'POSTAL_ADDRESS','Postal address');
INSERT INTO CFG_FCLASS (FCLASS_ID,FCLASS_CODE,FCLASS_DESC) VALUES (5,'PHONE','Phone');
INSERT INTO CFG_FCLASS (FCLASS_ID,FCLASS_CODE,FCLASS_DESC) VALUES (6,'ELECTED_ID','Elected ID');
INSERT INTO CFG_FCLASS (FCLASS_ID,FCLASS_CODE,FCLASS_DESC) VALUES (7,'ISSUED_ID','Issued ID');
INSERT INTO CFG_FCLASS (FCLASS_ID,FCLASS_CODE,FCLASS_DESC) VALUES (8,'PARTIAL_ID','Partial ID');
INSERT INTO CFG_FCLASS (FCLASS_ID,FCLASS_CODE,FCLASS_DESC) VALUES (9,'OTHER','Other');
INSERT INTO CFG_FCLASS (FCLASS_ID,FCLASS_CODE,FCLASS_DESC) VALUES (10,'INTERNAL_USE','Internal use only');
INSERT INTO CFG_FCLASS (FCLASS_ID,FCLASS_CODE,FCLASS_DESC) VALUES (11,'SPACE_TIME','Space-time');
INSERT INTO CFG_FCLASS (FCLASS_ID,FCLASS_CODE,FCLASS_DESC) VALUES (12,'RELATIONSHIP','Relationship');
CREATE TABLE CFG_FTYPE (FTYPE_ID smallint NOT NULL, FTYPE_CODE VARCHAR(25) NOT NULL, FTYPE_DESC VARCHAR(50), FCLASS_ID smallint NOT NULL, FTYPE_FREQ VARCHAR(5) NOT NULL, FTYPE_EXCL VARCHAR(5) NOT NULL, FTYPE_STAB VARCHAR(5) NOT NULL, PERSIST_HISTORY VARCHAR(5) NOT NULL, USED_FOR_CAND VARCHAR(5) WITH DEFAULT 'Yes' NOT NULL, DERIVED VARCHAR(5) NOT NULL, DERIVATION VARCHAR(10), RTYPE_ID smallint, ANONYMIZE VARCHAR(5) WITH DEFAULT 'No' NOT NULL, VERSION smallint WITH DEFAULT 1 NOT NULL) ;
ALTER TABLE CFG_FTYPE ADD CONSTRAINT CFG_FTYPE_PK PRIMARY KEY(FTYPE_ID) ;
CREATE UNIQUE INDEX CFG_FTYPE_SK ON CFG_FTYPE(FTYPE_CODE) ;
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (1,'NAME','Name',1,'NAME','No','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (2,'DOB','Date of birth',2,'FM','Yes','Yes','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (3,'DOD','Date of death',2,'FM','Yes','Yes','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (4,'GENDER','Gender',3,'FM','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (5,'ADDRESS','Address',4,'FF','No','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (6,'PHONE','Phone',5,'FF','No','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (7,'SSN','Social security number',7,'F1','Yes','Yes','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (8,'SSN_LAST4','Last4 SSN',8,'FM','Yes','Yes','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (9,'DRLIC','Drivers license',7,'F1','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (10,'PASSPORT','Passport number',7,'F1','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (11,'TAX_ID','Tax ID',7,'F1','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (12,'NATIONAL_ID','National ID number',7,'F1','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (13,'LOGIN_ID','Login ID',6,'F1','No','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (14,'EMAIL_ADDR','Email address',6,'FF','No','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (15,'WEBSITE_ADDR','Website address',6,'FF','No','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (16,'ACCT_NUM','Account number',7,'F1','No','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (17,'GROUPER_KEY','Grouper key',10,'NONE','No','No','Yes','Yes','Yes',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (18,'NAME_KEY','Name key',10,'NONE','No','No','Yes','Yes','Yes',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (19,'ADDR_KEY','Address key',10,'NONE','No','No','Yes','Yes','Yes',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (20,'ID_KEY','ID Key',10,'NONE','No','No','Yes','Yes','Yes',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (21,'PHONE_KEY','Phone Key',10,'NONE','No','No','Yes','Yes','Yes',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (22,'SEARCH_KEY','Search key',10,'NONE','No','No','Yes','Yes','Yes',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (23,'REL_LINK','Relation link',12,'NONE','No','No','Yes','No','No',NULL,11,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (24,'GEO_LOC','Geo location',11,'FM','No','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (26,'STB_KEY','Space-time box',10,'FF','No','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (27,'INTERESTING_ENTITY','Interest code',9,'FM','No','No','No','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (28,'CONFUSED_ENTITY','Confused entity',9,'FM','No','No','No','No','Yes',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (29,'ACCT_TYPE','Account type',9,'FM','No','No','No','No','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (30,'STATUS','Status',9,'FM','No','No','No','No','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (31,'STATUS_DATE','Status date',9,'FM','No','No','No','No','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (32,'CREATE_DATE','Create date',9,'FM','No','No','No','No','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (33,'LAST_ACT_DATE','Last activity date',9,'FM','No','No','No','No','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (34,'CURRENT_BAL','Current balance',9,'FM','No','No','No','No','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (35,'CREDIT_LIMIT','Credit limit',9,'FM','No','No','No','No','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (36,'VEH_VIN','Vehicle ID number',7,'F1','Yes','Yes','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (37,'VEH_LIC_PLATE','Vehicle license plate',7,'F1','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (38,'VEH_MAKE','Vehicle make',3,'FM','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (39,'VEH_MODEL','Vehicle model',3,'FM','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (40,'VEH_COLOR','Vehicle color',3,'FM','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (41,'VEH_YEAR','Vehicle year',3,'FM','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (42,'IMO_NUM','IMO number',7,'F1','Yes','Yes','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (43,'MMSI_NUM','MMSI number',7,'F1','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (44,'CALL_SIGN','Call sign',7,'F1','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (45,'FLAG_CODE','Flag code',3,'FM','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (46,'REG_PORT','Port of registry',3,'FM','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (47,'VESSEL_TYPE','Vessel type',3,'FM','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (48,'VESSEL_LENGTH','Vessel length',3,'FM','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (49,'VESSEL_BEAM','Vessel beam',3,'FM','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (50,'GROSS_TONNAGE','Gross tonnage',3,'FM','Yes','No','Yes','Yes','No',NULL,0,'No',1);
INSERT INTO CFG_FTYPE (FTYPE_ID,FTYPE_CODE,FTYPE_DESC,FCLASS_ID,FTYPE_FREQ,FTYPE_EXCL,FTYPE_STAB,PERSIST_HISTORY,USED_FOR_CAND,DERIVED,DERIVATION,RTYPE_ID,ANONYMIZE,VERSION) VALUES (51,'NET_TONNAGE','Net tonnage',3,'FM','Yes','No','Yes','Yes','No',NULL,0,'No',1);
CREATE TABLE CFG_FELEM (FELEM_ID smallint NOT NULL, FELEM_CODE VARCHAR(25) NOT NULL, FELEM_DESC VARCHAR(50), TOKENIZE VARCHAR(5) NOT NULL, DATA_TYPE VARCHAR(25) NOT NULL) ;
ALTER TABLE CFG_FELEM ADD CONSTRAINT CFG_FELEM_PK PRIMARY KEY(FELEM_ID) ;
CREATE UNIQUE INDEX CFG_FELEM_SK ON CFG_FELEM(FELEM_CODE) ;
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (2,'FULL_NAME','Full name','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (3,'ORG_NAME','Organization name','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (4,'SUR_NAME','Surname','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (5,'GIVEN_NAME','Given name','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (6,'MIDDLE_NAME','Middle name','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (7,'NAME_PREFIX','Name prefix','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (8,'NAME_SUFFIX','Name suffix','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (9,'NAME_GEN','Name generation','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (10,'CULTURE','Name culture','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (11,'SCRIPT','Script type','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (12,'CATEGORY','Name category','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (13,'GENDER','Gender','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (14,'MAKE','Make','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (15,'MODEL','Model','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (16,'COLOR','Color','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (17,'YEAR','Year','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (18,'TYPE','Type','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (19,'OS','Operating system','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (22,'ADDR1','Addr line 1','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (23,'ADDR2','Addr line 2','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (24,'ADDR3','Addr line 3','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (25,'CITY','City','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (26,'STATE','State','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (27,'POSTAL_CODE','Postal code','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (28,'COUNTRY','Country','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (29,'STR_NUM','Street number','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (30,'STR_NAME','Street name','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (31,'UNIT_TYPE','Unit type','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (32,'UNIT_NUM','Unit number','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (33,'PHONE_NUM','Phone number','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (34,'PHONE_EXT','Phone extension','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (35,'ADDR','Address','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (36,'EXPRESSION','Expression','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (37,'ID_NUM','ID number','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (38,'ID_TYPE','Type of ID','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (39,'ID_LAST4','Last4 ID num','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (40,'ACCT_NUM','Account number','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (41,'DSRC_CODE','Data source code','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (42,'ACCT_TYPE','Account type','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (43,'DATE','Date','No','date');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (44,'YESNO_FLAG','Yes/No flag','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (45,'CALL_SIGN','Call sign','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (46,'CODE','Code','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (47,'PORT','Port','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (48,'LENGTH','Length','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (49,'BEAM','Beam','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (50,'TONNAGE','Tonnage','No','number');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (51,'LATITUDE','Latitude','No','number');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (52,'LONGITUDE','Longitude','No','number');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (53,'TIME','Time','No','datetime');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (54,'REL_KEY','Relationship key','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (55,'REL_TYPE','Relationship type','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (56,'LOGIN_ID','Login ID','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (57,'LOGIN_DOMAIN','Login domain','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (58,'ACCT_DOMAIN','Account domain','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (59,'AMOUNT','Amount','No','number');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (60,'PHONE_LAST_10','Phone Last10','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (61,'PHONE_LAST_5','Phone Last5','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (62,'DATE_YEAR','Date Year','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (63,'DATE_MONTH','Date Month','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (64,'DATE_DAY','Date Day','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (65,'STR_NAME_METAPHONE','Metaphone Street Name','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (66,'CITY_METAPHONE','Metaphone City Name','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (69,'ID_NUM_STD','Standardized ID number','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (71,'DATE_HASH','Date Hash','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (72,'STR_NAME_STD','Standardized Street Name Metaphone','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (73,'CITY_STD','Standardized City Metaphone','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (74,'POSTAL_5','Postal Code (first 5 digits)','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (75,'GEO_PRECISION', 'In Meters', 'No', 'number');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (76,'TIME_PRECISION', 'Timebox Precision', 'No', 'number');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (77,'ALL_NM','All for NAME_KEY','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (78,'ALL_META','Meta for NAME_KEY','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (79,'NM_PAIR','Pairs for NAME_KEY','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (81,'ORIG_GN','Original (standardised) Given Name','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (83,'META_GN','Metaphoned Given Name','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (84,'ORIG_SN','Original (standardised) Surname','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (86,'META_SN','Metaphoned Surname','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (87,'ORIG_ON','Original Organisation Name','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (89,'META_ON','Metaphoned Organisation Name','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (91,'STD_PRE','Standardized Name Prefixes','No', 'string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (92,'STD_SUF','Standardized Name Suffixes','No', 'string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (93,'STD_GEN','Standardized Name Generation','No', 'string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (94,'ORIG_FN','Original (standardised) Full Name','No','string');
INSERT INTO CFG_FELEM (FELEM_ID,FELEM_CODE,FELEM_DESC,TOKENIZE,DATA_TYPE) VALUES (96,'META_FN','Metaphoned Full Name','No','string');
CREATE TABLE CFG_FBOM (FTYPE_ID smallint NOT NULL, FELEM_ID smallint NOT NULL, EXEC_ORDER smallint NOT NULL, DISPLAY_LEVEL smallint NOT NULL, DISPLAY_DELIM VARCHAR(25), DERIVED VARCHAR(5) NOT NULL) ;
ALTER TABLE CFG_FBOM ADD CONSTRAINT CFG_FBOM_PK PRIMARY KEY(FTYPE_ID, FELEM_ID) ;
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,2,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,3,2,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,4,3,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,5,4,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,6,5,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,7,6,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,8,7,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,9,8,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,10,9,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,11,10,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,12,11,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,77,12,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,78,13,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,79,14,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,81,15,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,83,16,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,84,17,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,86,18,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,87,19,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,89,20,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,91,21,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,92,22,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,93,23,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,94,24,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (1,96,25,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (2,43,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (2,62,2,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (2,63,3,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (2,64,4,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (2,71,5,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (3,43,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (3,62,2,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (3,63,3,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (3,64,4,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (3,71,5,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (4,13,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,22,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,23,2,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,24,3,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,25,4,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,26,5,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,27,6,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,28,7,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,29,8,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,30,9,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,31,10,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,32,11,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,65,12,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,66,13,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,72,14,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,73,15,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,74,16,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (5,11,17,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (6,33,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (6,34,2,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (6,60,3,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (6,61,4,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (7,37,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (7,69,2,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (8,39,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (9,37,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (9,26,2,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (9,69,3,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (10,37,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (10,28,2,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (10,69,3,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (11,37,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (11,69,2,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (12,37,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (12,38,2,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (12,69,3,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (13,56,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (13,57,2,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (14,35,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (15,35,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (16,40,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (16,58,2,0,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (17,36,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (18,36,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (19,36,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (20,36,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (21,36,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (22,36,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (23,55,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (23,54,2,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (24,51,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (24,52,2,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (24,53,3,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (24,75,4,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (24,76,5,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (26,36,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (27,46,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (28,44,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (29,42,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (30,46,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (31,43,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (32,43,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (33,43,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (34,59,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (35,59,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (36,37,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (36,69,2,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (37,37,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (37,26,2,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (37,69,3,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (38,14,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (39,15,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (40,16,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (41,17,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (42,37,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (42,69,2,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (43,37,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (43,69,2,0,NULL,'Yes');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (44,45,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (45,46,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (46,47,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (47,18,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (48,48,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (49,49,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (50,50,1,1,NULL,'No');
INSERT INTO CFG_FBOM (FTYPE_ID,FELEM_ID,EXEC_ORDER,DISPLAY_LEVEL,DISPLAY_DELIM,DERIVED) VALUES (51,50,1,1,NULL,'No');
CREATE TABLE CFG_UTYPE (UTYPE_ID smallint NOT NULL, UTYPE_CODE VARCHAR(25) NOT NULL, UTYPE_DESC VARCHAR(50)) ;
ALTER TABLE CFG_UTYPE ADD CONSTRAINT CFG_UTYPE_PK PRIMARY KEY(UTYPE_ID) ;
CREATE UNIQUE INDEX CFG_UTYPE_SK ON CFG_UTYPE(UTYPE_CODE) ;
INSERT INTO CFG_UTYPE (UTYPE_ID,UTYPE_CODE,UTYPE_DESC) VALUES (1,'HOME','HOME');
INSERT INTO CFG_UTYPE (UTYPE_ID,UTYPE_CODE,UTYPE_DESC) VALUES (2,'MAIL','MAIL');
INSERT INTO CFG_UTYPE (UTYPE_ID,UTYPE_CODE,UTYPE_DESC) VALUES (3,'PRIMARY','PRIMARY');
INSERT INTO CFG_UTYPE (UTYPE_ID,UTYPE_CODE,UTYPE_DESC) VALUES (4,'SECONDARY','SECONDARY');
INSERT INTO CFG_UTYPE (UTYPE_ID,UTYPE_CODE,UTYPE_DESC) VALUES (5,'BILLING','BILLING');
INSERT INTO CFG_UTYPE (UTYPE_ID,UTYPE_CODE,UTYPE_DESC) VALUES (6,'MAILING','MAILING');
INSERT INTO CFG_UTYPE (UTYPE_ID,UTYPE_CODE,UTYPE_DESC) VALUES (7,'WORK','WORK');
INSERT INTO CFG_UTYPE (UTYPE_ID,UTYPE_CODE,UTYPE_DESC) VALUES (8,'MOBILE','MOBILE');
INSERT INTO CFG_UTYPE (UTYPE_ID,UTYPE_CODE,UTYPE_DESC) VALUES (9,'FAX','FAX');
INSERT INTO CFG_UTYPE (UTYPE_ID,UTYPE_CODE,UTYPE_DESC) VALUES (10,'PRESENCE', 'PRESENCE');
CREATE TABLE CFG_EBOM (ETYPE_ID smallint NOT NULL, EXEC_ORDER smallint NOT NULL, FTYPE_ID smallint NOT NULL, UTYPE_ID smallint) ;
ALTER TABLE CFG_EBOM ADD CONSTRAINT CFG_EBOM_PK PRIMARY KEY(ETYPE_ID, EXEC_ORDER) ;
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,1,1,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,2,2,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,3,3,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,4,4,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,5,5,3);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,6,5,4);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,7,6,3);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,8,6,4);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,9,14,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,10,7,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,11,8,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,12,9,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,13,10,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,14,12,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (1,15,16,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (2,1,1,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (2,2,5,3);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (2,3,5,4);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (2,4,6,3);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (2,5,6,4);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (2,6,14,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (2,7,15,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (2,8,11,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (2,9,16,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,1,1,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,2,2,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,3,3,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,4,4,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,5,5,3);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,6,5,4);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,7,6,3);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,8,6,4);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,9,14,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,10,15,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,11,7,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,12,8,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,13,11,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,14,9,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,15,10,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,16,12,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (3,17,16,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (4,1,36,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (4,2,37,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (4,3,41,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (4,4,38,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (4,5,39,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (4,6,40,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,1,1,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,2,42,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,3,43,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,4,44,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,5,45,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,6,46,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,7,47,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,8,48,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,9,49,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,10,50,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,11,51,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,12,24,NULL);
INSERT INTO CFG_EBOM (ETYPE_ID,EXEC_ORDER,FTYPE_ID,UTYPE_ID) VALUES (5,13,26,NULL);
CREATE TABLE CFG_ESCORE (BEHAVIOR_CODE VARCHAR(25) NOT NULL, GROUPER_FEAT VARCHAR(5) NOT NULL, RICHNESS_SCORE smallint NOT NULL, EXCLUSIVITY_SCORE smallint NOT NULL) ;
ALTER TABLE CFG_ESCORE ADD CONSTRAINT CFG_ESCORE_PK PRIMARY KEY(BEHAVIOR_CODE) ;
INSERT INTO CFG_ESCORE (BEHAVIOR_CODE,GROUPER_FEAT,RICHNESS_SCORE,EXCLUSIVITY_SCORE) VALUES ('NAME','Yes',3,0);
INSERT INTO CFG_ESCORE (BEHAVIOR_CODE,GROUPER_FEAT,RICHNESS_SCORE,EXCLUSIVITY_SCORE) VALUES ('FMES','Yes',7,5);
INSERT INTO CFG_ESCORE (BEHAVIOR_CODE,GROUPER_FEAT,RICHNESS_SCORE,EXCLUSIVITY_SCORE) VALUES ('FME','No',1,3);
INSERT INTO CFG_ESCORE (BEHAVIOR_CODE,GROUPER_FEAT,RICHNESS_SCORE,EXCLUSIVITY_SCORE) VALUES ('FM','No',1,0);
INSERT INTO CFG_ESCORE (BEHAVIOR_CODE,GROUPER_FEAT,RICHNESS_SCORE,EXCLUSIVITY_SCORE) VALUES ('FFES','No',0,0);
INSERT INTO CFG_ESCORE (BEHAVIOR_CODE,GROUPER_FEAT,RICHNESS_SCORE,EXCLUSIVITY_SCORE) VALUES ('FFE','No',0,0);
INSERT INTO CFG_ESCORE (BEHAVIOR_CODE,GROUPER_FEAT,RICHNESS_SCORE,EXCLUSIVITY_SCORE) VALUES ('FF','Yes',5,0);
INSERT INTO CFG_ESCORE (BEHAVIOR_CODE,GROUPER_FEAT,RICHNESS_SCORE,EXCLUSIVITY_SCORE) VALUES ('F1ES','Yes',10,15);
INSERT INTO CFG_ESCORE (BEHAVIOR_CODE,GROUPER_FEAT,RICHNESS_SCORE,EXCLUSIVITY_SCORE) VALUES ('F1E','Yes',7,10);
INSERT INTO CFG_ESCORE (BEHAVIOR_CODE,GROUPER_FEAT,RICHNESS_SCORE,EXCLUSIVITY_SCORE) VALUES ('F1','No',5,0);
INSERT INTO CFG_ESCORE (BEHAVIOR_CODE,GROUPER_FEAT,RICHNESS_SCORE,EXCLUSIVITY_SCORE) VALUES ('NONE','No',0,0);
CREATE TABLE CFG_SFUNC (SFUNC_ID smallint NOT NULL, SFUNC_CODE VARCHAR(25) NOT NULL, SFUNC_DESC VARCHAR(50), FUNC_LIB VARCHAR(25), FUNC_VER VARCHAR(25), CONNECT_STR VARCHAR(100)) ;
ALTER TABLE CFG_SFUNC ADD CONSTRAINT CFG_SFUNC_PK PRIMARY KEY(SFUNC_ID) ;
CREATE UNIQUE INDEX CFG_SFUNC_SK ON CFG_SFUNC(SFUNC_CODE) ;
INSERT INTO CFG_SFUNC (SFUNC_ID,SFUNC_CODE,SFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (1,'PARSE_NAME','Parse name','g2func_lib','1','g2ParseName');
INSERT INTO CFG_SFUNC (SFUNC_ID,SFUNC_CODE,SFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (2,'PARSE_DOB','Parse DOB','g2func_lib','1','g2ParseDOB');
INSERT INTO CFG_SFUNC (SFUNC_ID,SFUNC_CODE,SFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (4,'FORMAT_SSN','Parse SSN','g2func_lib','1','g2FormatSSN');
INSERT INTO CFG_SFUNC (SFUNC_ID,SFUNC_CODE,SFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (6,'PARSE_ID','Parse ID numbers','g2func_lib','1','g2ParseID');
INSERT INTO CFG_SFUNC (SFUNC_ID,SFUNC_CODE,SFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (7,'PARSE_ADDR','Parse address','g2func_lib','1','g2ConfigParseAddr');
INSERT INTO CFG_SFUNC (SFUNC_ID,SFUNC_CODE,SFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (8,'PARSE_PHONE','Parse phone','g2func_lib','1','g2ParsePhone');
CREATE TABLE CFG_SFCALL (SFCALL_ID smallint NOT NULL, FTYPE_ID smallint NOT NULL, SFUNC_ID smallint NOT NULL, EXEC_ORDER smallint NOT NULL) ;
ALTER TABLE CFG_SFCALL ADD CONSTRAINT CFG_SFCALL_PK PRIMARY KEY(SFCALL_ID) ;
CREATE UNIQUE INDEX CFG_SFCALL_SK ON CFG_SFCALL(FTYPE_ID, SFUNC_ID) ;
INSERT INTO CFG_SFCALL (SFCALL_ID,FTYPE_ID,SFUNC_ID,EXEC_ORDER) VALUES (1,1,1,1);
INSERT INTO CFG_SFCALL (SFCALL_ID,FTYPE_ID,SFUNC_ID,EXEC_ORDER) VALUES (2,2,2,1);
INSERT INTO CFG_SFCALL (SFCALL_ID,FTYPE_ID,SFUNC_ID,EXEC_ORDER) VALUES (3,5,7,1);
INSERT INTO CFG_SFCALL (SFCALL_ID,FTYPE_ID,SFUNC_ID,EXEC_ORDER) VALUES (4,6,8,1);
INSERT INTO CFG_SFCALL (SFCALL_ID,FTYPE_ID,SFUNC_ID,EXEC_ORDER) VALUES (5,7,4,1);
INSERT INTO CFG_SFCALL (SFCALL_ID,FTYPE_ID,SFUNC_ID,EXEC_ORDER) VALUES (6,9,6,1);
INSERT INTO CFG_SFCALL (SFCALL_ID,FTYPE_ID,SFUNC_ID,EXEC_ORDER) VALUES (7,10,6,1);
INSERT INTO CFG_SFCALL (SFCALL_ID,FTYPE_ID,SFUNC_ID,EXEC_ORDER) VALUES (8,12,6,1);
INSERT INTO CFG_SFCALL (SFCALL_ID,FTYPE_ID,SFUNC_ID,EXEC_ORDER) VALUES (9,24,9,1);
INSERT INTO CFG_SFCALL (SFCALL_ID,FTYPE_ID,SFUNC_ID,EXEC_ORDER) VALUES (10,37,6,1);
CREATE TABLE CFG_EFUNC (EFUNC_ID smallint NOT NULL, EFUNC_CODE VARCHAR(25) NOT NULL, EFUNC_DESC VARCHAR(50), FUNC_LIB VARCHAR(25), FUNC_VER VARCHAR(25), CONNECT_STR VARCHAR(100)) ;
ALTER TABLE CFG_EFUNC ADD CONSTRAINT CFG_EFUNC_PK PRIMARY KEY(EFUNC_ID) ;
CREATE UNIQUE INDEX CFG_EFUNC_SK ON CFG_EFUNC(EFUNC_CODE) ;
INSERT INTO CFG_EFUNC (EFUNC_ID,EFUNC_CODE,EFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (1,'EXPRESS_BOM','General BOM Hasher','g2func_lib','1','g2GenericHasher');
INSERT INTO CFG_EFUNC (EFUNC_ID,EFUNC_CODE,EFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (2,'NAME_HASHER','Name expression','g2func_lib','1','g2NameHasher');
INSERT INTO CFG_EFUNC (EFUNC_ID,EFUNC_CODE,EFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (3,'ADDR_HASHER','Address expression','g2func_lib','1','g2AddressHasher');
INSERT INTO CFG_EFUNC (EFUNC_ID,EFUNC_CODE,EFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (4,'PHONE_HASHER','Phone Hasher','g2func_lib','1','g2PhoneHasher');
INSERT INTO CFG_EFUNC (EFUNC_ID,EFUNC_CODE,EFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (5,'EXPRESS_ID','General ID Hasher','g2funclib','1','g2IDHasher');
CREATE TABLE CFG_EFCALL (EFCALL_ID smallint NOT NULL, FTYPE_ID smallint NOT NULL, EFUNC_ID smallint NOT NULL, EXEC_ORDER smallint NOT NULL) ;
ALTER TABLE CFG_EFCALL ADD CONSTRAINT CFG_EFCALL_PK PRIMARY KEY(EFCALL_ID) ;
CREATE UNIQUE INDEX CFG_EFCALL_SK ON CFG_EFCALL(FTYPE_ID, EFUNC_ID) ;
INSERT INTO CFG_EFCALL (EFCALL_ID,FTYPE_ID,EFUNC_ID,EXEC_ORDER) VALUES (1,6,4,1);
INSERT INTO CFG_EFCALL (EFCALL_ID,FTYPE_ID,EFUNC_ID,EXEC_ORDER) VALUES (2,9,5,1);
INSERT INTO CFG_EFCALL (EFCALL_ID,FTYPE_ID,EFUNC_ID,EXEC_ORDER) VALUES (3,10,5,1);
INSERT INTO CFG_EFCALL (EFCALL_ID,FTYPE_ID,EFUNC_ID,EXEC_ORDER) VALUES (4,12,5,1);
INSERT INTO CFG_EFCALL (EFCALL_ID,FTYPE_ID,EFUNC_ID,EXEC_ORDER) VALUES (5,13,1,1);
INSERT INTO CFG_EFCALL (EFCALL_ID,FTYPE_ID,EFUNC_ID,EXEC_ORDER) VALUES (7,1,2,2);
INSERT INTO CFG_EFCALL (EFCALL_ID,FTYPE_ID,EFUNC_ID,EXEC_ORDER) VALUES (8,37,5,1);
CREATE TABLE CFG_EFBOM (EFCALL_ID smallint NOT NULL, FTYPE_ID smallint NOT NULL, FELEM_ID smallint NOT NULL, EXEC_ORDER smallint NOT NULL, FELEM_REQ VARCHAR(5) NOT NULL) ;
ALTER TABLE CFG_EFBOM ADD CONSTRAINT CFG_EFBOM_PK PRIMARY KEY(EFCALL_ID, FTYPE_ID, FELEM_ID) ;
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (1,6,60,1,'Yes');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (2,9,69,1,'Yes');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (3,10,69,1,'Yes');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (4,12,69,1,'Yes');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (5,13,56,1,'Yes');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,1,3,1,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,1,4,2,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,1,5,3,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,1,6,4,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,1,2,5,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,1,10,6,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,1,11,7,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,1,12,8,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,1,77,9,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,1,78,10,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,1,79,11,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,2,71,12,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (7,8,39,13,'No');
INSERT INTO CFG_EFBOM (EFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER,FELEM_REQ) VALUES (8,37,69,1,'Yes');
CREATE TABLE CFG_CFUNC (CFUNC_ID smallint NOT NULL, CFUNC_CODE VARCHAR(25) NOT NULL, CFUNC_DESC VARCHAR(50), FUNC_LIB VARCHAR(25), FUNC_VER VARCHAR(25), CONNECT_STR VARCHAR(100), ANON_SUPPORT VARCHAR(5)) ;
ALTER TABLE CFG_CFUNC ADD CONSTRAINT CFG_CFUNC_PK PRIMARY KEY(CFUNC_ID) ;
CREATE UNIQUE INDEX CFG_CFUNC_SK ON CFG_CFUNC(CFUNC_CODE) ;
INSERT INTO CFG_CFUNC (CFUNC_ID,CFUNC_CODE,CFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR,ANON_SUPPORT) VALUES (1,'STR_COMP','String comparison','INT_LIB','1','g2StringComp','Yes');
INSERT INTO CFG_CFUNC (CFUNC_ID,CFUNC_CODE,CFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR,ANON_SUPPORT) VALUES (2,'GNR_COMP','GNR name comparison','INT_LIB','1','g2GNRNameComp','Yes');
INSERT INTO CFG_CFUNC (CFUNC_ID,CFUNC_CODE,CFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR,ANON_SUPPORT) VALUES (3,'EXACT_COMP','Exact match comp','INT_LIB','1','g2ExactMatchComp','Yes');
INSERT INTO CFG_CFUNC (CFUNC_ID,CFUNC_CODE,CFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR,ANON_SUPPORT) VALUES (4,'ADDR_COMP','Address comparison','INT_LIB','1','g2AddressComp','Yes');
INSERT INTO CFG_CFUNC (CFUNC_ID,CFUNC_CODE,CFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR,ANON_SUPPORT) VALUES (5,'DOB_COMP','DOB comparison','INT_LIB','1','g2DateComp','Yes');
INSERT INTO CFG_CFUNC (CFUNC_ID,CFUNC_CODE,CFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR,ANON_SUPPORT) VALUES (7,'PHONE_COMP','Phone comparison','INT_LIB','1','g2PhoneComp','Yes');
INSERT INTO CFG_CFUNC (CFUNC_ID,CFUNC_CODE,CFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR,ANON_SUPPORT) VALUES (8,'SSN_COMP','SSN comp','INT_LIB','1','g2SSNComp','Yes');
INSERT INTO CFG_CFUNC (CFUNC_ID,CFUNC_CODE,CFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR,ANON_SUPPORT) VALUES (9,'ID_COMP','ID Comparison','INT_LIB','1','g2DLComp','Yes');
CREATE TABLE CFG_CFRTN (CFRTN_ID smallint NOT NULL, CFUNC_ID smallint NOT NULL, CFUNC_RTNVAL VARCHAR(25) NOT NULL, EXEC_ORDER smallint NOT NULL, SAME_SCORE smallint NOT NULL, CLOSE_SCORE smallint NOT NULL, LIKELY_SCORE smallint NOT NULL, PLAUSIBLE_SCORE smallint NOT NULL, UN_LIKELY_SCORE smallint NOT NULL) ;
ALTER TABLE CFG_CFRTN ADD CONSTRAINT CFG_CFRTN_PK PRIMARY KEY(CFRTN_ID) ;
CREATE UNIQUE INDEX CFG_CFRTN_SK ON CFG_CFRTN(CFUNC_ID, CFUNC_RTNVAL) ;
INSERT INTO CFG_CFRTN (CFRTN_ID,CFUNC_ID,CFUNC_RTNVAL,EXEC_ORDER,SAME_SCORE,CLOSE_SCORE,LIKELY_SCORE,PLAUSIBLE_SCORE,UN_LIKELY_SCORE) VALUES (1,1,'FULL_SCORE',1,100,90,80,70,60);
INSERT INTO CFG_CFRTN (CFRTN_ID,CFUNC_ID,CFUNC_RTNVAL,EXEC_ORDER,SAME_SCORE,CLOSE_SCORE,LIKELY_SCORE,PLAUSIBLE_SCORE,UN_LIKELY_SCORE) VALUES (2,2,'GNR_FN',1,99,95,80,70,60);
INSERT INTO CFG_CFRTN (CFRTN_ID,CFUNC_ID,CFUNC_RTNVAL,EXEC_ORDER,SAME_SCORE,CLOSE_SCORE,LIKELY_SCORE,PLAUSIBLE_SCORE,UN_LIKELY_SCORE) VALUES (3,2,'GNR_SN',2,99,95,80,70,60);
INSERT INTO CFG_CFRTN (CFRTN_ID,CFUNC_ID,CFUNC_RTNVAL,EXEC_ORDER,SAME_SCORE,CLOSE_SCORE,LIKELY_SCORE,PLAUSIBLE_SCORE,UN_LIKELY_SCORE) VALUES (4,2,'GNR_GN',3,99,95,80,70,60);
INSERT INTO CFG_CFRTN (CFRTN_ID,CFUNC_ID,CFUNC_RTNVAL,EXEC_ORDER,SAME_SCORE,CLOSE_SCORE,LIKELY_SCORE,PLAUSIBLE_SCORE,UN_LIKELY_SCORE) VALUES (6,2,'GENERATION_MATCH',4,2,2,2,2,1);
INSERT INTO CFG_CFRTN (CFRTN_ID,CFUNC_ID,CFUNC_RTNVAL,EXEC_ORDER,SAME_SCORE,CLOSE_SCORE,LIKELY_SCORE,PLAUSIBLE_SCORE,UN_LIKELY_SCORE) VALUES (5,3,'FULL_SCORE',1,100,90,80,70,60);
INSERT INTO CFG_CFRTN (CFRTN_ID,CFUNC_ID,CFUNC_RTNVAL,EXEC_ORDER,SAME_SCORE,CLOSE_SCORE,LIKELY_SCORE,PLAUSIBLE_SCORE,UN_LIKELY_SCORE) VALUES (7,4,'MATCH_SCORE',1,100,90,80,70,60);
INSERT INTO CFG_CFRTN (CFRTN_ID,CFUNC_ID,CFUNC_RTNVAL,EXEC_ORDER,SAME_SCORE,CLOSE_SCORE,LIKELY_SCORE,PLAUSIBLE_SCORE,UN_LIKELY_SCORE) VALUES (8,4,'ZIP_SCORE',2,100,90,80,70,60);
INSERT INTO CFG_CFRTN (CFRTN_ID,CFUNC_ID,CFUNC_RTNVAL,EXEC_ORDER,SAME_SCORE,CLOSE_SCORE,LIKELY_SCORE,PLAUSIBLE_SCORE,UN_LIKELY_SCORE) VALUES (9,5,'FULL_SCORE',1,100,90,80,70,60);
INSERT INTO CFG_CFRTN (CFRTN_ID,CFUNC_ID,CFUNC_RTNVAL,EXEC_ORDER,SAME_SCORE,CLOSE_SCORE,LIKELY_SCORE,PLAUSIBLE_SCORE,UN_LIKELY_SCORE) VALUES (10,7,'FULL_SCORE',1,100,90,80,70,60);
INSERT INTO CFG_CFRTN (CFRTN_ID,CFUNC_ID,CFUNC_RTNVAL,EXEC_ORDER,SAME_SCORE,CLOSE_SCORE,LIKELY_SCORE,PLAUSIBLE_SCORE,UN_LIKELY_SCORE) VALUES (11,8,'FULL_SCORE',1,100,95,80,70,60);
INSERT INTO CFG_CFRTN (CFRTN_ID,CFUNC_ID,CFUNC_RTNVAL,EXEC_ORDER,SAME_SCORE,CLOSE_SCORE,LIKELY_SCORE,PLAUSIBLE_SCORE,UN_LIKELY_SCORE) VALUES (12,9,'FULL_SCORE',1,100,90,80,70,60);
CREATE TABLE CFG_CFCALL (CFCALL_ID smallint NOT NULL, FTYPE_ID smallint NOT NULL, CFUNC_ID smallint NOT NULL, EXEC_ORDER smallint NOT NULL) ;
ALTER TABLE CFG_CFCALL ADD CONSTRAINT CFG_CFCALL_PK PRIMARY KEY(CFCALL_ID) ;
CREATE UNIQUE INDEX CFG_CFCALL_SK ON CFG_CFCALL(FTYPE_ID, CFUNC_ID) ;
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (1,1,2,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (2,2,5,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (3,3,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (4,4,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (5,5,4,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (6,6,7,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (7,7,8,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (8,8,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (9,9,9,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (10,10,9,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (11,11,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (12,12,9,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (13,13,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (14,14,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (15,15,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (16,16,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (17,17,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (18,36,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (19,37,9,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (20,38,1,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (21,39,1,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (22,40,1,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (23,41,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (24,42,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (25,43,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (26,44,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (27,45,1,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (28,46,1,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (29,47,1,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (30,48,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (31,49,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (32,50,3,1);
INSERT INTO CFG_CFCALL (CFCALL_ID,FTYPE_ID,CFUNC_ID,EXEC_ORDER) VALUES (33,51,3,1);
CREATE TABLE CFG_CFBOM (CFCALL_ID smallint NOT NULL, FTYPE_ID smallint NOT NULL, FELEM_ID smallint NOT NULL, EXEC_ORDER smallint NOT NULL) ;
ALTER TABLE CFG_CFBOM ADD CONSTRAINT CFG_CFBOM_PK PRIMARY KEY(CFCALL_ID, FTYPE_ID, FELEM_ID) ;
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,2,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,3,2);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,4,3);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,5,4);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,6,5);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,7,6);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,8,7);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,9,8);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,10,9);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,11,10);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,12,11);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,81,12);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,83,13);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,84,14);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,86,15);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,87,16);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,89,17);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,91,18);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,92,19);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,93,20);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,94,21);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (1,1,96,22);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (2,2,43,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (2,2,62,2);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (2,2,63,3);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (2,2,64,4);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (3,3,43,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (4,4,13,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (5,5,22,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (5,5,23,2);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (5,5,24,3);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (5,5,25,4);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (5,5,26,5);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (5,5,27,6);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (5,5,28,7);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (5,5,29,8);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (5,5,30,9);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (5,5,31,10);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (5,5,32,11);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (6,6,33,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (6,6,60,2);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (6,6,61,3);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (7,7,37,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (8,8,39,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (9,9,37,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (9,9,26,2);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (10,10,37,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (10,10,28,2);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (11,11,37,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (12,12,37,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (12,12,38,2);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (13,13,56,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (13,13,57,2);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (14,14,35,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (15,15,35,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (16,16,40,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (16,16,58,2);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (17,17,36,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (18,36,37,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (19,37,37,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (19,37,26,2);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (20,38,14,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (21,39,15,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (22,40,16,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (23,41,17,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (24,42,37,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (25,43,37,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (26,44,45,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (27,45,46,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (28,46,47,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (29,47,18,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (30,48,48,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (31,49,49,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (32,50,50,1);
INSERT INTO CFG_CFBOM (CFCALL_ID,FTYPE_ID,FELEM_ID,EXEC_ORDER) VALUES (33,51,50,1);
CREATE TABLE CFG_ERFRAG (ERFRAG_ID smallint NOT NULL, ERFRAG_CODE VARCHAR(25) NOT NULL, ERFRAG_DESC VARCHAR(50) NOT NULL, ERFRAG_SOURCE VARCHAR(1000) NOT NULL, ERFRAG_DEPENDS VARCHAR(25)) ;
ALTER TABLE CFG_ERFRAG ADD CONSTRAINT CFG_ERFRAG_PK PRIMARY KEY(ERFRAG_ID) ;
CREATE UNIQUE INDEX CFG_ERFRAG_SK ON CFG_ERFRAG(ERFRAG_CODE) ;
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (9,'GROUPER_KEY','GROUPER_KEY','/CANDIDATE/SCORES/GROUPER_KEY[./FULL_SCORE = 100]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (11,'SAME_NAME','SAME_NAME','/CANDIDATE/SCORES/NAME[./GNR_FN >= 95 and ./GNR_GN >= 95 and ./GNR_SN >= 95]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (12,'CLOSE_NAME','CLOSE_NAME','/CANDIDATE/SCORES/NAME[./GNR_FN >= 90 and ./GNR_GN >= 90 and ./GNR_SN >= 90]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (13,'PART_NAME','PART_NAME','/CANDIDATE/SCORES/NAME[./GNR_FN >= 85 or ./GNR_GN >= 95]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (14,'SUR_NAME','SUR_NAME','/CANDIDATE/SCORES/NAME[./GNR_SN >= 95]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (15,'DIFF_NAME','DIFF_NAME','/CANDIDATE/SUMMARY/BEHAVIOR/NAME[./LIKELY + ./PLAUSIBLE + ./UNLIKELY + ./NO_CHANCE > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (16,'NO_NAME','NO_NAME','/CANDIDATE/SUMMARY/BEHAVIOR/NAME[./SAME + ./CLOSE + ./LIKELY + ./PLAUSIBLE + ./UNLIKELY + ./NO_CHANCE = 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (20,'MULT_F1','MULT_F1','/CANDIDATE/SUMMARY/BEHAVIOR/F1[./SAME > 1]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (21,'SAME_F1','SAME_F1','/CANDIDATE/SUMMARY/BEHAVIOR/F1[./SAME > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (25,'DIFF_F1','DIFF_F1','/CANDIDATE/SUMMARY/BEHAVIOR/F1[./LIKELY + ./PLAUSIBLE + ./UNLIKELY + ./NO_CHANCE > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (26,'NO_F1','NO_F1','/CANDIDATE/SUMMARY/BEHAVIOR/F1[./SAME + ./CLOSE + ./LIKELY + ./PLAUSIBLE + ./UNLIKELY + ./NO_CHANCE = 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (31,'SAME_FF','SAME_FF','/CANDIDATE/SUMMARY/BEHAVIOR/FF[./SAME > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (32,'CLOSE_FF','CLOSE_FF','/CANDIDATE/SUMMARY/BEHAVIOR/FF[./SAME + ./CLOSE > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (35,'DIFF_FF','DIFF_FF','/CANDIDATE/SUMMARY/BEHAVIOR/FF[./LIKELY + ./PLAUSIBLE + ./UNLIKELY + ./NO_CHANCE > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (36,'NO_FF','NO_FF','/CANDIDATE/SUMMARY/BEHAVIOR/FF[./SAME + ./CLOSE + ./LIKELY + ./PLAUSIBLE + ./UNLIKELY + ./NO_CHANCE = 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (41,'SAME_FMES','SAME_FMES','/CANDIDATE/SUMMARY/BEHAVIOR/FMES[./SAME > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (42,'CLOSE_FMES','CLOSE_FMES','/CANDIDATE/SUMMARY/BEHAVIOR/FMES[./SAME + ./CLOSE > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (45,'DIFF_FMES','DIFF_FMES','/CANDIDATE/SUMMARY/BEHAVIOR/FMES[./LIKELY + ./PLAUSIBLE + ./UNLIKELY + ./NO_CHANCE > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (46,'NO_FMES','NO_FMES','/CANDIDATE/SUMMARY/BEHAVIOR/FMES[./SAME + ./CLOSE + ./LIKELY + ./PLAUSIBLE + ./UNLIKELY + ./NO_CHANCE = 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (51,'SAME_EXCL','SAME_EXCL','/CANDIDATE/SUMMARY/BEHAVIOR/EXCLUSIVE[./SAME > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (52,'CLOSE_EXCL','CLOSE_EXCL','/CANDIDATE/SUMMARY/BEHAVIOR/EXCLUSIVE[./SAME + ./CLOSE > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (55,'DIFF_EXCL','DIFF_EXCL','/CANDIDATE/SUMMARY/BEHAVIOR/EXCLUSIVE[./LIKELY + ./PLAUSIBLE + ./UNLIKELY + ./NO_CHANCE > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (56,'NO_EXCL','NO_EXCL','/CANDIDATE/SUMMARY/BEHAVIOR/EXCLUSIVE[./SAME + ./CLOSE + ./LIKELY + ./PLAUSIBLE + ./UNLIKELY + ./NO_CHANCE = 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (60,'MULT_STAB','MULT_STAB','/CANDIDATE/SUMMARY/BEHAVIOR/STABLE[./SAME > 1]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (61,'SAME_STAB','SAME_STAB','/CANDIDATE/SUMMARY/BEHAVIOR/STABLE[./SAME > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (62,'CLOSE_STAB','CLOSE_STAB','/CANDIDATE/SUMMARY/BEHAVIOR/STABLE[./SAME + ./CLOSE > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (65,'DIFF_STAB','DIFF_STAB','/CANDIDATE/SUMMARY/BEHAVIOR/STABLE[./LIKELY + ./PLAUSIBLE + ./UNLIKELY + ./NO_CHANCE > 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (66,'NO_STAB','NO_STAB','/CANDIDATE/SUMMARY/BEHAVIOR/STABLE[./SAME + ./CLOSE + ./LIKELY + ./PLAUSIBLE + ./UNLIKELY + ./NO_CHANCE = 0]',NULL);
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (71,'NO_CONF1','NO_CONF1','/CANDIDATE/FRAGMENT[./DIFF_NAME + ./DIFF_EXCL = 0]','15,55');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (101,'SF1_PNAME_CFF_CSTAB','SAME_F1+PART_NAME+CLOSE_FF+CLOSE_STAB','/CANDIDATE/FRAGMENT[./SAME_F1>0 and ./PART_NAME>0 and ./CLOSE_FF>0 and ./CLOSE_STAB>0]','21,13,32,62');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (102,'SF1_PNAME_CFF_DSTAB','SAME_F1+PART_NAME+CLOSE_FF+DIFF_STAB','/CANDIDATE/FRAGMENT[./SAME_F1>0 and ./PART_NAME>0 and ./CLOSE_FF>0 and ./DIFF_STAB>0]','21,13,32,65');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (103,'SF1_PNAME_CFF','SAME_F1+PART_NAME+CLOSE_FF','/CANDIDATE/FRAGMENT[./SAME_F1>0 and ./PART_NAME>0 and ./CLOSE_FF>0]','21,13,32');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (104,'SF1_PNAME_CSTAB','SAME_F1+PART_NAME+CLOSE_STAB','/CANDIDATE/FRAGMENT[./SAME_F1>0 and ./PART_NAME>0 and ./CLOSE_STAB>0]','21,13,62');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (105,'SF1_PNAME_DSTAB','SAME_F1+PART_NAME+DIFF_STAB','/CANDIDATE/FRAGMENT[./SAME_F1>0 and ./PART_NAME>0 and ./DIFF_STAB>0]','21,13,65');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (106,'SF1_PNAME','SAME_F1+PART_NAME','/CANDIDATE/FRAGMENT[./SAME_F1>0 and ./PART_NAME>0]','21,13');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (107,'PNAME_MSTAB_CFF','PART_NAME+MULT_STAB+CLOSE_FF','/CANDIDATE/FRAGMENT[./PART_NAME>0 and ./MULT_STAB>0 and ./CLOSE_FF>0]','13,60,32');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (108,'PNAME_MSTAB','PART_NAME+MULT_STAB','/CANDIDATE/FRAGMENT[./PART_NAME>0 and ./MULT_STAB>0]','13,60');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (109,'CNAME_CFF_CSTAB','CLOSE_NAME+CLOSE_FF+CLOSE_STAB','/CANDIDATE/FRAGMENT[./CLOSE_NAME>0 and ./CLOSE_FF>0 and ./CLOSE_STAB>0]','12,32,62');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (110,'CNAME_CFF_DEXCL','CLOSE_NAME+CLOSE_FF+DIFF_EXCL','/CANDIDATE/FRAGMENT[./CLOSE_NAME>0 and ./CLOSE_FF>0 and ./DIFF_EXCL>0]','12,32,55');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (111,'CNAME_CFF','CLOSE_NAME+CLOSE_FF','/CANDIDATE/FRAGMENT[./CLOSE_NAME>0 and ./CLOSE_FF>0]','12,32');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (112,'SF1_CFF_CSTAB','SAME_F1+CLOSE_FF+CLOSE_STAB','/CANDIDATE/FRAGMENT[./SAME_F1>0 and ./CLOSE_FF>0 and ./CLOSE_STAB>0]','21,32,62');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (113,'SF1_NCONF','SAME_F1+NO_CONF1','/CANDIDATE/FRAGMENT[./SAME_F1>0 and ./NO_CONF1>0]','21,71');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (114,'MSTAB_NCONF','MULT_STAB+NO_CONF1','/CANDIDATE/FRAGMENT[./MULT_STAB>0 and ./NO_CONF1>0]','60,71');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (115,'SF1','SAME_F1','/CANDIDATE/FRAGMENT[./SAME_F1>0]','21');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (116,'SNAME_SSTAB','SAME_NAME+SAME_STAB','/CANDIDATE/FRAGMENT[./SAME_NAME>0 and ./SAME_STAB>0]','11,61');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (117,'SURNAME_CFF','SUR_NAME+CLOSE_FF','/CANDIDATE/FRAGMENT[./SUR_NAME>0 and ./CLOSE_FF>0]','14,32');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (118,'CFF','CLOSE_FF','/CANDIDATE/FRAGMENT[./CLOSE_FF>0]','32');
INSERT INTO CFG_ERFRAG (ERFRAG_ID,ERFRAG_CODE,ERFRAG_DESC,ERFRAG_SOURCE,ERFRAG_DEPENDS) VALUES (119,'CNAME','CLOSE_NAME','/CANDIDATE/FRAGMENT[./CLOSE_NAME>0]','12');
CREATE TABLE CFG_ERRULE (ERRULE_ID smallint NOT NULL, ERRULE_CODE VARCHAR(25) NOT NULL, ERRULE_DESC VARCHAR(50) NOT NULL, RESOLVE VARCHAR(5) NOT NULL, RELATE VARCHAR(5) NOT NULL, REF_SCORE smallint NOT NULL, RTYPE_ID smallint, QUAL_ERFRAG_CODE VARCHAR(1000) NOT NULL, DISQ_ERFRAG_CODE VARCHAR(1000)) ;
ALTER TABLE CFG_ERRULE ADD CONSTRAINT CFG_ERRULE_PK PRIMARY KEY(ERRULE_ID) ;
CREATE UNIQUE INDEX CFG_ERRULE_SK ON CFG_ERRULE(ERRULE_CODE) ;
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (99,'GROUPER_KEY','GROUPER_KEY','Yes','No',10,2,'GROUPER_KEY',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (101,'SF1_PNAME_CFF_CSTAB','SAME_F1+PART_NAME+CLOSE_FF+CLOSE_STAB','Yes','No',10,2,'SF1_PNAME_CFF_CSTAB','DIFF_STAB');
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (102,'SF1_PNAME_CFF_DSTAB','SAME_F1+PART_NAME+CLOSE_FF+DIFF_STAB','Yes','No',8,2,'SF1_PNAME_CFF_DSTAB',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (103,'SF1_PNAME_CFF','SAME_F1+PART_NAME+CLOSE_FF','Yes','No',9,2,'SF1_PNAME_CFF',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (104,'SF1_PNAME_CSTAB','SAME_F1+PART_NAME+CLOSE_STAB','Yes','No',9,2,'SF1_PNAME_CSTAB','DIFF_STAB');
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (105,'SF1_PNAME_DSTAB','SAME_F1+PART_NAME+DIFF_STAB','No','Yes',7,2,'SF1_PNAME_DSTAB',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (106,'SF1_PNAME','SAME_F1+PART_NAME','Yes','No',8,2,'SF1_PNAME',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (107,'PNAME_MSTAB_CFF','PART_NAME+MULT_STAB+CLOSE_FF','Yes','No',10,2,'PNAME_MSTAB_CFF',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (108,'PNAME_MSTAB','PART_NAME+MULT_STAB','Yes','No',9,2,'PNAME_MSTAB',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (109,'CNAME_CFF_CSTAB','CLOSE_NAME+CLOSE_FF+CLOSE_STAB','Yes','No',8,2,'CNAME_CFF_CSTAB','DIFF_STAB');
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (110,'CNAME_CFF_DEXCL','CLOSE_NAME+CLOSE_FF+DIFF_EXCL','No','Yes',6,2,'CNAME_CFF_DEXCL',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (111,'CNAME_CFF','CLOSE_NAME+CLOSE_FF','No','Yes',7,2,'CNAME_CFF',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (112,'SF1_CFF_CSTAB','SAME_F1+CLOSE_FF+CLOSE_STAB','Yes','No',8,2,'SF1_CFF_CSTAB','DIFF_STAB');
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (113,'SF1_NCONF','SAME_F1+NO_CONF1','Yes','No',7,2,'SF1_NCONF',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (114,'MSTAB_NCONF','MULT_STAB+NO_CONF1','Yes','No',7,2,'MSTAB_NCONF',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (115,'SF1','SAME_F1','No','Yes',5,2,'SF1',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (116,'SNAME_SSTAB','SAME_NAME+SAME_STAB','No','Yes',6,3,'SNAME_SSTAB','DIFF_STAB');
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (117,'SURNAME_CFF','SUR_NAME+CLOSE_FF','No','Yes',5,3,'SURNAME_CFF',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (118,'CFF','CLOSE_FF','No','No',4,3,'CFF',NULL);
INSERT INTO CFG_ERRULE (ERRULE_ID,ERRULE_CODE,ERRULE_DESC,RESOLVE,RELATE,REF_SCORE,RTYPE_ID,QUAL_ERFRAG_CODE,DISQ_ERFRAG_CODE) VALUES (119,'CNAME','CLOSE_NAME','No','No',2,NULL,'CNAME',NULL);
CREATE TABLE CFG_LENS (LENS_ID smallint NOT NULL, LENS_CODE VARCHAR(25) NOT NULL, LENS_DESC VARCHAR(50)) ;
ALTER TABLE CFG_LENS ADD CONSTRAINT CFG_LENS_PK PRIMARY KEY(LENS_ID) ;
CREATE UNIQUE INDEX CFG_LENS_SK ON CFG_LENS(LENS_CODE) ;
INSERT INTO CFG_LENS (LENS_ID,LENS_CODE,LENS_DESC) VALUES (1,'DEFAULT','Default lens');
CREATE TABLE CFG_LENSRL (LENS_ID smallint NOT NULL, ERRULE_ID smallint NOT NULL, EXEC_ORDER smallint NOT NULL) ;
ALTER TABLE CFG_LENSRL ADD CONSTRAINT CFG_LENSRL_PK PRIMARY KEY(LENS_ID, ERRULE_ID) ;
CREATE TABLE CFG_OMFUNC (OMFUNC_ID smallint NOT NULL, OMFUNC_CODE VARCHAR(25) NOT NULL, OMFUNC_DESC VARCHAR(50), FUNC_LIB VARCHAR(25), FUNC_VER VARCHAR(25), CONNECT_STR VARCHAR(100) NOT NULL) ;
ALTER TABLE CFG_OMFUNC ADD CONSTRAINT CFG_OMFUNC_PK PRIMARY KEY(OMFUNC_ID) ;
CREATE UNIQUE INDEX CFG_OMFUNC_SK ON CFG_OMFUNC(OMFUNC_CODE) ;
INSERT INTO CFG_OMFUNC (OMFUNC_ID,OMFUNC_CODE,OMFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (1,'DEBUG_OUTPUT','Debug output','INT_LIB','1','DefaultBuilder');
INSERT INTO CFG_OMFUNC (OMFUNC_ID,OMFUNC_CODE,OMFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (2,'MSG_BUILDER','Message Builder','INT_LIB','1','SADocBuilder');
INSERT INTO CFG_OMFUNC (OMFUNC_ID,OMFUNC_CODE,OMFUNC_DESC,FUNC_LIB,FUNC_VER,CONNECT_STR) VALUES (3,'CONF_ENT_BUILDER','Confused Entity Message Builder','INT_LIB','1','ConfusedEntityBuilder');
CREATE TABLE CFG_OMFUNCP (OMFUNCP_ID smallint NOT NULL, PARAM_GROUP VARCHAR(50) NOT NULL, PARAM_CODE VARCHAR(50) NOT NULL, CURRENT_VALUE VARCHAR(50), DEFAULT_VALUE VARCHAR(50), DATA_TYPE VARCHAR(50) NOT NULL, VALIDATION_TYPE VARCHAR(50), VALIDATION_ARG VARCHAR(50), HIDDEN_FLAG VARCHAR(50) NOT NULL) ;
ALTER TABLE CFG_OMFUNCP ADD CONSTRAINT CFG_OMFUNCP_PK PRIMARY KEY(OMFUNCP_ID) ;
CREATE UNIQUE INDEX CFG_OMFUNCP_SK ON CFG_OMFUNCP(PARAM_GROUP, PARAM_CODE) ;
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (1,'MSG_BUILDER','LENS_ID','1','1','integer','List','1','Yes');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (2,'MSG_BUILDER','MSG_STYLE','Resume','Resume','string','List','Resume/Candidate','No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (3,'MSG_BUILDER','XPATH_FILTER','','','string',NULL,NULL,'No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (4,'MSG_BUILDER','SAME_ETYPE_ONLY','No','No','string','List','Yes,No','No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (5,'MSG_BUILDER','INC_ENT_SUM','No','No','string','List','Yes,No','No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (6,'MSG_BUILDER','INC_FEAT_SUM','No','No','string','List','Yes,No','No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (7,'MSG_BUILDER','INC_OBS_LIST','No','No','string','List','Yes,No','No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (8,'MSG_BUILDER','DSRC_FILTER','None','None','string',NULL,'Include/Exclude/None','No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (9,'MSG_BUILDER','DSRC_LIST','None','None','string',NULL,NULL,'No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (10,'MSG_BUILDER','FEAT_FILTER','None','None','string',NULL,'Include/Exclude/None','No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (11,'MSG_BUILDER','FEAT_LIST','None','None','string',NULL,NULL,'No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (12,'MSG_BUILDER','INC_REL_ENT_LIST','No','No','string','List','Yes,No','No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (14,'MSG_BUILDER','REL_MAX_DEPTH','3','3','integer',NULL,NULL,'No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (15,'MSG_BUILDER','REL_MIN_DEPTH','1','1','integer',NULL,NULL,'No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (16,'MSG_BUILDER','REL_ENT_SUM','No','No','string','List','Yes,No','No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (17,'MSG_BUILDER','REL_FEAT_SUM','No','No','string','List','Yes,No','No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (18,'MSG_BUILDER','REL_REL_DETAIL','No','No','string','List','Yes,No','No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (19,'MSG_BUILDER','REL_DSRC_FILTER','None','None','string',NULL,NULL,'No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (20,'MSG_BUILDER','REL_DSRC_LIST','None','None','string',NULL,NULL,'No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (21,'MSG_BUILDER','REL_FEAT_FILTER','None','None','string',NULL,NULL,'No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (22,'MSG_BUILDER','REL_FEAT_LIST','None','None','string',NULL,NULL,'No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (23,'MSG_BUILDER','RELEVANT_SPATIAL_THRESHOLD','35','35','integer',NULL,NULL,'No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (24,'MSG_BUILDER','REL_INCLUDE','ALL','ALL','string','List','NONE/CLOSE/ALL','No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (25,'MSG_BUILDER','CLOSE_RELATIONSHIP_THRESHOLD','7','7','integer',NULL,NULL,'No');
INSERT INTO CFG_OMFUNCP (OMFUNCP_ID,PARAM_GROUP,PARAM_CODE,CURRENT_VALUE,DEFAULT_VALUE,DATA_TYPE,VALIDATION_TYPE,VALIDATION_ARG,HIDDEN_FLAG) VALUES (26,'MSG_BUILDER','REL_OBS_LIST','No','No','string','List','Yes,No','No');
CREATE TABLE CFG_ROUTE (ROUTE_ID smallint NOT NULL, ROUTE_CODE VARCHAR(25) NOT NULL, ROUTE_DESC VARCHAR(50), ROUTE_FILTER VARCHAR(1000), OMFUNC_ID smallint NOT NULL, TRANSPORT_URI VARCHAR(512), ENABLED CHAR(1) WITH DEFAULT 'Y' NOT NULL) ;
ALTER TABLE CFG_ROUTE ADD CONSTRAINT CFG_ROUTE_PK PRIMARY KEY(ROUTE_ID) ;
INSERT INTO CFG_ROUTE (ROUTE_ID,ROUTE_CODE,ROUTE_DESC,ROUTE_FILTER,OMFUNC_ID,TRANSPORT_URI,ENABLED) VALUES (1,'DEBUG_ROUTE','Debug route','',1,'','N');
INSERT INTO CFG_ROUTE (ROUTE_ID,ROUTE_CODE,ROUTE_DESC,ROUTE_FILTER,OMFUNC_ID,TRANSPORT_URI,ENABLED) VALUES (2,'RESUME','Entity resume','/UMF_DOC/INBOUND[./DSRC_CODE!="SEARCH"]',2,'','N');
INSERT INTO CFG_ROUTE (ROUTE_ID,ROUTE_CODE,ROUTE_DESC,ROUTE_FILTER,OMFUNC_ID,TRANSPORT_URI,ENABLED) VALUES (3,'RESUME+CAND','Entity and candidate resumes','/UMF_DOC/INBOUND[./DSRC_CODE!="SEARCH"]',2,'','N');
INSERT INTO CFG_ROUTE (ROUTE_ID,ROUTE_CODE,ROUTE_DESC,ROUTE_FILTER,OMFUNC_ID,TRANSPORT_URI,ENABLED) VALUES (4,'SEARCH_EXACT','Search exact','/UMF_DOC[./ROUTE_CODE="SEARCH_EXACT"]',2,'','Y');
INSERT INTO CFG_ROUTE (ROUTE_ID,ROUTE_CODE,ROUTE_DESC,ROUTE_FILTER,OMFUNC_ID,TRANSPORT_URI,ENABLED) VALUES (5,'SEARCH_CLOSE','Search close','/UMF_DOC[./ROUTE_CODE="SEARCH_CLOSE"]',2,'','Y');
INSERT INTO CFG_ROUTE (ROUTE_ID,ROUTE_CODE,ROUTE_DESC,ROUTE_FILTER,OMFUNC_ID,TRANSPORT_URI,ENABLED) VALUES (6,'SEARCH_ALL','Search all','/UMF_DOC[./ROUTE_CODE="SEARCH_ALL"]',2,'','Y');
INSERT INTO CFG_ROUTE (ROUTE_ID,ROUTE_CODE,ROUTE_DESC,ROUTE_FILTER,OMFUNC_ID,TRANSPORT_URI,ENABLED) VALUES (7,'CONFUSED_ENT', 'Detects confused entities',  'boolean(/UMF_DOC/INBOUND/LENS[not(./CONFUSED)]/CONFLICTING_EXCLUSIVES[./TOTAL_CONFLICTS >= 4 ])', 3, '', 'Y');
INSERT INTO CFG_ROUTE (ROUTE_ID,ROUTE_CODE,ROUTE_DESC,ROUTE_FILTER,OMFUNC_ID,TRANSPORT_URI,ENABLED) VALUES (8,'SEARCH_RES_ENT_ID','Search by RES_ENT_ID','/UMF_DOC[./ROUTE_CODE="SEARCH_RES_ENT_ID"]',2,'','Y');
CREATE TABLE CFG_ROUTEP (ROUTE_ID smallint NOT NULL, PARAM_CODE VARCHAR(50) NOT NULL, CURRENT_VALUE VARCHAR(3000) NOT NULL) ;
ALTER TABLE CFG_ROUTEP ADD CONSTRAINT CFG_ROUTEP_PK PRIMARY KEY(ROUTE_ID, PARAM_CODE) ;
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (2,'MSG_STYLE','Resume');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (2,'INC_ENT_SUM','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (2,'INC_FEAT_SUM','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (2,'INC_REL_ENT_LIST','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (2,'REL_ENT_SUM','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (2,'REL_FEAT_SUM','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (3,'MSG_STYLE','Candidate');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (3,'INC_OBS_LIST','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (3,'REL_OBS_LIST','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (3,'INC_REL_ENT_LIST','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (3,'REL_FEAT_SUM','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (3,'REL_ENT_SUM','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (4,'XPATH_FILTER','number(/CANDIDATE/RULE_EVALUATION/CAN_MERGE)  > 0');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (4,'MSG_STYLE','Candidate');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (4,'INC_OBS_LIST','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (4,'REL_OBS_LIST','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (5,'XPATH_FILTER','number(/CANDIDATE/SUMMARY/BEHAVIOR/F1/SAME)  > 0');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (5,'MSG_STYLE','Candidate');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (5,'INC_OBS_LIST','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (5,'REL_OBS_LIST','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (6,'MSG_STYLE','Candidate');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (6,'XPATH_FILTER','number(/CANDIDATE/RULE_EVALUATION/RULE_ID)  > 0');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (6,'INC_OBS_LIST','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (6,'REL_OBS_LIST','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (8,'XPATH_FILTER','number(/CANDIDATE/RULE_EVALUATION/CAN_MERGE)  > 0  or /CANDIDATE[./RES_ENT_ID = $INHERIT_FROM_ID$]');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (8,'MSG_STYLE','Candidate');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (8,'INC_OBS_LIST','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (8,'REL_OBS_LIST','Yes');
INSERT INTO CFG_ROUTEP (ROUTE_ID,PARAM_CODE,CURRENT_VALUE) VALUES (8,'REL_MAX_DEPTH','0');
CREATE TABLE CFG_RCLASS (RCLASS_ID smallint NOT NULL, RCLASS_CODE VARCHAR(25) NOT NULL, RCLASS_DESC VARCHAR(50), IS_DISCLOSED VARCHAR(5) NOT NULL) ;
ALTER TABLE CFG_RCLASS ADD CONSTRAINT CFG_RCLASS_PK PRIMARY KEY(RCLASS_ID) ;
INSERT INTO CFG_RCLASS (RCLASS_ID,RCLASS_CODE,RCLASS_DESC,IS_DISCLOSED) VALUES (1,'DERIVED','Derived','No');
INSERT INTO CFG_RCLASS (RCLASS_ID,RCLASS_CODE,RCLASS_DESC,IS_DISCLOSED) VALUES (2,'FAMILIAL','Familial','Yes');
INSERT INTO CFG_RCLASS (RCLASS_ID,RCLASS_CODE,RCLASS_DESC,IS_DISCLOSED) VALUES (3,'ORGANIZATIONAL','Organizational','Yes');
INSERT INTO CFG_RCLASS (RCLASS_ID,RCLASS_CODE,RCLASS_DESC,IS_DISCLOSED) VALUES (4,'OWNERSHIP','Ownership','Yes');
INSERT INTO CFG_RCLASS (RCLASS_ID,RCLASS_CODE,RCLASS_DESC,IS_DISCLOSED) VALUES (5,'EMPLOYMENT','Employment','Yes');
INSERT INTO CFG_RCLASS (RCLASS_ID,RCLASS_CODE,RCLASS_DESC,IS_DISCLOSED) VALUES (6,'COMMUNICATIONS','Communications','Yes');
INSERT INTO CFG_RCLASS (RCLASS_ID,RCLASS_CODE,RCLASS_DESC,IS_DISCLOSED) VALUES (7,'FINANCIAL','Financial','Yes');
INSERT INTO CFG_RCLASS (RCLASS_ID,RCLASS_CODE,RCLASS_DESC,IS_DISCLOSED) VALUES (8,'GENERIC','Generic','No');
CREATE TABLE CFG_RTYPE (RTYPE_ID smallint NOT NULL, RTYPE_CODE VARCHAR(25) NOT NULL, RTYPE_DESC VARCHAR(50), RCLASS_ID smallint NOT NULL, REL_STRENGTH smallint NOT NULL, BREAK_RES VARCHAR(5) WITH DEFAULT 'No' NOT NULL) ;
ALTER TABLE CFG_RTYPE ADD CONSTRAINT CFG_RTYPE_PK PRIMARY KEY(RTYPE_ID) ;
INSERT INTO CFG_RTYPE (RTYPE_ID,RTYPE_CODE,RTYPE_DESC,RCLASS_ID,REL_STRENGTH,BREAK_RES) VALUES (1,'SAME_BUT_AMBIGUOUS','Same but ambiguous',1,10,'No');
INSERT INTO CFG_RTYPE (RTYPE_ID,RTYPE_CODE,RTYPE_DESC,RCLASS_ID,REL_STRENGTH,BREAK_RES) VALUES (2,'POSSIBLY_SAME','Possibly same',1,8,'No');
INSERT INTO CFG_RTYPE (RTYPE_ID,RTYPE_CODE,RTYPE_DESC,RCLASS_ID,REL_STRENGTH,BREAK_RES) VALUES (3,'POSSIBLY_RELATED','Possibly related',1,5,'No');
INSERT INTO CFG_RTYPE (RTYPE_ID,RTYPE_CODE,RTYPE_DESC,RCLASS_ID,REL_STRENGTH,BREAK_RES) VALUES (4,'POSSIBLY_SAME_OR_RELATED','Possibly same or related',1,8,'No');
INSERT INTO CFG_RTYPE (RTYPE_ID,RTYPE_CODE,RTYPE_DESC,RCLASS_ID,REL_STRENGTH,BREAK_RES) VALUES (5,'FAMILY_LINK','Familial link',2,10,'No');
INSERT INTO CFG_RTYPE (RTYPE_ID,RTYPE_CODE,RTYPE_DESC,RCLASS_ID,REL_STRENGTH,BREAK_RES) VALUES (6,'ORG_LINK','Organization link',3,10,'No');
INSERT INTO CFG_RTYPE (RTYPE_ID,RTYPE_CODE,RTYPE_DESC,RCLASS_ID,REL_STRENGTH,BREAK_RES) VALUES (7,'COMPANY_LINK','Company link',4,10,'No');
INSERT INTO CFG_RTYPE (RTYPE_ID,RTYPE_CODE,RTYPE_DESC,RCLASS_ID,REL_STRENGTH,BREAK_RES) VALUES (8,'CREW_LINK','Crew link',5,10,'No');
INSERT INTO CFG_RTYPE (RTYPE_ID,RTYPE_CODE,RTYPE_DESC,RCLASS_ID,REL_STRENGTH,BREAK_RES) VALUES (9,'CALL_LINK','Call link',6,10,'No');
INSERT INTO CFG_RTYPE (RTYPE_ID,RTYPE_CODE,RTYPE_DESC,RCLASS_ID,REL_STRENGTH,BREAK_RES) VALUES (10,'MONEY_XFER_LINK','Money xfer link',7,10,'No');
INSERT INTO CFG_RTYPE (RTYPE_ID,RTYPE_CODE,RTYPE_DESC,RCLASS_ID,REL_STRENGTH,BREAK_RES) VALUES (11,'GENERIC_LINK','Generic link',8,10,'No');
CREATE TABLE CFG_GPLAN (GPLAN_ID smallint NOT NULL, GPLAN_CODE VARCHAR(25) NOT NULL, GPLAN_DESC VARCHAR(50)) ;
ALTER TABLE CFG_GPLAN ADD CONSTRAINT CFG_GPLAN_PK PRIMARY KEY(GPLAN_ID) ;
CREATE UNIQUE INDEX CFG_GPLAN_SK ON CFG_GPLAN(GPLAN_CODE) ;
INSERT INTO CFG_GPLAN (GPLAN_ID,GPLAN_CODE,GPLAN_DESC) VALUES (1,'INGEST','Standard Ingestion');
INSERT INTO CFG_GPLAN (GPLAN_ID,GPLAN_CODE,GPLAN_DESC) VALUES (2,'SEARCH','Standard Search');
INSERT INTO CFG_GPLAN (GPLAN_ID,GPLAN_CODE,GPLAN_DESC) VALUES (3,'SEARCH-EXHAUSTIVE','Exhaustive Search');
CREATE TABLE CFG_GENERIC_THRESHOLD (GPLAN_ID smallint NOT NULL, BEHAVIOR VARCHAR(50) NOT NULL, FTYPE_ID smallint NOT NULL, CANDIDATE_CAP BIGINT NOT NULL, SCORING_CAP BIGINT NOT NULL) ;
ALTER TABLE CFG_GENERIC_THRESHOLD ADD CONSTRAINT CFG_GENERIC_THRESH PRIMARY KEY(GPLAN_ID, BEHAVIOR, FTYPE_ID) ;
INSERT INTO CFG_GENERIC_THRESHOLD (GPLAN_ID,BEHAVIOR,FTYPE_ID,CANDIDATE_CAP,SCORING_CAP) VALUES (1,'F1ES',0,10,20);
INSERT INTO CFG_GENERIC_THRESHOLD (GPLAN_ID,BEHAVIOR,FTYPE_ID,CANDIDATE_CAP,SCORING_CAP) VALUES (1,'F1',0,10,50);
INSERT INTO CFG_GENERIC_THRESHOLD (GPLAN_ID,BEHAVIOR,FTYPE_ID,CANDIDATE_CAP,SCORING_CAP) VALUES (1,'FF',0,20,500);
INSERT INTO CFG_GENERIC_THRESHOLD (GPLAN_ID,BEHAVIOR,FTYPE_ID,CANDIDATE_CAP,SCORING_CAP) VALUES (1,'FME',0,20,100);
INSERT INTO CFG_GENERIC_THRESHOLD (GPLAN_ID,BEHAVIOR,FTYPE_ID,CANDIDATE_CAP,SCORING_CAP) VALUES (1,'FM',0,5,-1);
INSERT INTO CFG_GENERIC_THRESHOLD (GPLAN_ID,BEHAVIOR,FTYPE_ID,CANDIDATE_CAP,SCORING_CAP) VALUES (2,'F1',0,20,-1);
INSERT INTO CFG_GENERIC_THRESHOLD (GPLAN_ID,BEHAVIOR,FTYPE_ID,CANDIDATE_CAP,SCORING_CAP) VALUES (2,'FF',0,100,-1);
INSERT INTO CFG_GENERIC_THRESHOLD (GPLAN_ID,BEHAVIOR,FTYPE_ID,CANDIDATE_CAP,SCORING_CAP) VALUES (2,'FME',0,5,-1);
INSERT INTO CFG_GENERIC_THRESHOLD (GPLAN_ID,BEHAVIOR,FTYPE_ID,CANDIDATE_CAP,SCORING_CAP) VALUES (2,'FM',0,5,-1);
CREATE TABLE LIB_FEAT (LIB_FEAT_ID BIGINT NOT NULL, FTYPE_ID smallint NOT NULL, FEAT_HASH CHAR(40) NOT NULL, FEAT_DESC VARCHAR(150), FELEM_VALUES VARCHAR(3000) NOT NULL, NUM_TIMES_SEEN int, FIRST_SEEN_DT TIMESTAMP, LAST_SEEN_DT TIMESTAMP, LAST_TOUCH_DT TIMESTAMP, ANONYMIZED VARCHAR(5), VERSION smallint NOT NULL) ;
ALTER TABLE LIB_FEAT APPEND ON;
ALTER TABLE LIB_FEAT VOLATILE CARDINALITY;
ALTER TABLE LIB_FEAT ADD CONSTRAINT LIB_FEAT_PK PRIMARY KEY(LIB_FEAT_ID) ;
CREATE TABLE LIB_FEAT_HKEY (FEAT_HASH CHAR(40) NOT NULL, FTYPE_ID smallint NOT NULL, LIB_FEAT_ID BIGINT NOT NULL) ;
ALTER TABLE LIB_FEAT_HKEY APPEND ON;
ALTER TABLE LIB_FEAT_HKEY VOLATILE CARDINALITY;
ALTER TABLE LIB_FEAT_HKEY ADD CONSTRAINT LIB_FEAT_HKEY_PK PRIMARY KEY(FEAT_HASH, FTYPE_ID) ;
CREATE TABLE LIB_FELEM (LIB_FELEM_ID BIGINT NOT NULL, FELEM_ID smallint NOT NULL, FELEM_VALUE VARCHAR(1000) NOT NULL) ;
ALTER TABLE LIB_FELEM APPEND ON;
ALTER TABLE LIB_FELEM VOLATILE CARDINALITY;
ALTER TABLE LIB_FELEM ADD CONSTRAINT LIB_FELEM_PK PRIMARY KEY(LIB_FELEM_ID) ;
CREATE TABLE LIB_FELEM_SKEY (FELEM_VALUE VARCHAR(250) NOT NULL, FELEM_ID smallint NOT NULL, LIB_FELEM_ID BIGINT NOT NULL) ;
ALTER TABLE LIB_FELEM_SKEY APPEND ON;
ALTER TABLE LIB_FELEM_SKEY VOLATILE CARDINALITY;
ALTER TABLE LIB_FELEM_SKEY ADD CONSTRAINT LIB_FELEM_SKEY_PK PRIMARY KEY(FELEM_VALUE, FELEM_ID) ;
CREATE TABLE LIB_FELEM_FKEY (LIB_FELEM_ID BIGINT NOT NULL, LIB_FEAT_ID BIGINT NOT NULL) ;
ALTER TABLE LIB_FELEM_FKEY APPEND ON;
ALTER TABLE LIB_FELEM_FKEY VOLATILE CARDINALITY;
ALTER TABLE LIB_FELEM_FKEY ADD CONSTRAINT LIB_FELEM_FKEY_PK PRIMARY KEY(LIB_FELEM_ID, LIB_FEAT_ID) ;
CREATE TABLE LIB_TOKEN (LIB_TOKEN_ID BIGINT NOT NULL, TOKEN_VALUE VARCHAR(50) NOT NULL) ;
ALTER TABLE LIB_TOKEN APPEND ON;
ALTER TABLE LIB_TOKEN VOLATILE CARDINALITY;
ALTER TABLE LIB_TOKEN ADD CONSTRAINT LIB_TOKEN_PK PRIMARY KEY(LIB_TOKEN_ID) ;
CREATE TABLE LIB_TOKEN_SKEY (TOKEN_VALUE VARCHAR(50) NOT NULL, LIB_TOKEN_ID BIGINT NOT NULL) ;
ALTER TABLE LIB_TOKEN_SKEY APPEND ON;
ALTER TABLE LIB_TOKEN_SKEY VOLATILE CARDINALITY;
ALTER TABLE LIB_TOKEN_SKEY ADD CONSTRAINT LIB_TOKEN_SKEY_PK PRIMARY KEY(TOKEN_VALUE) ;
CREATE TABLE LIB_TOKEN_FKEY (LIB_TOKEN_ID BIGINT NOT NULL, LIB_FELEM_ID BIGINT NOT NULL) ;
ALTER TABLE LIB_TOKEN_FKEY APPEND ON;
ALTER TABLE LIB_TOKEN_FKEY VOLATILE CARDINALITY;
ALTER TABLE LIB_TOKEN_FKEY ADD CONSTRAINT LIB_TOKEN_FKEY_PK PRIMARY KEY(LIB_TOKEN_ID, LIB_FELEM_ID) ;
CREATE TABLE OBS_ENT (OBS_ENT_ID BIGINT NOT NULL, ETYPE_ID smallint NOT NULL, DSRC_ID smallint NOT NULL, ENT_SRC_KEY VARCHAR(250) NOT NULL, ENT_SRC_DESC VARCHAR(250), FROM_LENS_ID smallint, FROM_RES_ENT_ID BIGINT, NUM_TIMES_SEEN int, FIRST_SEEN_DT TIMESTAMP, LAST_SEEN_DT TIMESTAMP, LAST_TOUCH_DT TIMESTAMP) ;
ALTER TABLE OBS_ENT APPEND ON;
ALTER TABLE OBS_ENT VOLATILE CARDINALITY;
ALTER TABLE OBS_ENT ADD CONSTRAINT OBS_ENT_PK PRIMARY KEY(OBS_ENT_ID) ;
CREATE TABLE OBS_ENT_SKEY (ENT_SRC_KEY VARCHAR(250) NOT NULL, ETYPE_ID smallint NOT NULL, DSRC_ID smallint NOT NULL, OBS_ENT_ID BIGINT NOT NULL) ;
ALTER TABLE OBS_ENT_SKEY APPEND ON;
ALTER TABLE OBS_ENT_SKEY VOLATILE CARDINALITY;
ALTER TABLE OBS_ENT_SKEY ADD CONSTRAINT OBS_ENT_SKEY_PK PRIMARY KEY(ENT_SRC_KEY, ETYPE_ID, DSRC_ID) ;
CREATE TABLE OBS_FEAT_EKEY (OBS_ENT_ID BIGINT NOT NULL, LIB_FEAT_ID BIGINT NOT NULL, FTYPE_ID smallint NOT NULL, UTYPE_ID smallint, USED_FROM_DT TIMESTAMP, USED_THRU_DT TIMESTAMP, SYS_LSTUPD_DT TIMESTAMP) ;
ALTER TABLE OBS_FEAT_EKEY APPEND ON;
ALTER TABLE OBS_FEAT_EKEY VOLATILE CARDINALITY;
ALTER TABLE OBS_FEAT_EKEY ADD CONSTRAINT OBS_FEAT_EKEY_PK PRIMARY KEY(OBS_ENT_ID, LIB_FEAT_ID) ;
CREATE TABLE OBS_FEAT_LKEY (LIB_FEAT_ID BIGINT NOT NULL, OBS_ENT_ID BIGINT NOT NULL) ;
ALTER TABLE OBS_FEAT_LKEY APPEND ON;
ALTER TABLE OBS_FEAT_LKEY VOLATILE CARDINALITY;
ALTER TABLE OBS_FEAT_LKEY ADD CONSTRAINT OBS_FEAT_LKEY_PK PRIMARY KEY(LIB_FEAT_ID, OBS_ENT_ID) ;
CREATE TABLE RES_FEAT_STAT (LENS_ID smallint NOT NULL, LIB_FEAT_ID BIGINT NOT NULL, ECLASS_ID smallint NOT NULL, NUM_RES_ENT int NOT NULL, NUM_RES_ENT_OOM int NOT NULL) ;
ALTER TABLE RES_FEAT_STAT APPEND ON;
ALTER TABLE RES_FEAT_STAT VOLATILE CARDINALITY;
ALTER TABLE RES_FEAT_STAT ADD CONSTRAINT RES_FEAT_STAT_PK PRIMARY KEY(LIB_FEAT_ID, LENS_ID, ECLASS_ID) ;
CREATE TABLE RES_ENT (RES_ENT_ID BIGINT NOT NULL, LENS_ID smallint NOT NULL, ECLASS_ID smallint NOT NULL, INTEREST_LEVEL smallint, CONFUSION_LEVEL smallint, NUM_OBS_ENT int, FIRST_SEEN_DT TIMESTAMP, LAST_SEEN_DT TIMESTAMP, LAST_TOUCH_DT BIGINT, LOCKING_ID BIGINT NOT NULL, NODE_NAME VARCHAR(50) NOT NULL) ;
ALTER TABLE RES_ENT APPEND ON;
ALTER TABLE RES_ENT VOLATILE CARDINALITY;
ALTER TABLE RES_ENT ADD CONSTRAINT RES_ENT_PK PRIMARY KEY(RES_ENT_ID, LENS_ID) ;
CREATE TABLE RES_ENT_OKEY (OBS_ENT_ID BIGINT NOT NULL, LENS_ID smallint NOT NULL, RES_ENT_ID BIGINT NOT NULL, ER_ID BIGINT NOT NULL, ERRULE_ID smallint NOT NULL) ;
ALTER TABLE RES_ENT_OKEY APPEND ON;
ALTER TABLE RES_ENT_OKEY VOLATILE CARDINALITY;
ALTER TABLE RES_ENT_OKEY ADD CONSTRAINT RES_ENT_OKEY_PK PRIMARY KEY(OBS_ENT_ID, LENS_ID, RES_ENT_ID) ;
CREATE TABLE RES_ENT_RKEY (RES_ENT_ID BIGINT NOT NULL, LENS_ID smallint NOT NULL, OBS_ENT_ID BIGINT NOT NULL) ;
ALTER TABLE RES_ENT_RKEY APPEND ON;
ALTER TABLE RES_ENT_RKEY VOLATILE CARDINALITY;
ALTER TABLE RES_ENT_RKEY ADD CONSTRAINT RES_ENT_RKEY_PK PRIMARY KEY(RES_ENT_ID, LENS_ID, OBS_ENT_ID) ;
CREATE TABLE RES_FEAT_EKEY (RES_ENT_ID BIGINT NOT NULL, ECLASS_ID smallint NOT NULL, LENS_ID smallint NOT NULL, LIB_FEAT_ID BIGINT NOT NULL, FTYPE_ID smallint NOT NULL, UTYPE_ID smallint, USED_FROM_DT TIMESTAMP, USED_THRU_DT TIMESTAMP, FIRST_SEEN_DT TIMESTAMP, LAST_SEEN_DT TIMESTAMP) ;
ALTER TABLE RES_FEAT_EKEY APPEND ON;
ALTER TABLE RES_FEAT_EKEY VOLATILE CARDINALITY;
ALTER TABLE RES_FEAT_EKEY ADD CONSTRAINT RES_FEAT_EKEY_PK PRIMARY KEY(RES_ENT_ID, LENS_ID, LIB_FEAT_ID) ;
CREATE TABLE RES_FEAT_LKEY (LIB_FEAT_ID BIGINT NOT NULL, LENS_ID smallint NOT NULL, ECLASS_ID smallint NOT NULL, RES_ENT_ID BIGINT NOT NULL) ;
ALTER TABLE RES_FEAT_LKEY APPEND ON;
ALTER TABLE RES_FEAT_LKEY VOLATILE CARDINALITY;
ALTER TABLE RES_FEAT_LKEY ADD CONSTRAINT RES_FEAT_LKEY_PK PRIMARY KEY(LIB_FEAT_ID, LENS_ID, ECLASS_ID, RES_ENT_ID) ;
CREATE TABLE RES_RELATE (RES_REL_ID BIGINT NOT NULL, LENS_ID smallint NOT NULL, MIN_RES_ENT_ID BIGINT NOT NULL, MAX_RES_ENT_ID BIGINT NOT NULL, REL_STRENGTH smallint, REL_STATUS smallint, IS_DISCLOSED smallint, IS_AMBIGUOUS smallint, INTEREST_LEVEL smallint, CONFUSION_LEVEL smallint, LAST_ER_ID BIGINT, LAST_REF_SCORE smallint, LAST_ERRULE_ID smallint, FIRST_SEEN_DT TIMESTAMP, LAST_SEEN_DT TIMESTAMP, LAST_TOUCH_DT TIMESTAMP) ;
ALTER TABLE RES_RELATE APPEND ON;
ALTER TABLE RES_RELATE VOLATILE CARDINALITY;
ALTER TABLE RES_RELATE ADD CONSTRAINT RES_RELATE_PK PRIMARY KEY(RES_REL_ID) ;
CREATE TABLE RES_REL_EKEY (RES_ENT_ID BIGINT NOT NULL, LENS_ID smallint NOT NULL, REL_ENT_ID BIGINT NOT NULL, RES_REL_ID BIGINT NOT NULL) ;
ALTER TABLE RES_REL_EKEY APPEND ON;
ALTER TABLE RES_REL_EKEY VOLATILE CARDINALITY;
ALTER TABLE RES_REL_EKEY ADD CONSTRAINT RES_REL_EKEY_PK PRIMARY KEY(RES_ENT_ID, LENS_ID, REL_ENT_ID) ;
CREATE TABLE RES_RELDET (RES_REL_ID BIGINT NOT NULL, KEY_TYPE_ID smallint NOT NULL, KEY_ID BIGINT NOT NULL, RTYPE_ID smallint NOT NULL, ERRULE_ID smallint, SYS_CREATE_DT TIMESTAMP) ;
ALTER TABLE RES_RELDET ADD CONSTRAINT RES_RELDET_PK PRIMARY KEY(RES_REL_ID, KEY_TYPE_ID, KEY_ID) ;
CREATE TABLE RES_REL_COMP (RES_REL_ID BIGINT NOT NULL, LENS_ID smallint NOT NULL, ER_ID BIGINT NOT NULL, FTYPE_ID smallint NOT NULL, CFRTN_ID smallint NOT NULL, CFRTN_SCORE smallint NOT NULL, CFRTN_LEVEL smallint NOT NULL, INCOMING_FEAT_ID BIGINT NOT NULL, MATCHED_FEAT_ID BIGINT NOT NULL, FEAT_WEIGHT smallint, TIME_SPACE_DIFF smallint) ;
ALTER TABLE RES_REL_COMP APPEND ON;
ALTER TABLE RES_REL_COMP VOLATILE CARDINALITY;
ALTER TABLE RES_REL_COMP ADD CONSTRAINT RES_REL_COMP_PK PRIMARY KEY(RES_REL_ID, LENS_ID, ER_ID, FTYPE_ID, CFRTN_ID) ;
CREATE TABLE LOG_OBS (OBS_ID BIGINT NOT NULL, OBS_STATUS_ID smallint NOT NULL, OBS_SRC_KEY VARCHAR(250) NOT NULL, DSRC_ID smallint NOT NULL, DSRC_ACTION CHAR(1), SRC_CREATE_DT TIMESTAMP, SRC_LSTUPD_DT TIMESTAMP, SRC_PRUNE_BEFORE_DT TIMESTAMP, SRC_PRUNE_AFTER_DT TIMESTAMP, SRC_LSTUPD_USER VARCHAR(25), NODE_NAME VARCHAR(50) NOT NULL, SYS_CREATE_DT TIMESTAMP, SYS_LSTUPD_DT TIMESTAMP) ;
ALTER TABLE LOG_OBS APPEND ON;
ALTER TABLE LOG_OBS VOLATILE CARDINALITY;
ALTER TABLE LOG_OBS ADD CONSTRAINT LOG_OBS_PK PRIMARY KEY(OBS_ID) ;
CREATE TABLE LOG_OBS_ENT (OBS_ID BIGINT NOT NULL, OBS_ENT_ID BIGINT NOT NULL, FROM_LENS_ID smallint, FROM_RES_ENT_ID BIGINT, SYS_ACTION CHAR(1)) ;
ALTER TABLE LOG_OBS_ENT APPEND ON;
ALTER TABLE LOG_OBS_ENT VOLATILE CARDINALITY;
ALTER TABLE LOG_OBS_ENT ADD CONSTRAINT LOG_OBS_ENT_PK PRIMARY KEY(OBS_ID, OBS_ENT_ID) ;
CREATE TABLE LOG_ER (ER_ID BIGINT NOT NULL, ER_DT TIMESTAMP NOT NULL, OBS_ID BIGINT NOT NULL, DSRC_ACTION CHAR(1) NOT NULL, LENS_ID smallint NOT NULL, OBS_ENT_ID BIGINT, RES_ENT_ID BIGINT, ASSG_RES_ENT_ID BIGINT) ;
ALTER TABLE LOG_ER APPEND ON;
ALTER TABLE LOG_ER VOLATILE CARDINALITY;
ALTER TABLE LOG_ER ADD CONSTRAINT LOG_ER_PK PRIMARY KEY(ER_ID) ;
CREATE TABLE LOG_ER_STEP (ER_ID BIGINT NOT NULL, ER_STEP smallint NOT NULL, ER_PROC_ID smallint NOT NULL, OBS_ENT_ID BIGINT, RES_ENT_ID BIGINT) ;
ALTER TABLE LOG_ER_STEP APPEND ON;
ALTER TABLE LOG_ER_STEP VOLATILE CARDINALITY;
ALTER TABLE LOG_ER_STEP ADD CONSTRAINT LOG_ER_STEP_PK PRIMARY KEY(ER_ID, ER_STEP) ;
CREATE TABLE LOG_ER_CAND (ER_ID BIGINT NOT NULL, ER_STEP smallint NOT NULL, CAND_ENT_ID BIGINT NOT NULL, ERRULE_ID smallint, RESOLVED smallint, CONFLICTED smallint) ;
ALTER TABLE LOG_ER_CAND APPEND ON;
ALTER TABLE LOG_ER_CAND VOLATILE CARDINALITY;
ALTER TABLE LOG_ER_CAND ADD CONSTRAINT LOG_ER_CAND_PK PRIMARY KEY(ER_ID, ER_STEP, CAND_ENT_ID) ;
CREATE TABLE LOG_ER_CAND_EF (ER_ID BIGINT NOT NULL, ER_STEP smallint NOT NULL, CAND_ENT_ID BIGINT NOT NULL, LIB_EFEAT_ID BIGINT NOT NULL) ;
ALTER TABLE LOG_ER_CAND_EF APPEND ON;
ALTER TABLE LOG_ER_CAND_EF VOLATILE CARDINALITY;
ALTER TABLE LOG_ER_CAND_EF ADD CONSTRAINT LOG_ER_CAND_EF_PK PRIMARY KEY(ER_ID, ER_STEP, CAND_ENT_ID, LIB_EFEAT_ID) ;
CREATE TABLE LOG_ER_COMP (ER_ID BIGINT NOT NULL, ER_STEP smallint NOT NULL, CAND_ENT_ID BIGINT NOT NULL, FTYPE_ID smallint NOT NULL, CFRTN_ID smallint NOT NULL, CFRTN_SCORE smallint NOT NULL, CFRTN_LEVEL smallint NOT NULL, INCOMING_FEAT_ID BIGINT NOT NULL, MATCHED_FEAT_ID BIGINT NOT NULL, FEAT_WEIGHT smallint, TIME_SPACE_DIFF smallint) ;
ALTER TABLE LOG_ER_COMP APPEND ON;
ALTER TABLE LOG_ER_COMP VOLATILE CARDINALITY;
ALTER TABLE LOG_ER_COMP ADD CONSTRAINT LOG_ER_COMP_PK PRIMARY KEY(ER_ID, ER_STEP, CAND_ENT_ID, FTYPE_ID, CFRTN_ID) ;
CREATE TABLE LOG_ER_RES (ER_ID BIGINT NOT NULL, ER_ACTION_NUM smallint NOT NULL, ER_ACTION_ID smallint NOT NULL, ER_STEP smallint, CAND_ENT_ID BIGINT, ERRULE_ID smallint, OBS_ENT_ID BIGINT, FROM_RES_ENT_ID BIGINT, TO_RES_ENT_ID BIGINT, RES_REL_ID BIGINT) ;
ALTER TABLE LOG_ER_RES APPEND ON;
ALTER TABLE LOG_ER_RES VOLATILE CARDINALITY;
ALTER TABLE LOG_ER_RES ADD CONSTRAINT LOG_ER_RES_PK PRIMARY KEY(ER_ID, ER_ACTION_NUM) ;
CREATE VIEW CFG_GENERIC_THRESHOLD_VIEW 
as 
select
  A.GPLAN_ID,
  B.GPLAN_CODE,
  A.BEHAVIOR,
  A.FTYPE_ID,
  C.FTYPE_CODE,
  A.CANDIDATE_CAP,
  A.SCORING_CAP
from CFG_GENERIC_THRESHOLD A 
left join CFG_GPLAN B on A.GPLAN_ID = B.GPLAN_ID 
left join CFG_FTYPE C on A.FTYPE_ID = C.FTYPE_ID
;
CREATE VIEW cfg_dsrc_view 
as 
select
  dsrc_id,
  dsrc_code,
  dsrc_desc,
  dsrc_rely
from cfg_dsrc a
;
CREATE VIEW cfg_eclass_view 
as 
select 
  eclass_id,
  eclass_code,
  eclass_desc,
  resolve
from cfg_eclass a
;
CREATE VIEW cfg_etype_view 
as 
select 
  a.etype_id,
  a.etype_code,
  a.etype_desc,
  a.eclass_id,
  (select eclass_code from cfg_eclass where eclass_id = a.eclass_id) as eclass_code
from cfg_etype a
;
CREATE VIEW cfg_fclass_view 
as 
select 
  fclass_id,
  fclass_code,
  fclass_desc
from cfg_fclass a
;
CREATE VIEW CFG_FTYPE_VIEW 
as 
select 
  a.ftype_id,
  a.ftype_code,
  a.ftype_desc,
  a.fclass_id,
  (select fclass_code from CFG_FCLASS where fclass_id = a.fclass_id) as fclass_code,
  a.ftype_freq || case when upper(substr(ftype_excl,1,1)) = 'Y' then 'E' else '' end || case when upper(substr(ftype_stab,1,1)) = 'Y' then 'S' else '' end as behavior_code,
  a.ftype_freq,
  a.ftype_excl,
  a.ftype_stab,
  a.persist_history,
  a.used_for_cand,
  a.derived,
  a.rtype_id,
  (select rtype_code from CFG_RTYPE where rtype_id = a.rtype_id) rtype_code,
  a.anonymize,
  a.version
from CFG_FTYPE a
;
CREATE VIEW cfg_felem_view 
as 
select 
  felem_id,
  felem_code,
  felem_desc,
  tokenize,
  data_type
from cfg_felem a
;
CREATE VIEW cfg_fbom_view 
as 
select 
  a.ftype_id,
  (select ftype_code from cfg_ftype where ftype_id = a.ftype_id) as ftype_code,
  a.felem_id,
  b.felem_code,
  a.exec_order,
  b.data_type,
  a.display_level,
  a.display_delim,
  a.derived
from cfg_fbom a
join cfg_felem b on b.felem_id = a.felem_id
;
CREATE VIEW CFG_EBOM_VIEW 
as 
SELECT 
  B.ETYPE_CODE,
  A.EXEC_ORDER,
  C.FTYPE_CODE,
  (SELECT UTYPE_CODE FROM CFG_UTYPE WHERE UTYPE_ID = A.UTYPE_ID) AS UTYPE_CODE,
  C.USED_FOR_CAND,
  C.BEHAVIOR_CODE,
  C.DERIVED,
  C.ANONYMIZE,
  A.ETYPE_ID,
  A.FTYPE_ID,
  A.UTYPE_ID,
  (SELECT ECLASS_CODE FROM CFG_ECLASS WHERE ECLASS_ID = B.ECLASS_ID) ECLASS_CODE,
  (SELECT FCLASS_CODE FROM CFG_FCLASS WHERE FCLASS_ID = C.FCLASS_ID) FCLASS_CODE,
  (SELECT SFUNC_CODE FROM CFG_SFUNC WHERE SFUNC_ID = (SELECT SFUNC_ID FROM CFG_SFCALL WHERE FTYPE_ID = A.FTYPE_ID) fetch first 1 rows only) AS SFUNC_CODE,
  (SELECT EFUNC_CODE FROM CFG_EFUNC WHERE EFUNC_ID = (SELECT EFUNC_ID FROM CFG_EFCALL WHERE FTYPE_ID = A.FTYPE_ID) fetch first 1 rows only) AS EFUNC_CODE,
  (SELECT CFUNC_CODE FROM CFG_CFUNC WHERE CFUNC_ID = (SELECT CFUNC_ID FROM CFG_CFCALL WHERE FTYPE_ID = A.FTYPE_ID) fetch first 1 rows only) AS FFUNC_CODE
FROM CFG_EBOM A
JOIN CFG_ETYPE B ON B.ETYPE_ID = A.ETYPE_ID
JOIN CFG_FTYPE_VIEW C ON C.FTYPE_ID = A.FTYPE_ID
;
CREATE VIEW cfg_sfunc_view 
as 
select 
  sfunc_id,
  sfunc_code,
  sfunc_desc,
  func_lib,
  func_ver,
  connect_str
from cfg_sfunc a
;
CREATE VIEW cfg_sfcall_view 
as 
select 
  sfcall_id,
  ftype_id,
  (select ftype_code from cfg_ftype where ftype_id = a.ftype_id) as ftype_code,
  exec_order,
  sfunc_id,
  (select sfunc_code from cfg_sfunc where sfunc_id = a.sfunc_id) as sfunc_code
from cfg_sfcall a
;
CREATE VIEW cfg_efunc_view 
as 
select 
  efunc_id,
  efunc_code,
  efunc_desc,
  func_lib,
  func_ver,
  connect_str
from cfg_efunc a
;
CREATE VIEW cfg_efcall_view 
as 
select 
  efcall_id, 
  ftype_id,
  (select ftype_code from cfg_ftype where ftype_id = a.ftype_id) as ftype_code,
  efunc_id,
  (select efunc_code from cfg_efunc where efunc_id = a.efunc_id) as efunc_code,
  exec_order
from cfg_efcall a
;
CREATE VIEW cfg_efbom_view 
as 
select 
  a.efcall_id, 
  b.ftype_id as call_ftype_id,
  (select ftype_code from cfg_ftype where ftype_id = b.ftype_id) as call_ftype_code,
  efunc_id,
  (select efunc_code from cfg_efunc where efunc_id = b.efunc_id) as efunc_code,
  a.ftype_id as ftype_id,
  (select ftype_code from cfg_ftype where ftype_id = a.ftype_id) as ftype_code,
  a.felem_id as felem_id,
  (select felem_code from cfg_felem where felem_id = a.felem_id) as felem_code,
  a.exec_order,
  a.felem_req
from cfg_efbom a
join cfg_efcall b on b.efcall_id = a.efcall_id
;
CREATE VIEW cfg_cfunc_view 
as 
select 
  cfunc_id,
  cfunc_code,
  cfunc_desc,
  func_lib,
  func_ver,
  connect_str,
  anon_support
from cfg_cfunc a
;
CREATE VIEW cfg_cfrtn_view 
as 
select 
  cfrtn_id,
  cfunc_id,
  (select cfunc_code from cfg_cfunc where cfunc_id = a.cfunc_id) as cfunc_code,
  cfunc_rtnval,
  exec_order,
  same_score,
  close_score,
  likely_score,
  plausible_score,
  un_likely_score
from cfg_cfrtn a
;
CREATE VIEW cfg_cfcall_view 
as 
select 
  cfcall_id, 
  ftype_id,
  (select ftype_code from cfg_ftype where ftype_id = a.ftype_id) as ftype_code,
  cfunc_id,
  (select cfunc_code from cfg_cfunc where cfunc_id = a.cfunc_id) as cfunc_code,
  exec_order
from cfg_cfcall a
;
CREATE VIEW cfg_cfbom_view 
as 
select 
  a.cfcall_id, 
  b.ftype_id as call_ftype_id,
  (select ftype_code from cfg_ftype where ftype_id = b.ftype_id) as call_ftype_code,
  cfunc_id,
  (select cfunc_code from cfg_cfunc where cfunc_id = b.cfunc_id) as cfunc_code,
  a.ftype_id as ftype_id,
  (select ftype_code from cfg_ftype where ftype_id = a.ftype_id) as ftype_code,
  a.felem_id as felem_id,
  (select felem_code from cfg_felem where felem_id = a.felem_id) as felem_code,
  a.exec_order
from cfg_cfbom a
join cfg_cfcall b on b.cfcall_id = a.cfcall_id
;
CREATE VIEW CFG_FEAT_VIEW 
as 
SELECT 
 A.FTYPE_ID,
 B.FTYPE_CODE,
 B.FTYPE_DESC,
 (SELECT FCLASS_CODE FROM CFG_FCLASS WHERE FCLASS_ID = B.FCLASS_ID) FCLASS_CODE,
 B.FTYPE_FREQ,
 B.FTYPE_EXCL,
 B.FTYPE_STAB,
 B.PERSIST_HISTORY,
 B.USED_FOR_CAND,
 B.DERIVED,
 B.ANONYMIZE,
 (SELECT SFUNC_CODE FROM CFG_SFUNC WHERE SFUNC_ID = D.SFUNC_ID) AS SFUNC_CODE,
 (SELECT EFUNC_CODE FROM CFG_EFUNC WHERE EFUNC_ID = E.EFUNC_ID) AS EFUNC_CODE,
 (SELECT CFUNC_CODE FROM CFG_CFUNC WHERE CFUNC_ID = G.CFUNC_ID) AS CFUNC_CODE,
 A.EXEC_ORDER,
 C.FELEM_CODE,
 C.FELEM_DESC,
 C.DATA_TYPE,
 CASE A.DISPLAY_LEVEL WHEN 1 THEN 'Yes' ELSE 'No' END AS DISPLAY_LEVEL,
 CASE WHEN F.FELEM_ID IS NULL THEN 'No' ELSE 'Yes' END AS EFUNC_BOM,
 CASE WHEN H.FELEM_ID IS NULL THEN 'No' ELSE 'Yes' END AS CFUNC_BOM
FROM CFG_FBOM A
JOIN CFG_FTYPE B ON B.FTYPE_ID = A.FTYPE_ID
JOIN CFG_FELEM C ON C.FELEM_ID = A.FELEM_ID
LEFT JOIN CFG_SFCALL D ON D.FTYPE_ID = A.FTYPE_ID
LEFT JOIN CFG_EFCALL E ON E.FTYPE_ID = A.FTYPE_ID
LEFT JOIN CFG_EFBOM F ON F.EFCALL_ID = E.EFCALL_ID AND F.FTYPE_ID = A.FTYPE_ID AND F.FELEM_ID = A.FELEM_ID
LEFT JOIN CFG_CFCALL G ON G.FTYPE_ID = A.FTYPE_ID
LEFT JOIN CFG_CFBOM H ON H.CFCALL_ID = G.CFCALL_ID AND H.FTYPE_ID = A.FTYPE_ID AND H.FELEM_ID = A.FELEM_ID
;
CREATE VIEW cfg_erfrag_view 
as 
select 
  erfrag_id,
  erfrag_code,
  erfrag_desc,
  erfrag_source,
  erfrag_depends
from cfg_erfrag a
;
CREATE VIEW cfg_errule_view 
as 
select 
  a.errule_id,
  a.errule_code,
  a.errule_desc,
  a.resolve,
  a.relate,
  a.ref_score,
  a.rtype_id,
  (select rtype_code from cfg_rtype where rtype_id = a.rtype_id) rtype_code,
  a.qual_erfrag_code,
  a.disq_erfrag_code
from cfg_errule a
;
CREATE VIEW cfg_lens_view 
as 
select 
  lens_id,
  lens_code,
  lens_desc
from cfg_lens a
;
CREATE VIEW cfg_lensrl_view 
as 
select 
  lens_id, 
  (select lens_code from cfg_lens where lens_id = a.lens_id) as lens_code,
  errule_id,
  (select errule_code from cfg_errule where errule_id = a.errule_id) as errule_code,
  exec_order
from cfg_lensrl a
;
CREATE VIEW cfg_routep_view 
as 
select
  a.route_id,
  a.route_code,
  a.route_filter,
  a.enabled,
  c.omfuncp_id,
  c.param_code,
  case when d.current_value is null then c.current_value else d.current_value end as route_value
from cfg_route a
left join cfg_omfunc b on b.omfunc_id = a.omfunc_id
left join cfg_omfuncp c on c.param_group = b.omfunc_code
left join cfg_routep d on d.route_id = a.route_id and d.param_code = c.param_code
;
CREATE VIEW lib_feat_view 
as
select 
  a.lib_feat_id,
  b.ftype_id,
  (select ftype_code from cfg_ftype where ftype_id = b.ftype_id) as ftype_code,
  a.feat_desc,
  a.felem_values,
  a.last_seen_dt,
  a.anonymized,
  a.version
from lib_feat a
join lib_feat_hkey b on b.feat_hash = a.feat_hash and b.ftype_id = a.ftype_id
;
CREATE VIEW lib_feat_stats 
as
select 
  a.lib_feat_id,
  b.ftype_id,
  (select ftype_code from cfg_ftype where ftype_id = b.ftype_id) as ftype_code,
  a.feat_desc,
  a.felem_values,
  (select count(*) from obs_feat_lkey where lib_feat_id = a.lib_feat_id) as num_times_seen,
  a.last_seen_dt
from lib_feat a
join lib_feat_hkey b on b.feat_hash = a.feat_hash and b.ftype_id = a.ftype_id
;
CREATE VIEW obs_ent_view 
as 
select 
  a.obs_ent_id,
  a.dsrc_id,
  (select dsrc_code from cfg_dsrc where dsrc_id = a.dsrc_id) dsrc_code,
  a.etype_id,
  (select etype_code from cfg_etype where etype_id = a.etype_id) etype_code,
  a.ent_src_key,
  a.ent_src_desc,
  a.from_lens_id,
  a.from_res_ent_id,
  a.num_times_seen,
  a.first_seen_dt,
  a.last_seen_dt,
  a.last_touch_dt
from obs_ent a
;
CREATE VIEW obs_feat_view 
as
select 
  a.obs_ent_id,
  (select dsrc_code from cfg_dsrc where dsrc_id = a.dsrc_id) dsrc_code,
  (select etype_code from cfg_etype where etype_id = a.etype_id) etype_code,
  a.ent_src_key,
  a.ent_src_desc,
  b.ftype_id,
  d.derived,
  d.ftype_code,
  c.feat_desc,
  c.felem_values,
  (select utype_code from cfg_utype where utype_id = b.utype_id) utype_code,
  b.used_from_dt,
  b.used_thru_dt,
  b.sys_lstupd_dt,  
  b.lib_feat_id,
  a.dsrc_id,
  a.etype_id,
  b.utype_id
from obs_ent a 
join obs_feat_ekey b on b.obs_ent_id = a.obs_ent_id
join lib_feat c on c.lib_feat_id = b.lib_feat_id
join cfg_ftype d on d.ftype_id = c.ftype_id
;
CREATE VIEW RES_ENT_VIEW 
AS
SELECT
 A.LENS_ID,
 A.RES_ENT_ID,
 A.MIN_OBS_ENT_ID,
 C.DSRC_CODE,
 B.ENT_SRC_KEY,
 B.ENT_SRC_DESC
FROM (
 SELECT 
  X.LENS_ID, 
  X.RES_ENT_ID,
  (SELECT MIN(OBS_ENT_ID) FROM RES_ENT_RKEY WHERE RES_ENT_ID = X.RES_ENT_ID AND LENS_ID = X.LENS_ID) AS MIN_OBS_ENT_ID
 FROM RES_ENT X
) A
JOIN OBS_ENT B ON B.OBS_ENT_ID = A.MIN_OBS_ENT_ID
JOIN CFG_DSRC C ON C.DSRC_ID = B.DSRC_ID
;
CREATE VIEW RES_ENT_STAT 
AS
SELECT
 A.LENS_ID, 
 A.RES_ENT_ID,
 A.NUM_OBS_ENT, 
 A.NUM_DSRC_CODE, 
 (SELECT COUNT(*) FROM RES_REL_EKEY WHERE RES_ENT_ID = A.RES_ENT_ID AND LENS_ID = A.LENS_ID) AS NUM_RELS,
 A.MIN_OBS_ENT_ID, 
 C.DSRC_CODE,
 B.ENT_SRC_KEY,
 B.ENT_SRC_DESC
FROM (
 SELECT 
  X.LENS_ID, 
  X.RES_ENT_ID,
  COUNT(*) AS NUM_OBS_ENT, 
  COUNT(DISTINCT Y.DSRC_ID) AS NUM_DSRC_CODE, 
  MIN(X.OBS_ENT_ID) AS MIN_OBS_ENT_ID
 FROM RES_ENT_RKEY X
 JOIN OBS_ENT Y ON Y.OBS_ENT_ID = X.OBS_ENT_ID
 GROUP BY X.RES_ENT_ID, X.LENS_ID
) A
JOIN OBS_ENT B ON B.OBS_ENT_ID = A.MIN_OBS_ENT_ID
JOIN CFG_DSRC C ON C.DSRC_ID = B.DSRC_ID
;
CREATE VIEW RES_OBS_VIEW 
AS
SELECT 
 A.LENS_ID,  
 A.RES_ENT_ID,  
 D.DSRC_CODE,  
 E.ETYPE_CODE,  
 C.ENT_SRC_KEY,  
 C.ENT_SRC_DESC,  
 B.ERRULE_ID,
 F.ERRULE_CODE,
 C.OBS_ENT_ID,  
 C.DSRC_ID,  
 C.ETYPE_ID,
 B.ER_ID
FROM RES_ENT_RKEY A 
JOIN RES_ENT_OKEY B on B.OBS_ENT_ID = A.OBS_ENT_ID AND B.LENS_ID = A.LENS_ID
JOIN OBS_ENT C ON C.OBS_ENT_ID = A.OBS_ENT_ID 
JOIN CFG_DSRC D ON D.DSRC_ID = C.DSRC_ID 
JOIN CFG_ETYPE E ON E.ETYPE_ID = C.ETYPE_ID
LEFT JOIN CFG_ERRULE F ON F.ERRULE_ID = B.ERRULE_ID
;
CREATE VIEW RES_FEAT_VIEW 
as
SELECT 
 A.LENS_ID,
 A.RES_ENT_ID,
 A.FTYPE_ID,
 C.DERIVED,
 C.FTYPE_CODE,
 (SELECT UTYPE_CODE FROM CFG_UTYPE WHERE UTYPE_ID = A.UTYPE_ID) UTYPE_CODE,
 B.FEAT_DESC,
 B.FELEM_VALUES,
 A.USED_FROM_DT,
 A.USED_THRU_DT,
 A.FIRST_SEEN_DT,  
 A.LAST_SEEN_DT,  
 D.NUM_RES_ENT * D.NUM_RES_ENT_OOM AS EST_ENT_CNT,
 A.LIB_FEAT_ID
FROM RES_FEAT_EKEY A
JOIN LIB_FEAT B ON B.LIB_FEAT_ID = A.LIB_FEAT_ID
JOIN CFG_FTYPE C ON C.FTYPE_ID = A.FTYPE_ID
LEFT JOIN RES_FEAT_STAT D ON D.LIB_FEAT_ID = A.LIB_FEAT_ID AND D.LENS_ID = A.LENS_ID
;
CREATE VIEW res_relate_view 
as
select 
  a.res_rel_id,
  a.lens_id,
  a.min_res_ent_id,
  (select feat_desc from lib_feat where lib_feat_id = (select max(lib_feat_id) from RES_FEAT_EKEY where res_ent_id = a.min_res_ent_id and ftype_id = 1)) as min_ent_name,
  a.max_res_ent_id,
  (select feat_desc from lib_feat where lib_feat_id = (select max(lib_feat_id) from res_feat_ekey where res_ent_id = a.max_res_ent_id and ftype_id = 1)) as max_ent_name,
  a.last_er_id,
  a.last_errule_id,
  (select errule_code from cfg_errule where errule_id = a.last_errule_id) as errule_code,
  a.is_disclosed,
  0 as endx
from res_relate a
;
CREATE VIEW RES_REL_EKEY_VIEW 
AS
SELECT 
 A.LENS_ID,
 A.RES_ENT_ID,
 C.DSRC_CODE AS RES_DSRC_CODE,
 C.ENT_SRC_KEY AS RES_ENT_SRC_KEY,
 C.ENT_SRC_DESC AS RES_ENT_SRC_DESC,
 A.RES_REL_ID,
 IS_DISCLOSED,
 IS_AMBIGUOUS,
 B.LAST_ERRULE_ID,
 (SELECT ERRULE_CODE FROM CFG_ERRULE WHERE ERRULE_ID = B.LAST_ERRULE_ID) AS ERRULE_CODE,
 A.REL_ENT_ID,
 D.DSRC_CODE AS REL_DSRC_CODE,
 D.ENT_SRC_KEY AS REL_ENT_SRC_KEY,
 D.ENT_SRC_DESC AS REL_ENT_SRC_DESC,
 B.LAST_ER_ID
FROM RES_REL_EKEY A
LEFT JOIN RES_RELATE B ON B.RES_REL_ID = A.RES_REL_ID
LEFT JOIN RES_ENT_VIEW C ON C.RES_ENT_ID = A.RES_ENT_ID AND C.LENS_ID = A.LENS_ID
LEFT JOIN RES_ENT_VIEW D ON D.RES_ENT_ID = A.REL_ENT_ID AND C.LENS_ID = A.LENS_ID
;
CREATE VIEW LOG_OBS_VIEW 
AS 
SELECT 
 A.SYS_CREATE_DT,
 A.OBS_STATUS_ID,
 A.OBS_ID, 
 A.OBS_SRC_KEY,
 B.OBS_ENT_ID,
 A.DSRC_ACTION,
 B.SYS_ACTION,
 A.DSRC_ID,
 D.DSRC_CODE,
 C.ETYPE_ID,
 E.ETYPE_CODE,
 C.ENT_SRC_KEY,
 C.ENT_SRC_DESC,
 B.FROM_LENS_ID,
 B.FROM_RES_ENT_ID,
 A.SRC_CREATE_DT,
 A.SRC_LSTUPD_DT,
 A.SRC_LSTUPD_USER
FROM LOG_OBS A
JOIN LOG_OBS_ENT B ON B.OBS_ID = A.OBS_ID
LEFT JOIN OBS_ENT C ON C.OBS_ENT_ID = B.OBS_ENT_ID
LEFT JOIN CFG_DSRC D ON D.DSRC_ID = A.DSRC_ID
LEFT JOIN CFG_ETYPE E ON E.ETYPE_ID = C.ETYPE_ID
;
CREATE VIEW LOG_ER_CAND_VIEW 
AS 
SELECT 
 A.ER_DT,
 A.ER_ID,
 A.LENS_ID,
 A.OBS_ID,
 A.OBS_ENT_ID,
 C.DSRC_CODE,
 B.ENT_SRC_KEY,
 B.ENT_SRC_DESC,
 E.ER_STEP,
 CAST(CASE D.ER_PROC_ID WHEN 1 THEN 'RESOLVE' WHEN 2 THEN 'RE-RESOLVE' WHEN 3 THEN 'UN-RESOLVE' ELSE 'UNKNOWN' END AS VARCHAR(10)) AS ER_PROCESS,
 D.OBS_ENT_ID AS IN_OBS_ENT_ID,
 D.RES_ENT_ID AS IN_RES_ENT_ID,
 E.CAND_ENT_ID, 
 F.DSRC_CODE AS CAND_DSRC_CODE,
 F.ENT_SRC_KEY AS CAND_ENT_SRC_KEY,
 F.ENT_SRC_DESC AS CAND_ENT_SRC_DESC,
 E.ERRULE_ID, 
 (SELECT ERRULE_CODE FROM CFG_ERRULE WHERE ERRULE_ID = E.ERRULE_ID) AS ERRULE_CODE,
 CAST(CASE E.RESOLVED WHEN 1 THEN 'YES' ELSE 'NO' END AS VARCHAR(5)) AS RESOLVED, 
 CAST(CASE E.CONFLICTED WHEN 1 THEN 'YES' ELSE 'NO' END AS VARCHAR(5)) AS CONFLICTED
FROM LOG_ER A
LEFT JOIN OBS_ENT B ON B.OBS_ENT_ID = A.OBS_ENT_ID
LEFT JOIN CFG_DSRC C ON C.DSRC_ID = B.DSRC_ID
JOIN LOG_ER_CAND E ON E.ER_ID = A.ER_ID
LEFT JOIN LOG_ER_STEP D ON D.ER_ID = E.ER_ID AND D.ER_STEP = E.ER_STEP
LEFT JOIN RES_ENT_VIEW F ON F.RES_ENT_ID = E.CAND_ENT_ID AND F.LENS_ID = A.LENS_ID
;
CREATE VIEW LOG_ER_COMP_VIEW 
AS 
SELECT
 A.ER_DT,
 A.ER_ID,
 A.LENS_ID,
 A.OBS_ID,
 A.OBS_ENT_ID,
 C.DSRC_CODE,
 B.ENT_SRC_KEY,
 B.ENT_SRC_DESC,
 E.ER_STEP,
 CAST(CASE D.ER_PROC_ID WHEN 1 THEN 'RESOLVE' WHEN 2 THEN 'RE-RESOLVE' WHEN 3 THEN 'UN-RESOLVE' ELSE 'UNKNOWN' END AS VARCHAR(10)) AS ER_PROCESS,
 D.OBS_ENT_ID AS IN_OBS_ENT_ID,
 D.RES_ENT_ID AS IN_RES_ENT_ID,
 E.CAND_ENT_ID,
 E.ERRULE_ID,
 (SELECT ERRULE_CODE FROM CFG_ERRULE WHERE ERRULE_ID = E.ERRULE_ID) AS ERRULE_CODE,
 F.FTYPE_ID,
 G.FTYPE_CODE,
 H.CFUNC_RTNVAL AS CFRTN_CODE,
 F.CFRTN_SCORE,
 CAST(CASE F.CFRTN_LEVEL WHEN 5 THEN 'SAME' WHEN 4 THEN 'CLOSE' ELSE 'DIFF' END AS VARCHAR(5)) AS CFRTN_LEVEL,
 I.FEAT_DESC AS OBS_FEAT_DESC,
 J.FEAT_DESC AS RES_FEAT_DESC
FROM LOG_ER A
LEFT JOIN OBS_ENT B ON B.OBS_ENT_ID = A.OBS_ENT_ID
LEFT JOIN CFG_DSRC C ON C.DSRC_ID = B.DSRC_ID
JOIN LOG_ER_CAND E ON E.ER_ID = A.ER_ID 
LEFT JOIN LOG_ER_STEP D ON D.ER_ID = E.ER_ID AND D.ER_STEP = E.ER_STEP
JOIN LOG_ER_COMP F ON F.ER_ID = E.ER_ID AND F.ER_STEP = E.ER_STEP AND F.CAND_ENT_ID = E.CAND_ENT_ID
JOIN CFG_FTYPE G ON G.FTYPE_ID = F.FTYPE_ID
JOIN CFG_CFRTN H ON H.CFRTN_ID = F.CFRTN_ID
JOIN LIB_FEAT I ON I.LIB_FEAT_ID = F.INCOMING_FEAT_ID
JOIN LIB_FEAT J ON J.LIB_FEAT_ID = F.MATCHED_FEAT_ID
;
CREATE VIEW LOG_ER_RES_VIEW 
AS
SELECT 
 A.ER_DT,
 A.ER_ID,
 A.LENS_ID,
 A.OBS_ID,
 A.OBS_ENT_ID,
 C.DSRC_CODE,
 B.ENT_SRC_KEY,
 B.ENT_SRC_DESC,
 E.ER_STEP,
 CAST(CASE D.ER_PROC_ID WHEN 1 THEN 'RESOLVE' WHEN 2 THEN 'RE-RESOLVE' WHEN 3 THEN 'UN-RESOLVE' ELSE 'UNKNOWN' END AS VARCHAR(10)) AS ER_PROCESS,
 E.ER_ACTION_NUM,
 CAST(RTRIM(CAST(COALESCE(E.ER_ACTION_ID, 0) AS VARCHAR(3))) || '=' || 
   CASE COALESCE(E.ER_ACTION_ID, 0) 
   WHEN 0 THEN 'NO ACTION' 
   WHEN 1 THEN 'NEW ENTITY' 
   WHEN 2 THEN 'EXISTING ENTITY' 
   WHEN 3 THEN 'MOVE ENTITY' 
   WHEN 4 THEN 'DELETE ENTITY' 
   WHEN 5 THEN 'NEW RELATION' 
   WHEN 6 THEN 'EXISTING RELATION' 
   WHEN 7 THEN 'DELETE RELATION' 
   ELSE 'UNKNOWN' END AS VARCHAR(25)) AS ER_ACTION,
 E.CAND_ENT_ID,
 E.ERRULE_ID,
 (SELECT ERRULE_CODE FROM CFG_ERRULE WHERE ERRULE_ID = E.ERRULE_ID) AS ERRULE_CODE,
 E.OBS_ENT_ID AS IN_OBS_ENT_ID,
 E.FROM_RES_ENT_ID,
 E.TO_RES_ENT_ID,
 E.RES_REL_ID
FROM LOG_ER A
LEFT JOIN OBS_ENT B ON B.OBS_ENT_ID = A.OBS_ENT_ID
LEFT JOIN CFG_DSRC C ON C.DSRC_ID = B.DSRC_ID
JOIN LOG_ER_RES E ON E.ER_ID = A.ER_ID 
LEFT JOIN LOG_ER_STEP D ON D.ER_ID = E.ER_ID AND D.ER_STEP = E.ER_STEP
;
DELETE FROM SRD_PRODUCT_VERSIONS WHERE PRODUCT='PIPELINE';
INSERT INTO SRD_PRODUCT_VERSIONS VALUES('PIPELINE','4.2.0.0');
RUNSTATS ON TABLE LIB_FEAT ;

UPDATE SYSSTAT.INDEXES
SET NLEAF=-1,
    NLEVELS=-1,
    FIRSTKEYCARD=-1,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=-1,
    CLUSTERFACTOR=-1,
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=-1,
    PAGE_FETCH_PAIRS='',
    DENSITY=-1,
    AVERAGE_SEQUENCE_GAP=-1,
    AVERAGE_SEQUENCE_FETCH_GAP=-1,
    AVERAGE_SEQUENCE_PAGES=-1,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1,
    AVERAGE_RANDOM_PAGES=-1,
    AVERAGE_RANDOM_FETCH_PAGES=-1,
    NUMRIDS=-1,
    NUMRIDS_DELETED=-1,
    NUM_EMPTY_LEAFS=-1,
    INDCARD=-1
WHERE TABNAME = 'LIB_FEAT' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.COLUMNS
SET COLCARD=-1,
    NUMNULLS=-1
WHERE TABNAME = 'LIB_FEAT' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.TABLES
SET CARD=1425844,
    NPAGES=62328,
    MPAGES=0,
    FPAGES=62328,
    OVERFLOW=0,
    ACTIVE_BLOCKS=0
WHERE TABNAME = 'LIB_FEAT' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.INDEXES
SET NLEAF=7545,
    NLEVELS=3,
    FIRSTKEYCARD=1425844,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=1425844,
    CLUSTERFACTOR=-1.000000,
    CLUSTERRATIO=99,
    SEQUENTIAL_PAGES=7544,
    DENSITY=99,
    AVERAGE_SEQUENCE_GAP=0.000000,
    AVERAGE_SEQUENCE_FETCH_GAP=-1.000000,
    AVERAGE_SEQUENCE_PAGES=7544.000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1.000000,
    AVERAGE_RANDOM_PAGES=0.000000,
    AVERAGE_RANDOM_FETCH_PAGES=-1.000000,
    NUMRIDS=1425855,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0,
    INDCARD=1425844
WHERE COLNAMES = '+LIB_FEAT_ID'
      AND TABNAME = 'LIB_FEAT' AND TABSCHEMA = CURRENT SCHEMA;

COMMIT WORK;

RUNSTATS ON TABLE   LIB_FEAT_HKEY ;

UPDATE SYSSTAT.INDEXES
SET NLEAF=-1,
    NLEVELS=-1,
    FIRSTKEYCARD=-1,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=-1,
    CLUSTERFACTOR=-1,
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=-1,
    PAGE_FETCH_PAIRS='',
    DENSITY=-1,
    AVERAGE_SEQUENCE_GAP=-1,
    AVERAGE_SEQUENCE_FETCH_GAP=-1,
    AVERAGE_SEQUENCE_PAGES=-1,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1,
    AVERAGE_RANDOM_PAGES=-1,
    AVERAGE_RANDOM_FETCH_PAGES=-1,
    NUMRIDS=-1,
    NUMRIDS_DELETED=-1,
    NUM_EMPTY_LEAFS=-1,
    INDCARD=-1
WHERE TABNAME = 'LIB_FEAT_HKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.COLUMNS
SET COLCARD=-1,
    NUMNULLS=-1
WHERE TABNAME = 'LIB_FEAT_HKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.TABLES
SET CARD=1425855,
    NPAGES=21294,
    MPAGES=0,
    FPAGES=21294,
    OVERFLOW=0,
    ACTIVE_BLOCKS=0
WHERE TABNAME = 'LIB_FEAT_HKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.INDEXES
SET NLEAF=27248,
    NLEVELS=4,
    FIRSTKEYCARD=1425855,
    FIRST2KEYCARD=1425855,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=1425855,
    CLUSTERFACTOR=-1.000000,
    CLUSTERRATIO=1,
    SEQUENTIAL_PAGES=0,
    DENSITY=0,
    AVERAGE_SEQUENCE_GAP=0.000000,
    AVERAGE_SEQUENCE_FETCH_GAP=-1.000000,
    AVERAGE_SEQUENCE_PAGES=0.000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1.000000,
    AVERAGE_RANDOM_PAGES=27248.000000,
    AVERAGE_RANDOM_FETCH_PAGES=-1.000000,
    NUMRIDS=1425855,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0,
    INDCARD=1425855
WHERE COLNAMES = '+FEAT_HASH+FTYPE_ID'
      AND TABNAME = 'LIB_FEAT_HKEY' AND TABSCHEMA = CURRENT SCHEMA;

COMMIT WORK;

RUNSTATS ON TABLE  OBS_ENT ;

UPDATE SYSSTAT.INDEXES
SET NLEAF=-1,
    NLEVELS=-1,
    FIRSTKEYCARD=-1,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=-1,
    CLUSTERFACTOR=-1,
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=-1,
    PAGE_FETCH_PAIRS='',
    DENSITY=-1,
    AVERAGE_SEQUENCE_GAP=-1,
    AVERAGE_SEQUENCE_FETCH_GAP=-1,
    AVERAGE_SEQUENCE_PAGES=-1,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1,
    AVERAGE_RANDOM_PAGES=-1,
    AVERAGE_RANDOM_FETCH_PAGES=-1,
    NUMRIDS=-1,
    NUMRIDS_DELETED=-1,
    NUM_EMPTY_LEAFS=-1,
    INDCARD=-1
WHERE TABNAME = 'OBS_ENT' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.COLUMNS
SET COLCARD=-1,
    NUMNULLS=-1
WHERE TABNAME = 'OBS_ENT' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.TABLES
SET CARD=125231,
    NPAGES=2915,
    MPAGES=0,
    FPAGES=2915,
    OVERFLOW=0,
    ACTIVE_BLOCKS=0
WHERE TABNAME = 'OBS_ENT' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.INDEXES
SET NLEAF=663,
    NLEVELS=3,
    FIRSTKEYCARD=125231,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=125231,
    CLUSTERFACTOR=1.000000,
    PAGE_FETCH_PAIRS='100 2915 226 2915 565 2915 904 2915 1243 2915 1582 2915 1921 2915 2260 2915 2599 2915 2915 2915 2915 2915 ',
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=662,
    DENSITY=99,
    AVERAGE_SEQUENCE_GAP=0.000000,
    AVERAGE_SEQUENCE_FETCH_GAP=-1.000000,
    AVERAGE_SEQUENCE_PAGES=662.000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1.000000,
    AVERAGE_RANDOM_PAGES=0.000000,
    AVERAGE_RANDOM_FETCH_PAGES=-1.000000,
    NUMRIDS=125231,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0,
    INDCARD=125231
WHERE COLNAMES = '+OBS_ENT_ID'
      AND TABNAME = 'OBS_ENT' AND TABSCHEMA = CURRENT SCHEMA;

COMMIT WORK;

RUNSTATS ON TABLE  OBS_ENT_SKEY ;

UPDATE SYSSTAT.INDEXES
SET NLEAF=-1,
    NLEVELS=-1,
    FIRSTKEYCARD=-1,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=-1,
    CLUSTERFACTOR=-1,
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=-1,
    PAGE_FETCH_PAIRS='',
    DENSITY=-1,
    AVERAGE_SEQUENCE_GAP=-1,
    AVERAGE_SEQUENCE_FETCH_GAP=-1,
    AVERAGE_SEQUENCE_PAGES=-1,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1,
    AVERAGE_RANDOM_PAGES=-1,
    AVERAGE_RANDOM_FETCH_PAGES=-1,
    NUMRIDS=-1,
    NUMRIDS_DELETED=-1,
    NUM_EMPTY_LEAFS=-1,
    INDCARD=-1
WHERE TABNAME = 'OBS_ENT_SKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.COLUMNS
SET COLCARD=-1,
    NUMNULLS=-1
WHERE TABNAME = 'OBS_ENT_SKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.TABLES
SET CARD=125231,
    NPAGES=1186,
    MPAGES=0,
    FPAGES=1189,
    OVERFLOW=0,
    ACTIVE_BLOCKS=0
WHERE TABNAME = 'OBS_ENT_SKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.INDEXES
SET NLEAF=1894,
    NLEVELS=3,
    FIRSTKEYCARD=125231,
    FIRST2KEYCARD=125231,
    FIRST3KEYCARD=125231,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=125231,
    CLUSTERFACTOR=-1.000000,
    CLUSTERRATIO=99,
    SEQUENTIAL_PAGES=1877,
    DENSITY=97,
    AVERAGE_SEQUENCE_GAP=0.000000,
    AVERAGE_SEQUENCE_FETCH_GAP=-1.000000,
    AVERAGE_SEQUENCE_PAGES=1877.000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1.000000,
    AVERAGE_RANDOM_PAGES=16.000000,
    AVERAGE_RANDOM_FETCH_PAGES=-1.000000,
    NUMRIDS=125231,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0,
    INDCARD=125231
WHERE COLNAMES = '+ENT_SRC_KEY+ETYPE_ID+DSRC_ID'
      AND TABNAME = 'OBS_ENT_SKEY' AND TABSCHEMA = CURRENT SCHEMA;

COMMIT WORK;

RUNSTATS ON TABLE OBS_FEAT_EKEY ;

UPDATE SYSSTAT.INDEXES
SET NLEAF=-1,
    NLEVELS=-1,
    FIRSTKEYCARD=-1,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=-1,
    CLUSTERFACTOR=-1,
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=-1,
    PAGE_FETCH_PAIRS='',
    DENSITY=-1,
    AVERAGE_SEQUENCE_GAP=-1,
    AVERAGE_SEQUENCE_FETCH_GAP=-1,
    AVERAGE_SEQUENCE_PAGES=-1,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1,
    AVERAGE_RANDOM_PAGES=-1,
    AVERAGE_RANDOM_FETCH_PAGES=-1,
    NUMRIDS=-1,
    NUMRIDS_DELETED=-1,
    NUM_EMPTY_LEAFS=-1,
    INDCARD=-1
WHERE TABNAME = 'OBS_FEAT_EKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.COLUMNS
SET COLCARD=-1,
    NUMNULLS=-1
WHERE TABNAME = 'OBS_FEAT_EKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.TABLES
SET CARD=1553335,
    NPAGES=25068,
    MPAGES=0,
    FPAGES=25068,
    OVERFLOW=0,
    ACTIVE_BLOCKS=0
WHERE TABNAME = 'OBS_FEAT_EKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.INDEXES
SET NLEAF=12081,
    NLEVELS=3,
    FIRSTKEYCARD=125230,
    FIRST2KEYCARD=1553335,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=1553335,
    CLUSTERFACTOR=-1.000000,
    CLUSTERRATIO=100,
    SEQUENTIAL_PAGES=12080,
    DENSITY=99,
    AVERAGE_SEQUENCE_GAP=0.000000,
    AVERAGE_SEQUENCE_FETCH_GAP=-1.000000,
    AVERAGE_SEQUENCE_PAGES=12080.000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1.000000,
    AVERAGE_RANDOM_PAGES=0.000000,
    AVERAGE_RANDOM_FETCH_PAGES=-1.000000,
    NUMRIDS=1553335,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0,
    INDCARD=1553335
WHERE COLNAMES = '+OBS_ENT_ID+LIB_FEAT_ID'
      AND TABNAME = 'OBS_FEAT_EKEY' AND TABSCHEMA = CURRENT SCHEMA;

COMMIT WORK;

RUNSTATS ON TABLE OBS_FEAT_LKEY ;

UPDATE SYSSTAT.INDEXES
SET NLEAF=-1,
    NLEVELS=-1,
    FIRSTKEYCARD=-1,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=-1,
    CLUSTERFACTOR=-1,
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=-1,
    PAGE_FETCH_PAIRS='',
    DENSITY=-1,
    AVERAGE_SEQUENCE_GAP=-1,
    AVERAGE_SEQUENCE_FETCH_GAP=-1,
    AVERAGE_SEQUENCE_PAGES=-1,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1,
    AVERAGE_RANDOM_PAGES=-1,
    AVERAGE_RANDOM_FETCH_PAGES=-1,
    NUMRIDS=-1,
    NUMRIDS_DELETED=-1,
    NUM_EMPTY_LEAFS=-1,
    INDCARD=-1
WHERE TABNAME = 'OBS_FEAT_LKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.COLUMNS
SET COLCARD=-1,
    NUMNULLS=-1
WHERE TABNAME = 'OBS_FEAT_LKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.TABLES
SET CARD=1553335,
    NPAGES=10093,
    MPAGES=0,
    FPAGES=10093,
    OVERFLOW=0,
    ACTIVE_BLOCKS=0
WHERE TABNAME = 'OBS_FEAT_LKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.INDEXES
SET NLEAF=13637,
    NLEVELS=3,
    FIRSTKEYCARD=1425855,
    FIRST2KEYCARD=1553335,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=1553335,
    CLUSTERFACTOR=-1.000000,
    CLUSTERRATIO=89,
    SEQUENTIAL_PAGES=9431,
    DENSITY=75,
    AVERAGE_SEQUENCE_GAP=0.000000,
    AVERAGE_SEQUENCE_FETCH_GAP=-1.000000,
    AVERAGE_SEQUENCE_PAGES=9431.000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1.000000,
    AVERAGE_RANDOM_PAGES=1783.000000,
    AVERAGE_RANDOM_FETCH_PAGES=-1.000000,
    NUMRIDS=1553335,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0,
    INDCARD=1553335
WHERE COLNAMES = '+LIB_FEAT_ID+OBS_ENT_ID'
      AND TABNAME = 'OBS_FEAT_LKEY' AND TABSCHEMA = CURRENT SCHEMA;

COMMIT WORK;

RUNSTATS ON TABLE RES_ENT ;

UPDATE SYSSTAT.INDEXES
SET NLEAF=-1,
    NLEVELS=-1,
    FIRSTKEYCARD=-1,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=-1,
    CLUSTERFACTOR=-1,
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=-1,
    PAGE_FETCH_PAIRS='',
    DENSITY=-1,
    AVERAGE_SEQUENCE_GAP=-1,
    AVERAGE_SEQUENCE_FETCH_GAP=-1,
    AVERAGE_SEQUENCE_PAGES=-1,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1,
    AVERAGE_RANDOM_PAGES=-1,
    AVERAGE_RANDOM_FETCH_PAGES=-1,
    NUMRIDS=-1,
    NUMRIDS_DELETED=-1,
    NUM_EMPTY_LEAFS=-1,
    INDCARD=-1
WHERE TABNAME = 'RES_ENT' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.COLUMNS
SET COLCARD=-1,
    NUMNULLS=-1
WHERE TABNAME = 'RES_ENT' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.TABLES
SET CARD=125069,
    NPAGES=2053,
    MPAGES=0,
    FPAGES=2053,
    OVERFLOW=0,
    ACTIVE_BLOCKS=0
WHERE TABNAME = 'RES_ENT' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.INDEXES
SET NLEAF=732,
    NLEVELS=3,
    FIRSTKEYCARD=125069,
    FIRST2KEYCARD=125069,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=125069,
    CLUSTERFACTOR=-1.000000,
    CLUSTERRATIO=100,
    SEQUENTIAL_PAGES=731,
    DENSITY=99,
    AVERAGE_SEQUENCE_GAP=0.000000,
    AVERAGE_SEQUENCE_FETCH_GAP=-1.000000,
    AVERAGE_SEQUENCE_PAGES=731.000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1.000000,
    AVERAGE_RANDOM_PAGES=0.000000,
    AVERAGE_RANDOM_FETCH_PAGES=-1.000000,
    NUMRIDS=125069,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0,
    INDCARD=125069
WHERE COLNAMES = '+RES_ENT_ID+LENS_ID'
      AND TABNAME = 'RES_ENT' AND TABSCHEMA = CURRENT SCHEMA;

COMMIT WORK;

RUNSTATS ON TABLE RES_ENT_OKEY ;

UPDATE SYSSTAT.INDEXES
SET NLEAF=-1,
    NLEVELS=-1,
    FIRSTKEYCARD=-1,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=-1,
    CLUSTERFACTOR=-1,
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=-1,
    PAGE_FETCH_PAIRS='',
    DENSITY=-1,
    AVERAGE_SEQUENCE_GAP=-1,
    AVERAGE_SEQUENCE_FETCH_GAP=-1,
    AVERAGE_SEQUENCE_PAGES=-1,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1,
    AVERAGE_RANDOM_PAGES=-1,
    AVERAGE_RANDOM_FETCH_PAGES=-1,
    NUMRIDS=-1,
    NUMRIDS_DELETED=-1,
    NUM_EMPTY_LEAFS=-1,
    INDCARD=-1
WHERE TABNAME = 'RES_ENT_OKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.COLUMNS
SET COLCARD=-1,
    NUMNULLS=-1
WHERE TABNAME = 'RES_ENT_OKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.TABLES
SET CARD=125230,
    NPAGES=1184,
    MPAGES=0,
    FPAGES=1184,
    OVERFLOW=0,
    ACTIVE_BLOCKS=0
WHERE TABNAME = 'RES_ENT_OKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.INDEXES
SET NLEAF=1010,
    NLEVELS=3,
    FIRSTKEYCARD=125230,
    FIRST2KEYCARD=125230,
    FIRST3KEYCARD=125230,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=125230,
    CLUSTERFACTOR=-1.000000,
    CLUSTERRATIO=100,
    SEQUENTIAL_PAGES=1009,
    DENSITY=99,
    AVERAGE_SEQUENCE_GAP=0.000000,
    AVERAGE_SEQUENCE_FETCH_GAP=-1.000000,
    AVERAGE_SEQUENCE_PAGES=1009.000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1.000000,
    AVERAGE_RANDOM_PAGES=0.000000,
    AVERAGE_RANDOM_FETCH_PAGES=-1.000000,
    NUMRIDS=125230,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0,
    INDCARD=125230
WHERE COLNAMES = '+OBS_ENT_ID+LENS_ID+RES_ENT_ID'
      AND TABNAME = 'RES_ENT_OKEY' AND TABSCHEMA = CURRENT SCHEMA;

COMMIT WORK;

RUNSTATS ON TABLE RES_ENT_RKEY ;

UPDATE SYSSTAT.INDEXES
SET NLEAF=-1,
    NLEVELS=-1,
    FIRSTKEYCARD=-1,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=-1,
    CLUSTERFACTOR=-1,
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=-1,
    PAGE_FETCH_PAIRS='',
    DENSITY=-1,
    AVERAGE_SEQUENCE_GAP=-1,
    AVERAGE_SEQUENCE_FETCH_GAP=-1,
    AVERAGE_SEQUENCE_PAGES=-1,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1,
    AVERAGE_RANDOM_PAGES=-1,
    AVERAGE_RANDOM_FETCH_PAGES=-1,
    NUMRIDS=-1,
    NUMRIDS_DELETED=-1,
    NUM_EMPTY_LEAFS=-1,
    INDCARD=-1
WHERE TABNAME = 'RES_ENT_RKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.COLUMNS
SET COLCARD=-1,
    NUMNULLS=-1
WHERE TABNAME = 'RES_ENT_RKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.TABLES
SET CARD=125230,
    NPAGES=878,
    MPAGES=0,
    FPAGES=878,
    OVERFLOW=0,
    ACTIVE_BLOCKS=0
WHERE TABNAME = 'RES_ENT_RKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.INDEXES
SET NLEAF=1009,
    NLEVELS=3,
    FIRSTKEYCARD=125069,
    FIRST2KEYCARD=125069,
    FIRST3KEYCARD=125230,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=125230,
    CLUSTERFACTOR=-1.000000,
    CLUSTERRATIO=99,
    SEQUENTIAL_PAGES=1008,
    DENSITY=99,
    AVERAGE_SEQUENCE_GAP=0.000000,
    AVERAGE_SEQUENCE_FETCH_GAP=-1.000000,
    AVERAGE_SEQUENCE_PAGES=1008.000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1.000000,
    AVERAGE_RANDOM_PAGES=0.000000,
    AVERAGE_RANDOM_FETCH_PAGES=-1.000000,
    NUMRIDS=125230,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0,
    INDCARD=125230
WHERE COLNAMES = '+RES_ENT_ID+LENS_ID+OBS_ENT_ID'
      AND TABNAME = 'RES_ENT_RKEY' AND TABSCHEMA = CURRENT SCHEMA;

COMMIT WORK;

RUNSTATS ON TABLE RES_FEAT_EKEY ;

UPDATE SYSSTAT.INDEXES
SET NLEAF=-1,
    NLEVELS=-1,
    FIRSTKEYCARD=-1,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=-1,
    CLUSTERFACTOR=-1,
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=-1,
    PAGE_FETCH_PAIRS='',
    DENSITY=-1,
    AVERAGE_SEQUENCE_GAP=-1,
    AVERAGE_SEQUENCE_FETCH_GAP=-1,
    AVERAGE_SEQUENCE_PAGES=-1,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1,
    AVERAGE_RANDOM_PAGES=-1,
    AVERAGE_RANDOM_FETCH_PAGES=-1,
    NUMRIDS=-1,
    NUMRIDS_DELETED=-1,
    NUM_EMPTY_LEAFS=-1,
    INDCARD=-1
WHERE TABNAME = 'RES_FEAT_EKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.COLUMNS
SET COLCARD=-1,
    NUMNULLS=-1
WHERE TABNAME = 'RES_FEAT_EKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.TABLES
SET CARD=1552155,
    NPAGES=31060,
    MPAGES=0,
    FPAGES=31060,
    OVERFLOW=0,
    ACTIVE_BLOCKS=0
WHERE TABNAME = 'RES_FEAT_EKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.INDEXES
SET NLEAF=15151,
    NLEVELS=4,
    FIRSTKEYCARD=125069,
    FIRST2KEYCARD=125069,
    FIRST3KEYCARD=1552155,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=1552155,
    CLUSTERFACTOR=0.999881,
    PAGE_FETCH_PAIRS='100 31241 4956 31190 7434 31175 12390 31120 16107 31102 17346 31090 21063 31076 23541 31068 28497 31060 31060 31060 31060 31060 ',
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=15150,
    DENSITY=99,
    AVERAGE_SEQUENCE_GAP=0.000000,
    AVERAGE_SEQUENCE_FETCH_GAP=-1.000000,
    AVERAGE_SEQUENCE_PAGES=15150.000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1.000000,
    AVERAGE_RANDOM_PAGES=0.000000,
    AVERAGE_RANDOM_FETCH_PAGES=-1.000000,
    NUMRIDS=1552155,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0,
    INDCARD=1552155
WHERE COLNAMES = '+RES_ENT_ID+LENS_ID+LIB_FEAT_ID'
      AND TABNAME = 'RES_FEAT_EKEY' AND TABSCHEMA = CURRENT SCHEMA;

COMMIT WORK;

RUNSTATS ON TABLE  RES_FEAT_LKEY ;

UPDATE SYSSTAT.INDEXES
SET NLEAF=-1,
    NLEVELS=-1,
    FIRSTKEYCARD=-1,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=-1,
    CLUSTERFACTOR=-1,
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=-1,
    PAGE_FETCH_PAIRS='',
    DENSITY=-1,
    AVERAGE_SEQUENCE_GAP=-1,
    AVERAGE_SEQUENCE_FETCH_GAP=-1,
    AVERAGE_SEQUENCE_PAGES=-1,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1,
    AVERAGE_RANDOM_PAGES=-1,
    AVERAGE_RANDOM_FETCH_PAGES=-1,
    NUMRIDS=-1,
    NUMRIDS_DELETED=-1,
    NUM_EMPTY_LEAFS=-1,
    INDCARD=-1
WHERE TABNAME = 'RES_FEAT_LKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.COLUMNS
SET COLCARD=-1,
    NUMNULLS=-1
WHERE TABNAME = 'RES_FEAT_LKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.TABLES
SET CARD=1552155,
    NPAGES=11591,
    MPAGES=0,
    FPAGES=11591,
    OVERFLOW=0,
    ACTIVE_BLOCKS=0
WHERE TABNAME = 'RES_FEAT_LKEY' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.INDEXES
SET NLEAF=18607,
    NLEVELS=4,
    FIRSTKEYCARD=1425855,
    FIRST2KEYCARD=1425855,
    FIRST3KEYCARD=1425855,
    FIRST4KEYCARD=1552155,
    FULLKEYCARD=1552155,
    CLUSTERFACTOR=-1.000000,
    CLUSTERRATIO=89,
    SEQUENTIAL_PAGES=16181,
    DENSITY=85,
    AVERAGE_SEQUENCE_GAP=0.000000,
    AVERAGE_SEQUENCE_FETCH_GAP=-1.000000,
    AVERAGE_SEQUENCE_PAGES=16181.000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1.000000,
    AVERAGE_RANDOM_PAGES=2424.000000,
    AVERAGE_RANDOM_FETCH_PAGES=-1.000000,
    NUMRIDS=1552155,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0,
    INDCARD=1552155
WHERE COLNAMES = '+LIB_FEAT_ID+LENS_ID+ECLASS_ID+RES_ENT_ID'
      AND TABNAME = 'RES_FEAT_LKEY' AND TABSCHEMA = CURRENT SCHEMA;

COMMIT WORK;

RUNSTATS ON TABLE RES_FEAT_STAT ;

UPDATE SYSSTAT.INDEXES
SET NLEAF=-1,
    NLEVELS=-1,
    FIRSTKEYCARD=-1,
    FIRST2KEYCARD=-1,
    FIRST3KEYCARD=-1,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=-1,
    CLUSTERFACTOR=-1,
    CLUSTERRATIO=-1,
    SEQUENTIAL_PAGES=-1,
    PAGE_FETCH_PAIRS='',
    DENSITY=-1,
    AVERAGE_SEQUENCE_GAP=-1,
    AVERAGE_SEQUENCE_FETCH_GAP=-1,
    AVERAGE_SEQUENCE_PAGES=-1,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1,
    AVERAGE_RANDOM_PAGES=-1,
    AVERAGE_RANDOM_FETCH_PAGES=-1,
    NUMRIDS=-1,
    NUMRIDS_DELETED=-1,
    NUM_EMPTY_LEAFS=-1,
    INDCARD=-1
WHERE TABNAME = 'RES_FEAT_STAT' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.COLUMNS
SET COLCARD=-1,
    NUMNULLS=-1
WHERE TABNAME = 'RES_FEAT_STAT' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.TABLES
SET CARD=1425855,
    NPAGES=10648,
    MPAGES=0,
    FPAGES=10648,
    OVERFLOW=0,
    ACTIVE_BLOCKS=0
WHERE TABNAME = 'RES_FEAT_STAT' AND TABSCHEMA = CURRENT SCHEMA;

UPDATE SYSSTAT.INDEXES
SET NLEAF=11829,
    NLEVELS=3,
    FIRSTKEYCARD=1425855,
    FIRST2KEYCARD=1425855,
    FIRST3KEYCARD=1425855,
    FIRST4KEYCARD=-1,
    FULLKEYCARD=1425855,
    CLUSTERFACTOR=-1.000000,
    CLUSTERRATIO=100,
    SEQUENTIAL_PAGES=11828,
    DENSITY=99,
    AVERAGE_SEQUENCE_GAP=0.000000,
    AVERAGE_SEQUENCE_FETCH_GAP=-1.000000,
    AVERAGE_SEQUENCE_PAGES=11828.000000,
    AVERAGE_SEQUENCE_FETCH_PAGES=-1.000000,
    AVERAGE_RANDOM_PAGES=0.000000,
    AVERAGE_RANDOM_FETCH_PAGES=-1.000000,
    NUMRIDS=1425855,
    NUMRIDS_DELETED=0,
    NUM_EMPTY_LEAFS=0,
    INDCARD=1425855
WHERE COLNAMES = '+LIB_FEAT_ID+LENS_ID+ECLASS_ID'
      AND TABNAME = 'RES_FEAT_STAT' AND TABSCHEMA = CURRENT SCHEMA;

COMMIT WORK;


