Version 8.1.4
 —  Utilities  —

Adabas Personnel Demo File

Here is the FDT of the Personnel demo file distributed with Adabas. Other demo files distributed with Adabas include an Employees demo file, a Vehicle demo file, and a Miscellaneous demo file. The Personnel demo file includes data that makes use of the expanded features provided in Adabas 8, such as large object support. Associated with the Personnel demo file is a new LOB demo file, containing the LOB data referenced by the Personnel demo file. During installation, the LOB demo file is loaded in the same job used to load the Personnel demo file.

Note:
The Personnel demo file must be installed on a UES-enabled database because it includes wide-character format (W) fields.

1,A0                          personnel-data
2,AA,8,A,DE,UQ                personnel-id
2,AB                          id-data
3,AC,4,F,DE                   personnel-no !UQ taken!
3,AD,8,B,NU                   id-card
3,AE,0,A,LA,NU,NV,NB          signature
1,B0                          full-name
2,BA,40,W,NU                  first-name
2,BB,40,W,NU                  middle-name
2,BC,50,W,NU,DE               name
1,CA,1,A,FI                   mar-stat
1,DA,1,A,FI                   sex
1,ES,2,B,NU                   birth
1,EA,4,P,DE,NC                birth
1,F0,PE                       full-address
2,FA,60,W,NU,MU               address-line
2,FB,40,W,DE,NU               city
2,FC,10,A,NU                  post-code
2,FD,3,A,NU                   country
2,F1                          phone-numbers
3,FE,6,A,NU                   area-code
3,FF,15,A,NU                  home-phone
3,FG,15,A,NU                  home-fax
3,FH,15,A,NU                  private-mobile
3,FI,80,A,NU,MU,DE            private-email
1,I0,PE                       business-address
2,IA,40,W,NU,MU               address-line
2,IB,40,W,DE,NU               city
2,IC,10,A,NU                  post-code
2,ID,3,A,NU                   country
2,IE,5,A,NU                   room number
2,I1                          telephone
3,IF,6,A,NU                   area-code
3,IG,15,A,NU                  business-phone
3,IH,15,A,NU                  business-fax
3,II,15,A,NU                  business-mobile
3,IJ,80,A,NU,MU,DE            business-email
1,JA,6,A,DE                   dept
1,KA,66,W,DE,NU               job-title
1,L0,PE                       income
2,LA,3,A,NU                   curr-code
2,LB,6,P,NU                   salary P9.2
2,LC,6,P,NU,MU,DE             bonus P9.2
1,MA,4,G,NU                   total income (EUR)
1,N0                          leave-date
2,NA,2,U                      leave-due
2,NB,3,U,NU                   leave-taken N2.1
1,O0,PE                       leave-booked
2,OA,8,U,NU                   leave-start
2,OB,8,U,NU                   leave-end
1,PA,3,A,DE,NU,MU             language
1,QA,7,P                      last update (*TIMX)
1,RA,0,A,LB,NU,NV,NB          picture
1,S0,PE                       documents
2,SA,80,W,NU                  document-description
2,SB,3,A,NU                   document-type
2,SC,0,A,LB,NU,NV,NB,MU       document


H1=NA(1,2),NB(1,3)
S1=JA(1,2)
S2=JA(1,6),BC(1,40)
S3=LA(1,3),LB(1,6)

Top of page