 LeaveType (Let) |
Different types of Leave $
|
|
Keys
|
| Name |
Attributes |
Fields |
| Let:GuidKey |
Case |
+Let:Guid |
| Let:TYPEKEY |
Dup |
+Let:TYPE |
| Let:CODEKEY |
Primary |
+Let:TYPECODE |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| Let:Guid |
STRING |
@s16 |
Internal System Identifier |
| Let:TYPECODE |
BYTE |
@n3 |
|
| Let:TYPE |
STRING |
@s30 |
|
| Let:Paid |
BYTE |
@n3 |
|
| Let:PaidHoursCat |
SHORT |
@n-7 |
|
| Let:AffectsLeave |
BYTE |
@n3 |
|
| Let:AffectsSick |
BYTE |
@n3 |
|
| Let:COLOURFG |
LONG |
@n-13 |
|
| Let:COLOURBG |
LONG |
@n-13 |
|
| Let:SELCOLOURFG |
LONG |
@n-13 |
|
| Let:SELCOLOURBG |
LONG |
@n-13 |
|
| Let:ManualHours |
BYTE |
@n3 |
|
| Let:Hours |
LONG |
@n-14 |
|
| Let:Cat |
SHORT |
@n-7 |
|
| Let:Rate |
SHORT |
@n-7 |
|
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| Leave |
1:MANY |
Let:CODEKEY |
LEA:TypeKey |
|
