PSAESTEPSVW (SQL View)	Index Back
PSAESTEPSVW: Store all AE STEPS with only interested Fields. This view also force all field values converted to UPPER case in this view since there was a violation of Case defined in field PSAESTEPDEFN and PSAESTMTDEFN.

PSAESTEPSVW

(SQL View)

PSAESTEPSVW:

Store all AE STEPS with only interested Fields. This view also force all field values converted to UPPER case in this view since there was a violation of Case defined in field PSAESTEPDEFN and PSAESTMTDEFN.

SELECT UPPER(d.AE_APPLID) , UPPER(d.AE_SECTION) , UPPER(d.AE_STEP) , UPPER(m.AE_STMT_TYPE) , UPPER(d.PTAE_LOGGING_SQL) FROM PSAESTEPDEFN d JOIN PSAESTMTDEFN m ON 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'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 AE_STMT_TYPE Character(1) VARCHAR2(1) NOT NULL Type
C=Call Section
D=Do Select
H=Do When
M=Log Message
N=Do Until
P=PeopleCode
S=SQL
U=Update/Insert/Delete
W=Do While
X=XSLT

5 PTAE_LOGGING_SQL Character(1) VARCHAR2(1) NOT NULL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
2	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
3	AE_STEP	Character(8)	VARCHAR2(8) NOT NULL	Name
4	AE_STMT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type C=Call Section D=Do Select H=Do When M=Log Message N=Do Until P=PeopleCode S=SQL U=Update/Insert/Delete W=Do While X=XSLT
5	PTAE_LOGGING_SQL	Character(1)	VARCHAR2(1) NOT NULL