+CREATE TABLE "FS_LOOKUP_RESULTS_MT"                                             
+(	"LOOKUP_RESULT_SEQUENCE_NBR" VARCHAR2(14) CONSTRAINT "FS_LOOKUP_RESULTS_MTN1" 
+NOT NULL ENABLE,                                                                
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "FS_LOOKUP_RESULTS_MTN2" NOT
+NULL ENABLE,                                                                    
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "FS_LOOKUP_RESULTS_MTN3" NOT NULL    
+ENABLE,                                                                         
+"PERSON_UNVL_ID" VARCHAR2(10) CONSTRAINT "FS_LOOKUP_RESULTS_MTN4" NOT NULL      
+ENABLE,                                                                         
+"LOOKUP_DATE" DATE CONSTRAINT "FS_LOOKUP_RESULTS_MTN5" NOT NULL ENABLE,         
+"SERIALIZED_LOOKUP_RESULTS" CLOB,                                               
+CONSTRAINT "FS_LOOKUP_RESULTS_MTP1" PRIMARY KEY ("LOOKUP_RESULT_SEQUENCE_NBR")  
+ENABLE,                                                                         
+CONSTRAINT "FS_LOOKUP_RESULTS_MTC0" UNIQUE ("OBJ_ID") ENABLE                    
+) ;                                                                             
+                                                                                
+                                                                                
+CREATE TABLE "FS_LOOKUP_SELECTIONS_MT"                                          
+(	"LOOKUP_RESULT_SEQUENCE_NBR" VARCHAR2(14) CONSTRAINT                          
+"FS_LOOKUP_SELECTIONS_MTN1" NOT NULL ENABLE,                                    
+"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "FS_LOOKUP_SELECTIONS_MTN2" 
+NOT NULL ENABLE,                                                                
+"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "FS_LOOKUP_SELECTIONS_MTN3" NOT NULL 
+ENABLE,                                                                         
+"PERSON_UNVL_ID" VARCHAR2(10) CONSTRAINT "FS_LOOKUP_SELECTIONS_MTN4" NOT NULL   
+ENABLE,                                                                         
+"LOOKUP_DATE" DATE CONSTRAINT "FS_LOOKUP_SELECTIONS_MTN5" NOT NULL ENABLE,      
+"SELECTED_OBJ_IDS" CLOB,                                                        
+CONSTRAINT "FS_LOOKUP_SELECTIONS_MTP1" PRIMARY KEY                              
+("LOOKUP_RESULT_SEQUENCE_NBR") ENABLE,                                          
+CONSTRAINT "FS_LOOKUP_SELECTIONS_MTC0" UNIQUE ("OBJ_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,                

CREATE TABLE "UNIT"                                                             
(	"UNIT_NUMBER" VARCHAR2(8) CONSTRAINT "UNITN1" NOT NULL ENABLE,                
"UNIT_NAME" VARCHAR2(60),                                                       
"ADMINISTRATIVE_OFFICER" VARCHAR2(9),                                           
"OSP_ADMINISTRATOR" VARCHAR2(9),                                                
"UNIT_HEAD" VARCHAR2(10),                                                       
"DEAN_VP" VARCHAR2(9),                                                          
"OTHER_INDIVIDUAL_TO_NOTIFY" VARCHAR2(9),                                       
"ORGANIZATION_ID" VARCHAR2(8),                                                  
"UPDATE_TIMESTAMP" DATE CONSTRAINT "UNITN2" NOT NULL ENABLE,                    
"UPDATE_USER" VARCHAR2(8) CONSTRAINT "UNITN3" NOT NULL ENABLE,                  
"VER_NBR" NUMBER(8,0) DEFAULT 1 CONSTRAINT "UNITN4" NOT NULL ENABLE,            
"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID() CONSTRAINT "UNITN5" NOT NULL ENABLE,   
CONSTRAINT "PK_UNIT_KRA" PRIMARY KEY ("UNIT_NUMBER") ENABLE
   ) ;
             
                                                                                
CREATE TABLE "EPS_PROPOSAL"                                                     
(	"DOCUMENT_NUMBER" NUMBER(10,0) CONSTRAINT "EPS_PROPOSAL_N1" NOT NULL ENABLE,  

   ) ;
             
                                                                                
CREATE TABLE "PROPOSAL_TYPE"                                                    
(	"PROPOSAL_TYPE_CODE" VARCHAR2(3) CONSTRAINT "PROPOSAL_TYPE_N1" NOT NULL       
ENABLE,                                                                         
