PRCSRENMAP_VW

index back

SELECT U.MCFREN_URL_ID , U.MCFREN_INT_URL , U.MCFREN_BROWSER_URL , U.AUTHTOKEN , U.REN_CLUS_ROOT_PATH , U.ACTIVE_FLAG FROM PSMCFRENURLID U , PSRENCLUS_OWNER O WHERE U.MCFREN_URL_ID = O.MCFREN_URL_ID AND (RENOWNER ='R' OR RENOWNER ='A')

PeopleSoft Field Name Field Type Column Type Description
MCFREN_URL_ID Character(15) VARCHAR2(15) NOT NULL REN Server Cluster ID
MCFREN_INT_URL Character(254) VARCHAR2(254) NOT NULL REN Server Cluster URL
MCFREN_BROWSER_URL Character(254) VARCHAR2(254) NOT NULL REN Server Browser URL
AUTHTOKEN Character(100) VARCHAR2(100) NOT NULL Authentication Domain
REN_CLUS_ROOT_PATH Character(50) VARCHAR2(50) NOT NULL REN Server Cluster Root Path
ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19