TimeFile (TME) |
Working Hours, Lunch, Tea Breaks etc $
|
|
Keys
|
| Name |
Attributes |
Fields |
| TME:GuidKey |
Case |
+TME:Guid |
| TME:CodeKey |
Primary |
+TME:TimeSlotCode ,+TME:Start |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| TME:Guid |
STRING |
@s16 |
Internal System Identifier |
| TME:TimeSlotCode |
STRING |
@s6 |
|
| TME:Description |
STRING |
@s20 |
|
| TME:Start |
LONG |
@t1 |
|
| TME:Finish |
LONG |
@t1 |
|
| TME:EarlyStart |
SHORT |
@n3 |
|
| TME:EarlyFinish |
SHORT |
@n3 |
|
| TME:LateStart |
SHORT |
@n3 |
|
| TME:LateFinish |
SHORT |
@n3 |
|
| TME:GraceStart |
SHORT |
@n-6 |
|
| TME:GraceFinish |
SHORT |
@n-6 |
|
| TME:Clock |
BYTE |
@n3 |
|
| TME:Paid |
BYTE |
@n3 |
|
| TME:Minimum |
SHORT |
@n6 |
|
| TME:Maximum |
SHORT |
@n6 |
|
| TME:Default |
SHORT |
@n6 |
|
| TME:Direction |
BYTE |
@n3 |
|
| TME:Round |
SHORT |
@n-7 |
|
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| TimeSlot |
MANY:1 |
TME:CodeKey |
TIM:CodeKey |
|