| # |
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 |
PM_SCHD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
|
| 3 |
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
|
| 4 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 5 |
NEXT_DUE_DT |
Date(10) |
DATE |
Preventive Maintenance due date
|
| 6 |
NEXT_RDG |
Signed Number(21,4) |
DECIMAL(19,4) NOT NULL |
Next preventive maintenance due reading
|
| 7 |
MAINT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used for maintenance type
|
| 8 |
PERCENT_DUE |
Signed Number(16,0) |
DECIMAL(15) NOT NULL |
Preventive Maintenance percent due
|
| 9 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 10 |
MAINT_LOOP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Maintenance Loop ID
|
| 11 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 12 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
|
| 13 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 14 |
CBM_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
CBM Alert source
1=AM Reading Tolerance
2=MM Alert
3=Alert set manually
|
| 15 |
CBM_ALERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Force WO. Disregard options.
1=On
2=Off
|
| 16 |
COMPLTED_DT |
Date(10) |
DATE |
Completed Date
|
| 17 |
DATE_OF_MONTH |
Character(2) |
VARCHAR2(2) NOT NULL |
Date of the Month
|
| 18 |
THRESHOLD_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Confidence %
|
| 19 |
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
|
| 20 |
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
|
| 21 |
INTERVAL_VAL |
Number(9,0) |
DECIMAL(9) NOT NULL |
Interval
|
| 22 |
INTERVAL_START_FRM |
Character(1) |
VARCHAR2(1) NOT NULL |
From the last PM completion
N=No
Y=Yes
Default Value: N
|
| 23 |
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
|
| 24 |
WEEK_OF_MONTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Week of the month
1=1st
2=2nd
3=3rd
4=4th
5=Last
|
| 25 |
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.
|
| 26 |
LAST_WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Last Preventive Maintenance Work Order ID
|
| 27 |
LAST_PJC_DT |
Date(10) |
DATE |
Preventive Maintenance due date
|
| 28 |
METER_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Meter Type
|
| 29 |
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
|
| 30 |
REQ_START_DT |
Date(10) |
DATE |
Required Start
|
| 31 |
PM_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Options
1=Preventive
2=Projection
|
| 32 |
MTR_CALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Meter
|
| 33 |
BKP_CALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Blackout Period
|
| 34 |
START_DATE |
Date(10) |
DATE NOT NULL |
Start Date for Gen Standing PO
|
| 35 |
LAST_WO_RDG |
Signed Number(21,4) |
DECIMAL(19,4) NOT NULL |
Last reading
|
| 36 |
CBM_ALERT_DATETIME |
DateTime(26) |
TIMESTAMP |
CBM Alert Datetime
|
| 37 |
CBM_ALERT_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
CBM Alert ID
|
| 38 |
CBM_ALERT_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
CBM Alert Level
1=1
2=2
3=3
4=4
5=5
|
| 39 |
BUS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 40 |
ASSET_ID2 |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 41 |
LAST_SCHD_DT |
Date(10) |
DATE |
Last Preventive maintenance schedule date
|
| 42 |
TAG_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Tag Number
|
| 43 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 44 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 45 |
DESCR_LONG |
Character(254) |
VARCHAR2(254) NOT NULL |
Long Description
|
| 46 |
VIN |
Character(18) |
VARCHAR2(18) NOT NULL |
VIN
|
| 47 |
ASSET_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Asset Type
010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
|
| 48 |
ASSET_SUBTYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Asset Subtype
|
| 49 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
|
| 50 |
MODEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Model
|
| 51 |
MANUFACTURER |
Character(60) |
VARCHAR2(60) NOT NULL |
Manufacturer Name
|
| 52 |
SHOP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shop Identification
Default Value: OPR_DEF_TBL_WM.SHOP_ID
|
| 53 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 54 |
WM_PM_LINK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Linked
Y/N Table Edit
|
| 55 |
WM_PM_EXCEPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Exception Flag
|
| 56 |
PM_LEAD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
LEAD DAYS
|