Function: SENIOR

SENIOR (Empl-no, Option-requested, As-of-date, Units, ...)

Arguments

  1. Employee number (PERSID)
  2. Option requested. See list below
  3. As-of-date: for what date to return the seniority
    (Default is today's date)
  4. Units requested. See list below

Result

A number, or in some cases a date: The employee's seniority in the units requested.

Possible OPTION values

  • A category from the SENCAT table. Returns the employee's seniority, in the units requested, using the new seniority calculation engine.

  • HIRE : The number of years (and fraction) since the employee's first hire date (E_ORIGHIRE) *

  • HIRE1 : The number of years (and fraction) since the employee's seniority date (E_SENIORDT), or if empty, from their first hire date (E_ORIGHIRE) *

  • HIREDT : The employee's original date of hire (E_ORIGHIRE). Note: this option returns a date, not a number.

  • REHIRE : The number of years (and fraction) since the employee's last rehire date (E_LASTHIRE). *

  • REHIRE1 : The number of years (and fraction) since the employee's seniority date (E_SENIORDT), or if empty, from their last hire date (E_LASTHIRE) *

  • REHIREDT : The employee's last date of hire (E_LASTHIRE). Note: this option returns a date, not a number.

  • SENRANK : The employee's seniority rank (E_SENRANK). Returns 0 if not assigned. This function does not recalculate it.

These options always return years, regardless of the units requested. For employees terminated before the requested date, they return the number of years up to the termination date.


© Carver Technologies, 2022 • Updated: 08/22/22
Comment or report a problem with this topic