 Disciplinary (DIS) |
Employee Disciplinaries #
|
|
Keys
|
| Name |
Attributes |
Fields |
| DIS:GuidKey |
Case |
+DIS:Guid |
| DIS:EmpKey |
Primary |
+DIS:Site ,+DIS:EmpNumber ,+DIS:Date ,+DIS:OffenceCode |
| DIS:ActionKey |
Dup |
+DIS:ActionCode |
| DIS:OffenceKey |
Dup |
+DIS:OffenceCode |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| DIS:Guid |
STRING |
@s16 |
Internal System Identifier |
| DIS:Date |
LONG |
@d06 |
|
| DIS:Site |
STRING |
@s4 |
|
| DIS:EmpNumber |
STRING |
@s10 |
Employee number |
| DIS:OffenceCode |
LONG |
@n-13 |
|
| DIS:ActionCode |
LONG |
@n-13 |
|
| DIS:Details |
MEMO |
1000 |
|
| DIS:Decidedby |
STRING |
@s20 |
|
| DIS:Witness1 |
STRING |
@s20 |
|
| DIS:Witness2 |
STRING |
@s20 |
|
| DIS:HadHearing |
BYTE |
@n3 |
0 = none 1 = pending 2 = completed |
| DIS:Outcome |
MEMO |
1000 |
|
| DIS:Var1 |
STRING |
@s20 |
User defined field |
| DIS:Var2 |
STRING |
@s20 |
User defined field |
| DIS:Var3 |
STRING |
@s20 |
User defined field |
| DIS:Var4 |
STRING |
@s20 |
User defined field |
| DIS:Var5 |
STRING |
@s20 |
User defined field |
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| System |
MANY:1 |
DIS:EmpKey |
SYS:SiteKey |
| Offence |
MANY:1 |
DIS:OffenceKey |
OFF:CodeKey |
| Actions |
MANY:1 |
DIS:ActionKey |
ACT:CodeKey |
| Employee |
MANY:1 |
DIS:EmpKey |
EMP:Key |
|
