 |
 |
|
|
This view aggregates totals in ibvTimePostToColumns by Month.
Because the underlying view does not show whether the original instruction was in a different month (i.e. it only differentiates where the instruction was in a different period) this view aggregates all write out, write off and write back for the job and month into single total columns.
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 current and previous calendar year as determined by today's date.
Type = End user business view, incorporating business logic
| JobInternalId | The internal identifier of the client job that the aggregated totals apply to |
| Year | The time ledger year that the aggregated totals apply to |
| Period | The time ledger period that the aggregated totals apply to |
| ChargeableTime | The aggregated total of ChargeableTime from ibvTimePostToColumns (QV) |
| ChargeableExpenses | The aggregated total of ChargeableExpenses from ibvTimePostToColumns (QV) |
| OtherPostings | The aggregated total of OtherPostings from ibvTimePostToColumns (QV) |
| ActualMinutes | The aggregated total of ActualMinutes from ibvTimePostToColumns (QV) |
| Matched | The aggregated total of Matched from ibvTimePostToColumns (QV) |
| WriteOut | The aggregated total of WriteOutThisPd plus WriteOutOtherPd from ibvTimePostToColumns (QV) |
| WriteOff | The aggregated total of WriteOffThisPd plus WriteOffOtherPd from ibvTimePostToColumns (QV) |
| WriteBack | The aggregated total of WriteBackThisPd plus WriteBackOtherPd from ibvTimePostToColumns (QV) |