CTI_REASONCODERB_UAD_SYSRSNCD(SQL View) |
Index Back |
|---|---|
UAD Presence CodesThis view contains PeopleTools CTI Presence Codes for UAD purposes. |
| SELECT A.CTI_REASONCODE , A.CTI_REASONMSG FROM PS_CTI_SYSREASON A WHERE A.PT_CTI_CONFIGID = ( SELECT B.PT_CTI_CONFIGID FROM PS_PT_CTI_CONFIG B WHERE B.PT_CTI_CONFIGID = A.PT_CTI_CONFIGID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CTI_REASONCODE |
Character(30) | VARCHAR2(30) NOT NULL | Reason Code |
| 2 | CTI_REASONMSG | Character(254) | VARCHAR2(254) NOT NULL | Reason Message |