 |
 |
|
|
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.
This view is restricted to the current calendar year as determined by today's date.
Type = Base business view, incorporating business logic. Not intended for normal end user use
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 |