1 / 27

Establishing Login Interrupts in the PeopleSoft Enterprise Portal June 2007

Establishing Login Interrupts in the PeopleSoft Enterprise Portal June 2007. Today’s Presenters. Jim Gallamo Director Sonya Hughes Web Specialist Suman Rustagi Senior Technical Advisor. Overview.

niyati
Télécharger la présentation

Establishing Login Interrupts in the PeopleSoft Enterprise Portal June 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Establishing Login Interrupts in the PeopleSoft Enterprise Portal June 2007

  2. Today’s Presenters Jim Gallamo Director Sonya Hughes Web Specialist Suman Rustagi Senior Technical Advisor

  3. Overview Catholic University created a unique method for interrupting the PeopleSoft Enterprise Portal login process to collect important information. This presentation describes our experience in developing and implementing this service.

  4. Agenda • CUA Overview • PeopleSoft Environment • Development Goals • Implementation Options • Key Development Considerations • Process Flow • Technical Details • Questions

  5. Overview • Located in Washington, DC • Founded in 1887 • 6000 Students • 1500 Faculty and Staff • Undergrad, Grad and Doctoral programs • 12 Schools including Law School • Research – Tier II

  6. PeopleSoft Environment • PeopleSoft SA/HRMS v8.0 SP1, PTools v8.20 • PeopleSoft Enterprise Portal v8.8, PTools v8.44 • Oracle 9i database • Dell and Sun Microsystems servers • Windows 2000 and Solaris v9 operating systems • Access to SA/HRMS via Enterprise Portal

  7. Server Environment

  8. Development Goals • Create a simple method for collecting data • Create a user-friendly interface • Configurable to any user population • Reusable technology components • Minimize impact to system performance

  9. Key Development Considerations • Maintain target data in source system • Maintain data integrity between systems • Real-time processing of updates • Removing and reapplying user access • Timing of feature usage by campus • Minimal impact to user navigation

  10. Implementation Options • Use Delivered PeopleSoft functionality • Hold/To Do Lists • Third-party development tools • ColdFusion, AJAX, etc. • Delivered PeopleSoft technology • PeopleTools, PeopleCode, SQR

  11. Solution • Custom development using PeopleSoft tools • Employ expire password functionality in Enterprise Portal • Use Sign-on PeopleCode from Enterprise Portal • Establish data links between systems

  12. Interrupt Process • Users load the guest bypass page on initial login • The password is expired to trigger the interrupt process • The custom pages are displayed, forcing data entry • The password will remain expired until the data entry is complete • Upon finishing, the password is un-expired and the user is logged out • Users can re-login successfully with full access on their next attempt

  13. Interrupt Process (cont’d)

  14. Interrupt Process (cont’d)

  15. Interrupt Process (cont’d)

  16. Interrupt Process (cont’d)

  17. Interrupt Process (cont’d)

  18. Interrupt Process (cont’d)

  19. Technical Details

  20. Technical Details (cont’d)

  21. Technical Details (cont’d)

  22. Technical Details (cont’d)

  23. Technical Details (cont’d) PeopleTools > Security > Password Configuration > Password Controls

  24. Technical Details (cont’d) PeopleTools > Web Profile > Select the profile you are using > Go to Look and Feel Tab. Permission List PSWDEXPR needs access to the new component and all the pages in the component.

  25. Update psoprdefn@PAPRD L set L.lastpswdchange = '18-APR-2006' where exists(SELECT 'K' FROM PS_STDNT_CAR_TERM Z WHERE Z.STRM in ('1071', '1075') AND L.EMPLID = Z.EMPLID AND EXISTS (select 'x' from PS_STDNT_ENRL B where Z.emplid = b.emplid and z.strm = B.STRM AND Z.ACAD_CAREER = B.ACAD_CAREER AND B.STDNT_ENRL_STATUS = 'E' AND B.ENRL_STATUS_REASON <> 'WDRW') AND NOT EXISTS(SELECT 'Y' FROM PS_ACAD_PROG A WHERE A.EMPLID = Z.EMPLID AND A.ACAD_CAREER = Z.ACAD_CAREER AND A.STDNT_CAR_NBR = Z.STDNT_CAR_NBR AND A.EXP_GRAD_TERM = '1071' AND A.ACAD_CAREER = Z.ACAD_CAREER AND A.STDNT_CAR_NBR = Z.STDNT_CAR_NBR AND A.EXP_GRAD_TERM = '1071' AND A.DEGR_CHKOUT_STAT <> ' ' AND A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_ACAD_PROG A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.ACAD_CAREER = A_ED.ACAD_CAREER AND A.STDNT_CAR_NBR = A_ED.STDNT_CAR_NBR AND A_ED.EFFDT <= SYSDATE) AND A.EFFSEQ = (SELECT MAX(A_ES.EFFSEQ) FROM PS_ACAD_PROG A_ES WHERE A.EMPLID = A_ES.EMPLID AND A.ACAD_CAREER = A_ES.ACAD_CAREER AND A.STDNT_CAR_NBR = A_ES.STDNT_CAR_NBR AND A.EFFDT = A_ES.EFFDT))) Technical Details

  26. Interrupt Usage • Current • Emergency Contact Information • Local Addresses • Cell Phone Notification • Future • Health Insurance Waivers • Financial Responsibility Statement

  27. Points of Contact • Suman Rustagi (rustagi@cua.edu) • Sonya Hughes (hughess@cua.edu) • Jim Gallamo (gallamo@cua.edu)

More Related