Diagrams


Table

Employee Qualification

Fields

# Name Type
1 Employee No. (Employee No.) Code20 NotBlank: Yes
2 Line No. (Line No.) Integer
3 Qualification Code (Qualification Code) Code10
4 From Date (From Date) Date
5 To Date (To Date) Date
6 Type (Type) Option
7 Description (Description) Text50
8 Institution/Company (Institution/Company) Text50
9 Cost (Cost) Decimal
10 Course Grade (Course Grade) Text50
11 Employee Status (Employee Status) Option Editable: No
12 Comment (Comment) Boolean Editable: No
FlowField
13 Expiration Date (Expiration Date) Date

Keys

# Fields
0 Employee No.,Line No. (Employee No.,Line No.) Clustered: Yes
1 Qualification Code (Qualification Code)

Table Relations To Other Tables

Field Related Table Related Field
Employee No. (Employee No.) Employee No. (No.) 1..n
Qualification Code (Qualification Code) Qualification Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Human Resource Comment Line No. (No.) 1..n