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