OPRIDEFFDT0=0 - None
1=1 - Info
2=2 - Debug
Default Value: 0
RB_AGT_CRCTI_VW(SQL View) |
Index Back |
|---|---|
Current CTI Agent InformationView used to fetch the current effective dated CTI agent information |
| SELECT A.OPRID ,A.EFFDT ,A.PT_CTI_AGENTID ,A.PT_CTI_PASSWORD ,A.PT_CTI_QUEUE ,A.PT_CTI_CONFIGID ,A.PT_CTI_TRACELEVEL ,A.PT_CTI_APPUSERNAME ,A.PT_CTI_APPUSERPSWD ,A.PT_CTI_CLIENTSIG FROM PS_PT_CTI_AGENT A WHERE ((EXISTS ( SELECT 'X' FROM PS_PT_CTI_AGENT B WHERE A.OPRID=B.OPRID AND B.EFFDT <= %CurrentDateIn) AND A.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_PT_CTI_AGENT B1 WHERE A.OPRID=B1.OPRID AND B1.EFFDT <= %CurrentDateIn) ) OR (NOT EXISTS ( SELECT 'X' FROM PS_PT_CTI_AGENT C WHERE A.OPRID=C.OPRID AND C.EFFDT <= %CurrentDateIn) AND A.EFFDT = ( SELECT MIN(C1.EFFDT) FROM PS_PT_CTI_AGENT C1 WHERE A.OPRID=C1.OPRID AND C1.EFFDT > %CurrentDateIn) ) ) |
| # | 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 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | PT_CTI_AGENTID | Character(32) | VARCHAR2(32) NOT NULL | CTI Agent ID |
| 4 | PT_CTI_PASSWORD | Character(128) | VARCHAR2(128) NOT NULL | Agent Password |
| 5 | PT_CTI_QUEUE | Character(6) | VARCHAR2(6) NOT NULL | Queue |
| 6 | PT_CTI_CONFIGID | Character(4) | VARCHAR2(4) NOT NULL | Configuration ID |
| 7 | PT_CTI_TRACELEVEL | Character(1) | VARCHAR2(1) NOT NULL |
trace level
0=0 - None 1=1 - Info 2=2 - Debug Default Value: 0 |
| 8 | PT_CTI_APPUSERNAME | Character(32) | VARCHAR2(32) NOT NULL | Application User Name |
| 9 | PT_CTI_APPUSERPSWD | Character(64) | VARCHAR2(64) NOT NULL | Application User Password |
| 10 | PT_CTI_CLIENTSIG | Character(32) | VARCHAR2(32) NOT NULL | CTI Client Signature |