text: CREATE TABLE "RESEARCH_AREAS" 
     (	"RESEARCH_AREA_CODE" VARCHAR2(8) constraint RESEARCH_AREASN1 NOT NULL ENABLE, 
  	"PARENT_RESEARCH_AREA_CODE" VARCHAR2(8) constraint RESEARCH_AREASN2 NOT NULL ENABLE, 
  	"HAS_CHILDREN_FLAG" VARCHAR2(1) constraint RESEARCH_AREASN3 NOT NULL ENABLE, 
  	"DESCRIPTION" VARCHAR2(200) constraint RESEARCH_AREASN4 NOT NULL ENABLE, 
  	"UPDATE_TIMESTAMP" DATE constraint RESEARCH_AREASN5 NOT NULL ENABLE, 
  	"UPDATE_USER" VARCHAR2(8) constraint RESEARCH_AREASN6 NOT NULL ENABLE, 
  	 "VER_NBR" NUMBER(8,0) DEFAULT 1  constraint  RESEARCH_AREASN7  NOT NULL ENABLE,
  	"OBJ_ID" VARCHAR2(36) DEFAULT SYS_GUID()  constraint  RESEARCH_AREASN8  NOT NULL ENABLE,
  	CONSTRAINT "PK_RESEARCH_AREAS_KRA" PRIMARY KEY ("RESEARCH_AREA_CODE") ENABLE
  );
  INSERT INTO FP_DOC_TYPE_T (FDOC_TYP_CD,FDOC_NM,FDOC_TYP_ACTIVE_CD) VALUES ('REAR','RESEARCH AREAS','Y');
  commit;
  