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.

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