Business View ibvStaffTotalsByMonthCCY

Description

This view presents an aggregation of ibvStaffTimeCCY by nonth.

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

CalendarYear Calendar year independant of period structure on ledger
CalendarMonth Calendar month (1 = Jan, 2 = Feb etc)
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

 

  •