PSREN_MCF_VW(SQL View) |
Index Back |
---|
SELECT DISTINCT A.MCFREN_URL_ID , A.MCFREN_INT_URL , A.MCFREN_BROWSER_URL FROM PSMCFRENURLID A , PSRENCLUS_OWNER B WHERE A.MCFREN_URL_ID=B.MCFREN_URL_ID AND (B.RENOWNER='A' OR B.RENOWNER='M') |
# | 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 |