WM_HDR_SRCH_VW

(SQL View)
 Index Back

Work Order Header Table

Work Order Header Table

SELECT BUSINESS_UNIT , WO_ID , DESCR254 , SHOP_ID , PRIORITY_CD , SRVC_GRP_ID , WO_TYPE , STATUS_CD , MAINT_TYPE , BUSINESS_UNIT_AM , ASSET_ID , BUSINESS_UNIT_WR , WR_ID , WO_APPROVAL_STATUS , ENTERED_DTTM , REQ_START_DT , REQ_END_DT , PARENT_WO_ID , LOCATION , PROJECT_ID , WO_SOURCE_CD FROM PS_WM_WO_HDR

# 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_WO_HDR

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_SHOP_HDR

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

Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT_AM

Prompt Table: SP_BU_AM_NONVW

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

Prompt Table: WM_ASSET_VWA

12 BUSINESS_UNIT_WR Character(5) VARCHAR2(5) NOT NULL Work Request Business Unit

Prompt Table: SP_BU_WR_NONVW

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

Prompt Table: WM_WR_WO_SRCH

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

Prompt Table: WM_WO_HDR

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

Prompt Table: LOCATION_TBL

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

Prompt Table: PROJECT

21 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