PeopleSoft IDs Explained..

User Id
The User Id is the ID associated with the individual user logging onto the PeopleSoft application, via PeopleTools. Validation of this ID is performed by the People Tools themselves at log-in time, by virtue of verifying that a row has been defined in the PSOPRDEFN table for this ID. The row in the PSOPERDEFN table contains information pertinant to PeopleSoft internal security administration, such as the access profile defining what areas of the application this ID will have access to, and a link to the ACCESS ID (defined later) associated with the User Id.

---

Connect Id
The Connect Id is the actual ID that makes the initial log on connection to the database. It requires SELECT ONLY access to three tables: PSSTATUS, PSOPRDEFN, and PSACCESSPRFL. Once the row is located in PSOPRDEFN associated with the User Id entered, the associated Access Id is validated within PeopleTools, and the Connect Id is disconnected, and the Access Id is logged on.

---

Symbolic Id
The Symbolic Id isn't really an Id at all, but is referred to as such in the People Tools documentation. The Symbolic Id provides the "link" between the row containing the User Id in table PSOPRDEFN with the row containing the corresponding Access Id and Password in table PSACCESSPRFL. The Symbolic Id field is a regular field on table PSOPRDEFN and the key field on table PSACCESSPRFL. For each Access Id defined, you should define a unique Symbolic Id within the People Tools table PSACCESSPRFL. The Access Id is associated with the unique Symbolic Id in table PSACCESSPRFL, and the Symbolic ID is then linked with the specific User Id in table PSOPRDEFN, by updating the PSOPRDEFN.SYMBOLICID column.

---

Access Id
The Access Id is Database ID under which all DML statements are executed.

Stop the online save processing without displaying the error message

Recently during one of my development activity, I came across a requirement in which I needed to stop the save processing at certain condition.


First thing that came to my mind to use exit(1) function but it didn't work as exit(1) takes you out of peoplecode event but it doesn't stop the save processing.

In order to stop the save processing you need to raise an error but whenever you issue a error statement, it comes as a alert box on user window which was not desirable in my case.

After doing some googling I found a way to stop the online save processing without displaying the error message.
Steps:
1. Insert a HTML area on the 0 level of the page.

2. Assign a constant value to this HTML area as mentioned below.

Java Script Code

3. Now raise an error message like in save prechange people code

   Error "$sys$NoEcho: Save Cancelled";
Whenever system finds this magical string "$sys$NoEcho" in error statement, system will stop the save processing without displaying the error.

Privacy Policy for http://rahul-khandelwal.blogspot.com/ If you require any more information or have any questions about our privacy policy, please feel free to contact us by email at rahulkhandelw@gmail.com. At http://rahul-khandelwal.blogspot.com/, the privacy of our visitors is of extreme importance to us. This privacy policy document outlines the types of personal information is received and collected by http://rahul-khandelwal.blogspot.com/ and how it is used. Log Files Like many other Web sites, http://rahul-khandelwal.blogspot.com/ makes use of log files. The information inside the log files includes internet protocol ( IP ) addresses, type of browser, Internet Service Provider ( ISP ), date/time stamp, referring/exit pages, and number of clicks to analyze trends, administer the site, track user’s movement around the site, and gather demographic information. IP addresses, and other such information are not linked to any information that is personally identifiable. Cookies and Web Beacons http://rahul-khandelwal.blogspot.com/ does not use cookies. DoubleClick DART Cookie .:: Google, as a third party vendor, uses cookies to serve ads on http://rahul-khandelwal.blogspot.com/. .:: Google's use of the DART cookie enables it to serve ads to users based on their visit to http://rahul-khandelwal.blogspot.com/ and other sites on the Internet. .:: Users may opt out of the use of the DART cookie by visiting the Google ad and content network privacy policy at the following URL - http://www.google.com/privacy_ads.html Some of our advertising partners may use cookies and web beacons on our site. Our advertising partners include .... Google Adsense These third-party ad servers or ad networks use technology to the advertisements and links that appear on http://rahul-khandelwal.blogspot.com/ send directly to your browsers. They automatically receive your IP address when this occurs. Other technologies ( such as cookies, JavaScript, or Web Beacons ) may also be used by the third-party ad networks to measure the effectiveness of their advertisements and / or to personalize the advertising content that you see. http://rahul-khandelwal.blogspot.com/ has no access to or control over these cookies that are used by third-party advertisers. You should consult the respective privacy policies of these third-party ad servers for more detailed information on their practices as well as for instructions about how to opt-out of certain practices. http://rahul-khandelwal.blogspot.com/'s privacy policy does not apply to, and we cannot control the activities of, such other advertisers or web sites. If you wish to disable cookies, you may do so through your individual browser options. More detailed information about cookie management with specific web browsers can be found at the browsers' respective websites.