Testing for non-recording of Annual Leave

2 posts / 0 new
Log in or register to post comments
Last post
Sun, 07/07/2019 - 20:27
#1
ericardo79
Offline
Joined: 03/07/2019 - 21:58
Testing for non-recording of Annual Leave

Hi,
I am testing for the risk of employees not recording Annual Leave appropriately. I have 3 sets of data, ie Employee Leave Taken, Network Access and Building Access listing. I cannot get my head around how I can identify instances on an ordinary working day have not access the network or building. The assumption in this scenario is that if the employee is working, they would have accessed both. Of course, there will be some explained reasons.
 
Have any of you performed such test? I am curious to hear how you performed it in IDEA. Thanks.

Top
Mon, 07/08/2019 - 08:37
Equipmentman1662
Offline
Joined: 05/23/2018 - 16:46

Could you add a field to each table and name it  "Table" and input the following  for each table "Employee Leave Taken", "Network Access", and "Building Access Listing"  respectively and then join the three tables on the field "Table".  
Then perform a Duplicate Exclusion where EE Name and Date are the same but the "Table" field is different?

Top