PTIA_AEPGMS_VW (SQL View)	Index Back
Application Engine Programs Search Record for the PTIA_DCAEPGMS Component and a Prompt Table for the PTIA_DCAEPGMS Page.

PTIA_AEPGMS_VW

(SQL View)

Application Engine Programs

Search Record for the PTIA_DCAEPGMS Component and a Prompt Table for the PTIA_DCAEPGMS Page.

SELECT AE_APPLID , DESCR FROM PSAEAPPLDEFN WHERE AE_APPLID LIKE 'UPG%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description