PTAE_ACT_STP_VW

(SQL View)

SELECT DISTINCT AE_APPLID , AE_SECTION , AE_STEP FROM PSAESTMTDEFN WHERE AE_STMT_TYPE IN ('P', 'S', 'C')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PTAE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
2	PTAE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
3	PTAE_STEP	Character(8)	VARCHAR2(8) NOT NULL	Name