PTAE_ST_TRACLVL

(SQL Table)
Index Back

Selective Tracing Levels

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

Prompt Table: PTAE_ACT_PLGXVW

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

Prompt Table: PTAE_ST_SCTP_V
Set Control Field: AE_APPLID

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

Prompt Table: PTAE_ST_STPP_V
Set Control Field: PTAE_SECTION

5 PTAE_STMT_TYPE Character(1) VARCHAR2(1) NOT NULL Actions Available for Selective Tracing.
C=Call Section
D=Do Select
H=Do When
M=Log Message
N=Do Until
P=PeopleCode
S=SQL
W=Do While
X=XSLT
6 PTAE_TRCPCVAL Number(7,0) INTEGER NOT NULL PepopleCode Trace Bit Value Indicator

Default Value: 0

7 PTAE_TRCSQLVAL Number(7,0) INTEGER NOT NULL SQL Trace Bit Value Indicator

Default Value: 0

8 PTAE_ST_ENROLL Character(1) VARCHAR2(1) NOT NULL Selecitve Tracing Enrollment Indicator

Y/N Table Edit