| DB | Areas | X-idx | Tables | Sequences | <- prs-ccshift | prs-clerk -> | HtmlDict 11 |
Personnel Code tables
| Area | FinData |
|---|---|
| Dumpname | prs-cdet |
| Label | Personnel Code tables |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 20 | cde | X | Code | character | x(8) | |||
| 10 | cde-type | X | Code Type | integer | >>9 | 0 | ||
| 50 | cde-usage | X | Code Usage | character | x(8) | |||
| 40 | disp-desc | X | Display Desc | character | x(15) | |||
| 80 | fld-format | X | Format | character | x(10) | |||
| 60 | prog-name | X | Program Name | character | x(10) | |||
| 30 | short-desc | X | Description | character | x(30) | |||
| 70 | sys-tab-ind | X | System Table Ind | logical | Yes/No | No |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| cde-type-cde | P U | cde-type (+) | integer |
| cde (+) | character | ||
| cde-type-desc | cde-type (+) | integer | |
| short-desc (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| ins-control |
| Child tables |
|---|
| acp-cdetab acr-cdetab acs-cdetab asr-cdetab cbk-cdetab coe-cdetab fra-cdetab glr-cdetab ins-cdetab inv-imcde lsc-cdetab lve-cdetab pmm-cdetab pur-cdetab sal-cdetab sys-cdetab |
| generated 18-9-2026 10:03 |