| DB | Areas | X-idx | Tables | Sequences | <- prs-skill | prs-subject -> | HtmlDict 11 |
Employee Spouse Detail
| Area | FinData |
|---|---|
| Dumpname | spouse |
| Label | Employee Spouse Detail |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 40 | birth-date | X | Birth Date | date | 99/99/9999 | ? | ||
| 130 | cell-no | X | Cell No | character | x(15) | |||
| 135 | X | character | x(24) | |||||
| 10 | emp-no | X | Employee No | character | x(8) | |||
| 75 | emplr-name | X | Employer Name | character | x(30) | |||
| 30 | end-date | X | End Date | date | 99/99/9999 | ? | ||
| 45 | first-name | X | First Name | character | x(12) | |||
| 50 | full-name | X | Full Name | character [5] | x(15) | |||
| 60 | id-no | X | Id No | character | x(13) | |||
| 70 | maiden-name | X | Maiden Name | character | x(20) | |||
| 20 | mar-date | X | Maritial Date | date | 99/99/9999 | ? | ||
| 150 | med-depend | X | Medical Dependend | logical | Yes/No | NO | ||
| 140 | med-scheme | X | Medical Scheme | character | x(30) | |||
| 110 | post-cde | X | Postal Code | character | 9999 | |||
| 180 | spouse-emp-no | X | Spous Emp No | character | x(8) | |||
| 170 | spouse-stat | X | Spouse Status | character | x(2) | |||
| 160 | tax-depend | X | Tax Dependend | logical | Yes/No | NO | ||
| 190 | tax-no | X | Tax Reg No | character | x(15) | |||
| 120 | tel-no | X | Tel No | character | x(20) | |||
| 80 | work-addr | X | Address | character [2] | x(24) | |||
| 100 | work-city | X | Work City | character | x(24) | |||
| 90 | work-suburb | X | Work Suburb | character | x(24) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| emp-no | P | emp-no (+) | character |
| mar-date (+) | date | ||
| spouse-emp-no | spouse-emp-no (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| prs-employee |
| generated 24-6-2026 08:26 |