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_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 |
| DES_TYPE | Provides the EMPLOYMENT_TYPE for an Employment STATUS_CODE |
| 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 |
| VALB | Retrieves attendance bank information (official and processed only) for an employee, as seen on VALB |
| BEN | *Retrieves benefit plan and enrollment information for an employee, as seen on IBEN |
| PPR | *Retrieves payment rule information for an employee, as seen on IPPM |
| EIN_CODE | Get federal or state government registrations |
| CLOCK | Format time values |
| EASD_DIST | Retrieve distribution information for an assignment, as seen on IEAS |
| PSN | Retrieve sundry line information, as seen on IPSN |
| EID | Retrieve Identity information |
| ECT | *Retrieve Contact information |
| PPH | *Retrieve Pay Header information |
| FIRST_MGR | *Get Identity ID for derived first manager |
| GC | Retrieve column value from a table, given the table ID |
