 Dependants (DPN) |
employee dependant's info #
|
|
Keys
|
| Name |
Attributes |
Fields |
| DPN:GuidKey |
Case |
+DPN:Guid |
| DPN:EmpKey |
Dup |
+DPN:Site ,+DPN:EmpNumber |
| DPN:AgeKey |
Dup |
+DPN:Site ,+DPN:EmpNumber ,+DPN:DateofBirth |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| DPN:Guid |
STRING |
@s16 |
Internal System Identifier |
| DPN:Site |
STRING |
@s4 |
|
| DPN:EmpNumber |
STRING |
@s10 |
|
| DPN:DateofBirth |
LONG |
@d6 |
|
| DPN:Name |
STRING |
@s40 |
|
| DPN:Relationship |
STRING |
@s10 |
|
| DPN:Var1 |
STRING |
@s20 |
User defined field |
| DPN:Var2 |
STRING |
@s20 |
User defined field |
| DPN:Var3 |
STRING |
@s20 |
User defined field |
| DPN:Var4 |
STRING |
@s20 |
User defined field |
| DPN:Var5 |
STRING |
@s20 |
User defined field |
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| System |
MANY:1 |
DPN:EmpKey |
SYS:SiteKey |
| Employee |
MANY:1 |
DPN:EmpKey |
EMP:Key |
|
