Wiki: P 2 K

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:

BEN	Retrieves benefit plan and enrollment information for an employee, as seen on IBEN
CLOCK	Format time values
DES_TYPE	Provides the EMPLOYMENT_TYPE for an Employment STATUS_CODE
EASD	Retrieve assignment detail information for an assignment, as seen on IEAS
EASD_DIST	Retrieve distribution information for an assignment, as seen on IEAS
EID	Retrieve Identity information
EIN_CODE	Get federal or state government registrations
ECT	Retrieve Contact information
PSN	Retrieve sundry line information, as seen on IPSN
PPH	Retrieve Pay Header information
PPR	Retrieves payment rule information for an employee, as seen on IPPM
SSR	Retrieves Salary Range information, as seen on ISSR
VALB	Retrieves attendance bank information (official and processed only) for an employee, as seen on VALB
TRANSLATE	Retrieves any translations as defined on IMLA
FIRST_MGR	Get Identity ID for derived first manager
GC	Retrieve column value from a table, given the table ID
GET_EID	Determines the EID_ID for an employee, given either PERSON_CODE or GOVERNMENT_CODE
GET_EASD	Determines the primary assignment EASD_ID for an employee, given a PERSON_CODE or GOVERNMENT_CODE
ACCUM_INIT	Used for totaling values outside the realm of the UPPHF and UEEF totaling functionality
ACCUM_ADD	Used for totaling values outside the realm of the UPPHF and UEEF totaling functionality
ACCUM_VALUE	Used for totaling values outside the realm of the UPPHF and UEEF totaling functionality
FILE_NAME	Used to transform a file name parameter using replacement phrases