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:


|[AAL_TODATE|P2K_PU.AAL_TODATE]|Given an employment ID [EEM_ID], a leave type [ALPT_ID] an Attendance code [AC_CODE] and a date range, captures total amount of processed leave lines for the specified range 
|[ACCUM_ADD|P2K_PU.ACCUMULATORS]|Used for totaling values outside the realm of the [UPPHF] and [UEEF] totaling functionality
|[ACCUM_INIT|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
|[ALA_LAST|P2K_PU.ALA_LAST]|Given an employment ID [EEM_ID], a leave type [ALPT_ID] an Attendance code [AC_CODE] and an as of date, capture the value of an AC_CODE from the last Accrual Record produced in the month. 
|[ALA|P2K_PU.ALA]|Retrieves attendance information as seen on [IALA]
|[BBL|P2K_PU.BBL]|Retrieves benefit line information from an employee's pay
|[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 [STATUS_TYPE] for an Employment [STATUS_CODE]
|[EASD_DIST|P2K_PU.EASD_DIST]|Retrieve distribution information for an assignment, as seen on [IEAS]
|[EASD|P2K_PU.EASD]|Retrieve assignment detail 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
|[ELEMENT_PC|P2K_PU.ELEMENT_PC]|Retrieves a comma separated list of Pay Components in the element identified, as seen on IPEL
|[EPS|P2K_PU.EPS] |Retrieve PERSONALS information
|[FILE_NAME|P2K_PU.FILE_NAME]|Used to transform a file name parameter using replacement phrases
|[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_BBR|P2K_PU.GET_BBR]|Captures Recipient ID [BBR_ID] for a contact, using a [PLAN_CODE] and an as of date 
|[GET_CHILD_ID|P2K_PU.GET_CHILD_ID]|Determines the ID of date-sensitive child record|
|[GET_EAS|P2K_PU.GET_EAS]|Determines the [EAS_ID] for an employee, given an [EEM_ID] and an [ASSIGNMENT_CODE] 
|[GET_EASD|P2K_PU.GET_EASD]|Determines the primary assignment [EASD_ID] for an employee, given a [PERSON_CODE] or [GOVERNMENT_CODE] 
|[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_EEM_ASOF|GET_EEM_ASOF]|Determine the [EEM_ID] for the employee given [PERSON_CODE],[ASSIGNMENT_TYPE] and an as of date.
|[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_PPH|P2K_PU.GET_PPH]|Captures Pay Header ID [PPH_ID] for an employee, given a [PERSON_CODE], a pay number [PAY_NUMBER] and batch id [PBT_ID] 
|[GET_PPP|P2K_PU.GET_PPP]|Determines the ID of the pay period record for an employee
|[GET_PPRU|P2K_PU.GET_PPRU]|Given an employment ID [EEM_ID], a state id [DSP_ID] and an as of date, capture US Pay Rule ID [IPRLU] 
|[IS_DATE|P2K_PU.IS_DATE]|Verifies if the string contains a valid formatted date
|[IS_NUMERIC|P2K_PU.IS_NUMERIC]|Verifies if the string contains only numeric values
|[PPH|P2K_PU.PPH]|Retrieve Pay Header information
|[PPR|P2K_PU.PPR]|Retrieves payment rule information for an employee, as seen on [IPPM]
|[PSN|P2K_PU.PSN]|Retrieve sundry line information, as seen on [IPSN]
|[SSR|P2K_PU.SSR]|Retrieves Salary Range information, as seen on [ISSR]
|[TCC|P2K_PU.TCC]|Retrieves CLOCK CARD information for an employee, as seen on [ITTC]
|[TOTAL_FTE|P2K_PU.TOTAL_FTE]|Totals the FTE across active assignments given an employment ID [EEM_ID] and an as of date  
|[TRANSLATE|P2K_PU.TRANSLATE]|Retrieves any translations as defined on [IMLA]
|[VALB|P2K_PU.VALB]|Retrieves attendance bank information (official and processed only) for an employee, as seen on [VALB]