Business View ibvStaffTotalsLCPY

Description

This view presents an aggregation of ibvStaffTimeLCPY by year and period.

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

Year

Time ledger year

Period

Time ledger period in year

StaffInternalId

See ibvStaffTime

ChargeRateInternalId

See ibvStaffTime

CostRateInternalId

See ibvStaffTime

Type

See ibvStaffTime

PostTypeDesc

See ibvStaffTime

Activity

See ibvStaffTime

ActivityDescription

See ibvStaffTime

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 ibvStaffTime

WorkTypeDescription

See ibvStaffTime

Amount

See ibvStaffTime

Matched

See ibvStaffTime

ChargeableAmount

See ibvStaffTime

NonChargeableAmount

See ibvStaffTime

AccountableAmount

See ibvStaffTime

NonAccountableAmount

See ibvStaffTime

ActualMinutes

See ibvStaffTime

ChargeableMinutes

See ibvStaffTime

NonChargeableMinutes

See ibvStaffTime

AccountableMinutes

See ibvStaffTime

NonAccountableMinutes

See ibvStaffTime

 

  •