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. (FK)
Ÿ TASK – The Task ID that has been assigned to the accrual rule. (FK)
Ÿ 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")