Business View ibvStaffCatsTotalsByMonthCC2Y

Description

This view presents ibvStaffTotalsByMonthCC2Y (QV) joined with staff categories and charge rate identifier.

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 calendar year as determined by today's date.

Type = End user business view, incorporating business logic

Columns

Inherits columns from view ibvStaffCategorisation plus

CalendarYear	Calendar year independant of period structure on ledger
CalendarMonth	Calendar month (1 = Jan, 2 = Feb etc)
ChargeRate	Visible identifier of the charge rate
CostRate	Visible identifier of the cost rate
Type	See ibvStaffTotals views
PostTypeDesc	See ibvStaffTotals views
Activity	See ibvStaffTotals views
ActivityDescription	See ibvStaffTotals views
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 ibvStaffTotals views
WorkTypeDescription	See ibvStaffTotals views
Amount	See ibvStaffTotals views
Matched	See ibvStaffTotals views
ChargeableAmount	See ibvStaffTotals views
NonChargeableAmount	See ibvStaffTotals views
AccountableAmount	See ibvStaffTotals views
NonAccountableAmount	See ibvStaffTotals views
ActualMinutes	See ibvStaffTotals views
ChargeableMinutes	See ibvStaffTotals views
NonChargeableMinutes	See ibvStaffTotals views
AccountableMinutes	See ibvStaffTotals views
NonAccountableMinutes	See ibvStaffTotals views