Feed on
Posts
Comments

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.

Wesleyan_Function push button

 

 

 

 

 

 

Latest news from HEUG about Alliance 2019:

Call for Proposals is Now Open!

Who makes the Alliance conference a success? YOU! Attendees want to hear about ideas, tools and lessons learned from someone that has been there and done that. As a fellow user, you can offer them just that. Not to mention, it gets you a discounted registration!

The Alliance Planning Committee would like to encourage you to share your knowledge and experience. Any idea is welcome no matter how big or small.

Propose a Session

Latest news from HEUG about Alliance 2019:

Registration & Housing Rates are Now Available

The Alliance 2019 Planning team has received several inquiries about the 2019 registration and housing costs.

While you can’t book your accommodations or register for the conference until November 7, 2018, we wanted to get the registration and housing information up for you to review so you can begin planning your trip to Alliance 2019!

 

Northeast Regional User Group (NERUG) 2018 Conference

Advanced Registration Rate available for NERUG Conference August 6 through September 9, 2019

Click here for more information

 

 

Older Posts »

Log in