7a0f2d796f06ab46b2dabd159f729bf8db20391a.svn-base 1.21 KB
Newer Older
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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
<DBXML>
	<TABLE name="SIMMBU1_APPLY_SOURCE" status="" rname="MBU1" central="true" out="inquiry">
		<FIELD>bu1id</FIELD>
		<FIELD>tdesc</FIELD>
		<FIELD>edesc</FIELD>
		<ORDER>
			<FIELD>bu1id</FIELD>
		</ORDER>
	</TABLE>
	<TABLE name="V1MJOBCODE" status="" central="false" out="inquiry">
		<FIELD>JOBCODEID</FIELD>
		<FIELD>TDESC</FIELD>
		<FIELD>EDESC</FIELD>
		<FIELD>JOBGROUP</FIELD>
		<FIELD>JOBCODE_LEVEL</FIELD>
		<FIELD>SUPERVISOR</FIELD>
		<FIELD>BU1</FIELD>
		<FIELD>BU2</FIELD>
		<FIELD>BU3</FIELD>
		<FIELD>BU4</FIELD>
		<!--FIELD>BU5</FIELD-->
		<FIELD>JOBCODE_POSITION</FIELD>
		<FIELD>JOBGRADEID</FIELD>
		<FIELD>CONSOLIDATE</FIELD>
		<FIELD>COMPANYID</FIELD>
		<FIELD>RESPONSIBILITY</FIELD>
		<FIELD>SKILL</FIELD>
		<FIELD>EXPERIENCE</FIELD>
		<FIELD>AGE1</FIELD>
		<FIELD>AGE0</FIELD>
		<FIELD>EDUBRANCH</FIELD>
		<FIELD>EDUCATE</FIELD>
		<ORDER>
			<FIELD>JOBCODEID</FIELD>
		</ORDER>
	</TABLE>
	<TABLE name="MAPPLICANT" status="center" central="V1MJOBCODE" out="inquiry">
		<FIELD>applicantid</FIELD>
		<FIELD>companyid</FIELD>
		<FIELD>applicantstatus</FIELD>
		<FIELD>applydate</FIELD>
		<FIELD>referee1positionid</FIELD>
		<ORDER>
			<FIELD>companyid</FIELD> 
			<FIELD>applicantid</FIELD> 
		</ORDER>
	</TABLE>
</DBXML>