text: delimiter /
  TRUNCATE TABLE RATE_TYPE
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('1',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'MTDC'),'MTDC','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('1',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'TDC'),'TDC','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('1',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'S&W'),'S&W','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('1',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Fund with Transaction Fee (FUNSN)'),'Salaries','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('1',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Employee Benefits'),'Research Rate','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('1',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Inflation'),'Faculty Salaries (6/1)','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('1',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Vacation'),'Vacation ','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('1',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Other'),'Other','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('1',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Lab Allocation - Salaries'),'Lab Allocation - Salaries','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('1',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Lab Allocation - M&S'),'Lab Allocation - M&S','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('1',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Lab Allocation - Utilities'),'Lab Allocation - Utilities','admin',NOW(),UUID(),1)
  /    
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('2',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Fund with Transaction Fee (FUNSN)'),'Materials and Services','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('2',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Employee Benefits'),'UROP Rate','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('2',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Inflation'),'Administrative Salaries (7/1)','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('2',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Vacation'),'Vacation on LA','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('3',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Employee Benefits'),'EB on LA','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('3',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Inflation'),'Support Staff Salaries (4/1)','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('4',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Employee Benefits'),'another EB rate','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('4',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Inflation'),'Materials and Services','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('5',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Employee Benefits'),'eb added in pb','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('5',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Inflation'),'Research Staff (1/1)','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('6',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Employee Benefits'),'Award Special EB Rate','admin',NOW(),UUID(),1)
  /
  INSERT INTO RATE_TYPE (RATE_TYPE_CODE,RATE_CLASS_CODE,DESCRIPTION,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES ('6',(SELECT RATE_CLASS_CODE FROM RATE_CLASS WHERE DESCRIPTION = 'Inflation'),'Students (6/1)','admin',NOW(),UUID(),1)
  /
  delimiter ;
  