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:

|[ALA|P2K_PU.ALA]|Retrieves attendance information as seen on [IALA]
|[BEN|P2K_PU.BEN]|Retrieves benefit plan and enrollment information for an employee, as seen on [IBEN]
|[CLOCK|P2K_PU.CLOCK]|Format time values
|[DES_TYPE|P2K_PU.DES_TYPE]|Provides the [EMPLOYMENT_TYPE] for an Employment [STATUS_CODE]
|[EASD|P2K_PU.EASD]|Retrieve assignment detail information for an assignment, as seen on [IEAS]
|[EASD_DIST|P2K_PU.EASD_DIST]|Retrieve distribution information for an assignment, as seen on [IEAS]
|[ECT|P2K_PU.ECT]|Retrieve Contact information
|[EID|P2K_PU.EID]|Retrieve Identity information
|[EIN_CODE|P2K_PU.EIN_CODE]|Get federal or state government registrations
|[EPS|P2K_PU.EPS] |Retrieve PERSONALS information
|[ELEMENT_PC|P2K_PU.ELEMENT_PC]|Retrieves a comma separated list of Pay Components in the element identified, as seen on IPEL
|[PSN|P2K_PU.PSN]|Retrieve sundry line information, as seen on [IPSN]
|[PPH|P2K_PU.PPH]|Retrieve Pay Header information
|[PPR|P2K_PU.PPR]|Retrieves payment rule information for an employee, as seen on [IPPM]
|[TCC|P2K_PU.TCC]|Retrieves CLOCK CARD information for an employee, as seen on [ITTC]
|[SSR|P2K_PU.SSR]|Retrieves Salary Range information, as seen on [ISSR]
|[VALB|P2K_PU.VALB]|Retrieves attendance bank information (official and processed only) for an employee, as seen on [VALB]
|[TRANSLATE|P2K_PU.TRANSLATE]|Retrieves any translations as defined on [IMLA]
|[FIRST_MGR|P2K_PU.FIRST_MGR]|Get Identity ID for derived first manager
|[GC|P2K_PU.GC]|Retrieve column value from a table, given the table ID
|[GET_EID|P2K_PU.GET_EID]|Determines the [EID_ID] for an employee, given either [PERSON_CODE] or [GOVERNMENT_CODE] or [EXTERNAL_RETIREMENT_ID]
|[GET_EEM|P2K_PU.GET_EEM]|Determines the [EEM_ID] for the first active employment for an employee, given a [PERSON_CODE] or [GOVERNMENT_CODE] or [EXTERNAL_RETIREMENT_ID]
|[GET_EASD|P2K_PU.GET_EASD]|Determines the primary assignment [EASD_ID] for an employee, given a [PERSON_CODE] or [GOVERNMENT_CODE] 
|[ACCUM_INIT|P2K_PU.ACCUMULATORS]|Used for totaling values outside the realm of the [UPPHF] and [UEEF] totaling functionality
|[ACCUM_ADD|P2K_PU.ACCUMULATORS]|Used for totaling values outside the realm of the [UPPHF] and [UEEF] totaling functionality
|[ACCUM_VALUE|P2K_PU.ACCUMULATORS]|Used for totaling values outside the realm of the [UPPHF] and [UEEF] totaling functionality
|[FILE_NAME|P2K_PU.FILE_NAME]|Used to transform a file name parameter using replacement phrases
|[ISNUMBER|P2K_PU.ISNUMBER]|Verifies if the string contains only numeric values