Business View ibvStaffCatsTotalsLCPY

Description

This view presents ibvStaffTotalsLCPY (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 latest closed ledger period plus earlier periods in same ledger year.

Type = End user business view, incorporating business logic

Columns

Inherits columns from view ibvStaffCategorisation plus

Year	Time ledger year
Period	Time ledger period in year
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