# Tile Reports

Click the star on the tile which needs to be pinned to your dashboard.\
Only the tiles which you have access to are displayed.

**No Access on Last Event Open Jobs**&#x20;

The last event on the job is {{ONSITE}} with an {{OPENSTATUS}} Job status and the result summary is contained in the {{NOACCESS}} list. KPI is the distinct job count.

**Abandon Job on Last Event**&#x20;

The last event on the job has a result summary of 'Abandon Job' KPI is the distinct job count.

**Follow On Required on Last Event**&#x20;

The last event on the job has a result summary of 'Follow On Required'. KPI is the distinct job count.

**Completed Jobs Not Cleared to Invoice**&#x20;

The job status is in the {{COMPLETESTATUS}} list and the Cleared To Invoice on the job is 'N'. KPI is the distinct job count.

**Recent Error Logs**

System Log entries created on the current date or the previous working date. Comes from the BPLOGS table.  KPI is count of logs.&#x20;

**Open Jobs Due within 2 Days**&#x20;

The job status is in the {{OPENSTATUS}} list and the job target date is either today, tomorrow or the next date. KPI is the distinct job count.

**Open Jobs Repairs**&#x20;

The job status is in the {{OPENSTATUS}} list and the contract is in the {{REPAIRSCONTRACTS}} list. KPI is the distinct job count.

**Open Jobs Void**&#x20;

The job status is in the {{OPENSTATUS}} list and the contract is in the {{VOIDCONTRACTS}} list. KPI is the distinct job count.

**Open Jobs Gas**&#x20;

The job status is in the {{OPENSTATUS}} list and the contract is in the {{GASCONTRACTS}} list. KPI is the distinct job count.

**Completed Jobs Today Repairs**&#x20;

The contract is in the {{REPAIRSCONTRACTS}} list and the job completed date is today. KPI is distinct job count

**Completed Jobs Today Voids**&#x20;

The contract is in the {{VOIDCONTRACTS}} list and the job completed date is today. KPI is distinct job count

**Completed Jobs Today Gas**

The contract is in the {{GASCONTRACTS}} list and the job completed date is today. KPI is distinct job count

**Recorded Jobs Today Repairs**&#x20;

The contract is in the {{REPAIRSCONTRACTS}} list and the job recorded date is today. KPI is distinct job count

**Recorded Jobs Today Voids**&#x20;

The contract is in the {{VOIDCONTRACTS}} list and the job recorded date is today. KPI is distinct job count

**Recorded Jobs Today Gas**&#x20;

The contract is in the {{GASSCONTRACTS}} list and the job recorded date is today. KPI is distinct job count

**Completed Jobs Repairs**&#x20;

The contract is in the {{REPAIRSCONTRACTS}} list and the job completed date is chosen from the list of default options. KPI is distinct job count.

**Completed Jobs Voids**&#x20;

The contract is in the {{VOIDCONTRACTS}} list and the job completed date is chosen from the list of default options. KPI is distinct job count.

**Completed Jobs Gas**&#x20;

The contract is in the {{GASCONTRACTS}} list and the job completed date is chosen from the list of default options. KPI is distinct job count.

**Avg Cost of Repairs by JobType This Financial Year**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list , grouped by Jobtype, we have the total cost value of all the jobs, the total sales value of all the jobs, the distinct count of the jobs, the average cost per job (total cost / number of jobs) and average sales per job (total sales / number of jobs). The time frame will be job completed date from the previous 1st April to the next 31st March which is the current UK financial year. KPI will be the overall average cost for the combined job types within the {{REPAIRSCONTRACTS}} list.&#x20;

**Avg Cost of Voids by JobType This Financial Year**&#x20;

From contracts in the {{VOIDCONTRACTS}} list , grouped by Jobtype, we have the total cost value of all the jobs, the total sales value of all the jobs, the distinct count of the jobs, the average cost per job (total cost / number of jobs) and average sales per job (total sales / number of jobs). The time frame will be job completed date from the previous 1st April to the next 31st March which is the current UK financial year. KPI will be the overall average cost for the combined job types within the {{VOIDCONTRACTS}} list.&#x20;

**Average Void Turnaround This Financial Year**&#x20;

From contracts in the {{VOIDCONTRACTS}} list, all jobs are listed. The day difference is the amount of days from the job recorded date to the job completed date. Working days difference is the amount of working days from the job recorded date to the job completed date, this depends on whether the contract is configured to account for working on Saturdays and/or Sundays. The time frame will be job completed date from the previous 1st April to the next 31st March which is the current UK financial year. KPI will be the average number of working days differences including all the jobs.

**Open Purchase Orders**&#x20;

Purchase Order information with linked GRN information on any Purchase Orders that have their status in the {{OPENSTATUS}} list. KPI is number of open purchase orders.

**Cleared To Invoice Events**&#x20;

Events information where the cleared to invoice (CTI) field for the event is 'Y'. KPI is count of all these events.&#x20;

**Open Pending Onsite Events**&#x20;

Event information where for {{ONSITE}} events with status in teh {{OPENSTATUS}} list and a designation type of 'PENDING'. KPI is count off all these events.

**First Time Fix**&#x20;

Any job that doesn't contain an event with action required of 'SECOND VISIT', 'THIRD VISIT' or 'FOLLOWUP VISIT' is classified as a first time fix job. The grid will list the jobs that ARE first time fixes within the chosen time frame (for job competed date) and the KPI is the percentage of the jobs that are first time fix jobs.

**Items Used Per Job Summary**&#x20;

Grouped by Stock Code with it's description, we have the sum off the quantity required and the sum of the total sell value from the job items table. It's for the event finish date for the chosen time frame. KPI is the overall sum of quantity required for all stock items combined.&#x20;

**Open Jobs with Zero Events**&#x20;

Jobs with status in the {{OPENSTATUS}} list that do not contain any events.&#x20;

**Completed Jobs Current FYTD Repairs**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list, jobs that have status in the {{COMPLETESTATUS}} list with the job completed date falling between the previous 1st April and following 31st March. KPI is count of these jobs.&#x20;

**Completed Jobs Last FYTD Repairs**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list, jobs that have status in the {{COMPLETESTATUS}} list with the job completed date falling between the 'previous' previous 1st April and following 31st March. KPI is count of these jobs.&#x20;

**Avg Cost of Repairs by JobType Last Financial Year**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list , grouped by Jobtype, we have the total cost value of all the jobs, the total sales value of all the jobs, the distinct count of the jobs, the average cost per job (total cost / number of jobs) and average sales per job (total sales / number of jobs). The time frame will be  job completed date falling between the 'previous' previous 1st April and following 31st March which is the previous UK financial year. KPI will be the overall average cost for the combined job types within the {{REPAIRSCONTRACTS}} list.&#x20;

**Avg Cost of Voids by JobType Last Financial Year**&#x20;

From contracts in the {{VOIDCONTRACTS}} list , grouped by Jobtype, we have the total cost value of all the jobs, the total sales value of all the jobs, the distinct count of the jobs, the average cost per job (total cost / number of jobs) and average sales per job (total sales / number of jobs). The time frame will be  job completed date falling between the 'previous' previous 1st April and following 31st March which is the previous UK financial year. KPI will be the overall average cost for the combined job types within the {{VOIDCONTRACTS}} list.&#x20;

**Average Void Turnaround Last Financial Year**&#x20;

From contracts in the {{VOIDCONTRACTS}} list, all jobs are listed. The day difference is the amount of days from the job recorded date to the job completed date. Working days difference is the amount of working days from the job recorded date to the job completed date, this depends on whether the contract is configured to account for working on Saturdays and/or Sundays. The time frame will be job completed date from the 'previous' previous 1st April to the next 31st March which is the previous UK financial year. KPI will be the average number of working days differences including all the jobs.

**% of all Emergency Repairs On Time**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list and have jobtype in the {{EMERGENCYJOBTYPES}} list including jobs with completed date within the chosen time frame. If a job is complete and its completed date is before or equal to its target date then it is 'In Target', if a job is open (technically none should if they contain a completed date) and the target date is before or equal to todays date then it is 'In Target', otherwise job is Out of Target'. The KPI is the percentage of the jobs that are 'In Target'

**% of all Recorded Repairs represented by Emergency**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list there is a 'count' of the jobs that have jobtype within {{EMERGENCYJOBTYPES}} list. The time frame is job recorded date for the chosen period. The KPI is the percentage of the {{EMERGENCYJOBTYPES}} jobs against all the {{REPAIRSCONTRACTS}} jobs.&#x20;

**% of all Recorded Repairs represented by Urgent**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list there is a 'count' of the jobs that have jobtype within {{URGENTJOBTYPES}} list. The time frame is job recorded date for the chosen period. The KPI is the percentage of the {{URGENTJOBTYPES}} jobs against all the {{REPAIRSCONTRACTS}} jobs.&#x20;

**% of all Responsive Repairs On Time**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list including jobs with completed date within the chosen time frame. If a job is complete and its completed date is before or equal to its target date then it is 'In Target', if a job is open (technically none should if they contain a completed date) and the target date is before or equal to todays date then it is 'In Target', otherwise job is Out of Target'. The KPI is the percentage of the jobs that are 'In Target'

**% of all Routine Repairs On Time**

From contracts in the {{REPAIRSCONTRACTS}} list and have jobtype in the {{ROUTINEJOBTYPES}} list including jobs with completed date within the chosen time frame. If a job is complete and its completed date is before or equal to its target date then it is 'In Target', if a job is open (technically none should if they contain a completed date) and the target date is before or equal to todays date then it is 'In Target', otherwise job is Out of Target'. The KPI is the percentage of the jobs that are 'In Target'

**% of all Urgent Repairs On Time**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list and have jobtype in the {{URGENTJOBTYPES}} list including jobs with completed date within the chosen time frame. If a job is complete and its completed date is before or equal to its target date then it is 'In Target', if a job is open (technically none should if they contain a completed date) and the target date is before or equal to todays date then it is 'In Target', otherwise job is Out of Target'. The KPI is the percentage of the jobs that are 'In Target'

**% Valid LGSR Properties (within 365 days)**&#x20;

Property information for Gas properties where their Service Group is either 'Gas' or 'Gascap' and the the property is currently active. The Last CP12 date on that property is greater or equal to this day last year. KPI is percentage of such properties against the full list of properties.

**Active Operative Device Details**&#x20;

Engineer and device details where the engineer has 'Active' status and the mobile supplier is 'ACCUMOBILE'. KPI is count of these engineers.

**Alarm Details**&#x20;

Exhaustive list of Alarms in the system recorded by AccuMobile. Has alarm information, associated job number and the property it belongs to.&#x20;

**Amount of Non-Productive Time by Operative**&#x20;

From the particular 'NONPRODUCTIVE' contract, this tile contains event information for all events with assigned date within the chosen time periods. The 'NonProdTime' column records the timereqdhours when populated otherwise it gets the total hours/mins values. The KPI is the sum of this column for all the events.&#x20;

**Average Cost per Operative per Job**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list this tile groups by operative and sums up their cost value (event level), count of jobs, and average cost per job (cost value / count of jobs). The time frame is the finished date within the chosen time period.  The KPI is the overall average cost per job for all operatives combined.&#x20;

**Average Days to Complete Job**&#x20;

All jobs are listed. The day difference is the amount of days from the job recorded date to the job completed date. Working days difference is the amount of working days from the job recorded date to the job completed date, this depends on whether the contract is configured to account for working on Saturdays and/or Sundays. The time frame will be job completed date from the chosen time period. KPI will be the average number of working days differences&#x20;

**Average Sales per Operative per Job**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list this tile groups by operative and sums up their sales value (event level), count of jobs, and average sales per job (sales value / count of jobs). The time frame is the finished date within the chosen time period.  The KPI is the overall average sales per job for all operatives combined.&#x20;

**Average Void Turnaround**&#x20;

From contracts in the {{VOIDCONTRACTS}} list, all jobs are listed. The day difference is the amount of days from the job recorded date to the job completed date. Working days difference is the amount of working days from the job recorded date to the job completed date, this depends on whether the contract is configured to account for working on Saturdays and/or Sundays. The time frame will be job completed date for the chosen time period.  KPI will be the overall average number of working days differences.

**Completed Jobs with Costs greater than Sales**&#x20;

All jobs with status within the {{COMPLETESTATUS}} with completed date within the chose time period that have a cost value on the job that is higher than the sales value on the job. KPI is count of these jobs.&#x20;

**Compliance Jobs Split per WorkStream**&#x20;

Taken from the compliance tables, the tile groups by description/workstream, counts the jobs where the Next Compliance Date is greater than today as ComplianceCount, counts the jobs where the the Next Compliance Date is before or equal to today as NonComplianceCount, we then have these counts as percentage of the property count. The KPI is the overall compliance percentage for all workstreams over the property count.

**Recorded Jobs Today**&#x20;

Job information for all jobs for when the job recorded date is today.

**Emergency Jobs Completed**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list and jobtypes in the {{EMERGENCYJOBTPES}} list where the status is in the {{COMPLETESTATUS}} list and the job completed date is the chosen time period. Grid is just a list of these jobs. KPI is a count of these jobs.&#x20;

**Equipment Listing**&#x20;

Exhaustive list of everything contained in the job asset table (GSJBASET). Fields include asset number, name, status, last and next checked date, notes, van reg and assignee id. KPI is count of rows.&#x20;

**First Time Fix (This Week)**&#x20;

Any job that doesn't contain an event with action required of 'SECOND VISIT', 'THIRD VISIT' or 'FOLLOWUP VISIT' is classified as a first time fix job. The grid will list the jobs that ARE first time fixes where the job completed date is within the past 7 days and the KPI is the percentage of the jobs that are first time fix jobs.

**Gas Service Properties Week 52**&#x20;

Information from the Gas Servicing Screen (GSPROSVC) where the custom week number is '52', the contract is in the {{GASCONTRACTS}} list. KPI is distinct count of properties

**Open Incident**&#x20;

Event information where the action required is 'INCIDENT' and the event status is 'OPEN'. KPI is count of events.&#x20;

**Jobs Recorded Today with Event Drilldown**&#x20;

Event information where the job recorded date is today for {{ONSTIE}} events. User can zoom into the event. KPI is distinct count of jobs.&#x20;

**Jobs with Classification LGSR Pending Review**&#x20;

Job information where job has classification of 'LGSR PENDING REVIEW'. KPI is distinct job count.

**Keys Received (Open)**&#x20;

From contracts in the {{VOIDCONTRACTS}} list, this tile has list of events where the event has status of 'OPEN' and an action required of 'KEYS RECEIVED'. KPI is count of events.&#x20;

**LGSRs Completed**&#x20;

LGSR (PDAMBZ04), job and property information from where the LGSR date is from the chosen time period.&#x20;

**MIleage**&#x20;

A report of the operatives, their van, their last mileage reading, their maximum mileage reading, their maximum/lastest amend date (so when they last took a mileage reading). KPI is a count of reg numbers.&#x20;

**Missing Client Order No**&#x20;

From contracts in the {GASCONTRACTS}} list, this tile lists the jobs where the client order number is blank. KPI is a count of these jobs.&#x20;

**Multiple Visits same Trade last 30 Days**&#x20;

From contracts in the {REPAIRSCONTRACTS}} list, including events with the arrived date within the last 30 days. The tile groups by job number and problem summary (trade) and contains the count of the problem summary where there is more than one. KPI is the distinct job count.&#x20;

**Next Check Date within 30 Days**&#x20;

Equipment information (GSJBASET) where the Next Checked Date is wihin the next 30 days. KPI is a count of these rows.&#x20;

**No Access Open Jobs >= 7 Days**&#x20;

The last event on the job is {{ONSITE}} with an {{OPENSTATUS}} Job status and the result summary is contained in the {{NOACCESS}} list and the arrived date wihin the past 7 days. KPI is the distinct job count.

**No LGSR Properties**&#x20;

List of service properties where the service group is 'Gas' or 'Gascap', the property is 'Active' and the last CP12 date is before this day last year. KPI is distinct count of properties.

**Non Compliant Properties**&#x20;

List of properties from the compliance table (JBCYTSK1) where the next compliance date is before or equal to today. KPI is dintinct count of these properties.

**Non Emergency Extended No Parts**

From contracts in the {REPAIRSCONTRACTS}} list and the jobtype is not in the {{EMERGENCYJOBTYPES}} list, this tile contains job information where the job recorded date is within the chosen time period and the extend reason is in the {{NOPARTS}} list. KPI is distinct count of these jobs.&#x20;

**Events in Dispute**&#x20;

This tile highlights events which have been rejected by the subcontractor. \
Events with 'Payment Amount Rejected' will need to be put into dispute manually via the 'Reset Event Status' screen under the SC Self Invoicing menu.\
All events need to be resolved and subsequently manually reset to resubmit to include the event in the following payment run.  The CTpaystatus is 'IN DISPUTE' or the Sub Con aprroved field is 'N'

**Non Emergency Extended Other Trade**&#x20;

From contracts in the {REPAIRSCONTRACTS}} list and the jobtype is not in the {{EMERGENCYJOBTYPES}} list, this tile contains job information where the job recorded date is within the chosen time period and the extend reason is in the {{OTHERTRADES}} list. KPI is distinct count of these jobs.&#x20;

**Number of Suppliers Not Paid (30 Days)**&#x20;

Information from the Purchase Invoice table (GSPURINV) where the posted status is not 'Y' and the purchase invoice date is within the past 30 days. KPI is distinct count of Purchase Invoice Doc Numbers.&#x20;

**Open POs Fully Authorised by Client**&#x20;

Purchase Order information where authorised = 'Y' and PO status is 'OPEN'. Table is linked to authorisation table (POHDRAUT) where the correct authorisation level needs to match. KPI is distinct purchase order count.&#x20;

**Contract Operative Absent Details**&#x20;

Entries from the engineer absent table (GSJBEGAB) for the current year. NonWeekendDaysOffFormula works out how many days they booked off, not including weekends. KPI is sum off all the days booked off for everyone.&#x20;

**Operative Events by Status Last 7 Days**&#x20;

Grouped by Assigned date, operative name and operative team, this tile counts their events completed, no access events, abandon events, follow on required events where assigned date is in the past 7 days . Psudeooperatives are not included. KPI is distinct count of events.&#x20;

**Operative Time Analysis**&#x20;

Grouped by Operative and action required, this tile adds up ther total time, their total onsite time and their total travel time for the assigned date within a chosen period. The KPI is the total time for all operatives in hours.&#x20;

**Operatives Driving Today**&#x20;

Coming from the mobile returns table, this tile shows the operatives, their start date, status, regno, mileage and if they are driving today or not. The actual date should be todays date and the status should be 'START DAY'.  KPI is percentage of drivers driving today over the full count of operatives in the returns table (who have driven before)

**POs Awaiting Authorisation by Client & Contract**&#x20;

Purchase Order information where authorised <> 'Y'. Table is linked to authorisation table (POHDRAUT) where the correct authorisation max and min level needs to match. KPI is distinct purchase order count.&#x20;

**Properties with 3 Service Letters & 3 No Accesses**&#x20;

Gas service table information (GSPROSVC) where contract is in the {{GASCONTACTS}} list, the service group is not 'NOGS' the service letters value is '3', the no access value is '3'. KPI is distinct count of these properties.

**Property Category Count**&#x20;

Tile report that counts the number of jobs per property category with the job completed date within the chosen date period.  KPI is the total count of these jobs.&#x20;

**Qualifications Expiring and Expired**&#x20;

Information from the engineers qualification table (GSJBEGQF) where the expiry date is less than 6 months (183 days) from today. KPI is distinct count of these rows.&#x20;

**SMV v Onsite Time**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list this tile lists {{ONSITE}} events where the assigned date is within the chosen time period. The grid contains a column 'Total Onstie Time for that Event' which is a total of onsite minutes, 'Total SOR SMVs for that Event' which is STD\_MIN\_VALS for that event and then the difference between these two columns. KPI is the count of events

**Stage Code Status**

An exhaustive list of all the entries in the GSJOBLGD table. The grid is grouped by 'sent'. KPI is a distinct count of the job numbers referenced in the table.&#x20;

**Stores PO Items**

Purchase order item entries (GSPOITM) where the Purchase Order ordertype is 'Stores' and item status is in the {{OPENSTATUS}} list. KPI is count of the rows.&#x20;

**Supplier Costs per Branch**&#x20;

Based on the Purchase Invoice table (GSPURINV), this tile groups by supplier and sums up the NetAmount, VATAmount, TotalAmount where posted = 'Y' and the invoice date is in the time period chosen.  KPI is the total amount.&#x20;

**Tenant Satisfaction - Repairs**&#x20;

From contracts in the {{REPAIRSCONTRACTS}} list, this tile is based on the core AccuMobile tenant satisfaction survey which lists all the surveys returned where the job completed date is in the chosen time period.  These tiles are quite complex and rely on pivot tables. The survey name needs to begin with 'Tenant-Sat'. It looks for entries named TENANTANSWER, TNTREASON, TNTSATAS1, TNTSATAS2, TNTSATAS3 and TNTSATAS4. Only rows with TENANTANSWER = 'Yes' are diplayed. KPI is distinct count of the jobs.&#x20;

**Tenant Satisfaction - Repairs Summary**&#x20;

This is a summary version of the above tile where it counts up the 'Yes' answers. And groups each row by the arrived month. KPI is a count of the surveys.&#x20;

**Tenant Satisfaction - Servicing**&#x20;

From contracts in the {{GASCONTRACTS}} list, this tile is based on the core AccuMobile tenant satisfaction survey which lists all the surveys returned where the job completed date is in the chosen time period.  These tiles are quite complex and rely on pivot tables. The survey name needs to begin with 'Tenant-Sat'. It looks for entries named TENANTANSWER, TNTREASON, TNTSATAS1, TNTSATAS2, TNTSATAS3 and TNTSATAS4. Only rows with TENANTANSWER = 'Yes' are diplayed. KPI is distinct count of the jobs.&#x20;

**Tenant Satisfaction - Servicing Summary**&#x20;

This is a summary version of the above tile where it counts up the 'Yes' answers. And groups each row by the arrived month. KPI is a count of the surveys.&#x20;

**Vehicle Checks**&#x20;

this tile is based on the core AccuMobile Vehicle Check survey which lists all the surveys returned where the survey load date is in the chosen time period.  These tiles are quite complex and rely on pivot tables. The survey name needs to begin with 'Vehicle-Check. It looks for entries named CABINGOODCONDITION, WATERLEVELOK, WINDWIPERSWORKOK, LIGHTSWORKINGOK, MIRROSINWORKORDER and TYRESWORKINGOK. KPI is distinct count of the rows.&#x20;

**WIP Breakdown**

This tile looks at all events with a status in {{OPENSTATUS}}. It is grouped by jobtype, and lists a count of jobs, events, OOT (todays date is greater than event target date), OOT percentage of all events, Appointed (events that don't have designation type of 'PENDING'), Appoint%, Not Appointed (events that do have designation type of 'PENDING') and NotAppointed%. KPI is a count off all the events.&#x20;
