Question

PLSQL code for confirmation of time registrations

  • 25 March 2023
  • 2 replies
  • 51 views

Badge +1

Hello,

Does anyone know the correct plsql code for confirmation of a set of employees for a specific week?

The code currently used running is doing ok but not days which are still have remaining hours. Does any one have a solution for this?

 

Thanks in advance


2 replies

Userlevel 4
Badge +9

Hi Rob (long time, no see 😉),

If you want to ignore remaining hours (i.e. if the day should be confirmed despite the fact that the sum of normal hours and absence is not equal to the scheduled hours, and/or the quantity of job hours is not equal to the presence), you have to change the settings.

One option: the company property JOBRECON should be absent or have the value FALSE. That would be the default for all employees entering time.

Another option (which might be used in combination with the first one): use settings in the Parameter List (part of the Rule Type) to allow deviations (parameters Allowed positive diff to schedule, Allowed negative diff to schedule, Allowed positive diff between presence and job hours, Allowed negative diff between presence and job hours).

Best regards,

Martin

Badge +1

Hello Martin (indeed long time no see..),

Thank you for your reply! I will try the options you mentioned.

Best regards,

Rob

Reply