TIMATTACC table

TIMATTACC – this table contains all accrual rules that have been assigned to time and attendance rule. The two columns TIMATT/TASK together form the Primary Key (PK)

Ÿ      TIMATT – The time and attendance ID that the accrual rule has been entered for.

Ÿ      TASK – The Task ID that has been assigned to the accrual rule.

Ÿ      ACCAMOUNT – The amount of accrual time given to the accrual rule.

Ÿ      ACCUNIT – The Unit for the accrual time (% = "Percentage" , H = "Hours", D = "Days")

Ÿ      MAXAMOUNT – The Maximum amount of accrual time allowed.

Ÿ      MAXUNIT – The Maximum amount Unit of the accrual rule. (H = "Hours", D = "Days")

Ÿ      WORAMOUNT – The Time Period that the accrual rule applies for.

Ÿ      WORUNIT – The time period unit that the accrual rule applies for. (H = "Hours", D = "Days", M = "Months", Y = "Years")

Ÿ      TYPE - The type of work to calculate the accrued time as. (F = "Flex Time Only", R = "Regular Time Only", G = "Both Regular Time and Flex Time", O = "Overtime Only", B = "Both Regular Time and Overtime")