LEGEND:

REQ
O = optional
M = mandatory
P = pair required
C = conditional
SM
S = single valued
M = multiple values
A = associated (array member)
COLUMN NAME (not case specific)
TYPE
A = alpha
N.n = numeric with decimals
B = boolean
D = datetime
U = UUID
LC = list of codes
SK = key sequence
S = sequence
U Key values and codes are uppercase
VALIDATE
links refer to code validation lists
Tablenames (uppercase) refer to verifiles
(‘values’) list allowed entries
DEFAULT a value default
JUST
Justify (L)eft, (C)enter, (R)ight, (T)ext
n = characters to show

Note

  1. Entries of type list code (TYPE=LC) are validated against the associated linked code option list.
  2. Entries with a paired requirement (REQ=P) are required when the associated paired entry or code is specified.