GP_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 |