This view presents an aggregation of ibvStaffTimeLCPC 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.
This view is restricted to the latest closed ledger period and same period in previous year.
Type = End user business view, incorporating business logic
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 |