OPRIDTRGR_EVENT_IDGP_RTO_EVT_SRCH(SQL View) |
Index Back |
|---|---|
Trigger event - RetroTrigger event - Retro |
| SELECT C.OPRID ,A.TRGR_EVENT_ID ,A.COUNTRY ,A.DESCR FROM PS_GP_RTO_EVT A , PS_GP_OPR_RULE_PRF C WHERE C.USED_BY= 'A' OR (C.USED_BY = 'C' AND A.COUNTRY = C.COUNTRY) |
| # | 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 | TRGR_EVENT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Trigger Event ID |
| 3 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |