<?xml version="1.0" encoding="utf-8"?>
<!--
/**
 * OrangeHRM is a comprehensive Human Resource Management (HRM) System that captures
 * all the essential functionalities required for any enterprise.
 * Copyright (C) 2006 OrangeHRM Inc., http://www.orangehrm.com
 *
 * OrangeHRM is free software; you can redistribute it and/or modify it under the terms of
 * the GNU General Public License as published by the Free Software Foundation; either
 * version 2 of the License, or (at your option) any later version.
 *
 * OrangeHRM is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
 * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License along with this program;
 * if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
 * Boston, MA  02110-1301, USA
 *
 * @copyright 2006 OrangeHRM Inc., http://www.orangehrm.com
 */
-->
<database>
	<table name="hs_hr_jobtitle">
		<fieldset name="jobtitle">
			<field name="JOB_TITLE" type="string" id="ejobtitle_id">
				<criteria>
					<value>JOB001</value>
					<value>JOB002</value>
				</criteria>
				<criteria>
					<value>JOB002</value>
				</criteria>
			</field>
			<field name="JOB_TITLE_NAME" type="string">
				<display />
			</field>
		</fieldset>
	</table>
	<table name="hs_hr_employee">
		<fieldset name="dob">
			<field name="DOB" type="date">
				<criteria>
					<range start="50" end="60" operation="intToDate"/>
					<compare type="&lt;" value="18" operation="intToDate"/>
				</criteria>
				<display />
			</field>
		</fieldset>
		<fieldset name="name" glue=" ">
			<field name="first_name" type="string">
				<display />
			</field>
			<field name="last_name" type="string">
				<display />
			</field>
		</fieldset>
		<fieldset name="subdivision">
			<field name="WORKSTATION" type="integer" operation="hierarchyString">
				<criteria>
					<children under="2" table="hs_hr_compstructtree" field="ID"/>
				</criteria>
				<display />
			</field>
		</fieldset>
		<field name="emp_number" id="emp_number" />
		<field name="jobtitle_id" id="jobtitle_id" />
		<join type="LEFT" >
			<pair field1="emp_number" field2="employee_id" compare="="/>
			<pair field1="jobtitle_id" field2="ejobtitle_id" compare="="/>
		</join>
	</table>
	<table name="leave_quota">
		<field name="employee_id" id="employee_id" />
	</table>
</database>
