<?xml version="1.0" encoding="ISO-8859-15"?>
<!--
  generated by Jailer, Wed May 13 09:51:16 CEST 2009 from wisser@u19
  
  Extraction Model:  EMPLOYEE where NAME='JONES' (/data/workspace/trunk/src/test/pseudocolumns/restricted_export/extractionmodel.csv)
  Database URL:      jdbc:mysql://localhost:3306/test
  Database User:     test
  Exported Rows:     11
      DEPARTMENT                     2
      EMPLOYEE                       4
      PROJECT                        1
      PROJECT_PARTICIPATION          1
      ROLE                           1
      SALARYGRADE                    2
  
-->
<dataset>
  <SALARYGRADE GRADE="4" LOSAL="2001" HISAL="3000"/>
  <SALARYGRADE GRADE="5" LOSAL="3001" HISAL="9999"/>

  <ROLE ROLE_ID="102" DESCRIPTION="Project manager"/>

  <PROJECT PROJECTNO="1003" DESCRIPTION="Foundation of Quantum Technology" START_DATE="2007-02-24" END_DATE="2008-07-31"/>

  <DEPARTMENT DEPTNO="10" NAME="ACCOUNTING" LOCATION="NEW YORK"/>
  <DEPARTMENT DEPTNO="20" NAME="RESEARCH" LOCATION="DALLAS"/>

  <EMPLOYEE EMPNO="7839" NAME="KING" JOB="PRESIDENT" 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="7788" NAME="SCOTT" JOB="ANALYST" BOSS="7566" HIREDATE="1982-12-09" SALARY="3000.00" DEPTNO="20"/>
  <EMPLOYEE EMPNO="7902" NAME="FORD" JOB="ANALYST" BOSS="7566" HIREDATE="1981-12-03" SALARY="3000.00" DEPTNO="20"/>

  <PROJECT_PARTICIPATION PROJECTNO="1003" EMPNO="7566" START_DATE="2007-02-24" END_DATE="2008-07-31" ROLE_ID="102"/>

  
</dataset>
