 MoveDailyTime (MDA) |
Rostering of Daily Shifts
|
|
Keys
|
| Name |
Attributes |
Fields |
| MDA:GuidKey |
Case |
+MDA:Guid |
| MDA:Key |
Primary |
+MDA:Site ,+MDA:EmpNumber ,+MDA:Date |
| MDA:SlotKey |
Dup |
+MDA:TimeSlot |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| MDA:Guid |
STRING |
@s16 |
Internal System Identifier |
| MDA:Site |
STRING |
@s4 |
|
| MDA:EmpNumber |
STRING |
@s10 |
|
| MDA:Date |
LONG |
@d6 |
|
| MDA:TimeSlot |
STRING |
@s10 |
|
| MDA:Type |
STRING |
@s1 |
M=Manual, B=Bulk |
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| TimeSlot |
MANY:1 |
MDA:SlotKey |
TIM:CodeKey |
| System |
MANY:1 |
MDA:Key |
SYS:SiteKey |
| Employee |
MANY:1 |
MDA:Key |
EMP:Key |
|
