
Most of you all must be using this form to check absentism one day or the other. I have made some changes in the way data is queried.First of all let me explain the form controls. On the top left hand side there are two date pickers. Set the date range for the query here.
Option1: This allows us to filter paybooks we want to see in the results.We can query a particular paybook or all Permanent or Temporary paybooks or all paybooks.
Option 2: There are five reports here.
Report 1 and 2 gives us monthwise absentism figures for each worker. We can query from a minimum period of one month upto 12 months.In report 1 the query checks for the presence of absent kamjari code in wage entry against each worker. In report 2 this condition is checked plus it marks a person as absent if no kamjaricode is found for a person in wage entry after leaving out sundays.
Report 1 and 2 gives us monthwise absentism figures for each worker. We can query from a minimum period of one month upto 12 months.In report 1 the query checks for the presence of absent kamjari code in wage entry against each worker. In report 2 this condition is checked plus it marks a person as absent if no kamjaricode is found for a person in wage entry after leaving out sundays.
Report 3 gives us a daywise absentism report. Here if a worker is found to be absent by Kamjari Code or No Kamjari Code a '-' mark is displayed. The other markings displayed are 'S' for Paid Sick or Unpaid Sick, 'H'for paid holiday and 'P' for rest.
Report 4 lists out absent days using logic of report no. 2. To find a worker we can get the 'FND' form by pressing key F12.
Report 5 lists out workers absent during a particular day using logic of report no. 2.
Option 3: Use these options to sort your results. The first option is by Emp. No. whereas option no. 2 will show the persons with more absentism on top and option no. 3 is by House No.
The latest update is covered in Version 7th September and the file can be downloaded from
https://cid-40c8c3127198e7ff.skydrive.live.com/browse.aspx/Public/Sept2009
This update is for Premium Version. I will update the Basic Version also soon.
I would request users to use this report and give me their feedback.
