Business View ibvStaffTotalsCL2Y

Description

This view presents an aggregation of ibvStaffTimeCL2Y by year and period.

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.

This view is restricted to the current and previous ledger year as determined by current ledger period.

Type = End user business view, incorporating business logic

Columns

Year	Time ledger year
Period	Time ledger period in year
StaffInternalId	See ibvStaffTime
ChargeRateInternalId	See ibvStaffTime
CostRateInternalId	See ibvStaffTime
Type	See ibvStaffTime
PostTypeDesc	See ibvStaffTime
Activity	See ibvStaffTime
ActivityDescription	See ibvStaffTime
NonChargeCode	The identifier of the non charge code that the non charge activity is contained within, or an empty string
NonChargeCodeDesc	The description of the non charge code that the non charge activity is contained within, or an empty string
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