| DB | Areas | X-idx | Tables | Sequences | <- prs-applcrse | prs-applqual -> | HtmlDict 11 |
Applicants for vacant posts
| Area | FinData |
|---|---|
| Dumpname | applican |
| Label | Applicants for vacant posts |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 10 | appl-no | X | Applicant No | integer | >>>>>9 | 0 | ||
| 150 | appl-race | X | Race | character | x(2) | 0 | ||
| 140 | appl-sex | X | Gender | logical | Male/Female | NO | ||
| 170 | birth-date | X | Birth Date | date | 99/99/9999 | ? | ||
| 100 | cell-no | X | Cell No | character | x(15) | |||
| 180 | curr-emplr | X | Current Employer | character | x(30) | |||
| 20 | first-name | X | First Name | character | x(12) | |||
| 50 | home-addr | X | Home Address | character [2] | x(24) | |||
| 70 | home-city | X | Home City | character | x(24) | |||
| 80 | home-post-cde | X | Postal Code | character | 9999 | |||
| 60 | home-suburb | X | Home Suburb | character | x(24) | |||
| 90 | home-tel-no | X | Home Tel No | character | x(20) | |||
| 40 | initials | X | Initials | character | x(10) | |||
| 160 | national | X | Nationality | character | x(3) | |||
| 120 | ref-name | X | Reference Name | character [3] | x(25) | |||
| 130 | ref-tel | X | Reference Telephone | character [3] | x(11) | |||
| 30 | surname | X | Surname | character | x(50) | |||
| 190 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 210 | upd-time | X | At | integer | 99999 | 0 | ||
| 200 | upd-user-id | X | By | character | x(12) | |||
| 110 | work-tel-no | X | Work Tel No | character | x(20) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| applicant | P U | appl-no (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| inv-combocom inv-comboitem |
| Child tables |
|---|
| prs-applcrse prs-applqual prs-applskill prs-apply |
| generated 18-9-2026 10:03 |