Table EMPLOIDMID
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| EMPLOIDMID | EMID | Additional Middle east fields | Common Data | KMIEA |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| EMID0 | REFNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AGNID | Agent | A | 9 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BLDGRP | Blood group | M | 15 | 11733 | ||||
| BUSTEL | Office number | TEL | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[EMID]CREUSR | Other | ||||
| CRYBRNMID | Country of birth | 10 | CRY | [TCY]TCY0=[EMID]CRYBRNMID | Block | |||
| EXPDATMID | Expiry date | 10 | D | |||||
| GUACPY | Company | 10 | A | 25 | ||||
| GUAEMPDAT | Employment date | 10 | D | |||||
| GUANAM | Name | 10 | A | 20 | ||||
| GUAPOT | Position | 10 | A | 20 | ||||
| GUARES | Address | 10 | A | 30 | ||||
| ISSAUZMID | Issuing authority | 10 | A | 40 | ||||
| MIDCNTCDE | Country code | 5 | CRY | [TCY]TCY0=[EMID]MIDCNTCDE | Block | |||
| MIDCOR | Set as default | 5 | M | 2 | 1 | |||
| MIDCPX | Complex | 5 | A | 50 | ||||
| MIDPOSAGN | Postal agency | 5 | A | 21 | ||||
| MIDPOSCDE | Postal code | 5 | A | 10 | ||||
| MIDPOSCOF | Care of postal address | 5 | M | 2 | 1 | |||
| MIDPOSINM | Care of intermediary | 5 | A | 21 | ||||
| MIDPOSNAM | Post office name | 5 | A | 22 | ||||
| MIDPOSNUM | Unit/postal number | 5 | A | 10 | ||||
| MIDPOSOTH | Other PO spec serv | 5 | A | 21 | ||||
| MIDPRI | Priority | 5 | C | 1 | ||||
| MIDPRV | Province | 5 | SAT | |||||
| MIDSRVTYP | Service type | 5 | M | 32 | 11652 | |||
| MIDSTA | Active | 5 | M | 4 | 1 | |||
| MIDSTRNAM | Street | 5 | A | 50 | ||||
| MIDSTRNUM | Street number | 5 | A | 10 | ||||
| MIDSUB | Suburb/District | 5 | A | 50 | ||||
| MIDTWN | City | 5 | A | 35 | ||||
| MIDTYP | Type | 5 | M | 12 | 11735 | |||
| NBRGUA | Counter | C | 4 | |||||
| NBRMID | Counter | C | 4 | |||||
| NBRPASMID | Counter | C | 4 | |||||
| PASCRYMID | Country | 10 | CRY | [TCY]TCY0=[EMID]PASCRYMID | Block | |||
| PASDTEMID | Date | 10 | D | |||||
| PASNUMMID | Number | 10 | A | 20 | ||||
| PLCISSMID | Place of issue | 10 | A | 30 | ||||
| REFNUM | Employee ID | MAT | [ID]ID0=[EMID]REFNUM | Delete | ||||
| REL | Religion | A | 30 | |||||
| SECNAM | Second name | A | 20 | |||||
| SPODET | Sponsor details | A | 75 | |||||
| SPOTYPEMP | Type | M | 12 | 11741 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[EMID]UPDUSR | Other |