| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
PM_SCHD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
PM_SCHD_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
Prompt Table:
%EDITTABLE
|
| 5 |
METER_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Meter Type
Prompt Table:
WM_ASSETMTR1_VW
|
| 6 |
WM_PM_DAYS_TOLER |
Number(2,0) |
SMALLINT NOT NULL |
PM Linking Days Tolerance
|
| 7 |
WM_PM_LINK_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
PM Linking Method
1=Linking by Cycle
3=Days Tolerance
|
| 8 |
WM_PM_LINK_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
PM Linking Action
1=Suppress Secondary Tasks
2=Merge All Tasks
3=Separate Work Orders
|
| 9 |
WM_PM_OCCURRENCES |
Number(2,0) |
SMALLINT NOT NULL |
PM Linking Occurrences per Cycle
|
| 10 |
WM_PM_CUR_OCCUR |
Number(2,0) |
SMALLINT NOT NULL |
PM Linking Current Occurrence
Default Value: 0
|
| 11 |
WM_PM_CURR_CYCLE |
Number(3,0) |
SMALLINT NOT NULL |
Current Cycle
Default Value: 1
|
| 12 |
WM_PM_INTERVAL_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
PM linking interval type
1=Day Interval
2=Meter Interval
|
| 13 |
INTERVAL_MTR |
Signed Number(21,4) |
DECIMAL(19,4) NOT NULL |
Meter Reading Interval
|
| 14 |
INTERVAL_MTR2 |
Signed Number(21,4) |
DECIMAL(19,4) NOT NULL |
Meter Reading Interval
|
| 15 |
INTERVAL_VAL |
Number(9,0) |
DECIMAL(9) NOT NULL |
Interval
|
| 16 |
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
|
| 17 |
INTERVAL_VAL2 |
Number(9,0) |
DECIMAL(9) NOT NULL |
Interval
|
| 18 |
PM_TM_SCHD_TYPE2 |
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
|
| 19 |
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
|
| 20 |
PM_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 21 |
PM_SEQ_NBR_PRIM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 22 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 23 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
Default Value: N
|
| 24 |
WM_PM_EFFDT_ORIG |
Date(10) |
DATE |
Effective Date
|