4c859c2cf16e57d4cd1d7a4f908d37773d506be7.svn-base 1.14 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
<?xml version="1.0" encoding="TIS-620"?>
<DBXML>
	<TABLE name="SIMTTRAININGTIME" status="" central="true" out="inquiry" rname="TTRAININGTIME">
		<FIELD>trainingid</FIELD>
		<FIELD>start_date</FIELD>
		<ORDER>
			<FIELD>trainingid</FIELD>
			<FIELD>start_date</FIELD>
		</ORDER>
	</TABLE>
	<TABLE name="TTRAINING" status="" central="false" out="record" issave="false">
		<FIELD>trainingid</FIELD>
		<FIELD>crsid</FIELD>
		<FIELD>trtitle</FIELD>
		<FIELD>locid</FIELD>
		<FIELD>roomid</FIELD>
		<FIELD>instid</FIELD>
		<FIELD>companyid</FIELD>
		<ORDER>
			<FIELD>trainingid</FIELD>
		</ORDER>
	</TABLE>
	<TABLE name="MCOURSE" status="" central="TTRAINING" out="record" issave="false">
		<FIELD>crsid</FIELD>
		<FIELD>crsdesc</FIELD>
		<FIELD>crsedesc</FIELD>
		<FIELD>roomid</FIELD>
		<FIELD>locid</FIELD>
		<FIELD>crsgid</FIELD>
		<FIELD>companyid</FIELD>
		<ORDER>
		</ORDER>
	</TABLE>
	<TABLE name="VW_UNCOMMONWORK" status="" central="false" out="inquiry">
		<FIELD>trainingid</FIELD>
		<FIELD>employeeid</FIELD>
		<FIELD>tfullname</FIELD>
		<FIELD>efullname</FIELD>
		<FIELD>companyid</FIELD>
		<ORDER>
			<FIELD>employeeid</FIELD>
		</ORDER>
	</TABLE>
</DBXML>