PNLGRPNAMERECNAMEDTTM_CREATEDEMPLIDGP_MT_ITR2_VW(SQL View) |
Index Back |
|---|---|
Iter Trg EE for Mass Trg EventThis view selects all employees for which GP iterative triggers that have been created with relation to a certain mass trigger event. It serves as a base record for the GP Iterative Triggers page GP_MT_ITER_TRG on level 2. |
| SELECT DISTINCT R.PNLGRPNAME , R.RECNAME , T.TRGR_CREATE_TS , T.EMPLID FROM PS_GP_MT_RESULT R , PS_GP_ITER_TRGR T WHERE T.EMPLID = R.EMPLID AND T.TRGR_CREATE_TS=R.DTTM_CREATED AND T.ITER_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 |