 Training (TRA) |
employee training records #
|
|
Keys
|
| Name |
Attributes |
Fields |
| TRA:GuidKey |
Case |
+TRA:Guid |
| TRA:EmpKey |
Primary |
+TRA:Site ,+TRA:EmpNumber ,+TRA:Date ,+TRA:CourseCode |
| TRA:CourseKey |
Dup |
+TRA:CourseCode |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| TRA:Guid |
STRING |
@s16 |
Internal System Identifier |
| TRA:Date |
LONG |
@d06 |
|
| TRA:Site |
STRING |
@s4 |
|
| TRA:EmpNumber |
STRING |
@s10 |
|
| TRA:CourseCode |
LONG |
@n-13 |
|
| TRA:Result |
STRING |
@s20 |
|
| TRA:Duration |
LONG |
@n-13 |
in days |
| TRA:Location |
STRING |
@s40 |
|
| TRA:Var1 |
STRING |
@s20 |
User defined field |
| TRA:Var2 |
STRING |
@s20 |
User defined field |
| TRA:Var3 |
STRING |
@s20 |
User defined field |
| TRA:Var4 |
STRING |
@s20 |
User defined field |
| TRA:Var5 |
STRING |
@s20 |
User defined field |
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| System |
MANY:1 |
TRA:EmpKey |
SYS:SiteKey |
| Employee |
MANY:1 |
TRA:EmpKey |
EMP:Key |
| Courses |
MANY:1 |
TRA:CourseKey |
COU:CodeKey |
|
