Attendance Report

                This Report gives the summarized view of Field Users  attendance for the selected date range. 

Figure 1: Screenshots of the parameters  available before downloading the report

It contains 3 different tabs:

• Attendance
• Summary 
• Activity

Detailed explanation of all these tabs is provided below. 

Report Logic: 

1. This report fetches the live data. That means, Hierarchy  of the Field Users will reflect as per the current mapping. 

2.Attendance of active Field Users  will reflect. 

Date Range Filter: Yes

Attendance

Figure 2: Screenshot  of a sample Attendance Report representing the headers 1-16

Understanding the Headers in the  sheet (from left to right):

1. Header (1-5) Employee Hierarchy: Hierarchy of a Field User. For Ex: ZonalSalesManager (Level-4) >   RegionalSalesManager(Level-3) > AreaSalesManager(Level-2) > Reporting   Manager (Whom the user is reporting) > User.

Note: Hierarchy level can be up to Level 7  depending upon the size/hierarchy principle of the company. 

1. User Rank: Rank of the user at which he is  present in Company Hierarchy. 
2. Employee Contact No.: Contact no. of the user by which he is registered in the system. 
3. Total Days: Total number of days (Date  range) for which the report is extracted. 
4. Working Days: Number of days for which user  has done working. That is if user has done retailing or other full day  activity. 
5. Retailing Days: Number of days user has done  retailing. 
6. Other Official Work: Number of days user has done Full day activities. 
7. Leave: Number  of days user has marked leave.
8. Holidays: Number of days user has marked holidays. 
9. Absent: Number  of days user has not marked any entry in the application.
10. Weekly Off: Number of days user has marked Weekly Off in the application. 
11. Avg. Retailing Time: Average time spend by the user in retailing wrt total days. 

Figure 3: Screenshot of a sample Attendance Report representing the  attendances day wise

The above screenshot is showing the day wise attendance of  the users with colour coding. 

P-Present

A-Absent

W-Weekly Off

L-Leave

O-Other Officials

Summary

The summary tab contains the day wise summary of the users.  Like: - Login time, Logout time, Retailing time, Total Time, TC, PC Productivity  etc.

Figure 4: Screenshot of a sample Attendance Report representing the  hierarchy headers

The above screenshot is representing the company hierarchy. 

Figure 5: Screenshot of a sample Attendance Report representing the  summary data 

Understanding the Headers in the sheet (from  left to right):

1. Tour Plan: If the company has opted Tour  Plan settings, the beats assigned to the user as per the tour plan will  reflect in this column. 
2. Type: Type of work done by the  user. Ex: Retailing, Meeting etc. 
3. Reason: Reason of doing other  activity. Like in (Meeting type), reason for the meeting. 
4. Assigned Beat: Pre-Assigned beat to the user  at the time of day start. Beats will reflect if company uses settings like Beat Plan. 
5. Selected Beats: Beats selected by the user at  the time of Start Day.
6. Login Time, Logout Time:  Login- Start Day time and Logout- End Day time in the application. 
7. Total Time: Total time when user was  logged In the application. (Logout-Login) time.
8. First Call Time: Time when first order was  done. (It can be productive/unproductive).
9. Last Call Time: Time when last order was  done. (It can be productive/unproductive).
10. Retail Time: Total time when user has done retailing. (Last Call-First Call) time.
11. TC: Total Calls done by the user.
12. PC: Total Productive Calls done by the user. 
13. Productivity: No. of Productive Calls/ No. of Total Calls * 100.
14. Retailing Grade: Grade given to the user based on the retailing time done by the user.
15. Retailing Grade Definition: Definition based on the Retailing Time. 

· A-  More than 3 Hours.

· B-  3 to 6 Hours.

· C-  Less than 2 Hours.

Activity:

This tab  shows the other activities done by the user date wise. 

The above screenshot is representing the company hierarchy. 

Understanding the Headers in the sheet (from  left to right):

1. Category: Type of Activity done by the user. Like: - Joint Working, Gate Meeting, Distributor Visit. 
2. Comment: Additional comments for the  Activity. 
3. Start Time: Start Time of the Activity.
4. End Time: End Time of the Activity.
5. Total Time: Total Time for which the  Activity is done. (End Time- Start Time).