 TimeSlot (TIM) |
Basic Shift building block $
|
|
Keys
|
| Name |
Attributes |
Fields |
| TIM:GuidKey |
Case |
+TIM:Guid |
| TIM:CodeKey |
Primary |
+TIM:TimeSlotCode |
| TIM:ScriptKey |
Dup |
+TIM:ScriptCode |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| TIM:Guid |
STRING |
@s16 |
Internal System Identifier |
| TIM:TimeSlotCode |
STRING |
@s6 |
|
| TIM:Description |
STRING |
@s20 |
|
| TIM:FixedTime |
LONG |
@t4 |
|
| TIM:RequiredSize |
LONG |
@t4 |
|
| TIM:ScriptCode |
STRING |
@s6 |
|
| TIM:MustBeOutBy |
LONG |
@t1 |
|
| TIM:orelse |
BYTE |
@n3 |
|
| TIM:StdHours |
LONG |
@t1 |
|
| TIM:BonusTime |
LONG |
@t1 |
|
| TIM:EarnedAfter |
LONG |
@t1 |
|
| TIM:BonusCategory |
LONG |
@n-14 |
|
| TIM:BonusRate |
LONG |
@n-14 |
|
| TIM:Notes |
MEMO |
1000 |
|
| TIM:DeductFromHoliday |
BYTE |
@n3 |
|
| TIM:DeductFromSick |
STRING |
@s20 |
|
| TIM:OnHolidayShift |
BYTE |
@n3 |
|
| TIM:ColorFG |
LONG |
@n-14 |
|
| TIM:ColorBG |
LONG |
@n-14 |
|
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| MoveDailyTime |
1:MANY |
TIM:CodeKey |
MDA:SlotKey |
| TimeHol |
1:MANY |
TIM:CodeKey |
THL:Key |
| Script |
MANY:1 |
TIM:ScriptKey |
SCR:key |
| Line |
1:MANY |
TIM:CodeKey |
LIN:SlotKey |
| TimeFile |
1:MANY |
TIM:CodeKey |
TME:CodeKey |
| Balancing |
1:MANY |
TIM:CodeKey |
BAL:Codekey |
| Slot |
1:MANY |
TIM:CodeKey |
SLO:CodeKey |
|
