 ) ;                                                                             
                                                                                 
                                                                                 
-CREATE TABLE "EN_RULE_TMPL_ATTRIB_T"                                            
-(	"RULE_TMPL_ATTRIB_ID" NUMBER(19,0) NOT NULL ENABLE,                           
-"RULE_TMPL_ID" NUMBER(19,0) NOT NULL ENABLE,                                    
-"RULE_ATTRIB_ID" NUMBER(19,0) NOT NULL ENABLE,                                  
-"REQ_IND" NUMBER(1,0) NOT NULL ENABLE,                                          
-"ACTV_IND" NUMBER(1,0) NOT NULL ENABLE,                                         
-"DSPL_ORD" NUMBER(5,0) NOT NULL ENABLE,                                         
-"DFLT_VAL" VARCHAR2(2000),                                                      
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_RULE_TMPL_ATTRIB_PK" PRIMARY KEY ("RULE_TMPL_ATTRIB_ID") ENABLE  
-) ;                                                                             
-                                                                                
-                                                                                
-CREATE TABLE "EN_RULE_TMPL_OPTN_T"                                              
-(	"RULE_TMPL_OPTN_ID" NUMBER(19,0) NOT NULL ENABLE,                             
-"RULE_TMPL_ID" NUMBER(19,0),                                                    
-"RULE_TMPL_OPTN_KEY" VARCHAR2(250),                                             
-"RULE_TMPL_OPTN_VAL" VARCHAR2(2000),                                            
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_RULE_TMPL_OPTN_T_PK" PRIMARY KEY ("RULE_TMPL_OPTN_ID") ENABLE    
-) ;                                                                             
-                                                                                
-                                                                                
-CREATE TABLE "EN_RULE_TMPL_T"                                                   
-(	"RULE_TMPL_ID" NUMBER(19,0) NOT NULL ENABLE,                                  
-"RULE_TMPL_NM" VARCHAR2(250) NOT NULL ENABLE,                                   
-"RULE_TMPL_DESC" VARCHAR2(2000),                                                
-"DLGN_RULE_TMPL_ID" NUMBER(19,0),                                               
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_RULE_TMPL_T_PK" PRIMARY KEY ("RULE_TMPL_ID") ENABLE
+CREATE TABLE "USER_ROLES"                                                       
+(	"USER_ID" VARCHAR2(10) CONSTRAINT "USER_ROLESN1" NOT NULL ENABLE,             
+"ROLE_ID" NUMBER(5,0) CONSTRAINT "USER_ROLESN2" NOT NULL ENABLE,                
+"UNIT_NUMBER" VARCHAR2(8) CONSTRAINT "USER_ROLESN3" NOT NULL ENABLE,            
+"DESCEND_FLAG" CHAR(1) CONSTRAINT "USER_ROLESN4" NOT NULL ENABLE,               
+"UPDATE_TIMESTAMP" DATE CONSTRAINT "USER_ROLESN5" NOT NULL ENABLE,              
+"UPDATE_USER" VARCHAR2(8) CONSTRAINT "USER_ROLESN6" NOT NULL ENABLE,            
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "USER_ROLESN7" NOT NULL ENABLE,      
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "USER_ROLESN8" NOT NULL     
+ENABLE,                                                                         
+CONSTRAINT "PK_USER_ROLES_KRA" PRIMARY KEY ("ROLE_ID", "USER_ID", "UNIT_NUMBER")
+ENABLE                                                                          
+) ;                                                                             
+                                                                                
+                                                                                
+CREATE TABLE "YNQ_EXPLANATION"                                                  
+(	"QUESTION_ID" VARCHAR2(4) CONSTRAINT "YNQ_EXPLANATIONN1" NOT NULL ENABLE,     
+"EXPLANATION_TYPE" CHAR(1) CONSTRAINT "YNQ_EXPLANATIONN2" NOT NULL ENABLE,      
+"EXPLANATION" LONG,                                                             
+"UPDATE_TIMESTAMP" DATE CONSTRAINT "YNQ_EXPLANATIONN3" NOT NULL ENABLE,         
+"UPDATE_USER" VARCHAR2(8) CONSTRAINT "YNQ_EXPLANATIONN4" NOT NULL ENABLE,       
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "YNQ_EXPLANATIONN5" NOT NULL ENABLE, 
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "YNQ_EXPLANATIONN6" NOT NULL
+ENABLE,                                                                         
+CONSTRAINT "PK_YNQ_EXPLANATION_KRA" PRIMARY KEY ("QUESTION_ID",                 
+"EXPLANATION_TYPE") ENABLE                                                      
+) ;                                                                             
+                                                                                
+                                                                                
+CREATE TABLE "PROPOSAL_RESPONSE"                                                
+(	"PROPOSAL_RESPONSE_CODE" VARCHAR2(3) CONSTRAINT "PROPOSAL_RESPONSE_N1" NOT    
+NULL ENABLE,                                                                    
+"DESCRIPTION" VARCHAR2(200) CONSTRAINT "PROPOSAL_RESPONSE_N2" NOT NULL ENABLE,  
+"UPDATE_TIMESTAMP" DATE CONSTRAINT "PROPOSAL_RESPONSE_N3" NOT NULL ENABLE,      
+"UPDATE_USER" VARCHAR2(8) CONSTRAINT "PROPOSAL_RESPONSE_N4" NOT NULL ENABLE,    
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "PROPOSAL_RESPONSE_N5" NOT NULL      
+ENABLE,                                                                         
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "PROPOSAL_RESPONSE_N6" NOT  
+NULL ENABLE,                                                                    
+CONSTRAINT "PROPOSAL_RESPONSE_P1" PRIMARY KEY ("PROPOSAL_RESPONSE_CODE") ENABLE,
+CONSTRAINT "PROPOSAL_RESPONSE_C0" UNIQUE ("OBJ_ID") ENABLE
+   ) ;
+              
+                                                                                
+CREATE TABLE "INV_CREDIT_TYPE"                                                  
+(	"INV_CREDIT_TYPE_CODE" VARCHAR2(3) CONSTRAINT "INV_CREDIT_TYPE_N1" NOT NULL   
+ENABLE,                                                                         
+"DESCRIPTION" VARCHAR2(300) NOT NULL ENABLE,                                    
+"ADDS_TO_HUNDRED" CHAR(1) NOT NULL ENABLE,                                      
+"UPDATE_TIMESTAMP" DATE CONSTRAINT "INV_CREDIT_TYPE_N2" NOT NULL ENABLE,        
+"UPDATE_USER" VARCHAR2(8) CONSTRAINT "INV_CREDIT_TYPE_N3" NOT NULL ENABLE,      
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "INV_CREDIT_TYPE_N4" NOT NULL ENABLE,
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL ENABLE,                       
+"ACTIVE_FLAG" CHAR(1),                                                          
+CONSTRAINT "INV_CREDIT_TYPE_P1" PRIMARY KEY ("INV_CREDIT_TYPE_CODE") ENABLE,    
+CONSTRAINT "INV_CREDIT_TYPE_C0" UNIQUE ("OBJ_ID") ENABLE
+   ) ;
+                
+                                                                                
+CREATE TABLE "NOTICE_OF_OPPORTUNITY"                                            
+(	"NOTICE_OF_OPPORTUNITY_CODE" VARCHAR2(3) CONSTRAINT "NOTICE_OF_OPPORTUNITY_N1"
+NOT NULL ENABLE,                                                                
+"DESCRIPTION" VARCHAR2(200) CONSTRAINT "NOTICE_OF_OPPORTUNITY_N2" NOT NULL      
+ENABLE,                                                                         
+"UPDATE_TIMESTAMP" DATE CONSTRAINT "NOTICE_OF_OPPORTUNITY_N3" NOT NULL ENABLE,  
+"UPDATE_USER" VARCHAR2(8) CONSTRAINT "NOTICE_OF_OPPORTUNITY_N4" NOT NULL ENABLE,
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "NOTICE_OF_OPPORTUNITY_N5" NOT NULL  
+ENABLE,                                                                         
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "NOTICE_OF_OPPORTUNITY_N6"  
+NOT NULL ENABLE,                                                                
+CONSTRAINT "NOTICE_OF_OPPORTUNITY_TP1" PRIMARY KEY                              
+("NOTICE_OF_OPPORTUNITY_CODE") ENABLE,                                          
+	 CONSTRAINT "NOTICE_OF_OPPORTUNITY_TC0" UNIQUE ("OBJ_ID") ENABLE
+   ) ;
+       
+                                                                                
+CREATE TABLE "EPS_PROP_PER_CREDIT_SPLIT"                                        
+(	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_PER_CREDIT_SPLIT_N1" NOT  
+NULL ENABLE,                                                                    
+"INV_CREDIT_TYPE_CODE" VARCHAR2(3) CONSTRAINT "EPS_PROP_PER_CREDIT_SPLIT_N3" NOT
+NULL ENABLE,                                                                    
+"PROP_PERSON_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_PER_CREDIT_SPLIT_N4" NOT 
+NULL ENABLE,                                                                    
+"CREDIT" NUMBER(5,2),                                                           
+"UPDATE_TIMESTAMP" DATE CONSTRAINT "EPS_PROP_PER_CREDIT_SPLIT_N6" NOT NULL      
+ENABLE,                                                                         
+"UPDATE_USER" VARCHAR2(8) CONSTRAINT "EPS_PROP_PER_CREDIT_SPLIT_N7" NOT NULL    
+ENABLE,                                                                         
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "EPS_PER_UNIT_CREDIT_SPLIT_N8" NOT   
+NULL ENABLE,                                                                    
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL ENABLE,                       
+CONSTRAINT "EPS_PROP_PER_CREDIT_SPLIT_P1" PRIMARY KEY ("PROPOSAL_NUMBER",       
+"PROP_PERSON_NUMBER", "INV_CREDIT_TYPE_CODE") ENABLE,                           
+CONSTRAINT "EPS_PROP_PER_CREDIT_SPLIT_C0" UNIQUE ("OBJ_ID") ENABLE
    ) ;
       
                                                                                 
-CREATE TABLE "EN_SERVICE_DEF_DUEX_T"                                            
-(	"SERVICE_DEF_ID" NUMBER(14,0) NOT NULL ENABLE,                                
-"SERVICE_NM" VARCHAR2(255) NOT NULL ENABLE,                                     
-"SERVICE_URL" VARCHAR2(500) NOT NULL ENABLE,                                    
-"SERVER_IP" VARCHAR2(40) NOT NULL ENABLE,                                       
-"MESSAGE_ENTITY_NM" VARCHAR2(10) NOT NULL ENABLE,                               
-"SERVICE_ALIVE" NUMBER(1,0) NOT NULL ENABLE,                                    
-"SERVICE_DEFINITION" CLOB NOT NULL ENABLE,                                      
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_SERVICE_DEF_DUEX_T_PK" PRIMARY KEY ("SERVICE_DEF_ID") ENABLE     
-) ;                                                                             
-                                                                                
-                                                                                
-CREATE TABLE "EN_SERVICE_DEF_INTER_T"                                           
-(	"SERVICE_DEF_INTER_ID" NUMBER(14,0) NOT NULL ENABLE,                          
-"SERVICE_DEF_ID" NUMBER(14,0) NOT NULL ENABLE,                                  
-"SERVICE_INTERFACE" VARCHAR2(500) NOT NULL ENABLE,                              
-"DB_LOC_VER_NBR" NUMBER(8,0) DEFAULT 0,                                         
-CONSTRAINT "EN_SERVICE_DEF_INTER_T_PK" PRIMARY KEY ("SERVICE_DEF_INTER_ID")     
-ENABLE                                                                          
-) ;                                                                             
-                                                                                
-                                                                                
-CREATE TABLE "EN_SERVICE_DEF_T"                                                 
-(	"SERVICE_DEF_ID" NUMBER(14,0) NOT NULL ENABLE,                                
-"SERVICE_NM" VARCHAR2(255) NOT NULL ENABLE,                                     
-"SERVICE_URL" VARCHAR2(500) NOT NULL ENABLE,                                    
-"EXCEPTION_HANDLER" VARCHAR2(500),                                              
-"ASYNC_QUEUE_IND" NUMBER(1,0),                                                  
-"PRIORITY" NUMBER(8,0),                                                         
-"RTRY_CNT" NUMBER(8,0),                                                         
-"MILLIS_TO_LIVE" NUMBER(14,0),                                                  
-"MESSAGE_ENTITY_NM" VARCHAR2(10) NOT NULL ENABLE,                               
-"SERVER_IP" VARCHAR2(40) NOT NULL ENABLE,                                       
-"SERVICE_ALIVE" NUMBER(1,0) NOT NULL ENABLE,                                    
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_SERVICE_DEF_T_PK" PRIMARY KEY ("SERVICE_DEF_ID") ENABLE
-   ) ;
-  
-                                                                                
-CREATE TABLE "EN_TRANSACTION_TST_ADDRS_T"                                       
-(	"ADDRS_ID" NUMBER(19,0) NOT NULL ENABLE,                                      
-"STREET" VARCHAR2(2000),                                                        
-"CITY" VARCHAR2(2000),                                                          
-"STATE" VARCHAR2(2),                                                            
-"ZIP" NUMBER(8,0),                                                              
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_TRANSACTION_TST_ADDRS_T_PK" PRIMARY KEY ("ADDRS_ID") ENABLE      
+CREATE TABLE "EPS_PROP_UNIT_CREDIT_SPLIT"                                       
+(	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_UNIT_CREDIT_SPLIT_N1" NOT 
+NULL ENABLE,                                                                    
+"INV_CREDIT_TYPE_CODE" VARCHAR2(3) CONSTRAINT "EPS_PROP_UNIT_CREDIT_SPLIT_N3"   
+NOT NULL ENABLE,                                                                
+"PROP_PERSON_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_UNIT_CREDIT_SPLIT_N4" NOT
+NULL ENABLE,                                                                    
+"UNIT_NUMBER" VARCHAR2(8) CONSTRAINT "EPS_PROP_UNIT_CREDIT_SPLIT_N5" NOT NULL   
+ENABLE,                                                                         
+"CREDIT" NUMBER(5,2),                                                           
+"UPDATE_TIMESTAMP" DATE CONSTRAINT "EPS_PROP_UNIT_CREDIT_SPLIT_N6" NOT NULL     
+ENABLE,                                                                         
+"UPDATE_USER" VARCHAR2(8) CONSTRAINT "EPS_PROP_UNIT_CREDIT_SPLIT_N7" NOT NULL   
+ENABLE,                                                                         
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "EPS_PROP_UNIT_CREDIT_SPLIT_N8" NOT  
+NULL ENABLE,                                                                    
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL ENABLE,                       
+CONSTRAINT "EPS_PROP_UNIT_CREDIT_SPLIT_P1" PRIMARY KEY ("PROPOSAL_NUMBER",      
+"PROP_PERSON_NUMBER", "INV_CREDIT_TYPE_CODE", "UNIT_NUMBER") ENABLE,            
+CONSTRAINT "EPS_PROP_UNIT_CREDIT_SPLIT_C0" UNIQUE ("OBJ_ID") ENABLE
+   ) ;
+     
+                                                                                
+CREATE TABLE "YNQ_EXPLANATION_TYPE"                                             
+(	"EXPLANATION_TYPE" CHAR(1) CONSTRAINT "YNQ_EXPLANATION_TYPEN2" NOT NULL       
+ENABLE,                                                                         
+"DESCRIPTION" VARCHAR2(200),                                                    
+"UPDATE_TIMESTAMP" DATE CONSTRAINT "YNQ_EXPLANATION_TYPEN3" NOT NULL ENABLE,    
+"UPDATE_USER" VARCHAR2(8) CONSTRAINT "YNQ_EXPLANATION_TYPEN4" NOT NULL ENABLE,  
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "YNQ_EXPLANATION_TYPEN5" NOT NULL    
+ENABLE,                                                                         
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "YNQ_EXPLANATION_TYPEN6" NOT
+NULL ENABLE,                                                                    
+CONSTRAINT "PK_YNQ_EXPLANATION_TYPE_KRA" PRIMARY KEY ("EXPLANATION_TYPE") ENABLE
 ) ;
                                                                             
                                                                                 
-CREATE TABLE "EN_TRANSACTION_TST_PRSN_T"                                        
-(	"PRSN_ID" NUMBER(19,0) NOT NULL ENABLE,                                       
-"FRST_NM" VARCHAR2(2000) NOT NULL ENABLE,                                       
-"LST_NM" VARCHAR2(2000) NOT NULL ENABLE,                                        
-"EMAIL" VARCHAR2(2000),                                                         
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_TRANSACTION_TST_PRSN_T_PK" PRIMARY KEY ("PRSN_ID") ENABLE        
-) ;                                                                             
-                                                                                
-                                                                                
-CREATE TABLE "EN_USR_OPTN_T"                                                    
-(	"PRSN_EN_ID" VARCHAR2(30),                                                    
-"PRSN_OPTN_ID" VARCHAR2(200) NOT NULL ENABLE,                                   
-"PRSN_OPTN_VAL" VARCHAR2(2000),                                                 
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_USR_OPTN_T_PK" PRIMARY KEY ("PRSN_EN_ID", "PRSN_OPTN_ID") ENABLE 
-) ;                                                                             
-                                                                                
-                                                                                
-CREATE TABLE "EN_USR_T"                                                         
-(	"PRSN_EN_ID" VARCHAR2(30) NOT NULL ENABLE,                                    
-"PRSN_UNIV_ID" VARCHAR2(11) NOT NULL ENABLE,                                    
-"PRSN_NTWRK_ID" VARCHAR2(30),                                                   
-"PRSN_UNVL_USR_ID" VARCHAR2(10),                                                
-"PRSN_EMAIL_ADDR" VARCHAR2(255),                                                
-"PRSN_NM" VARCHAR2(255),                                                        
-"PRSN_GVN_NM" VARCHAR2(255),                                                    
-"PRSN_LST_NM" VARCHAR2(255),                                                    
-"USR_CRTE_DT" DATE,                                                             
-"USR_LST_UPDT_DT" DATE,                                                         
-"PRSN_ID_MSNG_IND" NUMBER(1,0) DEFAULT 0,                                       
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_USR_T_PK" PRIMARY KEY ("PRSN_EN_ID") ENABLE
-   ) ;
-              
-                                                                                
-CREATE TABLE "EN_WRKGRP_EXT_DTA_T"                                              
-(	"WRKGRP_EXT_DTA_ID" NUMBER(19,0) NOT NULL ENABLE,                             
-"WRKGRP_EXT_ID" NUMBER(19,0) NOT NULL ENABLE,                                   
-"EXT_KEY" VARCHAR2(2000) NOT NULL ENABLE,                                       
-"EXT_VAL" VARCHAR2(2000),                                                       
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_WRKGRP_EXT_DTA_T_PK" PRIMARY KEY ("WRKGRP_EXT_DTA_ID") ENABLE    
-) ;                                                                             
-                                                                                
-                                                                                
-CREATE TABLE "EN_WRKGRP_EXT_T"                                                  
-(	"WRKGRP_EXT_ID" NUMBER(19,0) NOT NULL ENABLE,                                 
-"WRKGRP_ID" NUMBER(19,0) NOT NULL ENABLE,                                       
-"WRKGRP_VER_NBR" NUMBER(8,0) NOT NULL ENABLE,                                   
-"WRKGRP_TYP_ATTRIB_ID" NUMBER(19,0) NOT NULL ENABLE,                            
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_WRKGRP_EXT_T_PK" PRIMARY KEY ("WRKGRP_EXT_ID") ENABLE
-   ) ;
-    
-                                                                                
-CREATE TABLE "EN_WRKGRP_MBR_T"                                                  
-(	"WRKGRP_MBR_PRSN_EN_ID" VARCHAR2(30) NOT NULL ENABLE,                         
-"WRKGRP_ID" NUMBER(14,0) NOT NULL ENABLE,                                       
-"WRKGRP_MBR_TYP" CHAR(1) NOT NULL ENABLE,                                       
-"WRKGRP_VER_NBR" NUMBER(8,0) DEFAULT 0,                                         
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_WRKGRP_MBR_T_PK" PRIMARY KEY ("WRKGRP_MBR_PRSN_EN_ID",           
-"WRKGRP_ID", "WRKGRP_VER_NBR") ENABLE                                           
-) ;                                                                             
-                                                                                
-                                                                                
-CREATE TABLE "EN_WRKGRP_T"                                                      
-(	"WRKGRP_ID" NUMBER(14,0) NOT NULL ENABLE,                                     
-"WRKGRP_VER_NBR" NUMBER(8,0) DEFAULT 0,                                         
-"WRKGRP_NM" VARCHAR2(70) NOT NULL ENABLE,                                       
-"WRKGRP_ACTV_IND" NUMBER(1,0) NOT NULL ENABLE,                                  
-"WRKGRP_TYP_CD" VARCHAR2(255),                                                  
-"WRKGRP_DESC" VARCHAR2(2000),                                                   
-"WRKGRP_CUR_IND" NUMBER(1,0) DEFAULT 0,                                         
-"DOC_HDR_ID" NUMBER(14,0),                                                      
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_WRKGRP_T_PK" PRIMARY KEY ("WRKGRP_ID", "WRKGRP_VER_NBR") ENABLE  
-) ;                                                                             
-                                                                                
-                                                                                
-CREATE TABLE "EN_WRKGRP_TYP_ATTRIB_T"                                           
-(	"WRKGRP_TYP_ATTRIB_ID" NUMBER(19,0) NOT NULL ENABLE,                          
-"WRKGRP_TYP_ID" NUMBER(19,0) NOT NULL ENABLE,                                   
-"ATTRIB_ID" NUMBER(19,0) NOT NULL ENABLE,                                       
-"ACTV_IND" NUMBER(1,0) DEFAULT 1,                                               
-"ORD_INDX" NUMBER(4,0) DEFAULT 0,                                               
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_WRKGRP_TYP_ATTRIB_PK" PRIMARY KEY ("WRKGRP_TYP_ATTRIB_ID")       
-ENABLE
-   ) ;
-                                                                  
-                                                                                
-CREATE TABLE "EN_WRKGRP_TYP_T"                                                  
-(	"WRKGRP_TYP_ID" NUMBER(19,0) NOT NULL ENABLE,                                 
-"WRKGRP_TYP_NM" VARCHAR2(250) NOT NULL ENABLE,                                  
-"WRKGRP_TYP_LBL" VARCHAR2(2000) NOT NULL ENABLE,                                
-"WRKGRP_TYP_DESC" VARCHAR2(2000),                                               
-"DOC_TYP_NM" VARCHAR2(255),                                                     
-"ACTV_IND" NUMBER(1,0) DEFAULT 1,                                               
-"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
-CONSTRAINT "EN_WRKGRP_TYP_T_PK" PRIMARY KEY ("WRKGRP_TYP_ID") ENABLE
-   ) ;
-    
+CREATE TABLE "EPS_PROP_PERS_YNQ"                                                
+(	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_PERS_YNQN1" NOT NULL      
+ENABLE,                                                                         
+"PROP_PERSON_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_PERS_YNQN2" NOT NULL     
+ENABLE,                                                                         
+"QUESTION_ID" VARCHAR2(4) CONSTRAINT "EPS_PROP_PERS_YNQN3" NOT NULL ENABLE,     
+"ANSWER" CHAR(1),                                                               
+"UPDATE_TIMESTAMP" DATE CONSTRAINT "EPS_PROP_PERS_YNQN5" NOT NULL ENABLE,       
+"UPDATE_USER" VARCHAR2(8) CONSTRAINT "EPS_PROP_PERS_YNQN6" NOT NULL ENABLE,     
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "EPS_PROP_PERS_YNQN7" NOT NULL       
+ENABLE,                                                                         
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "EPS_PROP_PERS_YNQN8" NOT   
+NULL ENABLE,                                                                    
+CONSTRAINT "PK_EPS_PROP_PERS_YNQ_KRA" PRIMARY KEY ("PROPOSAL_NUMBER",           
+"PROP_PERSON_NUMBER", "QUESTION_ID") ENABLE                                     
+) ;
+                                                                            
+                                                                                
+CREATE TABLE "EPS_PROP_YNQ"                                                     
+(	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_YNQN1" NOT NULL ENABLE,   
+"QUESTION_ID" VARCHAR2(4) CONSTRAINT "EPS_PROP_YNQN2" NOT NULL ENABLE,          
+"ANSWER" CHAR(1),                                                               
+"EXPLANATION" LONG,                                                             
+"REVIEW_DATE" DATE,                                                             
+"UPDATE_TIMESTAMP" DATE CONSTRAINT "EPS_PROP_YNQN4" NOT NULL ENABLE,            
+"UPDATE_USER" VARCHAR2(8) CONSTRAINT "EPS_PROP_YNQN5" NOT NULL ENABLE,          
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "EPS_PROP_YNQN6" NOT NULL ENABLE,    
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "EPS_PROP_YNQN7" NOT NULL   
+ENABLE,                                                                         
+CONSTRAINT "PK_EPS_PROP_YNQ_KRA" PRIMARY KEY ("PROPOSAL_NUMBER", "QUESTION_ID") 
+ENABLE                                                                          
+) ;                                                                             
+                                                                                
                                                                                 
 CREATE TABLE "EPS_PROP_PERSON_BIO"                                              
 (	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_PERSON_BION1" NOT NULL    

) ;
                                                                            
                                                                                

"RTE_NODE_INSTN_ID") ENABLE
   ) ;
                                             
                                                                                
CREATE TABLE "EN_MSG_QUE_T"                                                     
(	"MESSAGE_QUE_ID" NUMBER(14,0) NOT NULL ENABLE,                                
