OVERTIME – This table is used to store overtime rules for the Track-IT pro database.
Ÿ ID – The unique ID for an overtime rule. (PK)
Ÿ NAME – The name of the overtime rule.
Ÿ PRORATE – The multiplier for the overtime rule.
Ÿ AFTER – The beginning boundary of the overtime rule.
Ÿ BEFORE – The ending boundary of the overtime rule.
Ÿ DESC – The description for the overtime rule.
Ÿ ARCHIVE – “T” if the overtime rule is flagged for archive, “F” otherwise.
Ÿ OUTSIDE – Can contain information not internally used by the software. Is used by the Import/Export tool, and can also be used for other customizable purposes.
Ÿ HIDE – “T” if the rate should be hidden in rate lists, “F” otherwise.