| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
|
| 4 |
PM_SCHD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
|
| 5 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 6 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 7 |
MAINT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used for maintenance type
|
| 8 |
NEXT_DUE_DT |
Date(10) |
DATE |
Preventive Maintenance due date
|
| 9 |
NEXT_RDG |
Signed Number(21,4) |
DECIMAL(19,4) NOT NULL |
Next preventive maintenance due reading
|
| 10 |
PRIORITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Priority Code
Prompt Table:
WM_PRIORITY
|
| 11 |
REQ_END_DT |
Date(10) |
DATE |
Required End
|
| 12 |
WO_DURATION |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Estimated Work Order Duration
Default Value: 1
|
| 13 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
|
| 14 |
WO_TXN_TMPLT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
WO Transaction Template ID
|
| 15 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 16 |
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
|
| 17 |
WO_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Work Order Type
|
| 18 |
AREA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Area ID
Prompt Table:
AM_AREA_TBL
|
| 19 |
PARENT_WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Parent Work Order ID
Prompt Table:
WM_WO_HDR
|
| 20 |
ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered by
Prompt Table:
PERSONAL_DATA
|
| 21 |
ENTERED_DTTM |
DateTime(26) |
TIMESTAMP |
Entered Datetime
|
| 22 |
BUSINESS_UNIT_WR |
Character(5) |
VARCHAR2(5) NOT NULL |
Work Request Business Unit
Prompt Table:
SP_BU_WR_NONVW
|
| 23 |
WR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Request ID
Prompt Table:
WM_WR_WO_SRCH
|
| 24 |
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
|
| 25 |
WO_APPRVL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Management Approval
1=Pre-Approved
3=Workflow Approval
Default Value: 1
|
| 26 |
SUBMIT_DTTM |
DateTime(26) |
TIMESTAMP |
Report Submitted On - DateTime
|
| 27 |
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
|
| 28 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
WM_PC_PRJ_DVW
|
| 29 |
ASSET_UP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset in Production Flag
|
| 30 |
LEAD_PERSON |
Character(30) |
VARCHAR2(30) NOT NULL |
Lead Person
Prompt Table:
WM_OPRID_VW
|
| 31 |
SUPERVISOR |
Character(30) |
VARCHAR2(30) NOT NULL |
Supervisor
Prompt Table:
WM_SHOP_RES_VW
|
| 32 |
SCHEDULER_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Scheduler Code
Prompt Table:
WM_SHOP_SCHEDLR
|
| 33 |
CONTACT_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contact Employee ID
Prompt Table:
PERSONAL_DATA
|
| 34 |
CONTACT_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Contact method
1=E-mail
2=Phone
3=Do Not Contact
|
| 35 |
CONTACT_DETAIL |
Character(70) |
VARCHAR2(70) NOT NULL |
Contact detail
|
| 36 |
RQST_FOR_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Requested for employee ID
|
| 37 |
RQST_FOR_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Requested for contact method
1=E-mail
2=Phone
3=Do Not Contact
|
| 38 |
RQST_FOR_DETAIL |
Character(70) |
VARCHAR2(70) NOT NULL |
Requested for detail
|
| 39 |
CLOSED_DT |
Date(10) |
DATE |
Date Closed
|
| 40 |
SCHED_COST_LBR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field will be used by WOM to store Scheduled Labor Cost
|
| 41 |
SCHED_COST_MAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Cost of Scheduled Materials
|
| 42 |
SCHED_COST_TLS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Schedule Tools Cost
|
| 43 |
SCHED_COST_PO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field will be used to store the Scheduled cost of Procurement
|
| 44 |
ACTL_COST_LBR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Actual Labor Cost
|
| 45 |
ACTL_COST_MAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Actual Cost
|
| 46 |
ACTL_COST_TLS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Actual Tools Cost
|
| 47 |
ACTL_COST_PO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Actual procurement costs for a work order
|
| 48 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 49 |
LAST_TASK_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Task ID
Default Value: 1
|
| 50 |
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
|
| 51 |
ALERT_INDICATOR |
Character(3) |
VARCHAR2(3) NOT NULL |
Note alert indicator
000=None
001=Outstanding Request
002=Reply Received
|
| 52 |
ORIGINATING_WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Originating Work Order ID
Prompt Table:
WM_WO_HDR
|
| 53 |
PERCENT_DUE |
Signed Number(16,0) |
DECIMAL(15) NOT NULL |
Preventive Maintenance percent due
|
| 54 |
MAINT_LOOP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Maintenance Loop ID
|
| 55 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 56 |
STATUS_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table:
WM_STATUS_HDR
|
| 57 |
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
|
| 58 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 59 |
CBM_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
CBM Alert source
1=AM Reading Tolerance
2=MM Alert
3=Alert set manually
|
| 60 |
CBM_ALERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Force WO. Disregard options.
1=On
2=Off
|
| 61 |
COMPLTED_DT |
Date(10) |
DATE |
Completed Date
|
| 62 |
DATE_OF_MONTH |
Character(2) |
VARCHAR2(2) NOT NULL |
Date of the Month
|
| 63 |
THRESHOLD_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Confidence %
|
| 64 |
PM_SCHD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Scheduling Option
1=One Cycle
2=Multiple Cycles Multiple WO
3=Multiple Cycles One WO
4=Non-recurring
|
| 65 |
PM_TM_SCHD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Type
1=None
2=Specific Date
3=Daily
4=Weekly by Day
5=Monthly by Day
6=Monthly by Date
7=On Demand
|
| 66 |
INTERVAL_VAL |
Number(9,0) |
DECIMAL(9) NOT NULL |
Interval
|
| 67 |
INTERVAL_START_FRM |
Character(1) |
VARCHAR2(1) NOT NULL |
From the last PM completion
N=No
Y=Yes
Default Value: N
|
| 68 |
DAY_OFWEEK |
Character(1) |
VARCHAR2(1) NOT NULL |
Day
0=0: Sunday
1=1: Monday
2=2: Tuesday
3=3 :Wednesday
4=4: Thursday
5=5: Friday
6=6: Saturday
|
| 69 |
WEEK_OF_MONTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Week of the month
1=1st
2=2nd
3=3rd
4=4th
5=Last
|
| 70 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
|
| 71 |
LAST_WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Last Preventive Maintenance Work Order ID
|
| 72 |
LAST_PJC_DT |
Date(10) |
DATE |
Preventive Maintenance due date
|
| 73 |
METER_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Meter Type
|
| 74 |
PM_CALC_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Preventive Maintenance Calculation type
100=Sampling days
101=Sampling Readings
102=Cycle
103=Average from Asset
2=Specific Date
200=Meter Reading
3=Day Interval
300=CBM Alert
4=Week interval
5=Month Interval by day
6=Month interval by date
|
| 75 |
REQ_START_DT |
Date(10) |
DATE |
Required Start
|
| 76 |
PM_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Options
1=Preventive
2=Projection
|
| 77 |
MTR_CALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Meter
|
| 78 |
BKP_CALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Blackout Period
|
| 79 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 80 |
CBM_ALERT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
CBM Alert ID
|
| 81 |
CBM_ALERT_DATETIME |
DateTime(26) |
TIMESTAMP |
CBM Alert Datetime
|
| 82 |
LAST_SCHD_DT |
Date(10) |
DATE |
Last Preventive maintenance schedule date
|
| 83 |
EST_COST_LBR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Labor Cost
|
| 84 |
EST_COST_MAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Material Cost
|
| 85 |
EST_COST_TLS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Tools Cost
|
| 86 |
EST_COST_PO |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Estimated Procurement costs for a work order
|
| 87 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY
|
| 88 |
WM_PM_LINK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Linked
|
| 89 |
PM_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
LEAD DAYS
|
| 90 |
SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop Identification
|
| 91 |
SRVC_GRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Group
|
| 92 |
WM_DAYS_OVERDUE |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Days Past Required Start
|
| 93 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 94 |
SCHED_START_DT |
Date(10) |
DATE |
Scheduled Start Date
|
| 95 |
SCHED_END_DT |
Date(10) |
DATE |
Scheduled End Date
|
| 96 |
WM_DAYS_OVERDUE1 |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Days Past Schedule Start
|
| 97 |
WM_DAYS_OVERDUE2 |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Days Past Required End
|
| 98 |
WM_DAYS_OVERDUE3 |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Days Past Schedule End
|
| 99 |
WM_DAYS_UPCOMING |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Days Past Creation Date
|
| 100 |
WM_DAYS_OVERDUE4 |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Days Past Actual Start
|
| 101 |
WM_DAYS_OVERDUE5 |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Days Past Actual End
|
| 102 |
ACTL_START_DT |
Date(10) |
DATE |
Actual Start Date
|
| 103 |
ACTL_END_DT |
Date(10) |
DATE |
Actual End Date
|
| 104 |
PM_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 105 |
WM_PM_EXCEP_STS |
Character(1) |
VARCHAR2(1) NOT NULL |
PM exception status
1=Pending
2=Checked
|
| 106 |
WM_PM_EXCEP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
PM exception type
1=PM Linking
2=Auto Assignment and Dispatch
|
| 107 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 108 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 109 |
WM_PM_RUN_DTTM |
DateTime(26) |
TIMESTAMP |
Process Run Date Time
|