PSQRYEXECLOG

index back

Query RunTime Log


  • Parent record: PSQRYDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
    APPLNAMECharacter(24)VARCHAR2(24) NOT NULLName of Appl executing Qry
    EXECDTTMDateTime(26)TIMESTAMPDate and Time of Execution
    RUNOPRIDCharacter(30)VARCHAR2(30) NOT NULLOperator Id that ran query
    EXECTIMENumber(19,3)DECIMAL(18,3) NOT NULLQuery Execution Time
    FETCHTIMENumber(19,3)DECIMAL(18,3) NOT NULLTime for Fetching Results
    NUMROWSNumber(15,0)DECIMAL(15) NOT NULLNumber of Rows fetched.
    MAXROWLIMITCharacter(1)VARCHAR2(1) NOT NULLMax Rows Limit Reached
    KILLEDREASONCharacter(1)VARCHAR2(1) NOT NULLKilled Reason
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19