 MoveCategory (MCA) |
Emplyee moving categories #
|
|
Keys
|
| Name |
Attributes |
Fields |
| MCA:GuidKey |
Case |
+MCA:Guid |
| MCA:EmpKey |
Primary |
+MCA:Site ,+MCA:EmpNumber ,+MCA:Date ,+MCA:Time |
| MCA:CategoryKey |
Dup |
+MCA:Category ,+MCA:Date ,+MCA:Time |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| MCA:Guid |
STRING |
@s16 |
Internal System Identifier |
| MCA:Site |
STRING |
@s4 |
|
| MCA:EmpNumber |
STRING |
@s10 |
|
| MCA:Date |
LONG |
@d6 |
|
| MCA:Time |
LONG |
@t4 |
|
| MCA:Category |
LONG |
@n-14 |
|
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| System |
MANY:1 |
MCA:EmpKey |
SYS:SiteKey |
| Employee |
MANY:1 |
MCA:EmpKey |
EMP:Key |
| Category |
MANY:1 |
MCA:CategoryKey |
CAT:key |
|
