Table DPERSOID
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| DPERSOID | DPI | Personal file | Common Data | PRH |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DPI0 | REFNUM+DEM | No | |
| DPI1 | STA+REFNUM+DEM | No | |
| DPI2 | FNC+REFNUM+DEM | 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 | ||||||
| CHD | Dependent child(ren) | C | 2 | |||||
| CIV | Title | M | 15 | 231 | ||||
| CODPOS | Postal code | POS | ||||||
| CODSEE | Municipality code | A | 5 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[DPI]CRY | Block | ||||
| CRYBRN | Country of birth | CRY | [TCY]TCY0=[DPI]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 | ||||||
| DEM | Request no. | L | 8 | |||||
| DEPBRN | Department | A | 2 | |||||
| EML | A | 50 | ||||||
| EMLCNT | 3 | A | 50 | |||||
| FAX | Fax | TEL | ||||||
| FLGBULDEM | Paperless payslip | C | 4 | DEMAT | ||||
| FLGTEL | Ex-directory | M | 4 | 1 | ||||
| FNC | Portal function | M | 15 | 745 | ||||
| FREEZON1 | Free field (1) | A | 20 | |||||
| FREEZON10 | Free field (10) | A | 20 | |||||
| FREEZON11 | Free field (11) | A | 20 | |||||
| FREEZON12 | Free field (12) | A | 20 | |||||
| FREEZON13 | Free field (13) | A | 20 | |||||
| FREEZON14 | Free field (14) | A | 20 | |||||
| FREEZON15 | Free field (15) | A | 20 | |||||
| FREEZON16 | Free field (16) | A | 20 | |||||
| FREEZON17 | Free field (17) | A | 20 | |||||
| FREEZON18 | Free field (18) | A | 20 | |||||
| FREEZON19 | Free field (19) | A | 20 | |||||
| FREEZON2 | Free field (2) | A | 20 | |||||
| FREEZON20 | Free field (20) | A | 20 | |||||
| FREEZON21 | Free field (21) | A | 20 | |||||
| FREEZON22 | Free field (22) | A | 20 | |||||
| FREEZON23 | Free field (23) | A | 20 | |||||
| FREEZON24 | Free field (24) | A | 20 | |||||
| FREEZON25 | Free field (25) | A | 20 | |||||
| FREEZON26 | Free field (26) | A | 20 | |||||
| FREEZON27 | Free field (27) | A | 20 | |||||
| FREEZON28 | Free field (28) | A | 20 | |||||
| FREEZON29 | Free field (29) | A | 20 | |||||
| FREEZON3 | Free field (3) | A | 20 | |||||
| FREEZON30 | Free field (30) | A | 20 | |||||
| FREEZON4 | Free field (4) | A | 20 | |||||
| FREEZON5 | Free field (5) | A | 20 | |||||
| FREEZON6 | Free field (6) | A | 20 | |||||
| FREEZON7 | Free field (7) | A | 20 | |||||
| FREEZON8 | Free field (8) | A | 20 | |||||
| FREEZON9 | Free field (9) | A | 20 | |||||
| JNTDATBRN | Born | 10 | D | |||||
| JNTNAM | Spouse's name | 10 | A | 40 | ||||
| JNTREFNUM | Spouse's registration number | 10 | A | 15 | ||||
| JNTSRN | First name | 10 | A | 20 | ||||
| JNTTEL | Telephone | 10 | TEL | |||||
| MOB | Mobile phone | TEL | ||||||
| MOBCNT | Mobile phone | 3 | TEL | |||||
| NAM | Name | A | 40 | |||||
| NAMCNT | Contact name | 3 | NAM | |||||
| NBCNT | Number | C | 4 | |||||
| NBRJNT | Number | C | 4 | |||||
| NTT | Nationality | CRY | [TCY]TCY0=[DPI]NTT | Block | ||||
| NTTNAM | Nationality | NCY | ||||||
| NUMSSC | Social Security | SSE | ||||||
| OLDNAM | Birth name | A | 40 | |||||
| REFNUM | Employee ID | MAT | [ID]ID0=[DPI]REFNUM | Delete | ||||
| SITFAM | Marital status | 10 | C | 2 | ||||
| SRN | Employee's first name | A | 40 | |||||
| SRNCNT | First name | 3 | NAM | |||||
| STA | Tracking | M | 15 | 743 | ||||
| TEL | Telephone | TEL | ||||||
| TELCNT | Telephone | 3 | TEL | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 |