3.45. db_rate

Table 3.45. db_rate
ColumnTypeReferencesComments
id Integer Primary key
vdb_id Integer
object_id Integer Object ID associated with the rate. ID of time code OR User
object_type Integer 22 = time code, 24 = user
context_id Integer The context in which this rate is defined. For example, user cost rates can be defined either at a company level OR at a project level. ID of project or company
context_type Integer 17 = project, 3 = company
amount Float Rate amount
period Integer
effective Date Effective from
kind Integer Which rate: 1 = cost, 2 = client billing
sub_kind Integer The rate type 1 = regular, 2 = overtime