CALENDARS Data Table ColumnsΒΆ
| REQ | SM | COLUMN NAME | TYPE | UC | VALIDATE | DEFAULT | JUST | NOTE |
|---|---|---|---|---|---|---|---|---|
| – – – – – – – – – – – – Keys | ||||||||
| M | S | GROUP | A | U | L12 | |||
| M | S | SERVICE | A | U | L8 | |||
| – – – – – – – – – – – – Process Control Entries | ||||||||
| O | S | DESCRIPTION | A | T40 | ||||
| O | S | DATE_PREVIOUS | D | U | DATE | R10 | ||
| M | S | DATE_LAST | D | U | DATE | TODAY | R10 | |
| F | S | DATE-NEXT | D | U | DATE | calc’d | R10 | |
| O | S | DATE-EXPIRE | D | U | DATE | R10 | ||
| – – – – – – – – – – – – Scheduling Entries | ||||||||
| M | S | REPEAT | LC | U | Calendar Repeat Codes | L12 | ||
| O | M | OPTIONS | LC | U | Calendar Options Codes | L12 | ||
| O | M | VALUES | LC | U | Calendar Values Codes | L12 | ||
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
- Entries of type list code (TYPE=LC) are validated against the associated linked code option list.
- Entries with a paired requirement (REQ=P) are required when the associated paired entry or code is specified.