SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
KEYWORD1CONV_KEYWRD_VW2(SQL View) |
Index Back |
|---|---|
Conversations by Keyword |
| SELECT a.setid , c.keyword1 , c.descr FROM PS_CUST_CONVER_HDR a , ps_keyword_tbl_ar c WHERE c.setid = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.setid AND RECNAME = 'KEYWORD_TBL_AR') AND (c.keyword1=a.keyword1 OR c.keyword1=a.keyword2 OR c.keyword1=a.keyword3) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | KEYWORD1 |
Character(10) | VARCHAR2(10) NOT NULL | Keyword |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |