Business View ibvStaffTimeCL2Y

Description

This view presents time postings for staff members with computed and joined columns representing additional information about the posting. Only postings linked to staff members are included, so this view is not a reliable method for determining balances, but it can be used to investigate the ratio of chargeable to non chargeable time, and how the non chargeable time is broken down. Only postings that have IncludeWIP equal to 'Y' are included. Specifically, any pure expenses postings are not.

Because of the nature of time ledger postings the volume of data presented by this view without additional criteria will, on a typical site that has been active for a couple of years, be large. Later views cut this view down by selection and aggregation. If you are linking directly to Excel you should not use this view directly (unless you form an SQL statement rather than linking to the entire table) since the volume of data returned will probably swamp the spreadsheet (even when considering pivot table views).

This view only includes postings of category WIP (typically timesheet and timesheet adjustments) that are linked to a staff member. It does not include pending postings that have not been updated to the time ledger.

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 = Base business view, incorporating business logic. Not intended for normal end user use

 

Columns

Chargeable

'Y' if time chargeable

NonAccountable

'Y' if non chargeable time is non accountable

Year

Time ledger year

Period

Time ledger period in year

Date

Date of posting

CalendarYear

Calendar year independant of period structure on ledger

CalendarMonth

Calendar month (1 = Jan, 2 = Feb etc)

StaffInternalId

Internal identifier of staff member

ChargeRateInternalId

Internal identifier of charge rate

CostRateInternalId

Internal identifier of cost rate

Type

Posting Type (see idvTimePosting)

PostTypeDesc

Posting type in human readable form

Activity

Non charge activity or 'ClientJob' if the posting is chargeable

ActivityDescription

Non charge activity description or 'Chargeable'

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

Work type visible identiifer (could be null)

WorkTypeDescription

Description of work type (could be null)

Narrative

Posting narrative

Amount

Posting amount (credit negative)

ActualMinutes

Number of actual minutes logged (same conventions)

Matched

Current amount matched (same conventions)

ChargeableAmount

Value of chargeable time

NonChargeableAmount

Value of non chargeable time (including both accountable and non accountable)

AccountableAmount

Value of accountable non chargeable time

NonAccountableAmount

Value of non accountable non chargeable time

ChargeableMinutes

Number of chargeable minutes

NonChargeableMinutes

Number of non chargeable minutes (including both accountable and non accountable)

AccountableMinutes

Number of accountable non chargeable minutes

NonAccountableMinutes

Number of non accountable non chargeable minutes

 

  •