<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE Sybase_eDataWindow>
<Sybase_eDataWindow>
	<Release>9</Release>
	<BaseDefinition>
		<units>0</units>
		<timer_interval>0</timer_interval>
		<color>79741120</color>
		<processing>1</processing>
		<HTMLDW>no</HTMLDW>
		<print>
			<documentname></documentname>
			<printername></printername>
			<orientation>0</orientation>
			<margin>
				<left>110</left>
				<right>110</right>
				<top>96</top>
				<bottom>96</bottom>
			</margin>
			<paper>
				<source>0</source>
				<size>0</size>
			</paper>
			<prompt>no</prompt>
			<canusedefaultprinter>yes</canusedefaultprinter>
			<buttons>no</buttons>
			<preview.buttons>no</preview.buttons>
			<cliptext>no</cliptext>
			<overrideprintjob>no</overrideprintjob>
		</print>
		<grid.lines>0</grid.lines>
	</BaseDefinition>
	<Header>
		<height>76</height>
		<color>536870912</color>
	</Header>
	<Summary>
		<height>0</height>
		<color>536870912</color>
	</Summary>
	<Footer>
		<height>0</height>
		<color>536870912</color>
	</Footer>
	<Detail>
		<height>96</height>
		<color>536870912</color>
	</Detail>
	<TableDefinition>
		<table_column>
			<type size="10">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<key>yes</key>
			<name>emp_code</name>
			<dbname>employee.emp_code</dbname>
		</table_column>
		<table_column>
			<type size="15">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>emp_fname</name>
			<dbname>employee.emp_fname</dbname>
		</table_column>
		<table_column>
			<type size="15">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>emp_lname</name>
			<dbname>employee.emp_lname</dbname>
		</table_column>
		<table_column>
			<type size="5">char</type>
			<update>yes</update>
			<updatewhereclause>yes</updatewhereclause>
			<name>work_shift</name>
			<dbname>employee.work_shift</dbname>
		</table_column>
		<table_column>
			<type size="1">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>shift_rot</name>
			<dbname>employee.shift_rot</dbname>
			<values>
				<item display="Yes" data="Y"/>
				<item display="No" data="N"/>
			</values>
		</table_column>
		<table_column>
			<type size="5">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>hol_tblno</name>
			<dbname>employee.hol_tblno</dbname>
		</table_column>
		<table_column>
			<type>datetime</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>relieve_date</name>
			<dbname>employee.relieve_date</dbname>
		</table_column>
		<retrieve>PBSELECT( VERSION(400) TABLE(NAME=&quot;employee&quot; ) COLUMN(NAME=&quot;employee.emp_code&quot;) COLUMN(NAME=&quot;employee.emp_fname&quot;) COLUMN(NAME=&quot;employee.emp_lname&quot;) COLUMN(NAME=&quot;employee.work_shift&quot;) COLUMN(NAME=&quot;employee.shift_rot&quot;) COLUMN(NAME=&quot;employee.hol_tblno&quot;) COLUMN(NAME=&quot;employee.relieve_date&quot;)WHERE(    EXP1 =&quot;( employee.emp_code&quot;   OP =&quot;&gt;=&quot;    EXP2 =&quot;:as_emp_fr )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( employee.emp_code&quot;   OP =&quot;&lt;=&quot;    EXP2 =&quot;:as_emp_to )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( employee.dept_code&quot;   OP =&quot;&gt;=&quot;    EXP2 =&quot;:as_dept_fr )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( employee.dept_code&quot;   OP =&quot;&lt;=&quot;    EXP2 =&quot;:as_dept_to )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( employee.work_site&quot;   OP =&quot;&gt;=&quot;    EXP2 =&quot;:as_site_fr )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( employee.work_site&quot;   OP =&quot;&lt;=&quot;    EXP2 =&quot;:as_site_to )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( employee.shift_rot&quot;   OP =&quot;=&quot;    EXP2 =&quot;&apos;Y&apos; )&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;( nvl(employee.status,&apos; &apos;)&quot;   OP =&quot;&lt;&gt;&quot;    EXP2 =&quot;&apos;S&apos; )&quot; ) ) ARG(NAME = &quot;as_emp_fr&quot; TYPE = string)  ARG(NAME = &quot;as_emp_to&quot; TYPE = string)  ARG(NAME = &quot;as_dept_fr&quot; TYPE = string)  ARG(NAME = &quot;as_dept_to&quot; TYPE = string)  ARG(NAME = &quot;as_site_fr&quot; TYPE = string)  ARG(NAME = &quot;as_site_to&quot; TYPE = string) </retrieve>
		<update>EMPLOYEE</update>
		<updatewhere>0</updatewhere>
		<updatekeyinplace>no</updatekeyinplace>
		<argument>
			<name>as_emp_fr</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_emp_to</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_dept_fr</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_dept_to</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_site_fr</name>
			<type>string</type>
		</argument>
		<argument>
			<name>as_site_to</name>
			<type>string</type>
		</argument>
	</TableDefinition>
	<TextObject>
		<band>Header</band>
		<alignment>2</alignment>
		<text>Emp Code</text>
		<border>6</border>
		<color>0</color>
		<x>9</x>
		<y>8</y>
		<height>64</height>
		<width>251</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_code_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>1</mode>
			<color>536870912</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>First Name</text>
		<border>6</border>
		<color>0</color>
		<x>270</x>
		<y>8</y>
		<height>64</height>
		<width>425</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_fname_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>1</mode>
			<color>536870912</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>2</alignment>
		<text>Work Shift</text>
		<border>6</border>
		<color>0</color>
		<x>1225</x>
		<y>8</y>
		<height>64</height>
		<width>265</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>work_shift_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>1</mode>
			<color>536870912</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Last Name</text>
		<border>6</border>
		<color>0</color>
		<x>704</x>
		<y>8</y>
		<height>64</height>
		<width>512</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_lname_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>1</mode>
			<color>536870912</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Shift Rotate</text>
		<border>6</border>
		<color>0</color>
		<x>1499</x>
		<y>8</y>
		<height>64</height>
		<width>302</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>t_1</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>1</mode>
			<color>536870912</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Relieve Date</text>
		<border>6</border>
		<color>0</color>
		<x>2130</x>
		<y>8</y>
		<height>64</height>
		<width>375</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>relieve_date_t</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>67108864</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Hol Tblno</text>
		<border>6</border>
		<color>0</color>
		<x>1810</x>
		<y>8</y>
		<height>64</height>
		<width>311</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>t_2</name>
		<visible>1</visible>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>1</mode>
			<color>536870912</color>
		</background>
	</TextObject>
	<ColumnObject>
		<band>Detail</band>
		<id>1</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>9</x>
		<y>8</y>
		<height>76</height>
		<width>251</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_code</name>
		<tag>Unique code of the employee, across the organisation</tag>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>10</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<autohscroll>yes</autohscroll>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>16777215</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>2</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>270</x>
		<y>8</y>
		<height>76</height>
		<width>425</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_fname</name>
		<tag>First name of the employee.</tag>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>15</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<autohscroll>yes</autohscroll>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>16777215</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>4</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>1225</x>
		<y>8</y>
		<height>76</height>
		<width>265</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>work_shift</name>
		<tag>The current shift in which the employee is working. Validated from working shifts master</tag>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>1</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<autohscroll>yes</autohscroll>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>16777215</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>3</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>704</x>
		<y>8</y>
		<height>76</height>
		<width>512</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_lname</name>
		<tag>Last name of the employee.</tag>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>15</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<autohscroll>yes</autohscroll>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>16777215</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>5</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>1499</x>
		<y>8</y>
		<height>76</height>
		<width>302</width>
		<format></format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>shift_rot</name>
		<visible>1</visible>
		<EditStyle name="Yesno" style="ddlb">
			<limit>1</limit>
			<allowedit>no</allowedit>
			<case>any</case>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>16777215</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>6</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>1810</x>
		<y>8</y>
		<height>76</height>
		<width>311</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>hol_tblno</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<autoselect>yes</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>16777215</color>
		</background>
	</ColumnObject>
	<ColumnObject>
		<band>Detail</band>
		<id>7</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>2130</x>
		<y>8</y>
		<height>76</height>
		<width>375</width>
		<format>[shortdate] [time]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>relieve_date</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<focusrectangle>no</focusrectangle>
			<autoselect>no</autoselect>
			<imemode>0</imemode>
		</EditStyle>
		<font>
			<face>Times New Roman</face>
			<height>-10</height>
			<weight>400</weight>
			<family>1</family>
			<pitch>2</pitch>
			<charset>0</charset>
		</font>
		<background>
			<mode>2</mode>
			<color>16777215</color>
		</background>
	</ColumnObject>
	<HtmlTable>
		<border>1</border>
	</HtmlTable>
	<HtmlGen>
		<clientevents>1</clientevents>
		<clientvalidation>1</clientvalidation>
		<clientcomputedfields>1</clientcomputedfields>
		<clientformatting>0</clientformatting>
		<clientscriptable>0</clientscriptable>
		<generatejavascript>1</generatejavascript>
		<encodeselflinkargs>1</encodeselflinkargs>
		<netscapelayers>0</netscapelayers>
	</HtmlGen>
	<Export.XML>
		<headgroups>1</headgroups>
		<includewhitespace>0</includewhitespace>
		<metadatatype>0</metadatatype>
		<savemetadata>0</savemetadata>
	</Export.XML>
	<Import.XML>
	</Import.XML>
	<Export.PDF>
		<method>0</method>
		<distill.custompostscript>0</distill.custompostscript>
		<xslfop.print>0</xslfop.print>
	</Export.PDF>
</Sybase_eDataWindow>
