index back

Query RunTime Log

  • Parent record: PSQRYDEFN
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    APPLNAME Character(24) VARCHAR2(24) NOT NULL Name of Appl executing Qry
    EXECDTTM DateTime(26) TIMESTAMP Date and Time of Execution
    RUNOPRID Character(30) VARCHAR2(30) NOT NULL Operator Id that ran query
    EXECTIME Number(19,3) DECIMAL(18,3) NOT NULL Query Execution Time
    FETCHTIME Number(19,3) DECIMAL(18,3) NOT NULL Time for Fetching Results
    NUMROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
    MAXROWLIMIT Character(1) VARCHAR2(1) NOT NULL Max Rows Limit Reached
    KILLEDREASON Character(1) VARCHAR2(1) NOT NULL Killed Reason
    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20