    ) ;
                                           
                                                                                 
-CREATE TABLE "EPS_PROP_SPECIAL_REVIEW"                                          
-(	"PROPOSAL_NUMBER" NUMBER(12,0) CONSTRAINT "EPS_PROP_SPECIAL_REVIEWN1" NOT NULL
-ENABLE,                                                                         
-"SPECIAL_REVIEW_NUMBER" NUMBER(3,0) CONSTRAINT "EPS_PROP_SPECIAL_REVIEWN2" NOT  
-NULL ENABLE,                                                                    
-"SPECIAL_REVIEW_CODE" VARCHAR2(3) CONSTRAINT "EPS_PROP_SPECIAL_REVIEWN3" NOT    
-NULL ENABLE,                                                                    
-"APPROVAL_TYPE_CODE" VARCHAR2(3) CONSTRAINT "EPS_PROP_SPECIAL_REVIEWN4" NOT NULL
-ENABLE,                                                                         
-"PROTOCOL_NUMBER" VARCHAR2(20),                                                 
-"APPLICATION_DATE" DATE,                                                        
-"APPROVAL_DATE" DATE,                                                           
-"COMMENTS" CLOB,                                                                
-"UPDATE_USER" VARCHAR2(8) CONSTRAINT "EPS_PROP_SPECIAL_REVIEWN5" NOT NULL       
-ENABLE,                                                                         
-"UPDATE_TIMESTAMP" DATE CONSTRAINT "EPS_PROP_SPECIAL_REVIEWN6" NOT NULL ENABLE, 
-"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "EPS_PROP_SPECIAL_REVIEWN7" NOT NULL 
-ENABLE,                                                                         
-"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "EPS_PROP_SPECIAL_REVIEWN8" 
-NOT NULL ENABLE,                                                                
-CONSTRAINT "PK_EPS_PROP_SPECIAL_REVIEW_KRA" PRIMARY KEY ("PROPOSAL_NUMBER",     
-"SPECIAL_REVIEW_NUMBER") ENABLE
-   ) ;
-                                         
-                                                                                
 CREATE TABLE "ABSTRACT_TYPE"                                                    
 (	"ABSTRACT_TYPE_CODE" VARCHAR2(3) CONSTRAINT "ABSTRACT_TYPE_N1" NOT NULL       
 ENABLE,                                                                         

CONSTRAINT "PK_UNIT_HIERARCHY_KRA" PRIMARY KEY ("UNIT_NUMBER") ENABLE           
) ;                                                                             
                                                                                
                                                                                
CREATE TABLE "SPONSOR_TYPE"                                                     
(	"SPONSOR_TYPE_CODE" VARCHAR2(3) CONSTRAINT "SPONSOR_TYPE_N1" NOT NULL ENABLE, 

ENABLE                                                                          
) ;
                                                                            
                                                                                
CREATE TABLE "DEGREE_TYPE"                                                      
(	"DEGREE_CODE" VARCHAR2(6) CONSTRAINT "DEGREE_TYPE_N1" NOT NULL ENABLE,        
