OPRIDRC_FILTER_NAMEA=Active
I=Inactive
RC_TRG_PRF_VW(SQL View) |
Index Back |
|---|---|
Call Center Async PAFThis record is for the asyncronous update of a case. |
| SELECT PRF.OPRID2 , AGT.RC_FILTER_NAME , AGT.RC_FILTER_DESCR , PRF.SEQ_NUM , PRF.ACTIVE_STATUS , AGT.WHERE_LONG FROM PS_RC_AGT_PREF AGT , PS_RC_AGT_TRG_PRF PRF WHERE AGT.OPRID = PRF.OPRID AND AGT.RC_FILTER_NAME = PRF.RC_FILTER_NAME |
| # | 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 | RC_FILTER_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Search Defintion name |
| 3 | RC_FILTER_DESCR | Character(35) | VARCHAR2(35) NOT NULL | Search definition description |
| 4 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | ACTIVE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Allows for Active and Inactive status.
A=Active I=Inactive |
| 6 | WHERE_LONG | Long Character | CLOB | Where Clause |