+CREATE TABLE "NARRATIVE_ATTACHMENT"                                             
+(	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "NARRATIVE_ATTACHMENTN1" NOT NULL   
+ENABLE,                                                                         
+"MODULE_NUMBER" NUMBER(4,0) CONSTRAINT "NARRATIVE_ATTACHMENTN2" NOT NULL ENABLE,
+"NARRATIVE_DATA" BLOB,                                                          
+"FILE_NAME" VARCHAR2(150),                                                      
+"CONTENT_TYPE" VARCHAR2(50),                                                    
+"UPDATE_USER" VARCHAR2(8) CONSTRAINT "NARRATIVE_ATTACHMENTN3" NOT NULL ENABLE,  
+"UPDATE_TIMESTAMP" DATE CONSTRAINT "NARRATIVE_ATTACHMENTN4" NOT NULL ENABLE,    
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "NARRATIVE_ATTACHMENTN5" NOT NULL    
+ENABLE,                                                                         
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "NARRATIVE_ATTACHMENTN6" NOT
+NULL ENABLE,                                                                    
+CONSTRAINT "PK_NARRATIVE_ATTACHMENT_KRA" PRIMARY KEY ("PROPOSAL_NUMBER",        
+"MODULE_NUMBER") ENABLE                                                         
+) ;                                                                             
+                                                                                
+                                                                                
+CREATE TABLE "EPS_PROP_ABSTRACT"                                                
+(	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_ABSTRACTN1" NOT NULL      
+ENABLE,                                                                         
+"ABSTRACT_TYPE_CODE" VARCHAR2(3) CONSTRAINT "EPS_PROP_ABSTRACTN2" NOT NULL      
+ENABLE,                                                                         
+"ABSTRACT_DETAILS" CLOB CONSTRAINT "EPS_PROP_ABSTRACTN3" NOT NULL ENABLE,       
+"UPDATE_TIMESTAMP" DATE CONSTRAINT "EPS_PROP_ABSTRACTN4" NOT NULL ENABLE,       
+"UPDATE_USER" VARCHAR2(8) CONSTRAINT "EPS_PROP_ABSTRACTN5" NOT NULL ENABLE,     
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "EPS_PROP_ABSTRACTN6" NOT NULL       
+ENABLE,                                                                         
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "EPS_PROP_ABSTRACTN7" NOT   
+NULL ENABLE,                                                                    
+CONSTRAINT "PK_EPS_PROP_ABSTRACT_KRA" PRIMARY KEY ("PROPOSAL_NUMBER",           
+"ABSTRACT_TYPE_CODE") ENABLE                                                    
+) ;                                                                             
+                                                                                
+                                                                                
+CREATE TABLE "FP_MAINTENANCE_DOCUMENT_T"                                        
+(	"FDOC_NBR" VARCHAR2(14) CONSTRAINT "FP_MAINTENANCE_DOCUMENT_TN1" NOT NULL     
+ENABLE,                                                                         
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT                             
+"FP_MAINTENANCE_DOCUMENT_TN2" NOT NULL ENABLE,                                  
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "FP_MAINTENANCE_DOCUMENT_TN3" NOT    
+NULL ENABLE,                                                                    
+"DOCUMENT_CONTENTS" CLOB,                                                       
+CONSTRAINT "FP_MAINTENANCE_DOCUMENT_TP1" PRIMARY KEY ("FDOC_NBR") ENABLE,       
+CONSTRAINT "FP_MAINTENANCE_DOCUMENT_TC0" UNIQUE ("OBJ_ID") ENABLE
+   ) ;
+       
+                                                                                
+CREATE TABLE "EN_BAM_PARAM_T"                                                   
+(	"BAM_PARAM_ID" NUMBER(14,0) NOT NULL ENABLE,                                  
+"BAM_ID" NUMBER(14,0) NOT NULL ENABLE,                                          
+"PARAM" CLOB NOT NULL ENABLE,                                                   
+CONSTRAINT "EN_BAM_PARAM_T_PK" PRIMARY KEY ("BAM_PARAM_ID") ENABLE              
+ ) ;
+                                                                           
+                                                                                
+CREATE TABLE "EN_BAM_T"                                                         
+(	"BAM_ID" NUMBER(14,0) NOT NULL ENABLE,                                        
+"SERVICE_NM" VARCHAR2(255) NOT NULL ENABLE,                                     
+"SERVICE_URL" VARCHAR2(500) NOT NULL ENABLE,                                    
+"METHOD_NM" VARCHAR2(2000) NOT NULL ENABLE,                                     
+"THREAD_NM" VARCHAR2(500) NOT NULL ENABLE,                                      
+"CALL_DT" DATE NOT NULL ENABLE,                                                 
+"TARGET_TO_STRING" VARCHAR2(2000) NOT NULL ENABLE,                              
+"SRVR_IND_IND" NUMBER(1,0) NOT NULL ENABLE,                                     
+"EXCEPTION_TO_STRING" VARCHAR2(2000),                                           
+"EXCEPTION_MSG" CLOB,                                                           
+CONSTRAINT "EN_BAM_T_PK" PRIMARY KEY ("BAM_ID") ENABLE
+   ) ;
+                  
+                                                                                
+CREATE TABLE "EN_DOC_HDR_CNTNT_T"                                               
+(	"DOC_HDR_ID" NUMBER(14,0) NOT NULL ENABLE,                                    
+"DOC_CNTNT_TXT" CLOB,                                                           
+CONSTRAINT "EN_DOC_HDR_T_CNTNT_PK" PRIMARY KEY ("DOC_HDR_ID") ENABLE
+   ) ;
+    
+                                                                                
+CREATE TABLE "EN_DOC_TYP_T"                                                     
+(	"DOC_TYP_ID" NUMBER(19,0) NOT NULL ENABLE,                                    
+"DOC_TYP_PARNT_ID" NUMBER(19,0),                                                
+"DOC_TYP_NM" VARCHAR2(255),                                                     
+"DOC_TYP_VER_NBR" NUMBER(10,0) DEFAULT 0,                                       
+"DOC_TYP_ACTV_IND" NUMBER(1,0),                                                 
+"DOC_TYP_CUR_IND" NUMBER(1,0),                                                  
+"DOC_TYP_LBL_TXT" VARCHAR2(255),                                                
+"DOC_TYP_PREV_VER" NUMBER(19,0),                                                
+"DOC_HDR_ID" NUMBER(14,0),                                                      
+"DOC_TYP_DESC" VARCHAR2(255),                                                   
+"DOC_TYP_HDLR_URL_ADDR" VARCHAR2(255),                                          
+"DOC_TYP_POST_PRCSR_NM" VARCHAR2(255),                                          
+"DOC_TYP_JNDI_URL_ADDR" VARCHAR2(255),                                          
+"WRKGRP_ID" NUMBER(14,0),                                                       
+"BLNKT_APPR_WRKGRP_ID" NUMBER(14,0),                                            
+"BLNKT_APPR_PLCY" VARCHAR2(10),                                                 
+"ADV_DOC_SRCH_URL_ADDR" VARCHAR2(255),                                          
+"CSTM_ACTN_LIST_ATTRIB_CLS_NM" VARCHAR2(255),                                   
+"CSTM_ACTN_EMAIL_ATTRIB_CLS_NM" VARCHAR2(255),                                  
+"CSTM_DOC_NTE_ATTRIB_CLS_NM" VARCHAR2(255),                                     
+"DOC_TYP_RTE_VER_NBR" VARCHAR2(2) DEFAULT '1' NOT NULL ENABLE,                  
+"DOC_TYP_NOTIFY_ADDR" VARCHAR2(255),                                            
+"MESSAGE_ENTITY_NM" VARCHAR2(10),                                               
+"DOC_TYP_EMAIL_XSL" VARCHAR2(255),                                              
+"DOC_TYP_SECURITY_XML" CLOB,                                                    
+"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
+CONSTRAINT "EN_DOC_TYP_T_PK" PRIMARY KEY ("DOC_TYP_ID") ENABLE
+   ) ;
+          
+                                                                                
+CREATE TABLE "EN_EDOCLT_DEF_T"                                                  
+(	"EDOCLT_DEF_ID" NUMBER(19,0) NOT NULL ENABLE,                                 
+"EDOCLT_DEF_NM" VARCHAR2(200) NOT NULL ENABLE,                                  
+"EDOCLT_DEF_XML" CLOB NOT NULL ENABLE,                                          
+"EDOCLT_DEF_ACTV_IND" NUMBER(1,0) NOT NULL ENABLE,                              
+"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
+CONSTRAINT "EN_EDOCLT_DEF_T" PRIMARY KEY ("EDOCLT_DEF_ID") ENABLE
+   ) ;
+       
+                                                                                
+CREATE TABLE "EN_EDOCLT_STYLE_T"                                                
+(	"EDOCLT_STYLE_ID" NUMBER(19,0) NOT NULL ENABLE,                               
+"EDOCLT_STYLE_NM" VARCHAR2(200) NOT NULL ENABLE,                                
+"EDOCLT_STYLE_XML" CLOB NOT NULL ENABLE,                                        
+"EDOCLT_STYLE_ACTV_IND" NUMBER(1,0) NOT NULL ENABLE,                            
+"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
+CONSTRAINT "EN_EDOCLT_STYLE_T" PRIMARY KEY ("EDOCLT_STYLE_ID") ENABLE
+   ) ;
+   
+                                                                                
+CREATE TABLE "EN_MESSAGE_QUE_T"                                                 
+(	"MESSAGE_QUE_ID" NUMBER(14,0) NOT NULL ENABLE,                                
+"MESSAGE_QUE_DT" DATE NOT NULL ENABLE,                                          
+"MESSAGE_EXP_DT" DATE,                                                          
+"MESSAGE_QUE_PRIO_NBR" NUMBER(8,0) NOT NULL ENABLE,                             
+"MESSAGE_QUE_STAT_CD" CHAR(1) NOT NULL ENABLE,                                  
+"MESSAGE_QUE_RTRY_CNT" NUMBER(8,0) NOT NULL ENABLE,                             
+"MESSAGE_QUE_IP_NBR" VARCHAR2(2000) NOT NULL ENABLE,                            
+"MESSAGE_PAYLOAD" CLOB NOT NULL ENABLE,                                         
+"MESSAGE_SERVICE_NM" VARCHAR2(255),                                             
+"MESSAGE_ENTITY_NM" VARCHAR2(10) NOT NULL ENABLE,                               
+"SERVICE_METHOD_NM" VARCHAR2(2000),                                             
+"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
+CONSTRAINT "EN_MESSAGE_QUE_T_PK" PRIMARY KEY ("MESSAGE_QUE_ID") ENABLE
+   ) ;
+  
+                                                                                
+CREATE TABLE "EN_MSG_PAYLOAD_T"                                                 
+(	"MESSAGE_QUE_ID" NUMBER(14,0) NOT NULL ENABLE,                                
+"MESSAGE_PAYLOAD" CLOB NOT NULL ENABLE,                                         
+CONSTRAINT "EN_MSG_PAYLOAD_T" PRIMARY KEY ("MESSAGE_QUE_ID") ENABLE
+   ) ;
+     
+                                                                                
+CREATE TABLE "EN_RULE_ATTRIB_T"                                                 
+(	"RULE_ATTRIB_ID" NUMBER(19,0) NOT NULL ENABLE,                                
+"RULE_ATTRIB_NM" VARCHAR2(255) NOT NULL ENABLE,                                 
+"RULE_ATTRIB_LBL_TXT" VARCHAR2(2000) NOT NULL ENABLE,                           
+"RULE_ATTRIB_TYP" VARCHAR2(2000) NOT NULL ENABLE,                               
+"RULE_ATTRIB_DESC" VARCHAR2(2000),                                              
+"RULE_ATTRIB_CLS_NM" VARCHAR2(2000),                                            
+"RULE_ATTRIB_XML_RTE_TXT" CLOB,                                                 
+"DB_LOCK_VER_NBR" NUMBER(8,0) DEFAULT 0,                                        
+"MESSAGE_ENTITY_NM" VARCHAR2(10),                                               
+CONSTRAINT "EN_RULE_ATTRIB_PK" PRIMARY KEY ("RULE_ATTRIB_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 "KR_QRTZ_BLOB_TRIGGERS"                                            
+(	"TRIGGER_NAME" VARCHAR2(80) NOT NULL ENABLE,                                  
+"TRIGGER_GROUP" VARCHAR2(80) NOT NULL ENABLE,                                   
+"BLOB_DATA" BLOB,                                                               
+PRIMARY KEY ("TRIGGER_NAME", "TRIGGER_GROUP") ENABLE                            
+) ;                                                                             
+                                                                                
+                                                                                
+CREATE TABLE "KR_QRTZ_CALENDARS"                                                
+(	"CALENDAR_NAME" VARCHAR2(80) NOT NULL ENABLE,                                 
+"CALENDAR" BLOB NOT NULL ENABLE,                                                
+PRIMARY KEY ("CALENDAR_NAME") ENABLE
+   ) ;
+                                    
+                                                                                
+CREATE TABLE "KR_QRTZ_JOB_DETAILS"                                              
+(	"JOB_NAME" VARCHAR2(80) NOT NULL ENABLE,                                      
+"JOB_GROUP" VARCHAR2(80) NOT NULL ENABLE,                                       
+"DESCRIPTION" VARCHAR2(120),                                                    
+"JOB_CLASS_NAME" VARCHAR2(128) NOT NULL ENABLE,                                 
+"IS_DURABLE" VARCHAR2(1) NOT NULL ENABLE,                                       
+"IS_VOLATILE" VARCHAR2(1) NOT NULL ENABLE,                                      
+"IS_STATEFUL" VARCHAR2(1) NOT NULL ENABLE,                                      
+"REQUESTS_RECOVERY" VARCHAR2(1) NOT NULL ENABLE,                                
+"JOB_DATA" BLOB,                                                                
+PRIMARY KEY ("JOB_NAME", "JOB_GROUP") ENABLE                                    
+   ) ;
+                                                                         
+                                                                                
+CREATE TABLE "KR_QRTZ_TRIGGERS"                                                 
+(	"TRIGGER_NAME" VARCHAR2(80) NOT NULL ENABLE,                                  
+"TRIGGER_GROUP" VARCHAR2(80) NOT NULL ENABLE,                                   
+"JOB_NAME" VARCHAR2(80) NOT NULL ENABLE,                                        
+"JOB_GROUP" VARCHAR2(80) NOT NULL ENABLE,                                       
+"IS_VOLATILE" VARCHAR2(1) NOT NULL ENABLE,                                      
+"DESCRIPTION" VARCHAR2(120),                                                    
+"NEXT_FIRE_TIME" NUMBER(13,0),                                                  
+"PREV_FIRE_TIME" NUMBER(13,0),                                                  
+"PRIORITY" NUMBER(13,0),                                                        
+"TRIGGER_STATE" VARCHAR2(16) NOT NULL ENABLE,                                   
+"TRIGGER_TYPE" VARCHAR2(8) NOT NULL ENABLE,                                     
+"START_TIME" NUMBER(13,0) NOT NULL ENABLE,                                      
+"END_TIME" NUMBER(13,0),                                                        
+"CALENDAR_NAME" VARCHAR2(80),                                                   
+"MISFIRE_INSTR" NUMBER(2,0),                                                    
+"JOB_DATA" BLOB,                                                                
+PRIMARY KEY ("TRIGGER_NAME", "TRIGGER_GROUP") ENABLE
+   ) ;
+                    
+                                                                                
+CREATE TABLE "NOTIFICATIONS"                                                    
+(	"ID" NUMBER(8,0) NOT NULL ENABLE,                                             
+"DELIVERY_TYPE" VARCHAR2(3) NOT NULL ENABLE,                                    
+"CREATED_DATETIME" TIMESTAMP (6) NOT NULL ENABLE,                               
+"SEND_DATETIME" TIMESTAMP (6),                                                  
+"AUTO_REMOVE_DATETIME" TIMESTAMP (6),                                           
+"PRIORITY_ID" NUMBER(8,0) NOT NULL ENABLE,                                      
+"TITLE" VARCHAR2(255),                                                          
+"CONTENT" CLOB NOT NULL ENABLE,                                                 
+"CONTENT_TYPE_ID" NUMBER(8,0) NOT NULL ENABLE,                                  
+"NOTIFICATION_CHANNEL_ID" NUMBER(8,0) NOT NULL ENABLE,                          
+"PRODUCER_ID" NUMBER(8,0) NOT NULL ENABLE,                                      
+"PROCESSING_FLAG" VARCHAR2(15) NOT NULL ENABLE,                                 
+"LOCKED_DATE" TIMESTAMP (6),                                                    
+"DB_LOCK_VER_NBR" NUMBER(*,0) DEFAULT 0 NOT NULL ENABLE,                        
+CONSTRAINT "NOTIFICATIONS_PK" PRIMARY KEY ("ID") ENABLE
+   ) ;
+                 
+                                                                                
+CREATE TABLE "NOTIFICATION_CONTENT_TYPES"                                       
+(	"ID" NUMBER(8,0) NOT NULL ENABLE,                                             
+"NAME" VARCHAR2(500) NOT NULL ENABLE,                                           
+"DESCRIPTION" VARCHAR2(1000) NOT NULL ENABLE,                                   
+"NAMESPACE" VARCHAR2(1000) NOT NULL ENABLE,                                     
+"XSD" CLOB NOT NULL ENABLE,                                                     
+"XSL" CLOB NOT NULL ENABLE,                                                     
+CONSTRAINT "NOTIFICATION_CONTENT_TYPE_UK1" UNIQUE ("NAME") ENABLE,              
+CONSTRAINT "NOTIFICATION_CONTENT_TYPE_PK" PRIMARY KEY ("ID") ENABLE
+   ) ;
+     
+                                                                                
 CREATE TABLE "FS_LOOKUP_RESULTS_MT"                                             
 (	"LOOKUP_RESULT_SEQUENCE_NBR" VARCHAR2(14) CONSTRAINT "FS_LOOKUP_RESULTS_MTN1" 
 NOT NULL ENABLE,                                                                

   ) ;
                                                                  
                                                                                
CREATE TABLE "KR_QRTZ_SCHEDULER_STATE"                                          
(	"INSTANCE_NAME" VARCHAR2(80) NOT NULL ENABLE,                                 
"LAST_CHECKIN_TIME" NUMBER(13,0) NOT NULL ENABLE,                               
"CHECKIN_INTERVAL" NUMBER(13,0) NOT NULL ENABLE,                                
PRIMARY KEY ("INSTANCE_NAME") ENABLE                                            
   ) ;
                                                                         
                                                                                
CREATE TABLE "KR_QRTZ_SIMPLE_TRIGGERS"                                          
(	"TRIGGER_NAME" VARCHAR2(80) NOT NULL ENABLE,                                  
"TRIGGER_GROUP" VARCHAR2(80) NOT NULL ENABLE,                                   
"REPEAT_COUNT" NUMBER(7,0) NOT NULL ENABLE,                                     
"REPEAT_INTERVAL" NUMBER(12,0) NOT NULL ENABLE,                                 
"TIMES_TRIGGERED" NUMBER(7,0) NOT NULL ENABLE,                                  
PRIMARY KEY ("TRIGGER_NAME", "TRIGGER_GROUP") ENABLE
   ) ;
                    
                                                                                
CREATE TABLE "KR_QRTZ_TRIGGERS"                                                 
(	"TRIGGER_NAME" VARCHAR2(80) NOT NULL ENABLE,                                  
"TRIGGER_GROUP" VARCHAR2(80) NOT NULL ENABLE,                                   
"JOB_NAME" VARCHAR2(80) NOT NULL ENABLE,                                        
"JOB_GROUP" VARCHAR2(80) NOT NULL ENABLE,                                       
"IS_VOLATILE" VARCHAR2(1) NOT NULL ENABLE,                                      
"DESCRIPTION" VARCHAR2(120),                                                    
"NEXT_FIRE_TIME" NUMBER(13,0),                                                  
"PREV_FIRE_TIME" NUMBER(13,0),                                                  
"PRIORITY" NUMBER(13,0),                                                        
"TRIGGER_STATE" VARCHAR2(16) NOT NULL ENABLE,                                   
"TRIGGER_TYPE" VARCHAR2(8) NOT NULL ENABLE,                                     
"START_TIME" NUMBER(13,0) NOT NULL ENABLE,                                      
"END_TIME" NUMBER(13,0),                                                        
"CALENDAR_NAME" VARCHAR2(80),                                                   
"MISFIRE_INSTR" NUMBER(2,0),                                                    
"JOB_DATA" BLOB,                                                                
PRIMARY KEY ("TRIGGER_NAME", "TRIGGER_GROUP") ENABLE
   ) ;
                    
                                                                                
CREATE TABLE "KR_QRTZ_TRIGGER_LISTENERS"                                        
(	"TRIGGER_NAME" VARCHAR2(80) NOT NULL ENABLE,                                  
"TRIGGER_GROUP" VARCHAR2(80) NOT NULL ENABLE,                                   
"TRIGGER_LISTENER" VARCHAR2(80) NOT NULL ENABLE,                                
PRIMARY KEY ("TRIGGER_NAME", "TRIGGER_GROUP", "TRIGGER_LISTENER") ENABLE        
) ;                                                                             
                                                                                
                                                                                
CREATE TABLE "KIM_ATTRIBUTE_TYPES_T"                                            
(	"ID" NUMBER(8,0) NOT NULL ENABLE,                                             
"NAME" VARCHAR2(500) NOT NULL ENABLE,                                           
"DESCRIPTION" VARCHAR2(4000),                                                   
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL ENABLE,                       
"VER_NBR" NUMBER(8,0) DEFAULT 1 NOT NULL ENABLE,                                
CONSTRAINT "KIM_ATTRIBUTE_TYPES_PK" PRIMARY KEY ("ID") ENABLE,                  
CONSTRAINT "KIM_ATTRIBUTE_TYPES_UK1" UNIQUE ("NAME") ENABLE                     
 ) ;
                                                                           
                                                                                
CREATE TABLE "KIM_GROUPS_GROUPS_T"                                              
(	"PARENT_GROUP_ID" NUMBER(8,0) NOT NULL ENABLE,                                
"MEMBER_GROUP_ID" NUMBER(8,0) NOT NULL ENABLE,                                  
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL ENABLE,                       
"VER_NBR" NUMBER(8,0) DEFAULT 1 NOT NULL ENABLE,                                
CONSTRAINT "KIM_GROUPS_GROUPS_PK" PRIMARY KEY ("PARENT_GROUP_ID",               
"MEMBER_GROUP_ID") ENABLE                                                       
) ;                                                                             
                                                                                
                                                                                
CREATE TABLE "KIM_GROUPS_PERSONS_T"                                             
(	"GROUP_ID" NUMBER(8,0) NOT NULL ENABLE,                                       
"PERSON_ID" NUMBER(8,0) NOT NULL ENABLE,                                        
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL ENABLE,                       
"VER_NBR" NUMBER(8,0) DEFAULT 1 NOT NULL ENABLE,                                
CONSTRAINT "KIM_GROUPS_PERSONS_PK" PRIMARY KEY ("GROUP_ID", "PERSON_ID") ENABLE 
) ;                                                                             
                                                                                
                                                                                
CREATE TABLE "KIM_GROUPS_T"                                                     
(	"ID" NUMBER(8,0) NOT NULL ENABLE,                                             
"NAME" VARCHAR2(500) NOT NULL ENABLE,                                           
"DESCRIPTION" VARCHAR2(4000),                                                   
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL ENABLE,                       
"VER_NBR" NUMBER(8,0) DEFAULT 1 NOT NULL ENABLE,                                
CONSTRAINT "KIM_GROUPS_PK" PRIMARY KEY ("ID") ENABLE,                           
CONSTRAINT "KIM_GROUPS_UK1" UNIQUE ("NAME") ENABLE                              
) ;                                                                             
                                                                                
                                                                                
CREATE TABLE "KIM_GROUP_ATTRIBUTES_T"                                           
(	"ID" NUMBER(8,0) NOT NULL ENABLE,                                             
"GROUP_ID" NUMBER(8,0) NOT NULL ENABLE,                                         
"ATTRIBUTE_NAME" VARCHAR2(500) NOT NULL ENABLE,                                 
"ATTRIBUTE_TYPE_ID" NUMBER(8,0) NOT NULL ENABLE,                                
"ATTRIBUTE_VALUES" VARCHAR2(4000),                                              
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL ENABLE,                       
"VER_NBR" NUMBER(8,0) DEFAULT 1 NOT NULL ENABLE,                                
CONSTRAINT "KIM_GROUP_ATTRIBUTES_PK" PRIMARY KEY ("ID") ENABLE,                 
CONSTRAINT "KIM_GROUP_ATTRIBUTES_UK1" UNIQUE ("GROUP_ID", "ATTRIBUTE_NAME")     
ENABLE                                                                          
) ;                                                                             
                                                                                
                                                                                
CREATE TABLE "KIM_NAMESPACES_T"                                                 
(	"ID" NUMBER(8,0) NOT NULL ENABLE,                                             
"NAME" VARCHAR2(500) NOT NULL ENABLE,                                           
"DESCRIPTION" VARCHAR2(4000),                                                   
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL ENABLE,                       
"VER_NBR" NUMBER(8,0) DEFAULT 1 NOT NULL ENABLE,                                
CONSTRAINT "KIM_NAMESPACE_PK" PRIMARY KEY ("ID") ENABLE,                        
CONSTRAINT "KIM_NAMESPACES_T_UK1" UNIQUE ("NAME") ENABLE                        
) ;                                                                             
                                                                                
                                                                                
CREATE TABLE "KIM_NAMESPACE_DFLT_ATTRIBS_T"                                     
(	"ID" NUMBER(8,0) NOT NULL ENABLE,                                             
"NAMESPACE_ID" NUMBER(8,0) NOT NULL ENABLE,                                     
"ATTRIBUTE_NAME" VARCHAR2(500) NOT NULL ENABLE,                                 
"ATTRIBUTE_TYPE_ID" NUMBER(8,0) NOT NULL ENABLE,                                
"DESCRIPTION" VARCHAR2(4000),                                                   
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL ENABLE,                       
"VER_NBR" NUMBER(8,0) DEFAULT 1 NOT NULL ENABLE,                                
CONSTRAINT "KIM_NMSPCE_DFLT_ATTR_PK" PRIMARY KEY ("ID") ENABLE,                 
CONSTRAINT "KIM_NMSPCE_DFLT_ATTR_UK1" UNIQUE ("NAMESPACE_ID", "ATTRIBUTE_NAME") 
ENABLE                                                                          
) ;
                                                                            
                                                                                
CREATE TABLE "DEGREE_TYPE"                                                      
(	"DEGREE_CODE" VARCHAR2(6) CONSTRAINT "DEGREE_TYPE_N1" NOT NULL ENABLE,        
"DESCRIPTION" VARCHAR2(200),                                                    
"UPDATE_TIMESTAMP" DATE NOT NULL ENABLE,                                        
"UPDATE_USER" VARCHAR2(8) NOT NULL ENABLE,                                      
"VER_NBR" NUMBER(8,0) DEFAULT 1 NOT NULL ENABLE,                                
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL ENABLE,                       
CONSTRAINT "DEGREE_TYPE_N2" PRIMARY KEY ("DEGREE_CODE") ENABLE,                 
CONSTRAINT "DEGREE_TYPE_C0" UNIQUE ("OBJ_ID") ENABLE                            
   ) ;
                                                                         
                                                                                
CREATE TABLE "EPS_PROP_PERSON_ROLE"                                             
(	"PROP_PERSON_ROLE_ID" VARCHAR2(12) CONSTRAINT "EPS_PROP_PERSON_ROLE_N1" NOT   
NULL ENABLE,                                                                    
"DESCRIPTION" VARCHAR2(25) NOT NULL ENABLE,                                     
"UPDATE_TIMESTAMP" DATE NOT NULL ENABLE,                                        
"UPDATE_USER" VARCHAR2(8) NOT NULL ENABLE,                                      
"VER_NBR" NUMBER(8,0) DEFAULT 1 NOT NULL ENABLE,                                
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() NOT NULL ENABLE,                       
"CERTIFICATION_REQUIRED" CHAR(1) DEFAULT 'Y' CONSTRAINT                         
"EPS_PROP_PERSON_ROLE_N3" NOT NULL ENABLE,                                      
CONSTRAINT "EPS_PROP_PERSON_ROLE_N2" PRIMARY KEY ("PROP_PERSON_ROLE_ID") ENABLE,
CONSTRAINT "EPS_PROP_PERSON_ROLE_C0" UNIQUE ("OBJ_ID") ENABLE
   ) ;
           
                                                                                
CREATE TABLE "NARRATIVE"                                                        
(	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "NARRATIVEN1" NOT NULL ENABLE,      
"MODULE_NUMBER" NUMBER(4,0) CONSTRAINT "NARRATIVEN2" NOT NULL ENABLE,           
"MODULE_SEQUENCE_NUMBER" NUMBER(4,0) CONSTRAINT "NARRATIVEN3" NOT NULL ENABLE,  
"MODULE_TITLE" VARCHAR2(150),                                                   
"MODULE_STATUS_CODE" VARCHAR2(3) CONSTRAINT "NARRATIVEN4" NOT NULL ENABLE,      
"CONTACT_NAME" VARCHAR2(30),                                                    
"PHONE_NUMBER" VARCHAR2(20),                                                    
"EMAIL_ADDRESS" VARCHAR2(60),                                                   
"COMMENTS" VARCHAR2(300),                                                       
"FILE_NAME" VARCHAR2(150),                                                      
"UPDATE_USER" VARCHAR2(8) CONSTRAINT "NARRATIVEN5" NOT NULL ENABLE,             
"UPDATE_TIMESTAMP" DATE CONSTRAINT "NARRATIVEN6" NOT NULL ENABLE,               
"NARRATIVE_TYPE_CODE" VARCHAR2(3) CONSTRAINT "NARRATIVEN9" NOT NULL ENABLE,     
"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "NARRATIVEN7" NOT NULL ENABLE,       
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "NARRATIVEN8" NOT NULL      
ENABLE,                                                                         
CONSTRAINT "PK_NARRATIVE_KRA" PRIMARY KEY ("PROPOSAL_NUMBER", "MODULE_NUMBER")  
ENABLE                                                                          
) ;
                                                                            
                                                                                
CREATE TABLE "NARRATIVE_STATUS"                                                 
(	"NARRATIVE_STATUS_CODE" VARCHAR2(3) CONSTRAINT "NARRATIVE_STATUSN1" NOT NULL  
ENABLE,                                                                         
"DESCRIPTION" VARCHAR2(20) CONSTRAINT "NARRATIVE_STATUSN2" NOT NULL ENABLE,     
"UPDATE_TIMESTAMP" DATE CONSTRAINT "NARRATIVE_STATUSN3" NOT NULL ENABLE,        
"UPDATE_USER" VARCHAR2(8) CONSTRAINT "NARRATIVE_STATUSN4" NOT NULL ENABLE,      
"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "NARRATIVE_STATUSN5" NOT NULL ENABLE,
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "NARRATIVE_STATUSN6" NOT    
NULL ENABLE,                                                                    
CONSTRAINT "PK_NARRATIVE_STATUS_KRA" PRIMARY KEY ("NARRATIVE_STATUS_CODE")      
ENABLE                                                                          
) ;                                                                             
                                                                                
                                                                                
CREATE TABLE "NARRATIVE_ATTACHMENT"                                             
(	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "NARRATIVE_ATTACHMENTN1" NOT NULL   
ENABLE,                                                                         
"MODULE_NUMBER" NUMBER(4,0) CONSTRAINT "NARRATIVE_ATTACHMENTN2" NOT NULL ENABLE,
"NARRATIVE_DATA" BLOB,                                                          
"FILE_NAME" VARCHAR2(150),                                                      
"CONTENT_TYPE" VARCHAR2(50),                                                    
"UPDATE_USER" VARCHAR2(8) CONSTRAINT "NARRATIVE_ATTACHMENTN3" NOT NULL ENABLE,  
"UPDATE_TIMESTAMP" DATE CONSTRAINT "NARRATIVE_ATTACHMENTN4" NOT NULL ENABLE,    
"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "NARRATIVE_ATTACHMENTN5" NOT NULL    
ENABLE,                                                                         
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "NARRATIVE_ATTACHMENTN6" NOT
NULL ENABLE,                                                                    
CONSTRAINT "PK_NARRATIVE_ATTACHMENT_KRA" PRIMARY KEY ("PROPOSAL_NUMBER",        
"MODULE_NUMBER") ENABLE                                                         
) ;                                                                             
                                                                                
                                                                                
CREATE TABLE "UNIT_HIERARCHY"                                                   
(	"UNIT_NUMBER" VARCHAR2(8) CONSTRAINT "UNIT_HIERARCHYN1" NOT NULL ENABLE,      
"PARENT_UNIT_NUMBER" VARCHAR2(8) CONSTRAINT "UNIT_HIERARCHYN2" NOT NULL ENABLE, 
"HAS_CHILDREN_FLAG" CHAR(1),                                                    
"UPDATE_TIMESTAMP" DATE CONSTRAINT "UNIT_HIERARCHYN3" NOT NULL ENABLE,          
"UPDATE_USER" VARCHAR2(8) CONSTRAINT "UNIT_HIERARCHYN4" NOT NULL ENABLE,        
"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "UNIT_HIERARCHYN5" NOT NULL ENABLE,  
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "UNIT_HIERARCHYN6" NOT NULL 
ENABLE,                                                                         
CONSTRAINT "PK_UNIT_HIERARCHY_KRA" PRIMARY KEY ("UNIT_NUMBER") ENABLE           
) ;                                                                             
                                                                                
                                                                                
CREATE TABLE "EN_OUT_BOX_ITM_T"                                                 
(	"ACTN_ITM_ID" NUMBER(14,0) NOT NULL ENABLE,                                   
"ACTN_ITM_PRSN_EN_ID" VARCHAR2(30) NOT NULL ENABLE,                             

ENABLE                                                                          
) ;                                                                             
                                                                                
                                                                                
CREATE TABLE "EN_RULE_ATTRIB_VLD_VAL_T"                                         
(	"RULE_ATTRIB_VLD_VAL_ID" NUMBER(19,0) NOT NULL ENABLE,                        
