MARKETPNLGRPNAMEPrompt Table: RC_AUTH_PG_VW
EVENTNAMERC_EVENTDFN_USE(SQL View) |
Index Back |
|---|---|
Event definition record |
| SELECT A.MARKET ,A.PNLGRPNAME , A.EVENTNAME , COUNT(*) FROM PS_RC_EVENT_DFN A , PS_RC_EVENT_SET B , PS_RC_EVENTSET_ITM C WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND C.MARKET = A.MARKET AND B.SETID= C.SETID AND B.EVENT_SET_ID = C.EVENT_SET_ID AND (A.EVENTNAME = C.EVENTNAME OR A.EVENTNAME = C.EVENTNAME_EVAL) GROUP BY A.MARKET,A.PNLGRPNAME, A.EVENTNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL | Market |
| 2 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Component Name
Prompt Table: RC_AUTH_PG_VW |
| 3 | EVENTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 4 | COUNT_TOTAL | Number(9,0) | DECIMAL(9) NOT NULL | Total Count |