EMPL Structure
From CrossRoad
Revision as of 03:09, 16 September 2009 by WikiSysop (talk | contribs) (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...)
| FieldName | Data Type | Length | Decimals | Picture | Caption | Description | HelpContext | Name |
|---|---|---|---|---|---|---|---|---|
| SURNAME | C | 20 | 0 | @! XXXXXXXXXXXXXXXXXXXX | Surname | Family Name of this individual | SURNAME | |
| FNAME | C | 15 | 0 | @! XXXXXXXXXXXXXXX | First Name | First or Given name for this individual | FNAME | |
| ADDR1 | C | 60 | 0 | @! | Address | Address | ADDREMG | |
| CITY | C | 20 | 0 | @! XXXXXXXXXXXXXXXXXXXX | City | City or Town | CHURLCCITY | |
| PROV | C | 2 | 0 | !! | Province | Province or State | PROVLOC | |
| PCODE | C | 9 | 0 | @! | PostalCode | Postal or Zip Code | PCODELOC | |
| ENTCODE | N | 5 | 0 | 99999 | File # | Application File Number | ENTCODE | |
| FORCEEXP | L | 1 | 0 | Forceexp | EMPL_forceexp | FORCEEXP | ||
| PHONE | C | 10 | 0 | Phone | EMPL_phone | PHONE | ||
| FAX | C | 10 | 0 | Fax | EMPL_fax | FAX | ||
| CONTACT | C | 20 | 0 | Contact | EMPL_contact | CONTACT | ||
| EMPLID | C | 12 | 0 | Emplid | Employee ID (From AccPac) | EMPL_EMPLID | EMPLID | |
| EXTENSION | C | 4 | 0 | Extension | EMPL_extension | EXTENSION | ||
| DEPARTMENT | C | 20 | 0 | Department | EMPL_department | DEPARTMENT | ||
| ROOM | C | 6 | 0 | Room | EMPL_room | ROOM | ||
| NEWENT | N | 5 | 0 | NEWENT | NEWENT | |||
| C | 50 | 0 | Home Email | Home email for this employee | EMPL_email |
