OPRIDRB_AGT_CFG_VW(SQL View) |
Index Back |
|---|---|
Agent Configure SearchSupervisor Desktop Agent Configuration Search record |
| SELECT A.OPRID , A.OPRDEFNDESC , B.PT_CTI_AGENTID , B.PT_CTI_QUEUE , C.MCFUQAGENTID , P.PERSON_ID FROM PSOPRALIAS U , PS_RD_PERSON P , PS_RB_AGT_CRCTI_VW B , PSOPRDEFN A , PSOPRDEFN A2 , PSMCFUQAGENTS C WHERE A.OPRID = A2.OPRID AND U.OPRID = A.OPRID AND U.OPRALIASTYPE = 'PER' AND P.PERSON_ID = U.PERSON_ID AND P.CONTACT_FLAG='I' AND A.OPRID = B.OPRID (+) AND A2.OPRID = C.MCFUQAGENTID (+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 3 | PT_CTI_AGENTID | Character(32) | VARCHAR2(32) NOT NULL | CTI Agent ID |
| 4 | PT_CTI_QUEUE | Character(6) | VARCHAR2(6) NOT NULL | Queue |
| 5 | MCFUQAGENTID | Character(30) | VARCHAR2(30) NOT NULL | Agent Id |
| 6 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |