https://registry.kingsu.ca/mediawiki/index.php?action=history&feed=atom&title=EMPL_StructureEMPL Structure - Revision history2026-04-19T17:45:34ZRevision history for this page on the wikiMediaWiki 1.27.0https://registry.kingsu.ca/mediawiki/index.php?title=EMPL_Structure&diff=313&oldid=prevWikiSysop: New page: <table border><Caption>EMPL</caption> <tr><th>FieldName</th><th>Data Type</th><th>Length</th><th>Decimals</th><th>Picture</th><th>Caption</th><th>Description</th><th>HelpContext</th><th>Na...2009-09-16T03:09:28Z<p>New page: <table border><Caption>EMPL</caption> <tr><th>FieldName</th><th>Data Type</th><th>Length</th><th>Decimals</th><th>Picture</th><th>Caption</th><th>Description</th><th>HelpContext</th><th>Na...</p>
<p><b>New page</b></p><div><table border><Caption>EMPL</caption><br />
<tr><th>FieldName</th><th>Data Type</th><th>Length</th><th>Decimals</th><th>Picture</th><th>Caption</th><th>Description</th><th>HelpContext</th><th>Name</th></tr><tr><td><b><i>SURNAME</i></b></td><td>C</td><td>20</td><td>0</td><td>@! XXXXXXXXXXXXXXXXXXXX</td><td>Surname</td><td>Family Name of this individual</td><td></td><td>SURNAME</td></tr><br />
<tr><td><b><i>FNAME</i></b></td><td>C</td><td>15</td><td>0</td><td>@! XXXXXXXXXXXXXXX</td><td>First Name</td><td>First or Given name for this individual</td><td></td><td>FNAME</td></tr><br />
<tr><td><b><i>ADDR1</i></b></td><td>C</td><td>60</td><td>0</td><td>@! </td><td>Address</td><td>Address</td><td></td><td>ADDREMG</td></tr><br />
<tr><td><b><i>CITY</i></b></td><td>C</td><td>20</td><td>0</td><td>@! XXXXXXXXXXXXXXXXXXXX</td><td>City</td><td>City or Town</td><td></td><td>CHURLCCITY</td></tr><br />
<tr><td><b><i>PROV</i></b></td><td>C</td><td>2</td><td>0</td><td>!!</td><td>Province</td><td>Province or State</td><td></td><td>PROVLOC</td></tr><br />
<tr><td><b><i>PCODE</i></b></td><td>C</td><td>9</td><td>0</td><td>@!</td><td>PostalCode</td><td>Postal or Zip Code</td><td></td><td>PCODELOC</td></tr><br />
<tr><td><b><i>ENTCODE</i></b></td><td>N</td><td>5</td><td>0</td><td>99999</td><td>File #</td><td>Application File Number</td><td></td><td>ENTCODE</td></tr><br />
<tr><td><b><i>FORCEEXP</i></b></td><td>L</td><td>1</td><td>0</td><td></td><td>Forceexp</td><td></td><td>EMPL_forceexp</td><td>FORCEEXP</td></tr><br />
<tr><td><b><i>PHONE</i></b></td><td>C</td><td>10</td><td>0</td><td></td><td>Phone</td><td></td><td>EMPL_phone</td><td>PHONE</td></tr><br />
<tr><td><b><i>FAX</i></b></td><td>C</td><td>10</td><td>0</td><td></td><td>Fax</td><td></td><td>EMPL_fax</td><td>FAX</td></tr><br />
<tr><td><b><i>CONTACT</i></b></td><td>C</td><td>20</td><td>0</td><td></td><td>Contact</td><td></td><td>EMPL_contact</td><td>CONTACT</td></tr><br />
<tr><td><b><i>EMPLID</i></b></td><td>C</td><td>12</td><td>0</td><td></td><td>Emplid</td><td>Employee ID (From AccPac)</td><td>EMPL_EMPLID</td><td>EMPLID</td></tr><br />
<tr><td><b><i>EXTENSION</i></b></td><td>C</td><td>4</td><td>0</td><td></td><td>Extension</td><td></td><td>EMPL_extension</td><td>EXTENSION</td></tr><br />
<tr><td><b><i>DEPARTMENT</i></b></td><td>C</td><td>20</td><td>0</td><td></td><td>Department</td><td></td><td>EMPL_department</td><td>DEPARTMENT</td></tr><br />
<tr><td><b><i>ROOM</i></b></td><td>C</td><td>6</td><td>0</td><td></td><td>Room</td><td></td><td>EMPL_room</td><td>ROOM</td></tr><br />
<tr><td><b><i>NEWENT</i></b></td><td>N</td><td>5</td><td>0</td><td></td><td>NEWENT</td><td> </td><td></td><td>NEWENT</td></tr><br />
<tr><td><b><i>EMAIL</i></b></td><td>C</td><td>50</td><td>0</td><td></td><td>Home Email</td><td>Home email for this employee</td><td>EMPL_email</td><td>EMAIL</td></tr><br />
</table></div>WikiSysop