Hi,
Good morning everyone. I am new to developing queries and I am in a bit of a hang with this one.
I am in a process of creating a salary days checker in PeopleSoft Time and Labor. Here is the scenario:
A certain group of personnel gets a fixed monthly salary in addition to a daily rate for the number of days worked. The monthly salary is automatically added to each employee's record.
In some cases, the monthly salary is not generated automatically. New employees who are not yet included in a schedule should get this monthly salary but a trigger needs to set off beforehand. In this case, the monthly salary is missed accidentally if we are not informed about this.
My checker would have to be structured this way:
1. A query generates the list of employees that needs to get the monthly salary (I am currently at this stage of the query).
2. A table for the Employee Payable Time is joined. This has the date when employee gets salary days. The employee gets a total of 30 salary days per month.
3. A criteria for the period has to be added. This will only return those employees who got salary days. So if personnel does not get anything, he is removed from the list.
I can create two separate queries - first to get the list of personnel who should get salary days and second to get the number of salary days the personnel got and compare the results of each query to get the list of personnel that's missed.
What I want is to combine these so the personnel that does not appear in the second query should appear and just show 0.
Any help is appreciated. Thanks in advance.
Thanks,
Peter