<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE Sybase_eDataWindow>
<Sybase_eDataWindow>
	<Release>9</Release>
	<BaseDefinition>
		<units>1</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>24</left>
				<right>24</right>
				<top>24</top>
				<bottom>24</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>21</height>
		<color>536870912</color>
	</Header>
	<Summary>
		<height>0</height>
		<color>536870912</color>
	</Summary>
	<Footer>
		<height>0</height>
		<color>536870912</color>
	</Footer>
	<Detail>
		<height>19</height>
		<color>536870912</color>
	</Detail>
	<TableDefinition>
		<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="15">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>emp_fname</name>
			<dbname>employee.emp_fname</dbname>
		</table_column>
		<table_column>
			<type size="15">char</type>
			<update>yes</update>
			<updatewhereclause>yes</updatewhereclause>
			<key>yes</key>
			<name>redesign_no</name>
			<dbname>empredesign.redesign_no</dbname>
		</table_column>
		<table_column>
			<type size="10">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>emp_code</name>
			<dbname>empredesign.emp_code</dbname>
		</table_column>
		<table_column>
			<type>datetime</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>redesign_date</name>
			<dbname>empredesign.redesign_date</dbname>
		</table_column>
		<table_column>
			<type size="25">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>c_design</name>
			<dbname>empredesign.c_design</dbname>
		</table_column>
		<table_column>
			<type size="25">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>n_design</name>
			<dbname>empredesign.n_design</dbname>
		</table_column>
		<table_column>
			<type size="5">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>pay_site</name>
			<dbname>employee.pay_site</dbname>
		</table_column>
		<table_column>
			<type size="5">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>design_code__fr</name>
			<dbname>empredesign.design_code__fr</dbname>
		</table_column>
		<table_column>
			<type size="5">char</type>
			<updatewhereclause>yes</updatewhereclause>
			<name>design_code__to</name>
			<dbname>empredesign.design_code__to</dbname>
		</table_column>
		<retrieve>PBSELECT( VERSION(400) TABLE(NAME=&quot;employee&quot; )  TABLE(NAME=&quot;empredesign&quot; ) COLUMN(NAME=&quot;employee.emp_lname&quot;) COLUMN(NAME=&quot;employee.emp_fname&quot;) COLUMN(NAME=&quot;empredesign.redesign_no&quot;) COLUMN(NAME=&quot;empredesign.emp_code&quot;) COLUMN(NAME=&quot;empredesign.redesign_date&quot;) COLUMN(NAME=&quot;empredesign.c_design&quot;) COLUMN(NAME=&quot;empredesign.n_design&quot;) COLUMN(NAME=&quot;employee.pay_site&quot;) COLUMN(NAME=&quot;empredesign.design_code__fr&quot;) COLUMN(NAME=&quot;empredesign.design_code__to&quot;)    JOIN (LEFT=&quot;employee.emp_code&quot;    OP =&quot;=&quot;RIGHT=&quot;empredesign.emp_code&quot; )WHERE(    EXP1 =&quot;EMPREDESIGN.ORD_DATE&quot;   OP =&quot;&gt;=&quot;    EXP2 =&quot;:ordate_fr&quot;    LOGIC =&quot;and&quot; ) WHERE(    EXP1 =&quot;EMPREDESIGN.ORD_DATE&quot;   OP =&quot;&lt;=&quot;    EXP2 =&quot;:ordate_to&quot; ) ) ARG(NAME = &quot;ordate_fr&quot; TYPE = datetime)  ARG(NAME = &quot;ordate_to&quot; TYPE = datetime) </retrieve>
		<update>empredesign</update>
		<updatewhere>0</updatewhere>
		<updatekeyinplace>no</updatekeyinplace>
		<argument>
			<name>ordate_fr</name>
			<type>datetime</type>
		</argument>
		<argument>
			<name>ordate_to</name>
			<type>datetime</type>
		</argument>
	</TableDefinition>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Redesignation No</text>
		<border>6</border>
		<color>0</color>
		<x>2</x>
		<y>3</y>
		<height>16</height>
		<width>104</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>redesign_no_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>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Last Name</text>
		<border>6</border>
		<color>0</color>
		<x>205</x>
		<y>3</y>
		<height>16</height>
		<width>143</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>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>First Name</text>
		<border>6</border>
		<color>0</color>
		<x>350</x>
		<y>3</y>
		<height>16</height>
		<width>145</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>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>2</alignment>
		<text>Redesignation Date</text>
		<border>6</border>
		<color>0</color>
		<x>497</x>
		<y>3</y>
		<height>16</height>
		<width>118</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>redesign_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>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Employee Code</text>
		<border>6</border>
		<color>0</color>
		<x>108</x>
		<y>3</y>
		<height>16</height>
		<width>95</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>2</mode>
			<color>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Current Design Code</text>
		<border>6</border>
		<color>0</color>
		<x>617</x>
		<y>3</y>
		<height>16</height>
		<width>114</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>design_code__fr_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>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>New Design Code</text>
		<border>6</border>
		<color>0</color>
		<x>733</x>
		<y>3</y>
		<height>16</height>
		<width>114</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>design_code__to_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>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>New Designation</text>
		<border>6</border>
		<color>0</color>
		<x>990</x>
		<y>3</y>
		<height>16</height>
		<width>147</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>n_design_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>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Pay Site</text>
		<border>6</border>
		<color>0</color>
		<x>1139</x>
		<y>3</y>
		<height>16</height>
		<width>53</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>pay_site_t</name>
		<visible expression="&quot;false&quot;">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>79741120</color>
		</background>
	</TextObject>
	<TextObject>
		<band>Header</band>
		<alignment>0</alignment>
		<text>Current Designation</text>
		<border>6</border>
		<color>0</color>
		<x>849</x>
		<y>3</y>
		<height>16</height>
		<width>139</width>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>c_design_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>79741120</color>
		</background>
	</TextObject>
	<ColumnObject>
		<band>Detail</band>
		<id>3</id>
		<alignment>0</alignment>
		<tabsequence>10</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>2</x>
		<y>1</y>
		<height>16</height>
		<width>104</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>redesign_no</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>upper</case>
			<focusrectangle>no</focusrectangle>
			<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>4</id>
		<alignment>0</alignment>
		<tabsequence>20</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>108</x>
		<y>1</y>
		<height>16</height>
		<width>95</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_code</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>upper</case>
			<focusrectangle>no</focusrectangle>
			<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>1</id>
		<alignment>0</alignment>
		<tabsequence>30</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>205</x>
		<y>1</y>
		<height>16</height>
		<width>143</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_lname</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>15</limit>
			<case>upper</case>
			<focusrectangle>no</focusrectangle>
			<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>40</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>350</x>
		<y>1</y>
		<height>16</height>
		<width>145</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>emp_fname</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>15</limit>
			<case>upper</case>
			<focusrectangle>no</focusrectangle>
			<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>50</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>497</x>
		<y>1</y>
		<height>16</height>
		<width>118</width>
		<format>dd/mm/yy</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>redesign_date</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>any</case>
			<focusrectangle>no</focusrectangle>
			<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>9</id>
		<alignment>0</alignment>
		<tabsequence>60</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>617</x>
		<y>1</y>
		<height>16</height>
		<width>114</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>design_code__fr</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>5</limit>
			<case>upper</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>10</id>
		<alignment>0</alignment>
		<tabsequence>70</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>733</x>
		<y>1</y>
		<height>16</height>
		<width>114</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>design_code__to</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>5</limit>
			<case>upper</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>7</id>
		<alignment>0</alignment>
		<tabsequence>90</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>990</x>
		<y>1</y>
		<height>16</height>
		<width>147</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>n_design</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>upper</case>
			<focusrectangle>no</focusrectangle>
			<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>8</id>
		<alignment>0</alignment>
		<tabsequence>32766</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>1139</x>
		<y>1</y>
		<height>16</height>
		<width>53</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>pay_site</name>
		<visible expression="&quot;false&quot;">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>6</id>
		<alignment>0</alignment>
		<tabsequence>80</tabsequence>
		<border>5</border>
		<color>0</color>
		<x>849</x>
		<y>1</y>
		<height>16</height>
		<width>139</width>
		<format>[general]</format>
		<html>
			<valueishtml>0</valueishtml>
		</html>
		<name>c_design</name>
		<visible>1</visible>
		<EditStyle style="edit">
			<limit>0</limit>
			<case>upper</case>
			<focusrectangle>no</focusrectangle>
			<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>
	<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>
