 |
 |
|
|
This view presents an aggregation of ibvStaffTime for the current and previous calendar year.
Since this view is steered by the presence of postings, after any aggregation there will be no rows present for accounts and/or period combinations that have no postings present. Absence of an expected row should be taken as implying zero figures.
Type = End user business view, incorporating business logic
CalendarYear |
Calendar year independant of period structure on ledger |
CalendarMonth |
Calendar month (1 = Jan, 2 = Feb etc) |
StaffInternalId |
See ibvStaffTime |
ChargeRateInternalId |
See ibvStaffTime |
CostRateInternalId |
See ibvStaffTime |
Type |
See ibvStaffTime |
PostTypeDesc |
See ibvStaffTime |
Activity |
See ibvStaffTime |
ActivityDescription |
See ibvStaffTime |
WorkType |
See ibvStaffTime |
WorkTypeDescription |
See ibvStaffTime |
Amount |
See ibvStaffTime |
Matched |
See ibvStaffTime |
ChargeableAmount |
See ibvStaffTime |
NonChargeableAmount |
See ibvStaffTime |
AccountableAmount |
See ibvStaffTime |
NonAccountableAmount |
See ibvStaffTime |
ActualMinutes |
See ibvStaffTime |
ChargeableMinutes |
See ibvStaffTime |
NonChargeableMinutes |
See ibvStaffTime |
AccountableMinutes |
See ibvStaffTime |
NonAccountableMinutes |
See ibvStaffTime |