Diagrams


Table

Employee Absence

Fields

# Name Type
1 Employee No. (Employee No.) Code20 NotBlank: Yes
2 Entry No. (Entry No.) Integer
3 From Date (From Date) Date
4 To Date (To Date) Date
5 Cause of Absence Code (Cause of Absence Code) Code10
6 Description (Description) Text50
7 Quantity (Quantity) Decimal (0:5)
8 Unit of Measure Code (Unit of Measure Code) Code10
11 Comment (Comment) Boolean Editable: No
FlowField
12 Quantity (Base) (Quantity (Base)) Decimal (0:5)
13 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5) Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Employee No.,From Date (Employee No.,From Date)
2 Employee No.,Cause of Absence Code,From Date (Employee No.,Cause of Absence Code,From Date)
3 Cause of Absence Code,From Date (Cause of Absence Code,From Date)
4 From Date,To Date (From Date,To Date)

Table Relations To Other Tables

Field Related Table Related Field
Cause of Absence Code (Cause of Absence Code) Cause of Absence Code (Code) 1..n
Employee No. (Employee No.) Employee No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Human Resource Unit of Measure Code (Code) 1..n

Table Relations From Other Tables

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