<?xml version="1.0" encoding="ISO-8859-15"?>
<!--
  generated by Jailer, Mon Mar 30 16:34:00 CEST 2009
  
  Exported Rows:     44
      DEPARTMENT                     4
      EMPLOYEE                       14
      PROJECT                        4
      PROJECT_PARTICIPATION          14
      ROLE                           3
      SALARYGRADE                    5
  
-->
<dataset>
  <SALARYGRADE GRADE="1" LOSAL="700" HISAL="1200"/>
  <SALARYGRADE GRADE="2" LOSAL="1201" HISAL="1400"/>
  <SALARYGRADE GRADE="3" LOSAL="1401" HISAL="2000"/>
  <SALARYGRADE GRADE="4" LOSAL="2001" HISAL="3000"/>
  <SALARYGRADE GRADE="5" LOSAL="3001" HISAL="9999"/>

  <ROLE ROLE_ID="100" DESCRIPTION="Developer"/>
  <ROLE ROLE_ID="101" DESCRIPTION="Researcher"/>
  <ROLE ROLE_ID="102" DESCRIPTION="Project manager"/>

  <PROJECT PROJECTNO="1001" DESCRIPTION="Development of Novel Magnetic Suspension System" START_DATE="2006-01-01" END_DATE="2007-08-13"/>
  <PROJECT PROJECTNO="1002" DESCRIPTION="Research on thermofluid dynamics in Microdroplets" START_DATE="2006-08-22" END_DATE="2007-03-20"/>
  <PROJECT PROJECTNO="1003" DESCRIPTION="Foundation of Quantum Technology" START_DATE="2007-02-24" END_DATE="2008-07-31"/>
  <PROJECT PROJECTNO="1004" DESCRIPTION="High capacity optical network" START_DATE="2008-01-01"/>

  <DEPARTMENT DEPTNO="10" NAME="ACCOUNTING" LOCATION="NEW YORK"/>
  <DEPARTMENT DEPTNO="20" NAME="RESEARCH" LOCATION="DALLAS"/>
  <DEPARTMENT DEPTNO="30" NAME="SALES" LOCATION="CHICAGO"/>
  <DEPARTMENT DEPTNO="40" NAME="OPERATIONS" LOCATION="BOSTON"/>

  <EMPLOYEE EMPNO="7839" NAME="KING" JOB="PRESIDENT" BOSS="7839" HIREDATE="1981-11-17" SALARY="5000.00" DEPTNO="10"/>

  <EMPLOYEE EMPNO="7566" NAME="JONES" JOB="MANAGER" BOSS="7839" HIREDATE="1981-04-02" SALARY="2975.00" DEPTNO="20"/>
  <EMPLOYEE EMPNO="7698" NAME="BLAKE" JOB="MANAGER" BOSS="7839" HIREDATE="1981-05-01" SALARY="2850.00" DEPTNO="30"/>
  <EMPLOYEE EMPNO="7782" NAME="CLARK" JOB="MANAGER" BOSS="7839" HIREDATE="1981-06-09" SALARY="2450.00" DEPTNO="10"/>

  <EMPLOYEE EMPNO="7499" NAME="ALLEN" JOB="SALESMAN" BOSS="7698" HIREDATE="1981-02-20" SALARY="1600.00" COMM="300.00" DEPTNO="30"/>
  <EMPLOYEE EMPNO="7521" NAME="WARD" JOB="SALESMAN" BOSS="7698" HIREDATE="1981-02-22" SALARY="1250.00" COMM="500.00" DEPTNO="30"/>
  <EMPLOYEE EMPNO="7654" NAME="MARTIN" JOB="SALESMAN" BOSS="7698" HIREDATE="1981-09-28" SALARY="1250.00" COMM="1400.00" DEPTNO="30"/>
  <EMPLOYEE EMPNO="7788" NAME="SCOTT" JOB="ANALYST" BOSS="7566" HIREDATE="1982-12-09" SALARY="3000.00" DEPTNO="20"/>
  <EMPLOYEE EMPNO="7844" NAME="TURNER" JOB="SALESMAN" BOSS="7698" HIREDATE="1981-09-08" SALARY="1500.00" COMM="0.00" DEPTNO="30"/>
  <EMPLOYEE EMPNO="7900" NAME="JAMES" JOB="CLERK" BOSS="7698" HIREDATE="1981-12-03" SALARY="950.00" DEPTNO="30"/>
  <EMPLOYEE EMPNO="7902" NAME="FORD" JOB="ANALYST" BOSS="7566" HIREDATE="1981-12-03" SALARY="3000.00" DEPTNO="20"/>
  <EMPLOYEE EMPNO="7934" NAME="MILLER" JOB="CLERK" BOSS="7782" HIREDATE="1982-01-23" SALARY="1300.00" DEPTNO="10"/>

  <EMPLOYEE EMPNO="7369" NAME="SMITH" JOB="CLERK" BOSS="7902" HIREDATE="1980-12-17" SALARY="800.00" DEPTNO="20"/>
  <EMPLOYEE EMPNO="7876" NAME="ADAMS" JOB="CLERK" BOSS="7788" HIREDATE="1983-01-12" SALARY="1100.00" DEPTNO="20"/>

  <PROJECT_PARTICIPATION PROJECTNO="1001" EMPNO="7369" START_DATE="2006-01-01" END_DATE="2007-08-13" ROLE_ID="100"/>
  <PROJECT_PARTICIPATION PROJECTNO="1001" EMPNO="7788" START_DATE="2006-05-15" END_DATE="2006-11-01" ROLE_ID="100"/>
  <PROJECT_PARTICIPATION PROJECTNO="1001" EMPNO="7902" START_DATE="2006-01-01" END_DATE="2006-12-30" ROLE_ID="102"/>
  <PROJECT_PARTICIPATION PROJECTNO="1002" EMPNO="7782" START_DATE="2006-08-22" END_DATE="2007-03-20" ROLE_ID="101"/>
  <PROJECT_PARTICIPATION PROJECTNO="1002" EMPNO="7876" START_DATE="2006-08-22" END_DATE="2007-03-20" ROLE_ID="102"/>
  <PROJECT_PARTICIPATION PROJECTNO="1002" EMPNO="7934" START_DATE="2007-01-01" END_DATE="2007-03-20" ROLE_ID="101"/>
  <PROJECT_PARTICIPATION PROJECTNO="1003" EMPNO="7566" START_DATE="2007-02-24" END_DATE="2008-07-31" ROLE_ID="102"/>
  <PROJECT_PARTICIPATION PROJECTNO="1003" EMPNO="7900" START_DATE="2007-02-24" END_DATE="2007-01-31" ROLE_ID="101"/>
  <PROJECT_PARTICIPATION PROJECTNO="1004" EMPNO="7499" START_DATE="2008-01-01" ROLE_ID="102"/>
  <PROJECT_PARTICIPATION PROJECTNO="1004" EMPNO="7521" START_DATE="2008-05-01" ROLE_ID="101"/>
  <PROJECT_PARTICIPATION PROJECTNO="1004" EMPNO="7654" START_DATE="2008-04-15" ROLE_ID="101"/>
  <PROJECT_PARTICIPATION PROJECTNO="1004" EMPNO="7844" START_DATE="2008-02-01" ROLE_ID="101"/>
  <PROJECT_PARTICIPATION PROJECTNO="1004" EMPNO="7900" START_DATE="2008-03-01" END_DATE="2008-04-01" ROLE_ID="101"/>
  <PROJECT_PARTICIPATION PROJECTNO="1004" EMPNO="7900" START_DATE="2008-05-20" ROLE_ID="101"/>

  
</dataset>
