WM_WO_TSK_VW2 (SQL View)	Index Back
Work Order Header Table Work Order Header Table

WM_WO_TSK_VW2

(SQL View)

Work Order Header Table

SELECT ' ' , B.BUSINESS_UNIT , B.WO_ID , B.WO_TYPE , B.PRIORITY_CD , B.STATUS_CD AS STATUS_CD_HDR , B.SHOP_ID , A.WO_TASK_ID , A.SEQ_NBR_5 , A.BUSINESS_UNIT_PC , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.DEPEND_TASK_ID , A.TASK_ID_ASSOC , A.WO_TASK_ID_TO , A.OVERLAP_PERCENT , A.WO_DURATION , A.ASSET_UP_FLG , A.ASSET_LOCATION , A.LOCATION , A.DESCR254 , A.STATUS_CD , A.INTERNAL_STATUS , A.STATUS_DTTM , A.REQ_START_DT , A.REQ_START_TIME , A.SCHED_START_DT , A.SCHED_START_TIME , A.SCHED_END_DT , A.SCHED_END_TIME , A.REQ_END_DT , A.REQ_END_TIME , A.ACTL_END_DTTM , A.ACTL_START_DT , A.ACTL_START_TIME , A.ACTL_END_DT , A.ACTL_END_TIME , A.ACTL_START_DTTM , A.IS_PASSIVE_PROJECT , A.PROJECT_ID , A.ACTIVITY_ID , A.SCHEDULER_CODE , A.LEAD_PERSON , A.CLOSED_DT , A.COMPLTED_DT , A.EST_COST_LBR , A.EST_COST_MAT , A.EST_COST_TLS , A.EST_COST_PO , A.SCHED_COST_LBR , A.SCHED_COST_MAT , A.SCHED_COST_TLS , A.SCHED_COST_PO , A.ACTL_COST_LBR , A.ACTL_COST_MAT , A.ACTL_COST_TLS , A.ACTL_COST_PO , A.ASSET_DOWNTIME_HRS , A.FAILURE_DT , A.DOWNTIME_RATE , A.RECOVER_COST_FLG , A.WARRANTY_NAME , A.VENDOR_ID , A.CNTCT_SEQ_NUM , A.CLAIM_ID , A.PROBLEM_GROUP , A.PROBLEM_CD , A.CAUSE_CD , A.RESOLUTION_CD , A.TASK_ACTION , A.NEEDS_REPAIR_SW , A.SUPERVISOR , A.RES_LBR_EXIST , A.RES_TLS_EXIST , A.RES_MAT_EXIST , A.RES_PO_EXIST , A.LAST_RQMTLN_TLS , A.LAST_RQMTLN_LBR , A.LAST_SCHEDLN_LBR , A.LAST_SCHEDLN_TLS , A.LAST_RQMTLN_MAT , A.LAST_RQMTLN_PO , A.LAST_SCHEDLN_MAT , A.LAST_SCHEDLN_PO , A.ALERT_INDICATOR , A.GEN_CHARGEBACK , A.RATE_SELECT , A.PC_TEMPLATE_ID , A.DISPOSAL_CODE , A.CAPITALIZATION_FLG , A.CURRENCY_CD , A.FILTER_ID , A.CAPITALIZATION_MIN , A.CAPITALIZE_AMT , A.PROCESS_MAN_CLOSE , A.CUSTODIAN , A.COMPONENT_OF_ID , A.EMPLID AS EMPLID2 , A.DEPTID , A.WO_TEMPLATE_ID , A.WO_TASK_TMPLT_ID , A.WO_INV_COMMIT_RULE , A.INTERNAL_STAT_COMM , A.WO_RESERVE_RULE , A.INTERNAL_STAT_RSRV , A.PRIORITY_NBR , %subrec(WM_CREW_SBR, A) , A.AREA_ID , A.MAINT_TYPE , A.WM_EIP_SNT_DTTM , A.WM_EIP_UPD_DTTM , A.LAST_UPDATED_BY , A.LAST_UPDATE_DTTM , B.BUSINESS_UNIT_WR , B.WR_ID , B.SRVC_GRP_ID , B.WO_APPROVAL_STATUS , B.ENTERED_BY , B.ENTERED_DTTM , B.STANDING_WO_FLG , B.PM_SCHD_ID , B.DESCR254 AS WO_DESCR , C.DESCR AS ASSET_DESCR30 , C.DESCR_LONG AS ASSET_DESCR , C.HAZARDOUS_SW , C.TAG_NUMBER , C.SERIAL_ID , C.VIN FROM PS_WM_WO_TSK A LEFT OUTER JOIN PS_ASSET C ON A.BUSINESS_UNIT_AM = C.BUSINESS_UNIT AND A.ASSET_ID = C.ASSET_ID , PS_WM_WO_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WO_ID = B.WO_ID AND A.SCHEDULER_CODE = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

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

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

6 STATUS_CD_HDR Character(4) VARCHAR2(4) NOT NULL Header Status

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

8 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

9 SEQ_NBR_5 Number(5,0) INTEGER NOT NULL Sequence number five digits long

10 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

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

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

13 DEPEND_TASK_ID Number(8,0) INTEGER NOT NULL Dependent Task
Prompt Table: WM_WO_TSK_DEP

14 TASK_ID_ASSOC Character(18) VARCHAR2(18) NOT NULL Dependent Removal Task

15 WO_TASK_ID_TO Number(5,0) INTEGER NOT NULL To Task ID
Prompt Table: WM_WO_TSK

16 OVERLAP_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Overlap Percentage

17 WO_DURATION Number(8,2) DECIMAL(7,2) NOT NULL Estimated Work Order Duration

18 ASSET_UP_FLG Character(1) VARCHAR2(1) NOT NULL Asset in Production Flag

19 ASSET_LOCATION Character(10) VARCHAR2(10) NOT NULL Asset Location

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

21 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

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

23 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

24 STATUS_DTTM DateTime(26) TIMESTAMP 05/13/02 EGS (CN#PL900-1): Added

25 REQ_START_DT Date(10) DATE Required Start

26 REQ_START_TIME Time(15) TIMESTAMP Required Start Time

27 SCHED_START_DT Date(10) DATE Scheduled Start Date

28 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time

29 SCHED_END_DT Date(10) DATE Scheduled End Date

30 SCHED_END_TIME Time(15) TIMESTAMP Schedule End Time

31 REQ_END_DT Date(10) DATE Required End

32 REQ_END_TIME Time(15) TIMESTAMP Required End Time

33 ACTL_END_DTTM DateTime(26) TIMESTAMP Actual End Date/Time

34 ACTL_START_DT Date(10) DATE Actual Start Date

35 ACTL_START_TIME Time(15) TIMESTAMP Actual Start Time

36 ACTL_END_DT Date(10) DATE Actual End Date

37 ACTL_END_TIME Time(15) TIMESTAMP Actual End Time

38 ACTL_START_DTTM DateTime(26) TIMESTAMP Actual Start Date/Time

39 IS_PASSIVE_PROJECT Character(1) VARCHAR2(1) NOT NULL Passive Project Indicator
Y/N Table Edit

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

41 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

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

43 LEAD_PERSON Character(30) VARCHAR2(30) NOT NULL Lead Person

44 CLOSED_DT Date(10) DATE Date Closed

45 COMPLTED_DT Date(10) DATE Completed Date

46 EST_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Labor Cost

47 EST_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Material Cost

48 EST_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Tools Cost

49 EST_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Procurement costs for a work order

50 SCHED_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL This field will be used by WOM to store Scheduled Labor Cost

51 SCHED_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost of Scheduled Materials

52 SCHED_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Schedule Tools Cost

53 SCHED_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL This field will be used to store the Scheduled cost of Procurement

54 ACTL_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Labor Cost

55 ACTL_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Cost

56 ACTL_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Tools Cost

57 ACTL_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual procurement costs for a work order

58 ASSET_DOWNTIME_HRS Number(32,3) DECIMAL(31,3) NOT NULL Asset Downtime

59 FAILURE_DT Date(10) DATE Failure date

60 DOWNTIME_RATE Number(32,3) DECIMAL(31,3) NOT NULL Downtime rate

61 RECOVER_COST_FLG Character(1) VARCHAR2(1) NOT NULL Attempt to Recover Cost flag

62 WARRANTY_NAME Character(40) VARCHAR2(40) NOT NULL This field is used to store the name of the warranty.

63 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

64 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

65 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID

66 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group

67 PROBLEM_CD Character(15) VARCHAR2(15) NOT NULL Problem code

68 CAUSE_CD Character(15) VARCHAR2(15) NOT NULL Cause Code

69 RESOLUTION_CD Character(15) VARCHAR2(15) NOT NULL Resolution code

70 TASK_ACTION Character(1) VARCHAR2(1) NOT NULL The purpose of this field is to identify the kind of action that may be done for a task.
1=No Change
2=Install Component
3=Repair
4=Remove
5=Retire
6=Remove and Sell
7=Replacement asset
8=Ownership Change

71 NEEDS_REPAIR_SW Character(1) VARCHAR2(1) NOT NULL Needs Repair Indicator
Y/N Table Edit
Default Value: N

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

73 RES_LBR_EXIST Character(1) VARCHAR2(1) NOT NULL Labor exists flag - used on WO

74 RES_TLS_EXIST Character(1) VARCHAR2(1) NOT NULL Tools exists flag - indicates if Tools exists on a WO

75 RES_MAT_EXIST Character(1) VARCHAR2(1) NOT NULL Inventory exists flag - indicates if inventory exists on WO

76 RES_PO_EXIST Character(1) VARCHAR2(1) NOT NULL Procurement exists flag - indicates if Procurement exists in WO

77 LAST_RQMTLN_TLS Number(8,0) INTEGER NOT NULL Requirement Line Number
Default Value: 1

78 LAST_RQMTLN_LBR Number(8,0) INTEGER NOT NULL Requirement Line Number
Default Value: 1

79 LAST_SCHEDLN_LBR Number(8,0) INTEGER NOT NULL Requirement Line Number
Default Value: 1

80 LAST_SCHEDLN_TLS Number(8,0) INTEGER NOT NULL Requirement Line Number
Default Value: 1

81 LAST_RQMTLN_MAT Number(8,0) INTEGER NOT NULL Last requirement resource number for Material resource row(s)
Default Value: 1

82 LAST_RQMTLN_PO Number(8,0) INTEGER NOT NULL Last requirement resource number for procured resource row(s)
Default Value: 1

83 LAST_SCHEDLN_MAT Number(8,0) INTEGER NOT NULL Last Schedule resource number for Material resource row(s)
Default Value: 1

84 LAST_SCHEDLN_PO Number(8,0) INTEGER NOT NULL Last Schedule resource number for procured resource row(s)
Default Value: 1

85 ALERT_INDICATOR Character(3) VARCHAR2(3) NOT NULL Note alert indicator
000=None
001=Outstanding Request
002=Reply Received

86 GEN_CHARGEBACK Character(1) VARCHAR2(1) NOT NULL Generate Chargeback field, used in Maintenance Management
Default Value: N

87 RATE_SELECT Character(1) VARCHAR2(1) NOT NULL This will determine selection of 1) Rate Set and 2) Rate Plan in Project Type, Project and Activity.
1=Rate Set
2=Rate Plan

88 PC_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rate Template ID
Prompt Table: %EDITTABLE15

89 DISPOSAL_CODE Character(1) VARCHAR2(1) NOT NULL Retirement Type
A=Abandonment
C=Cannibalize for Other Assets
D=Disappeared Assets
E=Expensed
F=Disposal Due to Theft
I=Returned to Inventory
L=Like Kind Exchange
M=Missing Asset
N=Donated to External Group
O=ARO Settlement
R=Scrapped Assets
S=Retirement by Sale
T=Traded In for another Asset
V=Auto-Retire Fully Depr Assets
Y=Casualty Loss

90 CAPITALIZATION_FLG Character(1) VARCHAR2(1) NOT NULL Work Management user preferences option to override capitalization limit

91 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: WM_WO_HDR.CURRENCY_CD
Prompt Table: CURR_CD_EFF_VW

92 FILTER_ID Character(10) VARCHAR2(10) NOT NULL Filter criteria identification
Prompt Table: WM_PC_AMFLTR_VW

93 CAPITALIZATION_MIN Signed Number(28,3) DECIMAL(26,3) NOT NULL Capitalization Minimum

94 CAPITALIZE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount to be Capitalized

95 PROCESS_MAN_CLOSE Character(1) VARCHAR2(1) NOT NULL Process Manual Close
N=No
P=Processed
Y=Yes
Default Value: N

96 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian

97 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset
Prompt Table: WM_AM_COMPONENT

98 EMPLID2 Character(11) VARCHAR2(11) NOT NULL Employee ID

99 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

100 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID

101 WO_TASK_TMPLT_ID Character(25) VARCHAR2(25) NOT NULL WO Task Template ID (specific field)

102 WO_INV_COMMIT_RULE Character(1) VARCHAR2(1) NOT NULL Inventory commit rule, when to commit inventory for Work Management
1=Parts List Creation
2=Pick Plan Creation
3=Work Order Status Change
4=Commit at Reserve

103 INTERNAL_STAT_COMM Character(2) VARCHAR2(2) NOT NULL Work Order commit rule internal status.
02=Awaiting Schedule
03=Scheduled
04=Work In Progress

104 WO_RESERVE_RULE Character(1) VARCHAR2(1) NOT NULL Work Order Reservation rule
1=Parts List Creation
2=Pick Plan Creation
3=Work Order Status Change
4=Batch Reserve Only

105 INTERNAL_STAT_RSRV Character(2) VARCHAR2(2) NOT NULL Work Order Reservation rule internal status.
02=Awaiting Schedule
03=Scheduled
04=Work In Progress

106 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

107 CREW_BU Character(5) VARCHAR2(5) NOT NULL Crew Business Unit
Prompt Table: SP_BU_WM_NONVW

108 CREW_SHOP Character(10) VARCHAR2(10) NOT NULL Crew Shop ID
Prompt Table: WM_CREWSHOP_VW

109 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name
Prompt Table: WM_PREFCREW_VW

110 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID
Prompt Table: WM_AREA_PMT_VW

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

112 WM_EIP_SNT_DTTM DateTime(26) TIMESTAMP Date/Time Last Sent

113 WM_EIP_UPD_DTTM DateTime(26) TIMESTAMP Date/Time Last Updated

114 LAST_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL LastUpdatedUser

115 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

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

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

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

119 WO_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL work order approval status
A=Approved
C=Cancelled
E=Denied
I=Initial
P=Pending Approval

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

121 ENTERED_DTTM DateTime(26) TIMESTAMP Entered Datetime

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

123 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID

124 WO_DESCR Character(254) VARCHAR2(254) NOT NULL Work Order Description

125 ASSET_DESCR30 Character(30) VARCHAR2(30) NOT NULL Asset Description

126 ASSET_DESCR Character(254) VARCHAR2(254) NOT NULL Asset Description

127 HAZARDOUS_SW Character(1) VARCHAR2(1) NOT NULL Hazardous Asset

128 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number

129 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

130 VIN Character(18) VARCHAR2(18) NOT NULL VIN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification
4	WO_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Work Order Type
5	PRIORITY_CD	Character(3)	VARCHAR2(3) NOT NULL	Priority Code
6	STATUS_CD_HDR	Character(4)	VARCHAR2(4) NOT NULL	Header Status
7	SHOP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shop Identification
8	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
9	SEQ_NBR_5	Number(5,0)	INTEGER NOT NULL	Sequence number five digits long
10	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
11	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
12	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
13	DEPEND_TASK_ID	Number(8,0)	INTEGER NOT NULL	Dependent Task Prompt Table: WM_WO_TSK_DEP
14	TASK_ID_ASSOC	Character(18)	VARCHAR2(18) NOT NULL	Dependent Removal Task
15	WO_TASK_ID_TO	Number(5,0)	INTEGER NOT NULL	To Task ID Prompt Table: WM_WO_TSK
16	OVERLAP_PERCENT	Number(6,2)	DECIMAL(5,2) NOT NULL	Overlap Percentage
17	WO_DURATION	Number(8,2)	DECIMAL(7,2) NOT NULL	Estimated Work Order Duration
18	ASSET_UP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Asset in Production Flag
19	ASSET_LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Asset Location
20	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
21	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
22	STATUS_CD	Character(4)	VARCHAR2(4) NOT NULL	User defined Status Code
23	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
24	STATUS_DTTM	DateTime(26)	TIMESTAMP	05/13/02 EGS (CN#PL900-1): Added
25	REQ_START_DT	Date(10)	DATE	Required Start
26	REQ_START_TIME	Time(15)	TIMESTAMP	Required Start Time
27	SCHED_START_DT	Date(10)	DATE	Scheduled Start Date
28	SCHED_START_TIME	Time(15)	TIMESTAMP	Schedule Start Time
29	SCHED_END_DT	Date(10)	DATE	Scheduled End Date
30	SCHED_END_TIME	Time(15)	TIMESTAMP	Schedule End Time
31	REQ_END_DT	Date(10)	DATE	Required End
32	REQ_END_TIME	Time(15)	TIMESTAMP	Required End Time
33	ACTL_END_DTTM	DateTime(26)	TIMESTAMP	Actual End Date/Time
34	ACTL_START_DT	Date(10)	DATE	Actual Start Date
35	ACTL_START_TIME	Time(15)	TIMESTAMP	Actual Start Time
36	ACTL_END_DT	Date(10)	DATE	Actual End Date
37	ACTL_END_TIME	Time(15)	TIMESTAMP	Actual End Time
38	ACTL_START_DTTM	DateTime(26)	TIMESTAMP	Actual Start Date/Time
39	IS_PASSIVE_PROJECT	Character(1)	VARCHAR2(1) NOT NULL	Passive Project Indicator Y/N Table Edit
40	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
41	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
42	SCHEDULER_CODE	Character(10)	VARCHAR2(10) NOT NULL	Scheduler Code
43	LEAD_PERSON	Character(30)	VARCHAR2(30) NOT NULL	Lead Person
44	CLOSED_DT	Date(10)	DATE	Date Closed
45	COMPLTED_DT	Date(10)	DATE	Completed Date
46	EST_COST_LBR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Estimated Labor Cost
47	EST_COST_MAT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Estimated Material Cost
48	EST_COST_TLS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Estimated Tools Cost
49	EST_COST_PO	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Estimated Procurement costs for a work order
50	SCHED_COST_LBR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	This field will be used by WOM to store Scheduled Labor Cost
51	SCHED_COST_MAT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Cost of Scheduled Materials
52	SCHED_COST_TLS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Schedule Tools Cost
53	SCHED_COST_PO	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	This field will be used to store the Scheduled cost of Procurement
54	ACTL_COST_LBR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Actual Labor Cost
55	ACTL_COST_MAT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Actual Cost
56	ACTL_COST_TLS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Actual Tools Cost
57	ACTL_COST_PO	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Actual procurement costs for a work order
58	ASSET_DOWNTIME_HRS	Number(32,3)	DECIMAL(31,3) NOT NULL	Asset Downtime
59	FAILURE_DT	Date(10)	DATE	Failure date
60	DOWNTIME_RATE	Number(32,3)	DECIMAL(31,3) NOT NULL	Downtime rate
61	RECOVER_COST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Attempt to Recover Cost flag
62	WARRANTY_NAME	Character(40)	VARCHAR2(40) NOT NULL	This field is used to store the name of the warranty.
63	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
64	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
65	CLAIM_ID	Character(15)	VARCHAR2(15) NOT NULL	Claim ID
66	PROBLEM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Problem Group
67	PROBLEM_CD	Character(15)	VARCHAR2(15) NOT NULL	Problem code
68	CAUSE_CD	Character(15)	VARCHAR2(15) NOT NULL	Cause Code
69	RESOLUTION_CD	Character(15)	VARCHAR2(15) NOT NULL	Resolution code
70	TASK_ACTION	Character(1)	VARCHAR2(1) NOT NULL	The purpose of this field is to identify the kind of action that may be done for a task. 1=No Change 2=Install Component 3=Repair 4=Remove 5=Retire 6=Remove and Sell 7=Replacement asset 8=Ownership Change
71	NEEDS_REPAIR_SW	Character(1)	VARCHAR2(1) NOT NULL	Needs Repair Indicator Y/N Table Edit Default Value: N
72	SUPERVISOR	Character(30)	VARCHAR2(30) NOT NULL	Supervisor
73	RES_LBR_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Labor exists flag - used on WO
74	RES_TLS_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Tools exists flag - indicates if Tools exists on a WO
75	RES_MAT_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Inventory exists flag - indicates if inventory exists on WO
76	RES_PO_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Procurement exists flag - indicates if Procurement exists in WO
77	LAST_RQMTLN_TLS	Number(8,0)	INTEGER NOT NULL	Requirement Line Number Default Value: 1
78	LAST_RQMTLN_LBR	Number(8,0)	INTEGER NOT NULL	Requirement Line Number Default Value: 1
79	LAST_SCHEDLN_LBR	Number(8,0)	INTEGER NOT NULL	Requirement Line Number Default Value: 1
80	LAST_SCHEDLN_TLS	Number(8,0)	INTEGER NOT NULL	Requirement Line Number Default Value: 1
81	LAST_RQMTLN_MAT	Number(8,0)	INTEGER NOT NULL	Last requirement resource number for Material resource row(s) Default Value: 1
82	LAST_RQMTLN_PO	Number(8,0)	INTEGER NOT NULL	Last requirement resource number for procured resource row(s) Default Value: 1
83	LAST_SCHEDLN_MAT	Number(8,0)	INTEGER NOT NULL	Last Schedule resource number for Material resource row(s) Default Value: 1
84	LAST_SCHEDLN_PO	Number(8,0)	INTEGER NOT NULL	Last Schedule resource number for procured resource row(s) Default Value: 1
85	ALERT_INDICATOR	Character(3)	VARCHAR2(3) NOT NULL	Note alert indicator 000=None 001=Outstanding Request 002=Reply Received
86	GEN_CHARGEBACK	Character(1)	VARCHAR2(1) NOT NULL	Generate Chargeback field, used in Maintenance Management Default Value: N
87	RATE_SELECT	Character(1)	VARCHAR2(1) NOT NULL	This will determine selection of 1) Rate Set and 2) Rate Plan in Project Type, Project and Activity. 1=Rate Set 2=Rate Plan
88	PC_TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Rate Template ID Prompt Table: %EDITTABLE15
89	DISPOSAL_CODE	Character(1)	VARCHAR2(1) NOT NULL	Retirement Type A=Abandonment C=Cannibalize for Other Assets D=Disappeared Assets E=Expensed F=Disposal Due to Theft I=Returned to Inventory L=Like Kind Exchange M=Missing Asset N=Donated to External Group O=ARO Settlement R=Scrapped Assets S=Retirement by Sale T=Traded In for another Asset V=Auto-Retire Fully Depr Assets Y=Casualty Loss
90	CAPITALIZATION_FLG	Character(1)	VARCHAR2(1) NOT NULL	Work Management user preferences option to override capitalization limit
91	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: WM_WO_HDR.CURRENCY_CD Prompt Table: CURR_CD_EFF_VW
92	FILTER_ID	Character(10)	VARCHAR2(10) NOT NULL	Filter criteria identification Prompt Table: WM_PC_AMFLTR_VW
93	CAPITALIZATION_MIN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Capitalization Minimum
94	CAPITALIZE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount to be Capitalized
95	PROCESS_MAN_CLOSE	Character(1)	VARCHAR2(1) NOT NULL	Process Manual Close N=No P=Processed Y=Yes Default Value: N
96	CUSTODIAN	Character(30)	VARCHAR2(30) NOT NULL	Custodian
97	COMPONENT_OF_ID	Character(12)	VARCHAR2(12) NOT NULL	Component of Asset Prompt Table: WM_AM_COMPONENT
98	EMPLID2	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
99	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
100	WO_TEMPLATE_ID	Character(25)	VARCHAR2(25) NOT NULL	Work Order Task/Job Template ID
101	WO_TASK_TMPLT_ID	Character(25)	VARCHAR2(25) NOT NULL	WO Task Template ID (specific field)
102	WO_INV_COMMIT_RULE	Character(1)	VARCHAR2(1) NOT NULL	Inventory commit rule, when to commit inventory for Work Management 1=Parts List Creation 2=Pick Plan Creation 3=Work Order Status Change 4=Commit at Reserve
103	INTERNAL_STAT_COMM	Character(2)	VARCHAR2(2) NOT NULL	Work Order commit rule internal status. 02=Awaiting Schedule 03=Scheduled 04=Work In Progress
104	WO_RESERVE_RULE	Character(1)	VARCHAR2(1) NOT NULL	Work Order Reservation rule 1=Parts List Creation 2=Pick Plan Creation 3=Work Order Status Change 4=Batch Reserve Only
105	INTERNAL_STAT_RSRV	Character(2)	VARCHAR2(2) NOT NULL	Work Order Reservation rule internal status. 02=Awaiting Schedule 03=Scheduled 04=Work In Progress
106	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
107	CREW_BU	Character(5)	VARCHAR2(5) NOT NULL	Crew Business Unit Prompt Table: SP_BU_WM_NONVW
108	CREW_SHOP	Character(10)	VARCHAR2(10) NOT NULL	Crew Shop ID Prompt Table: WM_CREWSHOP_VW
109	CREW_ID	Character(10)	VARCHAR2(10) NOT NULL	Crew Name Prompt Table: WM_PREFCREW_VW
110	AREA_ID	Character(10)	VARCHAR2(10) NOT NULL	Area ID Prompt Table: WM_AREA_PMT_VW
111	MAINT_TYPE	Character(10)	VARCHAR2(10) NOT NULL	This field is used for maintenance type
112	WM_EIP_SNT_DTTM	DateTime(26)	TIMESTAMP	Date/Time Last Sent
113	WM_EIP_UPD_DTTM	DateTime(26)	TIMESTAMP	Date/Time Last Updated
114	LAST_UPDATED_BY	Character(30)	VARCHAR2(30) NOT NULL	LastUpdatedUser
115	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
116	BUSINESS_UNIT_WR	Character(5)	VARCHAR2(5) NOT NULL	Work Request Business Unit
117	WR_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Request ID
118	SRVC_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Group
119	WO_APPROVAL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	work order approval status A=Approved C=Cancelled E=Denied I=Initial P=Pending Approval
120	ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered by
121	ENTERED_DTTM	DateTime(26)	TIMESTAMP	Entered Datetime
122	STANDING_WO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Standing Work Order indicator N=Non-Standing Y=Standing
123	PM_SCHD_ID	Character(10)	VARCHAR2(10) NOT NULL	Preventive Maintenance Schedule ID
124	WO_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Work Order Description
125	ASSET_DESCR30	Character(30)	VARCHAR2(30) NOT NULL	Asset Description
126	ASSET_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Asset Description
127	HAZARDOUS_SW	Character(1)	VARCHAR2(1) NOT NULL	Hazardous Asset
128	TAG_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Tag Number
129	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
130	VIN	Character(18)	VARCHAR2(18) NOT NULL	VIN