WM_WO_HDR2_VW

(SQL View)
Index Back

Work Order Header Table

Work Order Header Table

SELECT BUSINESS_UNIT ,WO_ID ,WO_TYPE ,SRVC_GRP_ID ,SHOP_ID ,PRIORITY_CD ,REQ_START_DT ,REQ_START_TIME ,REQ_END_DT ,REQ_END_TIME ,WO_TXN_TMPLT_ID ,DESCR254 ,WO_SOURCE_CD ,BUSINESS_UNIT_AM ,ASSET_ID ,LOCATION ,AREA_ID ,PARENT_WO_ID ,ENTERED_BY ,ENTERED_DTTM ,BUSINESS_UNIT_WR ,WR_ID ,STATUS_CD ,INTERNAL_STATUS ,STATUS_DTTM ,WO_APPROVAL_STATUS ,WO_APPRVL_FLG ,SUBMIT_DTTM ,BUSINESS_UNIT_PC ,PROJECT_ID ,ASSET_UP_FLG ,LEAD_PERSON ,SUPERVISOR ,SCHEDULER_CODE ,CONTACT_EMPLID ,CONTACT_MTHD ,CONTACT_DETAIL ,RQST_FOR_EMPLID ,RQST_FOR_MTHD ,RQST_FOR_DETAIL ,CLOSED_DT ,COMPLTED_DT ,WO_DURATION ,EST_COST_LBR ,EST_COST_MAT ,EST_COST_TLS ,EST_COST_PO ,SCHED_COST_LBR ,SCHED_COST_MAT ,SCHED_COST_TLS ,SCHED_COST_PO ,ACTL_COST_LBR ,ACTL_COST_MAT ,ACTL_COST_TLS ,ACTL_COST_PO ,LANGUAGE_CD ,LAST_TASK_ID ,STANDING_WO_FLG ,ALERT_INDICATOR ,CURRENCY_CD ,MAINT_TYPE ,PM_SCHD_ID ,ORIGINATING_WO_ID , (EST_COST_LBR + EST_COST_MAT + EST_COST_TLS + EST_COST_PO) 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
3 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

Prompt Table: WM_WO_TYPE

4 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

5 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Default Value: OPR_DEF_TBL_WM.SHOP_ID

Prompt Table: WM_SHOP_LOC_VW

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

Prompt Table: WM_PRIORITY

7 REQ_START_DT Date(10) DATE Required Start
8 REQ_START_TIME Time(15) TIMESTAMP Required Start Time

Default Value: %Time

9 REQ_END_DT Date(10) DATE Required End
10 REQ_END_TIME Time(15) TIMESTAMP Required End Time

Default Value: %Time

11 WO_TXN_TMPLT_ID Character(25) VARCHAR2(25) NOT NULL WO Transaction Template ID
12 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
13 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

Default Value: 3

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

Default Value: OPR_DEF_TBL_WM.BUSINESS_UNIT_AM

Prompt Table: SP_BUS_AM_NONVW

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

Prompt Table: WM_ASSET_VWA

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

Prompt Table: LOCATION_VW

17 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

Prompt Table: AM_AREA_TBL

18 PARENT_WO_ID Character(10) VARCHAR2(10) NOT NULL Parent Work Order ID

Prompt Table: WM_WO_HDR

19 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by

Prompt Table: PERSONAL_DATA

20 ENTERED_DTTM DateTime(26) TIMESTAMP Entered Datetime
21 BUSINESS_UNIT_WR Character(5) VARCHAR2(5) NOT NULL Work Request Business Unit

Prompt Table: SP_BU_WR_NONVW

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

Prompt Table: WM_WR_WO_SRCH

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

Prompt Table: WM_STATUS_HDR

24 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
25 STATUS_DTTM DateTime(26) TIMESTAMP 05/13/02 EGS (CN#PL900-1): Added
26 WO_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL work order approval status
A=Approved
C=Cancelled
E=Denied
I=Initial
P=Pending Approval

Default Value: I

27 WO_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Work Management Approval
1=Pre-Approved
3=Workflow Approval

Default Value: 1

28 SUBMIT_DTTM DateTime(26) TIMESTAMP Report Submitted On - DateTime
29 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Default Value: BUS_UNIT_TBL_WM.BUSINESS_UNIT_PC

Prompt Table: BUS_UNIT_TBL_PC

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

Prompt Table: WM_PC_PRJ_DVW

31 ASSET_UP_FLG Character(1) VARCHAR2(1) NOT NULL Asset in Production Flag
32 LEAD_PERSON Character(30) VARCHAR2(30) NOT NULL Lead Person

Prompt Table: WM_OPRID_VW

33 SUPERVISOR Character(30) VARCHAR2(30) NOT NULL Supervisor

Prompt Table: WM_SHOP_RES_VW

34 SCHEDULER_CODE Character(10) VARCHAR2(10) NOT NULL Scheduler Code

Prompt Table: WM_SHOP_SCHEDLR

35 CONTACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact Employee ID

Prompt Table: PERSONAL_DATA

36 CONTACT_MTHD Character(1) VARCHAR2(1) NOT NULL Contact method
1=E-mail
2=Phone
3=Do Not Contact
37 CONTACT_DETAIL Character(70) VARCHAR2(70) NOT NULL Contact detail
38 RQST_FOR_EMPLID Character(11) VARCHAR2(11) NOT NULL Requested for employee ID
39 RQST_FOR_MTHD Character(1) VARCHAR2(1) NOT NULL Requested for contact method
1=E-mail
2=Phone
3=Do Not Contact
40 RQST_FOR_DETAIL Character(70) VARCHAR2(70) NOT NULL Requested for detail
41 CLOSED_DT Date(10) DATE Date Closed
42 COMPLTED_DT Date(10) DATE Completed Date
43 WO_DURATION Number(8,2) DECIMAL(7,2) NOT NULL Estimated Work Order Duration

Default Value: 1

44 EST_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Labor Cost
45 EST_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Material Cost
46 EST_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Tools Cost
47 EST_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Procurement costs for a work order
48 SCHED_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL This field will be used by WOM to store Scheduled Labor Cost
49 SCHED_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost of Scheduled Materials
50 SCHED_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Schedule Tools Cost
51 SCHED_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL This field will be used to store the Scheduled cost of Procurement
52 ACTL_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Labor Cost
53 ACTL_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Cost
54 ACTL_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Tools Cost
55 ACTL_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual procurement costs for a work order
56 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
57 LAST_TASK_ID Number(8,0) INTEGER NOT NULL Last Task ID

Default Value: 1

58 STANDING_WO_FLG Character(1) VARCHAR2(1) NOT NULL Standing Work Order indicator
N=Non-Standing
Y=Standing

Y/N Table Edit

Default Value: N

59 ALERT_INDICATOR Character(3) VARCHAR2(3) NOT NULL Note alert indicator
000=None
001=Outstanding Request
002=Reply Received
60 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY

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

Default Value: BUS_UNIT_TBL_WM.MAINT_TYPE

Prompt Table: MAINT_TYPE_TBL
Set Control Field: BUSINESS_UNIT

62 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID
63 ORIGINATING_WO_ID Character(10) VARCHAR2(10) NOT NULL Originating Work Order ID

Prompt Table: WM_WO_HDR

64 TOTAL_EST_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Estimated Cost