WM_WR_HDR_SRCH

(SQL View)
 Index Back

Work Request Search view

Work Request Search record definition

SELECT A.BUSINESS_UNIT , A.WR_ID , A.TREE_NODE , A.WR_LOCATION , A.WR_PRIORITY , A.WR_SUBJECT , A.STATUS_CD , A.INTERNAL_STATUS , A.BUSINESS_UNIT_AM , A.ASSET_ID , B.WR_ASSET_OPEN_WOS , B.ASSET_OPEN_WO_CNT , A.AGENT_ROLE , A.TECHNICIAN_ROLE , A.ASSIGNED_TO_OPRID , A.ASSIGNED_BY_OPRID , A.RQST_FOR_USERID , A.BUSINESS_UNIT_WO , A.WO_ID , A.RELATED_WR_ID , A.REQUIRED_DATE , A.ALERT_INDICATOR FROM PS_WM_WR_HDR A , PS_WM_WR_HDR_VW B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.WR_ID = A.WR_ID

# 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_WM.BUSINESS_UNIT_WR

Prompt Table: SP_BU_WR_NONVW

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_PRB_NODE_VW

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 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

10 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: WM_ASSET_VW

11 WR_ASSET_OPEN_WOS Character(1) VARCHAR2(1) NOT NULL Assets with Open WOs
N=No
Y=Yes
12 ASSET_OPEN_WO_CNT Number(5,0) INTEGER NOT NULL Asset Open WO Count
13 AGENT_ROLE Character(30) VARCHAR2(30) NOT NULL Agent role name

Prompt Table: WM_AGENT_ROL_VW

14 TECHNICIAN_ROLE Character(30) VARCHAR2(30) NOT NULL Technician role name
15 ASSIGNED_TO_OPRID Character(30) VARCHAR2(30) NOT NULL Assigned To

Prompt Table: WM_ASSIGN_TO_VW

16 ASSIGNED_BY_OPRID Character(30) VARCHAR2(30) NOT NULL Group Assigned by
17 RQST_FOR_USERID Character(30) VARCHAR2(30) NOT NULL Request For User ID

Prompt Table: WM_WR_FOR_VW

18 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
19 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
20 RELATED_WR_ID Character(15) VARCHAR2(15) NOT NULL Related work request ID

Prompt Table: WM_RELATED_WR

21 REQUIRED_DATE Date(10) DATE Required By
22 ALERT_INDICATOR Character(3) VARCHAR2(3) NOT NULL Note alert indicator
000=None
001=Outstanding Request
002=Reply Received