    ) ;
                                                                   
                                                                                 
-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,                             

"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 "EPS_PROP_PERSON_UNITS_N5" PRIMARY KEY ("PROPOSAL_NUMBER",           
"PROP_PERSON_NUMBER", "UNIT_NUMBER") ENABLE,                                    
CONSTRAINT "EPS_PROP_PERSON_UNITS_C0" UNIQUE ("OBJ_ID") ENABLE
   ) ;
          
                                                                                
CREATE TABLE "EPS_PROP_USER_ROLES"                                              
(	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_USER_ROLESN1" NOT NULL    

CONSTRAINT "EN_DLGN_RSP_PK" PRIMARY KEY ("DLGN_RULE_ID") ENABLE
   ) ;
         
                                                                                
CREATE TABLE "EN_DOC_HDR_EXT_DT_T"                                              
(	"DOC_HDR_EXT_ID" NUMBER(19,0) NOT NULL ENABLE,                                
