Business View ibvStaffCatsTotalsCCY

Description

This view presents ibvStaffTotalsCCY (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.

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
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