Wesleyan Functions List
Aug. 29, 2018 by Carolyn Pike
The most recent iteration of the list of Wesleyan Functions can be accessed on the page Query – WESLEYAN FUNCTIONS
What is a “Wesleyan Function“?
- A Wesleyan Function is a user-defined function, i.e. it is pre-written text created specifically for inclusion in Query Expressions for Wesleyan PeopleSoft users.
- These functions are in addition to the numerous standard SQL functions that can be applied to Query Expressions. They have been developed by ITS programmers to enable the PeopleSoft user to exploit the benefit that Expressions can lend to a query.
- The term “function” as used with PeoplesSoft Query can have a number of definitions. So to differentiate this specialized, Wesleyan use of the term, we refer to a function created by ITS as a Wesleyan (or Wes) Function.
- Examples include WES_GET_NAME, WES_GET_CLASS_YEAR, and WES_GET_MAJORS
- As with most Functions used in an Expression, the Wesleyan Function is usually related to a field in the SFIS Database.
- The most commonly associated field is EMPL_ID.
