WM_HDR_SRCH_VWA

(SQL View)
 Index Back

Work Order Header View

Work Order Header View

SELECT A.BUSINESS_UNIT , A.WO_ID , A.DESCR254 , A.SHOP_ID , A.PRIORITY_CD , A.SRVC_GRP_ID , A.WO_TYPE , A.STATUS_CD , A.MAINT_TYPE , A.BUSINESS_UNIT_AM , A.ASSET_ID , B.TAG_NUMBER , B.SERIAL_ID , A.BUSINESS_UNIT_WR , A.WR_ID , A.WO_APPROVAL_STATUS , A.ENTERED_DTTM , A.REQ_START_DT , A.REQ_END_DT , A.PARENT_WO_ID , A.LOCATION , A.PROJECT_ID , A.WO_SOURCE_CD FROM PS_WM_WO_HDR A LEFT OUTER JOIN PS_ASSET B ON B.BUSINESS_UNIT = A.BUSINESS_UNIT_AM AND B.ASSET_ID = A.ASSET_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

Prompt Table: SP_BU_WM_NONVW

2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

Prompt Table: WM_WOA_WOID

3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
4 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Default Value: OPR_DEF_TBL_WM.SHOP_ID

Prompt Table: WM_WOA_SHOPID

5 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code

Prompt Table: WM_PRIORITY

6 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

Default Value: OPR_DEF_TBL_WM.SRVC_GRP_ID

Prompt Table: WM_SRVC_GRP_BU

7 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

Prompt Table: WM_WO_TYPE

8 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code

Prompt Table: WM_STATUS_HDR

9 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type

Prompt Table: MAINT_TYPE_TBL
Set Control Field: BUSINESS_UNIT

10 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

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

Prompt Table: WM_ASSET_VWA

12 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
13 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
14 BUSINESS_UNIT_WR Character(5) VARCHAR2(5) NOT NULL Work Request Business Unit

Prompt Table: SP_BU_WR_NONVW

15 WR_ID Character(15) VARCHAR2(15) NOT NULL Work Request ID

Prompt Table: WM_WR_WO_SRCH

16 WO_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL work order approval status
A=Approved
C=Cancelled
E=Denied
I=Initial
P=Pending Approval
17 ENTERED_DTTM DateTime(26) TIMESTAMP Entered Datetime
18 REQ_START_DT Date(10) DATE Required Start
19 REQ_END_DT Date(10) DATE Required End
20 PARENT_WO_ID Character(10) VARCHAR2(10) NOT NULL Parent Work Order ID

Prompt Table: WM_WO_HDR

21 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

22 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJECT

23 WO_SOURCE_CD Character(4) VARCHAR2(4) NOT NULL Work order source code
1=Third Party
2=CRM Help Desk
3=Work Order
4=Service Request
5=Preventive Maintenance
6=Project Costing
7=Express Work Order
8=Condition-based Maintenance
9=WO Inspection