Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
Reality V15.0 ()
PERSONNEL File (SQL) (m6915af_.htm)
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.