Hi , This is an over view about REN server.Please go through the attached document

Open Configuration Manager -> Profile ->Create.
• Select Connection Type as Application Server.
• Enter Application Server Name
• Machine Name or IP Address should be your machine IP address on which application server domain resides.
• Port Number should be WSL port number.

Turn on Debugger Service. Bring the following changes in your PSAPPSRV.CFG file
Location: \\PS_HOME\appserv\DomainName\
Psappsrv.cfg:
..[People Code Debugger]
;————————————————————————-
PSDBGSRV Listener Port=15000
...
[PSAPPSRV]

If you are looking to learn about PeopleSoft Change Assistant and Upgrades, you can check the below site. It is a nice tutorial on how to do basic setup and use PeopleSoft Change Assistant

PeopleSoft Change Assistant and Upgrades

The PeopleSoft Internet Architecture (PIA) is a server-centric component architecture that enables secure end user access to PeopleSoft applications. Its components include the following:

• Internet Access Device
• Web Server
• Application Server
• Database Server

Each component fulfills a unique niche within the system, all of which are described in the PeopleSoft Internet Architecture Components lesson of this course.

Process scheduler status is stored as numeric values behind the RUNSTATUS field. So, here are the values corresponding to each value.

FIELDVALUE XLATSHORTNAME 
---------- ------------- 
1          Cancel    
2          Delete    
3          Error     
4          Hold      
5          Queued    
6          Initiated 
7          Processing
8          Cancelled 
9          Success   
10         No Success
11         Posted    
12         Not Posted
13         Resend    
14         Posting   
15         Generated 
16         Pending   

In this post I will attempt to explain how to dynamically assign a prompt table depending on a drop down value (see image below)

The table behind the grid is PORTAL_SECDYVW and as you can see from the image below, the PORTAL_AUTHNAME field has %EDITTABLE defined as a prompt table. The PORTAL_AUTHNAME is the "Name" column you see on the grid.

A very simple yet very useful code to give users the option to delete all grid rows on a page at once. I've implemented such a requirement by placing a "Delete all" button above a grid to give PeopleSoft users the option to delete all rows at once instead of clicking the "-" grid button. If the gird has, lets say, 20 rows, then a user will have to click the "-" delete grid button 20 times to delete all rows, compared to one click on the "Delete all" button.

Place the code below behind a field change event.

A straight forward SQL to get edit tables behind field(s) for a specific record. The SQL execludes any edit tables that start with "%" as those are dynamic edit tables with values populated by PeopleCode at run time and thus will not be of a good use in this query.

SELECT R.FIELDNAME 
 , R.EDITTABLE 
  FROM PSRECFIELDDB R 
  , PSDBFIELD F 
 WHERE R.RECNAME = :RecordName
   AND SUBSTR(R.EDITTABLE,1,1) <> '%'  
   AND R.EDITTABLE <> ' '  
   AND R.FIELDNAME = F.FIELDNAME
   AND F.FLDNOTUSED = 0;

A query that will take a PeopleSoft role name as an input and returns all pages that could be access by that role. The query will also indicate what kind of operations a user can perform on that page. Example, Add Update/Display and so forth.

A query that takes a PeopleSoft role name as a value and returns Permission List(s) associated to that role.