Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Time Tracking Id |
The automatically generated primary key of the time_tracking table. |
LONG |
Yes |
Time Tracking Description |
A descriptive name of the Time Tracking. This descriptive name may be localized.
|
VARCHAR(512) |
No |
Time Tracking Type Id |
A Foreign Key to the Time Tracking Type table. |
INTEGER |
Yes |
Item Definition Id |
A Foreign Key to the Definition table. |
LONG |
Yes |
Item Id |
A Foreign Key to the Item table. |
LONG |
Yes |
Application User Id |
A Foreign Key to the Application User table. |
LONG |
Yes |
Start Date Time |
The value of a Time Tracking, stored as a date. |
DATE |
Yes |
End Date Time |
The value of a Time Tracking, stored as a date. |
DATE |
No |
Duration Minutes |
The value of a Time Tracking stored as Long. |
LONG |
No |
Rate Per Hour |
The value of a Time Tracking stored as real. |
DECIMAL(,) |
No |
Rate Description |
A descriptive name of the Time Tracking. This descriptive name may be localized.
|
VARCHAR(512) |
No |
item_id |
  |
CHAR(18) |
No |