This topic lists the contents of the Reality file that is used in the examples in Table/Column Definition Design.
The format of the PERSONNEL data is:
| Attribute | Description |
|---|---|
| 0 | Item id |
| 1 | Title |
| 2 | Forenames |
| 3 | Surname |
| 4 | Address |
| 5 | Qualifications |
| 6 | Qualification date |
| 7 | Qualification company |
| 8 | Post date |
| 9 | Post company code |
| 10 | Post department code |
| 11 | Post pay point |
PERSONNEL holds the following data:
1 001 MR 002 MARK]ROBERT 003 ROBINSON 004 1 HIGHT STREET]STEVENAGE]SG4 1RE 005 MCSE]INTRODUCTION TO IMPROMPTU 006 11110]11182 007 MICROSOFT]COGNOS 008 10959]9951 009 AC1]RE2 010 10166]10023 011 P12]P54
2 001 MISS 002 RACHAEL]LOUISE 003 HOUSE 004 8 CHARLTON COTTAGES]LETCHWORTH]HERTS]SG6 7YT 005 IMPROMPTU ADMINISTRATOR 006 11118 007 COGNOS 008 10745 009 RE2 010 10023 011 P54
3 001 MR 002 SAMUEL]GEORGE 003 BROOKES 005 006 007 008 11272 009 AC1 010 10166 011 P12
:SORT DICT PERSONNEL *AO *Al *A2 *A3 *A4 *A5 *A6 *A7 *A8 *A9 *A1Odisplays the following listing of PERSONNEL data definition items:
PERSONNEL : ADDRESS *A0 ADDRESS *Al A *A2 4 *A3 ADDRESS *A9 L *Al0 50
PERSONNEL : ADDRESS.LINE1 *A0 ADDRESS.LINE1 *Al A *A2 4 *A3 ADDRESS LINE 1 *A8 A;(0)(TPERSONNEL;X1;4;4) *A9 L *Al0 30
PERSONNEL : ADDRESS.LINE2 *A0 ADDRESS.LINE2 *Al A *A2 4 *A3 ADDRESS LINE 2 *A8 A;(0)(TPERSONNEL;X2;4;4) *A9 L *Al0 30
PERSONNEL : ADDRESS.LINE3 *A0 ADDRESS.LINE3 *Al A A2 4 *A3 ADDRESS LINE 3 *A8 A;(0)(TPERSONNEL;X3;4;4) *A9 L *Al0 30
PERSONNEL : ADDRESS.LINE4 *A0 ADDRESS.LINE4 *Al A *A2 4 *A3 ADDRESS LINE 4 *A8 A;(0)(TPERSONNEL;X4;4;4) *A9 L *Al0 30
PERSONNEL : ADDRESS.LINE5 *A0 ADDRESS.LINE5 *Al A *A2 4 *A3 ADDRESS LINE 5 *A8 A;(0)(TPERSONNEL;X5;4;4) *A9 L *A10 30
PERSONNEL : ADDRESS.LINE6 *A0 ADDRESS.LINE6 *Al A *A2 4 *A3 ADDRESS LINE 6 *A8 A;(0)(TPERSONNEL;X6;4;4) *A9 L *Al0 30
PERSONNEL : FORENAMES *A0 FORENAMES *Al A *A2 0 *A3 F0RENAMES *A8 A;(0)(TPERSONNEL;X: ;2;2) *A9 L *Al0 20
PERSONNEL : FULL.ADDRESS *A0 FULL.ADDRESS *Al A *A2 4 *A3 FULL ADDRESS *A8 A;(0)(TPERSONNEL;X:,;4;4) *A9 L *Al 0 100
PERSONNEL : FULL.NAME *A0 FULL.NAME *Al A *A2 0 *A3 FULL NAME *A8 A;1:" ":N(FORENAMES): *A9 L *Al0 30
PERSONNEL : PERSON.ID *A0 PERSON.ID *Al A *A2 0 *A3 PERSON ID *A9 L *Al0 10
PERSONNEL : POST.CO *A0 POST.CO *Al A *A2 9 *A3 CO *A9 L *Al0 10
PERSONNEL : POST.CO.DESC *A0 POST.CO.DESC *Al A *A2 9 *A3 CO DESC *A8 A;((9)(TTCCO;X;1;1)) *A9 L *Al0 20
PERSONNEL : POST.DATE *A0 POST.DATE *Al A *A2 8 *A3 POST DATE *A7 D2 *A9 L *A10 10
PERSONNEL : POST.DEPT *A0 POST.DEPT *Al A *A2 10 *A3 DEPT *A9 L *Al0 10
PERSONNEL : POST.DEPT.DESC *A0 POST.DEPT.DESC *Al A *A2 10 *A3 DEPT DESC *A8 A;((10)(TTCDEPT;X;1;1)) *A9 L *Al0 20
PERSONNEL : POST.NO *A0 POST.NO *Al A *A2 8 *A3 POST NUMBER *A8 A;NV:((8)(T0,0)) *A9 L *Al0 10
PERSONNEL : POST.POINT *A0 POST.POINT *Al A *A2 11 *A3 PAY POINT *A9 L *Al0 10
PERSONNEL : POST.POINT.DESC *A0 POST.POINT.DESC *Al A *A2 11 *A3 PAY POINT DESC *A8 A;((11)(TTCPOINT;X;1;1)) *A9 L *Al0 20
PERSONNEL : QUAL.CO *A0 QUAL.CO *Al A *A2 7 *A3 QUAL CO *A9 L *A10 20
PERSONNEL : QUAL.DATE *A0 QUAL.DATE *Al A *A2 6 *A3 QUAL DATE *A7 D2 *A9 L *Al0 10
PERSONNEL : QUAL.NO *A0 QUAL.NO *Al A *A2 5 *A3 QUAL NUMBER *A8 A;NV:((5)(T0,0)) *A9 L *Al0 10
PERSONNEL : QUALS *A0 QUALS *AI A *A2 5 *A3 QUALIFICATIONS *A9 L *Al0 30
PERSONNEL : STARTER.FLAG *A0 STARTER.FLAG *A1 A *A2 0 *A3 STARTER (Y/N) *A8 A;IF (((0)(TTCSTARTERS;X;0;0)) # "") THEN "Y" ELSE "N" *A9 L *Al0 10
PERSONNEL : SURNAME *A0 SURNAME *Al A *A2 3 *A3 SURNAME *A9 L *Al0 20
PERSONNEL : PERSONNEL *A0 PERSONNEL *AI DL *A2 3444955,1,122 *A3 B3 1,1 *A9 L *Al0 10
PERSONNEL : TITLE *A0 TITLE *AI A *A2 1 *A3 TITLE *A9 L *Al0 10
27 Items listed.