GPES_SEG_TRG_VW

(SQL View)
Index Back

Payee Segmentation Triggers

Payee Segmentation Triggers

SELECT A.EMPLID , A.EMPL_RCD , A.COUNTRY , A.TRGR_EVENT_ID , A.TRGR_EFFDT , MIN(A.TRGR_CREATE_TS) , A.SEG_TRGR_STATUS , A.CAL_RUN_ID FROM PS_GP_SEG_TRGR A WHERE A.COUNTRY ='ESP' GROUP BY A.EMPLID, A.EMPL_RCD, A.COUNTRY, A.TRGR_EVENT_ID, A.TRGR_EFFDT, A.SEG_TRGR_STATUS, A.CAL_RUN_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
4 TRGR_EVENT_ID Character(10) VARCHAR2(10) NOT NULL Trigger Event ID
5 TRGR_EFFDT Date(10) DATE NOT NULL Trigger Effective Date

Default Value: %Date

6 TRGR_CREATE_TS DateTime(26) TIMESTAMP NOT NULL Trigger Creation Timestamp
7 SEG_TRGR_STATUS Character(1) VARCHAR2(1) NOT NULL Segmentation Trigger Status
A=Active
C=Cancelled

Default Value: A

8 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id