AUDIT_RQ_QA_VW2

(SQL View)
 Index Back

Audit Quality

Audit Quality application Work List

SELECT A.BUSINESS_UNIT , A.R_DEFECT_ID , A.AUDIT_STAMP , A.AUDIT_OPRID , A.AUDIT_ACTN , A.BUSPROCNAME , A.ACTIVITYNAME , A.EVENTNAME , A.WORKLISTNAME , A.INSTANCEID , A.TRANSACTIONID , A.R_PRIORITY_CODE , A.R_PRIORITY_CD_DESC , A.R_ST_STATUS_CD , A.R_ST_REASON_CD , B.OPRID FROM PS_AUDIT_RQ_QA_WL A , PSWORKLIST B WHERE A.BUSPROCNAME = B.BUSPROCNAME AND A.ACTIVITYNAME = B.ACTIVITYNAME AND A.EVENTNAME = B.EVENTNAME AND A.WORKLISTNAME = B.WORKLISTNAME AND A.INSTANCEID = B.INSTANCEID AND A.TRANSACTIONID = B.TRANSACTIONID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_RQ_NONVW

2 R_DEFECT_ID Character(15) VARCHAR2(15) NOT NULL Quality Defect Identification key unique by business unit
3 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
4 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.
5 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
6 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
7 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
8 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
9 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
10 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
11 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
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
16 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).