 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
-   ) ;
-             
+"PARENT_UNIT_NUMBER" VARCHAR2(8),                                               
+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,  

CONSTRAINT "TRV_ACCT_TYPE_P1" PRIMARY KEY ("ACCT_NUM", "ACCT_TYPE") ENABLE      
) ;                                                                             
                                                                                
                                                                                
CREATE TABLE "ORGANIZATION"                                                     
(	"ORGANIZATION_ID" VARCHAR2(8) CONSTRAINT "ORGANIZATIONN1" NOT NULL ENABLE,    

   ) ;
                                          
                                                                                
CREATE TABLE "ABSTRACT_TYPE"                                                    
(	"ABSTRACT_TYPE_CODE" VARCHAR2(3) CONSTRAINT "ABSTRACT_TYPE_N1" NOT NULL       
ENABLE,                                                                         
