AUDIT_RQ_QA_VW(SQL View) |
Index Back |
|---|---|
Audit QualityQuality application Work List |
| SELECT A.BUSINESS_UNIT , A.R_DEFECT_ID , B.BUSPROCNAME , B.ACTIVITYNAME , B.EVENTNAME , B.WORKLISTNAME , B.INSTANCEID , B.ACTIONDTTM , B.OPRID , B.ORIGINATORTYPE , B.ORIGINATORID , B.INSTSTATUS , B.PREVOPRID , B.INSTAVAILABLEDTTM , B.INSTSELECTEDDTTM , B.INSTWORKEDDTTM , B.INSTTIMEOUTDTTM , C.TRANSACTIONID , C.R_PRIORITY_CODE , C.R_PRIORITY_CD_DESC , C.R_ST_STATUS_CD , C.R_ST_REASON_CD FROM PS_RQ_DEFECT A , PSWORKLIST B , PS_AUDIT_RQ_QA_WL C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.R_DEFECT_ID = C.R_DEFECT_ID AND B.BUSPROCNAME = C.BUSPROCNAME AND B.ACTIVITYNAME = C.ACTIVITYNAME AND B.EVENTNAME = C.EVENTNAME AND B.WORKLISTNAME = C.WORKLISTNAME AND B.INSTANCEID = C.INSTANCEID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_RB.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 | BUSPROCNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: PSBUSPROCDEFN |
| 4 | ACTIVITYNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table: ACTIVITY_PROMPT |
| 5 | EVENTNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
Prompt Table: PSEVENTDEFN |
| 6 | WORKLISTNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Worklist Name
Prompt Table: WORKLIST_PRMPT |
| 7 | INSTANCEID |
Number(10,0) | DECIMAL(10) NOT NULL |
For a given worklist the unique number of rows in PSWORKLIST
Default Value: 999999999 |
| 8 | ACTIONDTTM | DateTime(26) | TIMESTAMP | Datetime action was taken on a worklist |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 10 | ORIGINATORTYPE | Number(5,0) | INTEGER NOT NULL | Originator Type |
| 11 | ORIGINATORID | Character(30) | VARCHAR2(30) NOT NULL |
Originator Identifier
Prompt Table: PSOPRDEFN |
| 12 | INSTSTATUS | Number(5,0) | INTEGER NOT NULL |
Determines worklist status, available, selected, worked, cancelled
0=Selected 1=Open 2=Worked 3=Cancelled |
| 13 | PREVOPRID | Character(30) | VARCHAR2(30) NOT NULL | Previous User ID |
| 14 | INSTAVAILABLEDTTM | DateTime(26) | TIMESTAMP NOT NULL | Datetime worklist instance was made available |
| 15 | INSTSELECTEDDTTM | DateTime(26) | TIMESTAMP | Datetime user selected a worklist entry |
| 16 | INSTWORKEDDTTM | DateTime(26) | TIMESTAMP | Datetime worklist instance was worked by a user |
| 17 | INSTTIMEOUTDTTM | DateTime(26) | TIMESTAMP | Datetime that a worklist times out |
| 18 | TRANSACTIONID | Number(10,0) | DECIMAL(10) NOT NULL | Transaction Identifier |
| 19 | R_PRIORITY_CODE | Character(2) | VARCHAR2(2) NOT NULL |
Priority
1=High 2=Medium 3=Low |
| 20 | R_PRIORITY_CD_DESC | Character(30) | VARCHAR2(30) NOT NULL | Priority code |
| 21 | R_ST_STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL | STATUS CODE |
| 22 | R_ST_REASON_CD | Character(4) | VARCHAR2(4) NOT NULL | Status Reason |