Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

DB actie om een loonjaar snel 'In afsluitfase' of 'Operationeel' te zetten:

UPDATE cXXXX.t_wm_loonjaar SET wm_lnjr_status = 22773 WHERE wm_lnjr_loonjaar = 2022;
22773 = in afsluitfase

UPDATE cXXXX.t_wm_loonjaar SET wm_lnjr_status = 22772 WHERE wm_lnjr_loonjaar = 2022;
22772 = operationeel