Analytics Data Structure

Overview of Data Structure of entities in Self Serve Analytics Reports

For the purpose of this document this section will focus only on details relevant to the self service Analytics data structure. It is included to provide a basic understanding of the high level architecture of Oneserve and to aid in querying the data provided. As such this information is subject to change.

Activity/Appointment

Against a job(s) there may be a number of appointments. Appointment attributes are all to do with actual visits to the properties and will include who went at what time and how long for etc.

A job may also be assigned several activities; these are high detail descriptions of individual work aspects based on a schedule of rates e.g. 2 x Fix tap.

Job Appointment

Job Activity

Job Costs

Job costs are assigned to jobs and may also be related to an activity. Alternatively they may have no relationship to an SOR, a late appointment charge for example.

Job Event(s)

Events can be related to jobs or work logs and are mainly concerned with ad hoc activity. Events can be generated either by the system or by an end user.

Job Events

Site/Contact(s)

Every job in Oneserve has to be created against a site, each site can have many contacts.

Sites

Sites (not linked to jobs)

Survey(s)

Job Surveys

Working Time

Job Working Time

Resource Working/Non-Working Time