Appendix B - File Definition For Example Programs

This file definition is used for the following example program.

1    ,  A0                                ; Personnel data
  2   ,  AA ,   8 ,    A  , DE,UQ         ; Personnel ID
  2   ,  AB                               ; ID data
   3   ,  AC ,   4 ,    F  , DE           ; Personnel no.
   3   ,  AD ,   8 ,    B  , NU,HF        ; 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            ; Maritial status
 1    ,  DA ,   1 ,    A  , FI            ; Sex
 1    ,  EA ,   4 ,    P  , DE,NC         ; Birth
 1    ,  F0 ,               PE            ; Private 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 email
   3   , FE ,   6 ,    A  , NU            ; Area code   
   3  ,  FF,   15 ,    A  , NU            ; Private phone
   3  ,  FG ,  15 ,    A  , NU            ; Private 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                               ; Phone email
   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            ; Department
 1    ,  KA ,  66 ,    W  , DE,NU         ; Job title
 1    ,  L0               , PE            ; Income
  2   ,  LA ,   3 ,    A  , NU            ; Currency code
  2   ,  LB ,   6 ,    P  , NU            ; Salary
  2   ,  LC ,   6 ,    P  , NU,MU,DE      ; Bonus
 1    ,  MA ,   4 ,    G  , NU            ; Total income
 1    ,  N0                               ; Leave data
  2   ,  NA ,   2 ,    U                  ; Leave due
  2   ,  NB ,   3 ,    U  , NU            ; Leave taken
 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
 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

CN,HE=COLLATING(BC,'de__PHONEBOOK',PRIMARY)
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)