MARKETRC_EVENT_SET_TYPEACTN=Case History
BP=Business Project Tracking
CREL=Case Relationship
ENBL=Entitlement Balances
SLA=Service Level Agreement Work
UPSL=Upsell Opportunities
WF=Workflow
SETIDPNLGRPNAMEEVENT_SET_IDUPG_RC_EVTST_VW(SQL View) |
Index Back |
|---|
| SELECT MARKET , RC_EVENT_SET_TYPE , SETID , PNLGRPNAME , EVENT_SET_ID FROM PS_RC_EVENT_SET A WHERE MARKET = 'GBL' AND PNLGRPNAME IN ( 'RC_CASE_HD', 'RC_CASE_HD_SS', 'RC_CASE_HD_SS_RPT', 'RC_CASE_SW', 'RC_CASE_SW_SS', 'RC_CASE_SW_SS_RPT') AND EXISTS ( SELECT 'X' FROM PS_RC_EVENT_SET B WHERE A.MARKET = B.MARKET AND A.SETID = B.SETID AND A.PNLGRPNAME = B.PNLGRPNAME AND A.RC_EVENT_SET_TYPE = B.RC_EVENT_SET_TYPE AND A.EVENT_SET_ID <> B.EVENT_SET_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 2 | RC_EVENT_SET_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Event Set Type
ACTN=Case History BP=Business Project Tracking CREL=Case Relationship ENBL=Entitlement Balances SLA=Service Level Agreement Work UPSL=Upsell Opportunities WF=Workflow |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 4 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 5 | EVENT_SET_ID |
Character(15) | VARCHAR2(15) NOT NULL | Event Set ID |