    ) ;
           
                                                                                 
-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" NUMBER(3,0) 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 "EPS_PROP_UNIT_CREDIT_SPLIT"                                       
-(	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_UNIT_CREDIT_SPLIT_N1" NOT 
-NULL ENABLE,                                                                    
-"INV_CREDIT_TYPE_CODE" NUMBER(3,0) 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 "EPS_PROP_USER_ROLES"                                              
 (	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_USER_ROLESN1" NOT NULL    
 ENABLE,                                                                         

ENABLE                                                                          
) ;
                                                                            
                                                                               
                                
CREATE TABLE EPS_PROP_PERSON_BIO 
   (	"PROPOSAL_NUMBER" NUMBER(12,0) constraint EPS_PROP_PERSON_BION1 NOT NULL ENABLE, 
	"PROP_PERSON_NUMBER" NUMBER(12,0) constraint EPS_PROP_PERSON_BION2 NOT NULL ENABLE, 
	"BIO_NUMBER" NUMBER(3,0) constraint EPS_PROP_PERSON_BION3 NOT NULL ENABLE, 
	"PERSON_ID" VARCHAR2(10), 
    "ROLODEX_ID"  NUMBER(6,0), 
	"DESCRIPTION" VARCHAR2(200), 
	"DOCUMENT_TYPE_CODE" VARCHAR2(3), 
	"FILE_NAME" VARCHAR2(150), 
	"UPDATE_TIMESTAMP" DATE constraint EPS_PROP_PERSON_BION5 NOT NULL ENABLE, 
	"UPDATE_USER" VARCHAR2(8) constraint EPS_PROP_PERSON_BION6 NOT NULL ENABLE, 
	 "VER_NBR" NUMBER(8,0) DEFAULT 1  constraint  EPS_PROP_PERSON_BION7  NOT NULL ENABLE,
	"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID()  constraint  EPS_PROP_PERSON_BION8  NOT NULL ENABLE,
	CONSTRAINT "PK_EPS_PROP_PERSON_BIO_KRA" PRIMARY KEY ("PROPOSAL_NUMBER", "PROP_PERSON_NUMBER","BIO_NUMBER") ENABLE
) ;
 
                                                                                
CREATE TABLE "EPS_PROP_PERSON_BIO_ATTACHMENT"                                   
(	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_PERSON_BIO_ATMTN1" NOT    
NULL ENABLE,                                                                    
"PERSON_ID" VARCHAR2(10) CONSTRAINT "EPS_PROP_PERSON_BIO_ATMTN2" NOT NULL       
ENABLE,                                                                         
"BIO_NUMBER" VARCHAR2(3) CONSTRAINT "EPS_PROP_PERSON_BIO_ATMTN3" NOT NULL       
ENABLE,                                                                         
"BIO_DATA" BLOB,                                                                
"FILE_NAME" VARCHAR2(150),                                                      
"CONTENT_TYPE" VARCHAR2(50),                                                    
"UPDATE_TIMESTAMP" DATE CONSTRAINT "EPS_PROP_PERSON_BIO_ATMTN4" NOT NULL ENABLE,
                                                                                
"UPDATE_USER" VARCHAR2(8) CONSTRAINT "EPS_PROP_PERSON_BIO_ATMTN5" NOT NULL      
ENABLE,                                                                         
"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "EPS_PROP_PERSON_BIO_ATMTN6" NOT NULL
ENABLE,                                                                         
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "EPS_PROP_PERSON_BIO_ATMTN7"
NOT NULL ENABLE,                                                                
CONSTRAINT "PK_EPS_PROP_PSN_BIO_ATMT_KRA" PRIMARY KEY ("PROPOSAL_NUMBER",       
"PERSON_ID", "BIO_NUMBER") ENABLE
   ) ;
                                       
                                                                                
CREATE TABLE "DEGREE_TYPE"                                                      
(	"DEGREE_CODE" VARCHAR2(6) CONSTRAINT "DEGREE_TYPE_N1" NOT NULL ENABLE,        

CONSTRAINT "DEADLINE_TYPE_C0" UNIQUE ("OBJ_ID") ENABLE
   ) ;
                  
                                                                                
CREATE TABLE "SCIENCE_KEYWORD"                                                  
(	"SCIENCE_KEYWORD_CODE" VARCHAR2(3) CONSTRAINT "SCIENCE_KEYWORD_N1" NOT NULL   
