EE_PROMPT_AL_VW

(SQL View)
 Index Back

All Entry Events

All effective entry event codes as of the current date.

SELECT A.SETID , A.ENTRY_EVENT FROM PS_EE_EVENT_PRCS A WHERE A.EFFDT = ( SELECT MAX(AA.EFFDT) FROM PS_EE_EVENT_PRCS AA WHERE A.SETID = AA.SETID AND A.ENTRY_EVENT = AA.ENTRY_EVENT AND A.EE_PROCESS = AA.EE_PROCESS AND A.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event