P 2 K_PU.VALB
Back to current versionRestore this version

Leave Accrual Balance Information#

Functionality:#

This function retrieves information as seen on VALB, for an employee's leave accrual balance.

Parameters:#

EEM_ID The actual ID for the employment record of the employee you are getting data for
POLICY_TYPE The leave policy type you are looking for
WHAT Optional. Identifies what value you are retrieving. This must be one of the values as noted below. If i t is not provided, "BALANCE" will be used
AS_OF Optional. Provides a date frame to retrieve the data. If it is not provided, the current system date will be used.

WHAT Parameter Values#

PRIOR Shows the value of Prior Balance (A900 + A050)
EARNED Shows the Capped Balance (A330)
TAKEN Shows the Taken Balance (A300)
BALANCE Shows the Current Balance, excluding any unofficial earned or taken amounts (Prior Balance + Earned - Taken)
TOTAL Shows the Total time (Current Balance as above - Termination Time Payout (A760))

Returns: #

Number

Errors: #

None. If any errors occur, a zero value will be returned.

Example: #

P2K_PU.VALB(~,'VACATION')

Will return the current, processed balance for the employee's VACATION type plan

P2K_PU.VALB(~,'SICK','TAKEN')

Will return the accumulated taken time for the employee's SICK type plan