PRCSRENMAP_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MCFREN_URL_ID | Character(15) | VARCHAR2(15) NOT NULL | REN Server Cluster ID |
| 2 | MCFREN_INT_URL | Character(254) | VARCHAR2(254) NOT NULL | REN Server Cluster URL |
| 3 | MCFREN_BROWSER_URL | Character(254) | VARCHAR2(254) NOT NULL | REN Server Browser URL |
| 4 | AUTHTOKEN | Character(100) | VARCHAR2(100) NOT NULL | Authentication Domain |
| 5 | REN_CLUS_ROOT_PATH | Character(50) | VARCHAR2(50) NOT NULL | REN Server Cluster Root Path |
| 6 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive |