PNLGRPNAMERECNAMEDTTM_CREATEDEMPLIDTRGR_EFFDTC=Cancelled
I=In Process
P=Processed
U=Unprocessed
Default Value: U
GP_MT_RTO_VW(SQL View) |
Index Back |
|---|---|
Retro Trg for Mass Trg EventThis view selects all GP retro triggers that have been created for a mass trigger event. It serves as a base record for the GP Retro Triggers page GP_MT_RTO_TRG on level 2. |
| SELECT E.PNLGRPNAME , E.RECNAME , T.TRGR_CREATE_TS , T.EMPLID , T.TRGR_EFFDT , T.TRGR_STATUS , T.TRGR_DESCR , T.CAL_RUN_ID FROM PS_GP_MT_TRG_DFN D , PS_GP_MT_TRIGGER E , PS_GP_RTO_TRGR T WHERE E.PNLGRPNAME = D.PNLGRPNAME AND E.RECNAME = D.RECNAME AND T.COUNTRY = D.COUNTRY AND T.TRGR_EVENT_ID = D.TRGR_EVENT_ID AND T.TRGR_CREATE_TS = E.DTTM_CREATED AND T.RTO_TRGR_SRC = 'S' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PNLGRPNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component Name |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | DTTM_CREATED |
DateTime(26) | TIMESTAMP | Datetime Created |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | TRGR_EFFDT |
Date(10) | DATE NOT NULL | Trigger Effective Date |
| 6 | TRGR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of a retro trigger. Contains code set (translate values)
C=Cancelled I=In Process P=Processed U=Unprocessed Default Value: U |
| 7 | TRGR_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Trigger Tag |
| 8 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |