Skip to content

D
DHAS
Switch branch/tag
Find file
Normal viewHistoryPermalink
c616bf21bf77a9534c545cd4e3649efeaf2859e6.svn-base 1.55 KB
Newer Older
UPGIT
6aad529a
 
Thitichaipun Wutthisak committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 
<?xml version="1.0" encoding="TIS-620"?>
<WORKFLOW>
	<APP_NAME>PERSONAL</APP_NAME>
	<SOURCE_TABLE>
		<TABLE name="Workflow_Data" central="true" out="inquiry">
			<FIELD>COMPANYID</FIELD>
			<FIELD>WF_ID</FIELD>
			<FIELD>WF_VER</FIELD>
			<FIELD>WF_DOC_NO</FIELD>
			<FIELD>SCREEN_VALUE</FIELD>
		</TABLE>
	</SOURCE_TABLE>
	<DESTINATION_TABLE>
		<TABLE name="TREQ_CERTIFICATE" central="true" out="record">
			<FIELD name="EMPLOYEEID" setcolumn="1" fix_value="" not_null="1">EMPLOYEEID</FIELD>
			<FIELD name="COMPANYID" setcolumn="1" fix_value="" not_null="1">COMPANYID</FIELD>
			<FIELD name="REQ_ID" setcolumn="1" fix_value="" not_null="0">WF_DOC_NO</FIELD>
			<FIELD name="TEMP_CERT" setcolumn="1" fix_value="" not_null="0">EMPTAMOUNT</FIELD>
			<!-- <FIELD name="EEMP_CERT" setcolumn="1" fix_value="" not_null="0">EMPEAMOUNT</FIELD> -->
			<FIELD name="TSALA_CERT" setcolumn="1" fix_value="" not_null="0">SALARYTAMOUNT</FIELD>
			<FIELD name="ESALA_CERT" setcolumn="1" fix_value="" not_null="0">SALARYEAMOUNT</FIELD>
			<FIELD name="CONFIRMEMP_CERT" setcolumn="1" fix_value="" not_null="0">CONFIRMEMPAMOUNT</FIELD>
			<FIELD name="CUTWAGE_FORM" setcolumn="1" fix_value="" not_null="0">CUTWAGEAMOUNT</FIELD>
			<FIELD name="REASON" setcolumn="1" fix_value="" not_null="0">REASON</FIELD>
			<FIELD name="COUNTRYID" setcolumn="1" fix_value="" not_null="0">COUNTRYID</FIELD>
			<FIELD name="START_DATE" setcolumn="1" fix_value="" not_null="0">STARTDATE</FIELD>
			<FIELD name="END_DATE" setcolumn="1" fix_value="" not_null="0">ENDDATE</FIELD>
		</TABLE>
	</DESTINATION_TABLE>
</WORKFLOW>