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:

BENRetrieves benefit plan and enrollment information for an employee, as seen on IBEN
CLOCKFormat time values
DES_TYPEProvides the EMPLOYMENT_TYPE for an Employment STATUS_CODE
EASDRetrieve assignment detail information for an assignment, as seen on IEAS
EASD_DISTRetrieve distribution information for an assignment, as seen on IEAS
EIDRetrieve Identity information
EIN_CODEGet federal or state government registrations
ECTRetrieve Contact information
PSNRetrieve sundry line information, as seen on IPSN
PPHRetrieve Pay Header information
PPRRetrieves payment rule information for an employee, as seen on IPPM
SSRRetrieves Salary Range information, as seen on ISSR
VALBRetrieves attendance bank information (official and processed only) for an employee, as seen on VALB
TRANSLATERetrieves any translations as defined on IMLA
FIRST_MGRGet Identity ID for derived first manager
GCRetrieve column value from a table, given the table ID
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
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
FILE_NAMEUsed to transform a file name parameter using replacement phrases