WM_RELATED_WR

(SQL View)
 Index Back

Related Work Request view

Prompt view of Related Work Requests

SELECT BUSINESS_UNIT , WR_ID , TREE_NODE , WR_LOCATION , WR_PRIORITY , WR_SUBJECT , STATUS_CD , INTERNAL_STATUS , AGENT_ROLE , TECHNICIAN_ROLE , ASSIGNED_TO_OPRID , ASSIGNED_BY_OPRID , CONTACT_EMPLID , BUSINESS_UNIT_WO , WO_ID , REQUIRED_DATE FROM PS_WM_WR_HDR WHERE RELATED_WR_ID = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WR_ID Character(15) VARCHAR2(15) NOT NULL Work Request ID
3 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

Prompt Table: WM_PROBLEM_TREE

4 WR_LOCATION Character(10) VARCHAR2(10) NOT NULL Service Location
5 WR_PRIORITY Character(1) VARCHAR2(1) NOT NULL Service Request Priority
1=1-Critical
2=2-Urgent
3=3-Standard
4=4-Low
6 WR_SUBJECT Character(60) VARCHAR2(60) NOT NULL Subject
7 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
8 INTERNAL_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
9 AGENT_ROLE Character(30) VARCHAR2(30) NOT NULL Agent role name
10 TECHNICIAN_ROLE Character(30) VARCHAR2(30) NOT NULL Technician role name
11 ASSIGNED_TO_OPRID Character(30) VARCHAR2(30) NOT NULL Assigned To
12 ASSIGNED_BY_OPRID Character(30) VARCHAR2(30) NOT NULL Group Assigned by
13 CONTACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact Employee ID
14 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
15 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
16 REQUIRED_DATE Date(10) DATE Required By