Table EMPLOID
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| EMPLOID | ID | Civil status | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| ID0 | REFNUM | No | |
| ID1 | NAM+REFNUM | No | |
| ID2 | FCY+SRV+REFNUM | No | |
| ID3 | CPY+FCY+SRV+REFNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADD1 | Address | ADL | ||||||
| ADD2 | Address | ADL | ||||||
| ADD3 | Address | ADL | ||||||
| ADT | Dependent adult(s) | C | 2 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BDFECOCOD | Economic reason | ADI | [ADI]CODE=309;BDFECOCOD | Block | ||||
| CHD | Dependent child(ren) | C | 2 | |||||
| CIV | Title | C | 2 | |||||
| CODACS | Access code | ACS | [ACS]ACS0=[ID]CODACS | Block | ||||
| CODPOS | Postal code | POS | ||||||
| CODSEE | Municipality code | A | 5 | |||||
| CODUE | EU coding | C | 4 | KFR | ||||
| CPY | Company | CPY | [CPY]CPY0=[ID]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[ID]CRY | Block | ||||
| CRYBRN | Country of birth | CRY | [TCY]TCY0=[ID]CRYBRN | Block | ||||
| CRYNAM | Country name | NCY | ||||||
| CRYNAMBRN | Name country birth | NCY | ||||||
| CTY | City | CTY | ||||||
| CTYBRN | Birth town | A | 30 | |||||
| CTYBRNSEE | Municipality code | A | 5 | |||||
| DATBRN | Birth date | D | ||||||
| DEPBRN | Department | A | 2 | |||||
| EML | A | 50 | ||||||
| EMLCNT | 3 | A | 50 | |||||
| ENAFLG | Active | M | 4 | 1 | ||||
| EXPNUM | Export number | L | 8 | |||||
| FAX | Fax | TEL | ||||||
| FCY | Site | FCY | [FCY]FCY0=[ID]FCY | Block | ||||
| FCYORI | Initial site | FCY | [FCY]FCY0=[ID]FCYORI | Block | ||||
| FLGBULDEM | Paperless payslip | C | 4 | DEMAT | ||||
| FLGEML | Email transmission | M | 4 | 1 | ||||
| FLGINT | Casual worker | M | 4 | 1 | ||||
| FLGMULCTR | Multi-contracts | M | 4 | 1 | ||||
| FLGNEWSAL | Temporary employee | M | 4 | 1 | ||||
| FLGPAY | Payroll mgmt | M | 4 | 1 | PAY | |||
| FLGTEL | Ex-directory | M | 4 | 1 | ||||
| FLGTPS | Time management | M | 4 | 1 | ||||
| JNTDATBRN | Born | D | ||||||
| JNTNAM | Spouse's name | A | 40 | |||||
| JNTREFNUM | Spouse's registration number | MAT | [ID]ID0=[ID]JNTREFNUM | RTZ | ||||
| JNTSRN | First name | A | 20 | |||||
| JNTTEL | Telephone | TEL | ||||||
| MOB | Mobile phone | TEL | ||||||
| MOBCNT | Mobile phone | 3 | TEL | |||||
| NAM | Name | A | 40 | |||||
| NAMCNT | Contact name | 3 | NAM | |||||
| NBCNT | Number | C | 4 | |||||
| NBRCHD | No. of children | C | 4 | |||||
| NBRCTR | No. of contracts | C | 4 | |||||
| NBREXM | No. | C | 4 | |||||
| NBRHAB | No. | C | 4 | |||||
| NBRJNT | Number | C | 4 | JNT | ||||
| NBRPOT | No. | C | 4 | CAR | ||||
| NBRRIB | Bank ID no. | C | 4 | PAY | ||||
| NBRSAL | No. | C | 4 | PAY | ||||
| NBRTRY | No. | C | 4 | |||||
| NBRVIS | No. | C | 4 | PAY | ||||
| NCKNAM | Initials | A | 5 | |||||
| NTT | Nationality | CRY | [TCY]TCY0=[ID]NTT | Block | ||||
| NTTNAM | Nationality | NCY | ||||||
| NUMCCS | Entertainment Fund no. | A | 10 | FINTM | ||||
| NUMSSC | Social Security | SSE | ||||||
| OLDNAM | Birth name | A | 40 | |||||
| PRF | Profile | PRF | [PRF]PRF0=[ID]PRF | Block | ||||
| PSD | Known as | NAM | ||||||
| REFNUM | Employee ID | MAT | [ID]ID0=[ID]REFNUM | Delete | ||||
| SEX | Individual's gender | M | 15 | 314 | ||||
| SITFAM | Marital status | C | 2 | |||||
| SRN | Employee's first name | A | 40 | |||||
| SRNCNT | First name | 3 | NAM | |||||
| SRV | Department | SRV | [SRV]SRV0=[ID]SRV | Block | ||||
| TEL | Telephone | TEL | ||||||
| TELCNT | Telephone | 3 | TEL | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 |