EMPPREFS – This table contains each employee’s personal preferences for Track-IT light and Track-IT web edition.
Ÿ EMPLOYEE - The Employee ID for the preferences. (PK)
Ÿ TDFROM - This is the From date in the Timesheet view Date range.
Ÿ TDDAYS - This is used internally by Track-IT light to automatically increment the date range when the Save Date option has not been selected.
Ÿ TDOFFSET - This is used internally by Track-IT light to automatically increment the date range when the Save Date option has not been selected.
Ÿ TDINC – The Timesheet view Save Date option. (T = "True", F= "False")
Ÿ EDFROM - This is the From date in the Expense view Date range.
Ÿ EDDAYS - This is used internally by Track-IT light to automatically increment the date range when the Save Date option has not been selected.
Ÿ EDOFFSET - This is used internally by Track-IT light to automatically increment the date range when the Save Date option has not been selected.
Ÿ EDINC - The Expense view Save Date option. (T = "True", F= "False")
Ÿ RDFROM - This is the From date in the Reports Date range.
Ÿ RDDAYS - This is used internally by Track-IT light to automatically increment the date range when the Save Date option has not been selected.
Ÿ RDOFFSET - This is used internally by Track-IT light to automatically increment the date range when the Save Date option has not been selected.
Ÿ RDINC – The reports Save Date option. (T = "True", F= "False")
Ÿ TSDFROM - This is the From date in the Submit Timesheet Date range.
Ÿ TSDDAYS - This is used internally by Track-IT light to automatically increment the date range when the Save Date option has not been selected.
Ÿ TSDOFFSET - This is used internally by Track-IT light to automatically increment the date range when the Save Date option has not been selected.
Ÿ TSDINC - The Submit timesheet Save Date option. (T = "True", F= "False")
Ÿ ESDFROM - This is the From date in the Submit Expense Date range.
Ÿ ESDDAYS - This is used internally by Track-IT light to automatically increment the date range when the Save Date option has not been selected.
Ÿ ESDOFFSET - This is used internally by Track-IT light to automatically increment the date range when the Save Date option has not been selected.
Ÿ ESDINC - The Submit expenses Save Date option. (T = "True", F= "False")
Ÿ DATSTART – The value of the "My Day Starts At" option.
Ÿ ADVMIN – The "Auto-advise when sending timesheet for days that have less then" value.
Ÿ ADVMAX- The "Auto-advise when sending timesheet for days that have more then" value.
Ÿ DEFVIEW – The default startup view.
Ÿ DETTIM – The Detailed Timesheet View option. (Track-IT web edition only)