Creating Left Outer Joins in PSQuery

To create a left outer join on a new query:

1. On the Query Manager search page (Reporting Tools, Query, Query Manager), click the Create New Query link.
   
2. On the Records page, search for the first (left) record for the left outer join.
   
3. Click the Add Record link on the same row as the record that you want to add.
   
   The Query page appears.
   
   
4. Select the appropriate fields to add to the query.
   
5. Navigate to the Records page.
   
6. Find the joining record and then click the Join Record link on the same row as that record.
   
7. Select Join to get additional fields only (Left outer join).
8. Complete the join.
   
   • If the Enable Auto Join preference is selected on the Query Preference page, click the record name to join with.
     
   • If the Enable Auto Join preference is not selected on the Query Preference page, click the OK button.
     
9. Define the join criteria.
   
   • If the Enable Auto Join preference is selected, the Auto Join Criteria page appears.
     You can clear the criteria from the query. You can also click the Add Criteria button to add or edit criteria or conditions. If no common keys are between the two join records, a message appears instead of the Add Criteria page.
     
   • If the Enable Auto Join preference is not selected, the Auto Join Criteria page does not appear.
     If you want, navigate to the Criteria page to add criteria to the ON clause of the outer join. The This Criteria Belongs To drop-down list box specifies where the criteria will appear. Select the alias that corresponds to this join record.
     
10. Define the effective date criteria.
    
    • For 2–3 tier client: If the joined record is an effective-dated record, the Effective Date Criteria page appears.
      You can accept the defaults or change them as desired.
      
    • For 4–tier PeopleSoft Pure Internet Architecture: If the joined record is an effective dated record, a message appears stating that an effective date criteria has been automatically added.
      Optionally, you can navigate to the Criteria page to change the defaults for this criteria.
      
11. To ensure that the left outer join finished successfully, navigate to the Query page.
    Text for the joined records confirms a successful left outer join.
    
12. (Optional) If the query has multiple joins to the same security record, which can be resource intensive and time consuming when it runs, select the Security Join Optimizer option to improve the performance of this query.
    
    
    HAPPY LEARNING :)
     

What is an Applcation Designer?

Lets understand what is an Application Designer in PeopleSoft.

PeopleSoft Application Designer or App Designer – as it is commonly called, as the name suggests, is used to create and modify PeopleSoft applications. With App. Designer, you can create and modify most of the objects in PeopleSoft.

This is the Integrated Development Environment (IDE) that you can use to work with numerous PeopleSoft definitions like Fields, Records, Pages, Components, Menus, PeopleCode and more.Like any other standard IDE, Application Designer supports graphical user interface and drag and drop facility.

HAPPY LEARNING :)

PeopleTools

Here are some PeopleTools we can learn.

1. Application Designer

    We use it for creating Fields, Records, Pages, Component, Menu.

2. Application Engine 

    We use it to create background processes.

3. BI Publisher 

    It is a reporting tool, We use it for reporting.

4. nVision 

    It is a reporting tool.

5. Component Interface 

    It is used to expose a peoplesoft Component to third party applications like excel etc.

There are some more tools in peoplesoft but we will discuss them later.


HAPPY LEARNING :) 

History of PeopleSoft ? What is PeopleSoft ?

Dave Duffield and Ken Morris founded PeopleSoft in 1987, when they engineered the company’s first human resources application. Built on a client-server architecture, their solution offered flexibility and ease-of-use to a class of users previously barred from simplified access to the information and capabilities centralized in mainframes.

By putting ease of functionality directly in the hands of users, PeopleSoft quickly assumed industry leadership status in human resources solutions.

This would be the first of many innovations that would transform the way enterprises do business on a global scale. In 2000, PeopleSoft introduced the Pure Internet Architecture®. Even today, it is the only pure-internet architecture with no code on the client.

It has enabled what PeopleSoft calls the Real-Time Enterprise. It allows organizations to connect people directly to business processes, eliminating intermediaries, inside and outside the enterprise. It creates unprecedented efficiency and lowers costs.

It provides businesses with an unmatched competitive advantage. The Real-Time Enterprise sets the standard for business performance in the 21st century, and PeopleSoft is at the forefront of enabling businesses to make this model a reality.

PeopleSoft was the world’s second largest provider of enterprise application software. PeopleSoft’s business solutions are built with the flexibility to fit your business today and the adaptability to change with your business over time.

A broad portfolio of applications with industry-specific functionality gives you unprecedented flexibility to optimize business operations and compete more effectively.

PeopleSoft is a worldwide leader in providing complete solutions for more than 24 industries—from industrial manufacturing and consumer goods to financial services, healthcare, and public sector organizations.

More than 12,200 organizations worldwide—from mid-sized manufacturing companies to the largest service enterprises in both the private and public sectors—are using PeopleSoft solutions to build stronger and more profitable businesses.

PeopleSoft applications are built on innovative and open technology, enabling easy integration with third-party applications and legacy systems. And PeopleSoft’s pioneering Total Ownership Experience initiative ensures the best overall user experience at the lowest cost of ownership.

Founded in 1987 and headquartered in Pleasanton, California, PeopleSoft has 12,000 employees and annual revenues of more than $2.3 billion.

HAPPY LEARNING :)