MCFREN_URL_IDMCFREN_PHYS_RTENTMCFUQAGENTIDPSMCFAGENTVW(SQL View) |
Index Back |
|---|---|
Agent in MCF cluster and queuePrompt table |
| SELECT A.MCFREN_URL_ID , A.MCFREN_PHYS_RTENT , B.MCFUQAGENTID FROM PSMCFRENURL A , PSMCFUQAGENTQ B WHERE A.MCFREN_PHYS_RTENT=B.MCFREN_PHYS_RTENT |
| # | 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_PHYS_RTENT |
Character(32) | VARCHAR2(32) NOT NULL | Physical Queue Id |
| 3 | MCFUQAGENTID |
Character(30) | VARCHAR2(30) NOT NULL | Agent Id |