Skip to content

D
DHAS
Switch branch/tag
Find file
Normal viewHistoryPermalink
72966722802f763725043bc3be46d366b8a1b654.svn-base 6.83 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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 
<?xml version="1.0" encoding="TIS-620"?><VW_HTRAINTRNEE_YEAR desc_thai="ªͼѺý֡ͺ" desc_eng="Trainee list from History" editcheck="true" mainhelp="VW_HTRAINTRNEE_YEARHELP" referhelp="VW_HTRAINTRNEE_YEARHELP" mainkey="TRAININGID" fieldsystem="" deleteflag="true" config_field="">
<FIELD>
	<TRAININGID lang="A" encrypt="false" verify="false" log="false" type="String">
				<KEY>1</KEY>
				<WIDTH>15</WIDTH>
				<DESC_ENG>Training ID</DESC_ENG>
				<DESC_THAI></DESC_THAI>
				<COMPONENT type="text">
					<MAXSIZE>15</MAXSIZE>
					<SIZE>17</SIZE>
					<ALT_ENG>Training ID</ALT_ENG>
					<ALT_THAI></ALT_THAI>
				</COMPONENT>
	</TRAININGID>
	<TRAINEEID lang="A" encrypt="false" verify="false" log="false" type="String">
				<KEY>2</KEY>
				<WIDTH>15</WIDTH>
				<DESC_ENG>Emloyee ID</DESC_ENG>
				<DESC_THAI>ʾѡҹ</DESC_THAI>
				<COMPONENT type="text">
					<MAXSIZE>15</MAXSIZE>
					<SIZE>10</SIZE>
					<ALT_ENG>Employee ID</ALT_ENG>
					<ALT_THAI>ʾѡҹ</ALT_THAI>
				</COMPONENT>
	</TRAINEEID>
	<TRAINYEAR LANG="A" encrypt="false" verify="false" log="false" type="String">
				<WIDTH>4</WIDTH>
				<DESC_ENG>Train Year</DESC_ENG>
				<DESC_THAI>շͺ</DESC_THAI>
				<COMPONENT type="text">
					<MAXSIZE>4</MAXSIZE>
					<SIZE>5</SIZE>
					<ALT_ENG>Train Year</ALT_ENG>
					<ALT_THAI>շͺ</ALT_THAI>
				</COMPONENT>
	</TRAINYEAR>
	<ID_PEOPLE lang="A" encrypt="false" log="false" type="String">
			<WIDTH>13</WIDTH>
			<DESC_ENG>People ID</DESC_ENG>
			<DESC_THAI>ŢѵûЪҪ</DESC_THAI>
			<COMPONENT type="text">
				<MAXSIZE>13</MAXSIZE>
				<SIZE>15</SIZE>
				<ALT_ENG>People ID</ALT_ENG>
				<ALT_THAI>ŢѵûЪҪ</ALT_THAI>
			</COMPONENT>
	</ID_PEOPLE>
	<EMP_PREFIX lang="A" encrypt="false" log="false" type="String">
			<WIDTH>3</WIDTH>
			<RELATION>MPREFIX</RELATION>
			<DESC_ENG>Prefix ID</DESC_ENG>
			<DESC_THAI>ʤӹ˹Ҫ</DESC_THAI>
			<COMPONENT type="list">
				<SIZE>5</SIZE>
				<MAXSIZE>5</MAXSIZE>
				<ALT_ENG>Prefix ID</ALT_ENG>
				<ALT_THAI>ʤӹ˹Ҫ</ALT_THAI>
			</COMPONENT>
	</EMP_PREFIX>
	<FNAME lang="T" encrypt="false" log="false" type="String">
			<WIDTH>30</WIDTH>
			<REFER_LANG>EFNAME</REFER_LANG>
			<DESC_ENG>Name (Thai)</DESC_ENG>
			<DESC_THAI> ()</DESC_THAI>
			<COMPONENT type="Text">
				<SIZE>15</SIZE>
				<MAXSIZE>30</MAXSIZE>
				<ALT_ENG>Name (Thai)</ALT_ENG>
				<ALT_THAI> ()</ALT_THAI>
				<REQUIRE>true</REQUIRE>
			</COMPONENT>
	</FNAME>
	<LNAME lang="T" encrypt="false" log="false" type="String">
			<WIDTH>40</WIDTH>
			<REFER_LANG>ELNAME</REFER_LANG>
			<DESC_ENG>Surname (Eng)</DESC_ENG>
			<DESC_THAI>ʡ ()</DESC_THAI>
			<COMPONENT type="Text">
				<SIZE>20</SIZE>
				<MAXSIZE>40</MAXSIZE>
				<ALT_ENG>Surame (Eng)</ALT_ENG>
				<ALT_THAI>ʡ ()</ALT_THAI>
			</COMPONENT>
	</LNAME>
	<EFNAME lang="E" encrypt="false" log="false" type="String">
			<WIDTH>30</WIDTH>
			<REFER_LANG>FNAME</REFER_LANG>
			<DESC_ENG>Name (Eng)</DESC_ENG>
			<DESC_THAI> (ѧ)</DESC_THAI>
			<COMPONENT type="Text">
				<SIZE>15</SIZE>
				<MAXSIZE>30</MAXSIZE>
				<ALT_ENG>Name (Eng)</ALT_ENG>
				<ALT_THAI> (ѧ)</ALT_THAI>
				<REQUIRE>true</REQUIRE>
			</COMPONENT>
	</EFNAME>
	<ELNAME lang="E" encrypt="false" log="false" type="String">
			<WIDTH>40</WIDTH>
			<REFER_LANG>LNAME</REFER_LANG>
			<DESC_ENG>Surname (Eng)</DESC_ENG>
			<DESC_THAI>ʡ (ѧ)</DESC_THAI>
			<COMPONENT type="Text">
				<SIZE>20</SIZE>
				<MAXSIZE>40</MAXSIZE>
				<ALT_ENG>Surame (Eng)</ALT_ENG>
				<ALT_THAI>ʡ (ѧ)</ALT_THAI>
			</COMPONENT>
	</ELNAME>
	<CRSID lang="A" encrypt="false" log="false" type="String">
				<WIDTH>15</WIDTH>
				<DESC_ENG>Course ID</DESC_ENG>
				<DESC_THAI>ѡٵ</DESC_THAI>
				<COMPONENT type="text">
					<MAXSIZE>10</MAXSIZE>
					<SIZE>12</SIZE>
					<ALT_ENG>Course ID</ALT_ENG>
					<ALT_THAI>ѡٵ </ALT_THAI>
				</COMPONENT>
	</CRSID>
	<CRSDESC lang="T" encrypt="false" log="false" type="String">
			<WIDTH>100</WIDTH>
			<DESC_ENG>Course</DESC_ENG>
			<DESC_THAI>ѡٵ</DESC_THAI>
			<COMPONENT type="text">
				<MAXSIZE>100</MAXSIZE>
				<SIZE>60</SIZE>
				<ALT_THAI>ѡٵ</ALT_THAI>
				<ALT_ENG>Course</ALT_ENG>
			</COMPONENT>
	</CRSDESC>
	<CLASSDATEFRM lang="A" encrypt="false" verify="false" log="false" type="Date">
			<WIDTH>10</WIDTH>
			<DESC_ENG>Training date</DESC_ENG>
			<DESC_THAI>ͺѹ</DESC_THAI>
			<COMPONENT type="text">
				<MAXSIZE>10</MAXSIZE>
				<SIZE>10</SIZE>
				<ALT_ENG>Training date</ALT_ENG>
				<ALT_THAI>ͺѹ</ALT_THAI>
			</COMPONENT>
	</CLASSDATEFRM>
	<CLASSDATETO lang="A" encrypt="false" verify="false" log="false" type="Date">
			<WIDTH>10</WIDTH>
			<DESC_ENG>Class Date To</DESC_ENG>
			<DESC_THAI>֧ѹ</DESC_THAI>
			<COMPONENT type="text">
				<MAXSIZE>10</MAXSIZE>
				<SIZE>10</SIZE>
				<ALT_ENG>Class Date To</ALT_ENG>
				<ALT_THAI>֧ѹ</ALT_THAI>
			</COMPONENT>
	</CLASSDATETO>
	<INCLASS_HOUR lang="A" encrypt="false" verify="false" log="false" type="Double" >
			<WIDTH>8</WIDTH>
			<DESC_ENG>Total hour</DESC_ENG>
			<DESC_THAI>ӹǹ</DESC_THAI>
			<COMPONENT type="text">
				<MAXSIZE>5</MAXSIZE>
				<SIZE>5</SIZE>
				<ALT_ENG>Total hour</ALT_ENG>
				<ALT_THAI>ӹǹ</ALT_THAI>
				<DEFAULTVALUE>0.00</DEFAULTVALUE>
			</COMPONENT>
	</INCLASS_HOUR>
	<BRANCH lang="A" encrypt="false" log="false" type="String">
			<WIDTH>5</WIDTH>
			<RELATION>MBRANCH</RELATION>
			<DESC_ENG>Company Branch</DESC_ENG>
			<DESC_THAI>Ң</DESC_THAI>
			<COMPONENT type="text">
				<MAXSIZE>5</MAXSIZE>
				<SIZE>5</SIZE>
				<ALT_ENG>Company Branch</ALT_ENG>
				<ALT_THAI>Ң</ALT_THAI>
			</COMPONENT>
	</BRANCH>
	<COMPANYID lang="A" encrypt="false" verify="false" log="false" type="String">
				<WIDTH>5</WIDTH>
				<RELATION />
				<DESC_ENG>Company ID</DESC_ENG>
				<DESC_THAI>ʺѷ</DESC_THAI>
				<COMPONENT type="text">
					<MAXSIZE>5</MAXSIZE>
					<SIZE>5</SIZE>
					<DISABLE>false</DISABLE>
					<ALT_THAI>ʺѷ</ALT_THAI>
					<ALT_ENG>Company ID</ALT_ENG>
				</COMPONENT>
	</COMPANYID>
</FIELD>
	<RELATION>
		<MEMPLOYEE>
			<PARENT>VW_HTRAINTRNEE_YEAR.TRAINEEID</PARENT>
			<PARENT>VW_HTRAINTRNEE_YEAR.COMPANYID</PARENT>
			<CHILD>MEMPLOYEE.EMPLOYEEID</CHILD>
			<CHILD>MEMPLOYEE.COMPANYID</CHILD>
		</MEMPLOYEE>
		<HTRAINTRNEE>
			<PARENT>VW_HTRAINTRNEE_YEAR.TRAININGID</PARENT>
			<PARENT>VW_HTRAINTRNEE_YEAR.TRAINEEID</PARENT>
			<PARENT>VW_HTRAINTRNEE_YEAR.COMPANYID</PARENT>
			<CHILD>HTRAINTRNEE.TRAININGID</CHILD>
			<CHILD>HTRAINTRNEE.TRAINEEID</CHILD>
			<CHILD>HTRAINTRNEE.COMPANYID</CHILD>
		</HTRAINTRNEE>
		<MPREFIX>
			<PARENT>VW_HTRAINTRNEE_YEAR.EMP_PREFIX</PARENT>
			<CHILD>MPREFIX.PREFIXID</CHILD>
		</MPREFIX>
		<MBRANCH>
			<PARENT>VW_HTRAINTRNEE_YEAR.BRANCH</PARENT>
			<PARENT>VW_HTRAINTRNEE_YEAR.COMPANYID</PARENT>
			<CHILD>MBRANCH.BRANCHID</CHILD>
			<CHILD>MBRANCH.COMPANYID</CHILD>
		</MBRANCH>
	</RELATION>
</VW_HTRAINTRNEE_YEAR>