VSys One: Volunteer Management Software

Hours details report pipelines

There are five hours details pipelines available:

"Hours details" - the current record when the report is based on hours.
"Hours details" - zero or more items: all volunteer hours for this person.
"Hours merged" - same as "Hours details" except that records with basically identical jobs, locations and projects are merged together. This reduces repetition if the same person does the same job every day for a year. You only see one record with totals rather than 365 individual records.
"Hours in project" - same as "Hours details" but only hours records in the current project.
"Hours in project merged" - same as "Hours merged" but only records in the current project.

Hours details

Information about a volunteer hours record. If the report's basis is volunteer hours, it's the hours that met your criteria. Otherwise, it's a list of hours for the current person. In both cases, there will be zero or more records in this pipeline.

Field	Description or example
Date posted	The date this record was entered into VSys.
Delegation	Volunteer's delegation when this record was posted.
Duration	In "hh:mm" format, e.g. "`4:30`". Use this for displaying values.
Duration (number)	As a number, e.g. `4.5`. Use this when totaling values in reports.
Bonus duration
Bonus duration (number)
Total duration	Sum of Duration and Bonus duration in display format.
Total duration (number)	Sum of Duration and Bonus duration in numeric form.
Finish
Team members	Count of people in this hours record, will be "`1`" for non-teams.
Month, Quarter, Year	From the hours record's start date.
Month num	`04`
Month num/name	`04 April`
Year	`2011`
Year/month	`2011-04`
Fiscal month, Fiscal quarter, Fiscal year	Fiscal values from the hours record's start date.
Miles	Distance driven; will be labeled "Kilometers" if chosen as the unit of distance measurement in System preferences and feature enabling.
Comments
Group	Volunteer's group when this hours record was posted.
Current group	The volunteer's current group, may differ from the group that was assigned when this record was posted.
Job, Job group, Job group parent
Job group, job	Job group and job name in a single field.
Location
Project
Supervisor	The person's supervisor for this assignment, or the supervisor value entered when the record was posted.
Start
Value	Monetary value of these hours.
Volunteer ID	The volunteer's unique 16-digit ID code.
Automatic check-out reason	"`Not auto-checked out`", "`Back-to-back assignment`", "`Assignment ended`", "`Reached walkup checkin job max duration`", "`Reached max non-assignment duration`", or "`Other`"
Automatically checked out	`True` or `False`
Account records	Summary of account records associated with this hours record.
(various account names)	Value assigned to the specific account record associated with the selected field.