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

DATA RETRIEVAL

BI Publisher, Communication Generation, and Population Selection work with Query and other methods to categorize the data to be used in the final output.

 

_person with red i 

 

BI Publisher (formerly called XML Publisher or XMLP)

Oracle Business Intelligence Publisher or BI Publisher (formerly XML Publisher or XMLP)is a template-based reporting tool that you can use with PeopleSoft to directly take information from the database (generally through PS Query) to author, manage and deliver reports and forms more easily and faster than traditional reporting tools.

A primary feature of Oracle’s BI Publisher product is the separation of the data extraction process from the report layout. BI Publisher enables you to design and create report layout templates with the more common desktop applications of Microsoft Word and Adobe Acrobat, and renders XML data based on those templates.

BI Publisher is a key element in the Communication Generation process.

 

_person with letter mailbox 2

 

Communications Generation (Comm Gen)

The Communication Generation  process is a procedure that enables you to select specific fields from which to extract critical data for a letter code assigned to the individual (or organization) IDs for whom you want to generate the communication.  BI Publisher is a PeopleTools feature that enables you to manage and merge communication templates and data source files for the Communication Generation process to use to generate letters and emails. The process also enables you to generate corresponding envelopes and labels for a letter communication.  To use the Communication Generation process, you must first assign a communication record for the desired letter code to the intended recipients. You can assign communications to individuals or organizations manually, or you can use the 3C engine to assign them using the Population Selection process.

 

_magnifying glass with red handle

Population Selection (and Mass Assign) (Pop Select)

Population Selection is a framework that feeds Populations to a client process.  It can include any number of fields the process needs.  It enables loose integration to Selection Tools (PS Query, external files, Equation Engine).  It is highly configurable and extensible.

_red presentation

More information – from outside sources – can be found on this page:  PROCEDURES – OVERALL [External References]

There also is a page of outside references about PeopleSoft Query.

Comments are closed.

Modified on: Feb 13th, 2017 Log in

  • Student Faculty Information System

    PEOPLESOFT CAMPUS SOLUTIONS
  • Updates

    • Wesleyan Functions List
    • Alliance 2019 Call for Proposals
    • Alliance 2019 Registration and Housing Rates are Now Available
    • NERUG 2018 Conference Advance Rate Available
    • HEUG Webinars in August
  • Documentation

    • >Welcome<
    • ***Security Request Form***
    • INTRODUCTION
      • * SFIS Access
      • * SFIS and Web Browsers
      • * SFIS FAQs
      • * SFIS QUICK LINKS/ LOGIN
      • * SFIS User Defaults
      • UPGRADE: New & Notable Features
        • – What’s New? –
        • Activity Guide
        • Common Attribute Framework
        • Milestones
        • Program Enrollment and Activity Management
        • Query and Reporting Features
        • Related Content
        • Work Centers
    • PROCEDURES
      • PROCEDURES – SFIS
        • Committees
        • DATA RETRIEVAL
          • BI PUBLISHER/ XMLP
            • BIP Templates
              • BIP – Fields, Tables and Forms
              • BIP – Formatting
              • BIP – Pivot Table and Chart
            • BIP Tutorials and Demonstrations
          • COMM GEN (Communication Generation)
          • POP SELECT
        • Duplicate Records and Search/Match
        • Error Messages, Troubleshooting, Tips, FAQs
        • External Organizations
          • SAT Codes – CEEB Codes – ATP Codes
        • Glossary – PS Campus Solutions
        • Service Indicators (Holds)
      • PROCEDURES ~ General
        • CS 9.0, PTools 8.54
        • CS 9.2, PTools 8.55
        • HEUG WEBSITE Features
        • HEUG: Alliance and Other Links
        • HEUG: BI Publisher
        • HEUG: Comm Gen
        • HEUG: Pop Select and Pop Update
        • Link – Upgrade Blog
        • Links List
        • Oracle/PS Documentation
    • QUERY
      • QUERY INSTRUCTION
        • PS Query Instruction – Overview
          • 1 – Basic Query Concepts and Query Viewer
          • 2 – Query Manager
          • 3 – Advanced Concepts
      • QUERY PRESENTATIONS/ DEMOS
        • Counts, Sums and Conditions – Criteria and Having Pages
        • Dates in Query
        • Effective Dates in Query
        • Expressions and Wesleyan Functions
        • Joins In Query
        • Prompts in Query
      • QUERY TOOLS AND REFERENCES
        • Annotated Visual Demo – Creating a Query
        • Connected Query and BI Publisher
        • Criteria Properties
        • Encyclopedia/ Glossary
        • Query – EXPRESSIONS / FUNCTIONS
        • Query – WESLEYAN FUNCTIONS
        • Query FAQs and Troubleshooting
        • Query Manager Pages
        • Query to Excel – Pivot Table
        • Query Viewer – View Results & Run to Excel
        • Searching and Records Commonly Used
        • Tip Sheet for Query
      • QUERY ~ EXTERNAL REFERENCES
        • Expression Syntax (SQL) – Outside Sources
        • Using Microsoft Excel and Word with PS Query
    • Links

      • HEUG Website
      • Oracle Error Messages
      • PeopleSoft Wiki
    • SFIS Blog Links

      • Blog List of Links
      • Oracle / PS Documentation
      • Query Wesleyan Functions
      • SFIS Access
      • SFIS List of Links
      • SFIS Query Instruction Course
    • Wesleyan Links

      • Academic Calendar
      • Campus Solutions (SFIS) Upgrades
      • Finance Monthly
      • ITS System Announcements
      • News @ Wesleyan
      • SFIS Blog Home Page
      • WES ITS Home Page
      • WesMaps
  • Archives

Student Faculty Information System © 2025 All Rights Reserved.


Wesleyan University

44 Wyllys Avenue
Middletown, CT 06451
60-111-1111

  • Contact Us
  • Copyright & Privacy

© 2014 Wesleyan University

Resources

  • Human Resouces
  • Library
  • ITS
  • Student Accounts
  • Residential Life
  • Career Center
  • Offices & Services

Find It

  • Employment
  • Directions
  • Give
  • Apply
  • Athletics
  • CFA
  • Events
  • Visit Wesleyan
  • WESU (radio)

Tools

  • Portfolio
  • Directory
  • Library
  • OneStop
  • Wesconnect
  • Calendar
  • WesMaps
  • WFS
  • Moodle
  • EMS
  • Gapps

Connect With Us

Facebook Twitter Flickr YouTube Tumblr Google Plus
iTunes U