AUDIT_RQ_QA_WL

(SQL Table)
 Index Back

Audit Quality

Audit Quality application Work List

  • Audit Record Of RQ_DEFECT_WL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
    2 AUDIT_STAMP DateTime(26) TIMESTAMP Date and Time Stamp
    3 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
    A=Add
    C=Change Old (PPR Only)
    D=Delete
    K=Change - Old Values
    N=Change - New Values
    O=Change - Original Values
    4 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
    5 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
    6 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
    7 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
    8 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
    9 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
    10 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_RQ_NONVW

    11 R_DEFECT_ID Character(15) VARCHAR2(15) NOT NULL Quality Defect Identification key unique by business unit
    12 R_PRIORITY_CODE Character(2) VARCHAR2(2) NOT NULL Priority
    1=High
    2=Medium
    3=Low
    13 R_PRIORITY_CD_DESC Character(30) VARCHAR2(30) NOT NULL Priority code
    14 R_ST_STATUS_CD Character(4) VARCHAR2(4) NOT NULL STATUS CODE
    15 R_ST_REASON_CD Character(4) VARCHAR2(4) NOT NULL Status Reason