Logo: Wesleyan University
  • Tools
    • WesPortal
    • Directory
    • Library
    • OneStop
    • WesConnect
    • Calendar
    • WesMaps
    • WFS
    • Moodle
    • EMS
    • GApps
  • About
  • Admission & Financial Aid
  • Academics
  • Campus
  • Athletics
  • Give
  • Students
  • Alumni
  • Parents

Student Faculty Information System

PeopleSoft Campus Solutions

Feed on
Posts
Comments
« Alliance 2019 Call for Proposals

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.

Wesleyan_Function push button

Posted in BI Publisher, Campus Solutions Basics, Comm Gen, Demonstrations and presentations, PeopleTools, Query - Advanced, Query - Getting Started, Query Instruction

Comments are closed.