PSAESTEPSUI_VW

index back

PSAESTEPSUI_VW

A View for UI dropdown box display, using the promote table, promote to PSAESTEPSVW.
SELECT d.AE_APPLID , d.AE_SECTION , d.AE_STEP , m.AE_STMT_TYPE , d.PTAE_LOGGING_SQL FROM PSAESTEPDEFN d, PSAESTMTDEFN m WHERE d.AE_APPLID= m.AE_APPLID AND d.AE_SECTION= m.AE_SECTION AND d.AE_STEP= m.AE_STEP AND m.AE_STMT_TYPE = 'S' AND d.PTAE_LOGGING_SQL = 'Y'

PeopleSoft Field Name Field Type Column Type Description
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
PTAE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

Prompt Table: PTAE_ADL_SCT_VW
Set Control Field: AE_APPLID

PTAE_STEP Character(8) VARCHAR2(8) NOT NULL Name

Prompt Table: PTAE_ADL_STP_VW
Set Control Field: PTAE_SECTION

PTAE_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Type
P=PeopleCode
S=SQL
PTAE_LOGGING_SQL Character(1) VARCHAR2(1) NOT NULL

Y/N Table Edit

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20