This utility package of functions is intended to be used to assist in Derivation Expression and script creation. These custom functions also can be used in report writing to obtain information otherwise not easily obtained by other means.

This package contains the following functions:

ACCUM_INITUsed for totaling values outside the realm of the UPPHF and UEEF totaling functionality
ACCUM_ADDUsed for totaling values outside the realm of the UPPHF and UEEF totaling functionality
ACCUM_VALUEUsed for totaling values outside the realm of the UPPHF and UEEF totaling functionality
DES_TYPEProvides the EMPLOYMENT_TYPE for an Employment STATUS_CODE
GET_EIDDetermines the EID_ID for an employee, given either PERSON_CODE or GOVERNMENT_CODE
GET_EASDDetermines the primary assignment EASD_ID for an employee, given a PERSON_CODE or GOVERNMENT_CODE
VALBRetrieves attendance bank information (official and processed only) for an employee, as seen on VALB
BENRetrieves benefit plan and enrollment information for an employee, as seen on IBEN
PPRRetrieves payment rule information for an employee, as seen on IPPM
EIN_CODEGet federal or state government registrations
CLOCKFormat time values
EASD_DISTRetrieve distribution information for an assignment, as seen on IEAS
PSNRetrieve sundry line information, as seen on IPSN
EIDRetrieve Identity information
ECTRetrieve Contact information
PPHRetrieve Pay Header information
FIRST_MGRP2K_PU.FIRST_MGR]Get Identity ID for derived first manager