PSAESQLTIMINGS

 index back

PeopleSoft Field Name Field Type Column Type Description
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
AE_STEP Character(8) VARCHAR2(8) NOT NULL Name
PTAE_SQL_TYPE Character(1) VARCHAR2(1) NOT NULL
PTAE_ITERATION Number(5,0) INTEGER NOT NULL ITERATION
SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
    • SQLTEXT Long Character(14000) CLOB SQL Statement Text
    PTAE_SQL_VARIABLES Long Character(1024) VARCHAR2(1024)
    PTAE_SQL_ROWS Number(10,0) DECIMAL(10) NOT NULL SQL_ROWS
    STARTDATETIME DateTime(26) TIMESTAMP Start Datetime
    ENDDATETIME DateTime(26) TIMESTAMP End Datetime
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20