DERIVATION_EXPRESSION is a 2000 alphanumeric field which allows the user to add programming code for additional computation of the data within the record.

Derivation expressions provide the ability to translate values or to retrieve information otherwise not accessible in an interface format in IDIF. Data from within the Personality database may need to be translated to match the requirements from a receiving third party system. Also, data within a source file may need to be translated to match the Personality specifications.

See the article on derivation expression usage for details on how it work.

For additional information on what may be used within the Derivation Expression field see the page titled CALLABLE FUNCTION.

Derivation Expression usage is supported by the following list of functions:

  • UPPHF - Pay Header Interface
  • UEEF - Employee Interface
  • UPGLF - General Ledger Interface
  • UPVEND - Vendor A/P File Interface
  • UPDISBV - Disburse Vendor Payments (A/P File Interface)
  • UPPOSPAYW - Positive Pay Interface
  • LMTD - Table Loader
  • LBEN - Benefit Election Loader
  • LPTS - Timesheet Entry Loader


Notes #

Click to create a new notes page