GP_MT_ITER_VW (SQL View)	Index Back
Iter Trg for Mass Trg Event This view selects all GP iterative triggers that have been created for a mass trigger event. It serves as a base record for the GP Iterative Triggers page GP_MT_ITER_TRG on level 3.

GP_MT_ITER_VW

(SQL View)

Iter Trg for Mass Trg Event

This view selects all GP iterative triggers that have been created for a mass trigger event. It serves as a base record for the GP Iterative Triggers page GP_MT_ITER_TRG on level 3.

SELECT R.PNLGRPNAME , R.RECNAME , T.TRGR_CREATE_TS , T.EMPLID , T.CAL_RUN_ID , T.ITER_TRGR_STATUS FROM PS_GP_MT_RESULT R , PS_GP_MT_TRG_DFN D , PS_GP_ITER_TRGR T WHERE D.PNLGRPNAME = R.PNLGRPNAME AND D.RECNAME = R.RECNAME AND T.EMPLID = R.EMPLID AND T.TRGR_CREATE_TS = R.DTTM_CREATED AND T.ITER_TRGR_SRC = 'S' AND T.COUNTRY = D.COUNTRY

# 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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

6 ITER_TRGR_STATUS Character(1) VARCHAR2(1) NOT NULL Iterative Trigger Status
C=Cancelled
I=InProcess
P=Processed
U=UnProcessed
Default Value: U

#	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	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
6	ITER_TRGR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Iterative Trigger Status C=Cancelled I=InProcess P=Processed U=UnProcessed Default Value: U