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 | Retrieves attendance information as seen on IALA |
| BEN | Retrieves benefit plan and enrollment information for an employee, as seen on IBEN |
| BBL | Retrieves benefit line information from an employee's pay |
| 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 |
| ECT | Retrieve Contact information |
| EID | Retrieve Identity information |
| EIN_CODE | Get federal or state government registrations |
| EPS | Retrieve PERSONALS information |
| ELEMENT_PC | Retrieves a comma separated list of Pay Components in the element identified, as seen on IPEL |
| 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 |
| TCC | Retrieves CLOCK CARD information for an employee, as seen on ITTC |
| 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 or EXTERNAL_RETIREMENT_ID |
| 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 | Determines the primary assignment EASD_ID for an employee, given a PERSON_CODE or GOVERNMENT_CODE |
| GET_CHILD_ID | Determines the ID of date-sensitive child record |
| GET_PPP | Determines the ID of the pay period record for an employee |
| 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 |
| IS_NUMERIC | Verifies if the string contains only numeric values |
| IS_DATE | Verifies if the string contains a valid formatted date |
| GET_PPRU | Captures Pay Header ID PPH_ID for an employee, given a PERSON_CODE, a pay number PAY_NUMBER and batch id PBT_ID |
| TOTAL_FTE | Captures Pay Header ID PPH_ID for an employee, given a PERSON_CODE, a pay number PAY_NUMBER and batch id PBT_ID |
| AAL_TODATE | Captures Pay Header ID PPH_ID for an employee, given a PERSON_CODE, a pay number PAY_NUMBER and batch id PBT_ID |
| ALA_LAST | Captures Pay Header ID PPH_ID for an employee, given a PERSON_CODE, a pay number PAY_NUMBER and batch id PBT_ID |
| 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_BBR | Captures Recipient ID BBR_ID for a contact, using a PLAN_CODE and an as of date |
