REN Server

The PeopleSoft Real-time Event Notification (REN) Server is part of the PeopleTools Application Server. It is a vital part of the MultiChannel Framework (MCF).

Sometimes the REN Server black box needs some prompting in its set up. To get an overview of the set up, use the following tables:

PSMCFRENURLID

Key: MCFREN_URL_ID

Contains one row for each cluster and shows the URLs to use for the cluster.

PSRENCLUSTER

Key: MCFREN_URL_ID, REN_ID

Is the link table between PSMCFRENURLID and PSREN

PSREN

Key: REN_ID

Contains one row for each server within the cluster.

select * 
from PSMCFRENURLID 
where 
ACTIVE_FLAG='A'
;

select R.* 
from PSMCFRENURLID C
inner join PSRENCLUSTER RC on (RC.MCFREN_URL_ID=C.MCFREN_URL_ID)
inner join PSREN R on (RC.REN_ID=R.REN_ID)
where
C.ACTIVE_FLAG='A'
;