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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |