KK_EE_CODES_VW (SQL View)	Index Back
Entry Event Prompt View This prompt is within the CC budget definition. It's used for entry event code prompting. The view will retrieve the max entry event value that has atleast one active row. The view does not retrieve the results based on any date. This eliminates the need to insert a new effdt row in the cc defn each time a new entry event is added.

KK_EE_CODES_VW

(SQL View)

Entry Event Prompt View

This prompt is within the CC budget definition. It's used for entry event code prompting. The view will retrieve the max entry event value that has atleast one active row. The view does not retrieve the results based on any date. This eliminates the need to insert a new effdt row in the cc defn each time a new entry event is added.

SELECT DISTINCT B.ENTRY_EVENT , A.DESCR FROM PS_EE_EVENT_HDR A , PS_EE_EVENT_PRCS B WHERE A.SETID = B.SETID AND A.ENTRY_EVENT = B.ENTRY_EVENT AND B.EE_PROCESS IN ('BUDG','PCBUDG') AND B.EFFDT= ( SELECT MAX(C.EFFDT) FROM PS_EE_EVENT_PRCS C WHERE C.SETID=B.SETID AND C.ENTRY_EVENT=B.ENTRY_EVENT AND C.EFF_STATUS<>'I')

Related Language Record: KK_EE_CODE_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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