TL_AESECTPGM_VW (SQL View)	Index Back
Valdation AE Programs View against TL_AE_SECTION limiting return by PROCESS_TYPE = 'V'

TL_AESECTPGM_VW

(SQL View)

Valdation AE Programs

View against TL_AE_SECTION limiting return by PROCESS_TYPE = 'V'

SELECT DISTINCT S.AE_APPLID , A.DESCR FROM PS_TL_AE_SECTION S , PSAEAPPLDEFN A WHERE S.AE_APPLID = A.AE_APPLID AND PROCESS_TYPE = 'V'

# 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