Final Project PeopleSoft Application Development

1. Final ProjectPeopleSoft Application Development Advisor: Prof. Khaled Elleithy Submitted By: Madhan Maram Student ID: 514512

2. What is ERP? ERP attempts to integrate all departments and functions across a company onto a single computer system that can serve all those different departments' particular needs. That is a tall order, building a single software program that serves the needs of people in finance as well as it does the people in human resources and in the warehouse. Each of those departments typically has its own computer system optimized for the particular ways that the department does its work. But ERP combines them all together into a single, integrated software program that runs off a single database so that the various departments can more easily share information and communicate with each other.

3. Architecture Diagram

4. PeopleTools - Some areas of focus PeopleSoft Internet Architecture Application Designer Application Engine Component/component Interface File/File Layout PeopleCode Security Manger Integration Broker Portals Reporting Data Archiving

5. Application Development PeopleSoft Applications are made up of a navigational structure, menus, components and pages. Using these elements new data or change, delete and modify the existing data in the application. PeopleSoft web browsing and working with database.

6. Application Designer: Every PeopleSoft Internet Architecture (PIA) application contains a collection of related objects that work together for a specific purpose. Developing and customizing PeopleSoft applications is a step-by-step process where you define and build the objects, establish relationships among objects, implement security, run your PeopleSoft application within an Internet Browser, and test every aspect thoroughly. You use one interactive tool, Application Designer, for the majority of these activities. Application Designer is an integrated development environment that enables you to work with the numerous objects of a business application in a single work area. The following section introduces you to Application Designer's development environment.

7. Application Engine: Called App Engine is mostly used for batch processing, for example we have to schedule a student�s registration list for the whole semester on a particular date, and we can schedule and automates the process. Application Engine is the People Tool that you use to develop batch or online programs that are effective alternatives to COBOL or SQR programs (for non-report processing). Using Application Engine, you can create programs that perform high-volume, background processing against your data. Application Engine is comprised of two distinct components: the "front-end" where you define your batch program and the"back-end," which entails running and monitoring our program .

8. Web Interface Navigation Left-hand navigation . Updated structure Security Enhancements Create Row Level Security for Various Profiles Improved Home Pages

9. Peoplecode: Plays the major role in the application, considering the administration at UB. Not all users get the same access towards the application. This security is contained in the application sample. The PeopleSoft Internet Architecture falls into the category of PeopleSoft online security, also known as runtime security. Only authorized users can connect to the web and application servers, and only authorized application servers can connect to a given database.

10. Security: Plays the major role in the application, considering the administration at UB. Not all users get the same access towards the application. This security is contained in the application sample. The PeopleSoft Internet Architecture falls into the category of PeopleSoft online security, also known as runtime security. Only authorized users can connect to the web and application servers, and only authorized application servers can connect to a given database.

11. Web Interface Navigation Left-hand navigation . Updated structure Security Enhancements Create Row Level Security for Various Profiles Improved Home Pages

12. A few technical aspects in developing How the tables are created. How the pages are created, various tools used. How the relations are developed. How components are developed. How permissions and roles are created for access to only specific personnel in a business. How reports are generated. How search Engines can be developed.� How batch processes are scheduled. Security Administration.

13. Creation of Records Open Application DesignerFile New > Select type > Record The Records are thus created very much similar to any Online Objects. The fields, Application Engine Programs, and every other online objects skeletal build initiates through Application Designer. The ability to create robust and powerful internet applications of PeopleSoft functions like web pages. Support as many existing page controls and concepts as possible. Ability for the application to operate in a menu system independently.

15. Few of the Records created for the Application Course Tables Session tables Instructor tables Location tables Route tables Review tables Suggestions tables Enrollment tables Tasks Tables Task Review tables

16. Adding Controls to Pages Add controls to your page definition by the following: dragging and dropping a field definition (or record field in your project workspace) into a page using the Page Definition Toolbar using the Insert menu.

17. Developing RelationshipsRelationships are built using levels LEVELS Level 0 Course RecordsLevel 1 Session RecordLevel 2 Instructor Record The Records have a parent child relation, PeopleSoft holds this relation having at least one additional primary key together with all in the child record. This is explained with Multiple Sessions for a single course available for the semester. The level 2 record contains all the primary keys in Level 1 Record and an extra primary key.

18. Creating Components For all the WebPages, there will be a corresponding component create. The hierarchy � All the online pages are built in application designer and are attached to a Component. The Components are Attached to Menu. The Menus are classifies as USE and SET UP The Set up menu � Mostly are Configuration tables. A one time bulk data entry The USE tables are Transaction Tables, These are Informative and Helps to Query out the Information from the Database. The Components are Added to the MenuFile New � Menu � Insert Component

19. List of Pages Created Address Page Bus and Bus Routes Pages Course and Sub Pages Curriculum and Tasks page Enrollment Pages Equipment Pages Expenses Pages Location Pages Review and Search pages Session and Student Pages Suggestion and Suggestion Review Pages Task Effort Pages

20. List of Batch Programs Application Engine Programs To Load PeopleSoft tables from External Files These files are scheduled through Process Scheduler This loads Bulk data in to Application tables replicating the enterprise batch processing. The programs to write the bulk data in to a Flat File. The Programs using component Interface to load information, which helps to validate the information prior to loading.

24. File Layout A File Layout is a definition (or mapping) of a file to be processed. It identifies where in a file data fields are located. Once a File Layout has been created, you can write PeopleCode programs that use the file object, which in turn use the File Layout, to either read data from or write data to a file. Types of File layouts. Fixed Positional Each field has a starting position and a length which is their descriptive location. Sequence Positional (CSV) Fields are separated and the order of appearance is their descriptive location. Tagged (XML) Each field has predefined tags (or identifiers) surrounding it. In the Application that I have developed File Layout is used with application engine program for importing data in to the system and to send data out of the system. Replicating the arching job process at the corporate level.

25. Sample Input File ADCC DATA COMMUNICATIONS 06/11/2003 11/13/2003 5M 9 15OA AC1 CHECK 09/09/2003 10/09/2003 45D 9 5OA C1 F4 0D 0 0 AL1 0 0 C1 G6 0D 0 0 AL1 0 0 C1 S2 10/06/200310/12/2003 4D 3 7NAL1 2 3 AIB INTEGRATION BROKER 10/16/200310/18/2003 2D 0 0 A AD CC1 FINAL PROJECT 10/08/200210/17/2002 0D 2 6IA AL1 TWO TIER 10/16/200310/30/2003 4D 4 7II

26. Sample Output File E(0N&l0O&l8D&l88F(s16.66H&a9L&k2G REPORT GENERATION DCC DATA COMMUNICATIONS 11-JUN-2003 13-NOV-2003 C1 CHECK 09-SEP-2003 24-FEB-2004 IB INTEGRATION BROKER 16-OCT-2003 18-OCT-2003 DCC1 FINAL PROJECT 08-OCT-2002 17-OCT-2002 L1 TWO TIER 16-OCT-2003 30-OCT-2003 The Special Characters at the top of the report defines the printer configuration.

27. Main Menu AND Base Table Menu

28. All the base records are loaded Instructor Location Student Equipment Bus, etc.,

29. Sample Online Pages

30. Interface Thanks for the interest you showed in presentation, also special thanks to Professor Khaled elleithy and all CS department for the support throughout my course curriculum

31. Thanks