 MoveTime (MTI) |
Employee changing shifts #
|
|
Keys
|
| Name |
Attributes |
Fields |
| MTI:GuidKey |
Case |
+MTI:Guid |
| MTI:EmpKey |
Primary |
+MTI:Site ,+MTI:EmpNumber ,+MTI:Date ,+MTI:Time |
| MTI:TimeLineKey |
Dup |
+MTI:TimeLineCode ,+MTI:Date ,+MTI:Time |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| MTI:Guid |
STRING |
@s16 |
Internal System Identifier |
| MTI:Site |
STRING |
@s4 |
|
| MTI:EmpNumber |
STRING |
@s10 |
|
| MTI:Date |
LONG |
@n-14 |
|
| MTI:Time |
LONG |
@n-14 |
|
| MTI:TimeLineCode |
STRING |
@s6 |
|
| MTI:Type |
STRING |
@s1 |
M=Manual, B=Bulk |
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| Employee |
MANY:1 |
MTI:EmpKey |
EMP:Key |
| System |
MANY:1 |
MTI:EmpKey |
SYS:SiteKey |
| TimeLine |
MANY:1 |
MTI:TimeLineKey |
TIL:CodeKey |
|
