 History (HIS) |
Employment history #
|
|
Keys
|
| Name |
Attributes |
Fields |
| HIS:GuidKey |
Case |
+HIS:Guid |
| HIS:EmpKey |
Primary |
+HIS:Site ,+HIS:EmpNumber ,+HIS:Date |
| HIS:PositionKey |
Dup |
+HIS:PositionCode |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| HIS:Guid |
STRING |
@s16 |
Internal System Identifier |
| HIS:Date |
LONG |
@n-13 |
|
| HIS:Site |
STRING |
@s4 |
|
| HIS:EmpNumber |
STRING |
@s10 |
|
| HIS:PositionCode |
LONG |
@n-13 |
|
| HIS:Salary |
DECIMAL |
@n-11.2 |
|
| HIS:JobDescription |
MEMO |
1000 |
|
| HIS:Var1 |
STRING |
@s20 |
User defined field |
| HIS:Var2 |
STRING |
@s20 |
User defined field |
| HIS:Var3 |
STRING |
@s20 |
User defined field |
| HIS:Var4 |
STRING |
@s20 |
User defined field |
| HIS:Var5 |
STRING |
@s20 |
User defined field |
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| System |
MANY:1 |
HIS:EmpKey |
SYS:SiteKey |
| Employee |
MANY:1 |
HIS:EmpKey |
EMP:Key |
| Positions |
MANY:1 |
HIS:PositionKey |
POS:CodeKey |
|
