RATE table

 

RATE – This table contains wage/charge information for employees in the Track-IT pro database.

Ÿ      ID – The unique ID for a rate. (PK)

Ÿ      NAME – The name for the rate.

Ÿ      AMOUNT – The amount of the rate.

Ÿ      DESC – The description for the rate.

Ÿ      PERIOD – Reserved for future use.

Ÿ      ARCHIVE – “T” if the rate 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 item is hidden in rate lists, “F” otherwise.