| # |
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 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 4 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 5 |
NEXT_DUE_DT |
Date(10) |
DATE |
Preventive Maintenance due date
|
| 6 |
PM_SCHD_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Preventive Maintenance Schedule ID
Prompt Table:
WM_PM_SCHD
|
| 7 |
METER_TYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Meter Type
Prompt Table:
WM_ASSET_MTR_VW
|
| 8 |
WM_PM_DAYS_TOLER |
Number(2,0) |
SMALLINT NOT NULL |
PM Linking Days Tolerance
|
| 9 |
WM_PM_LINK_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
PM Linking Method
1=Linking by Cycle
3=Days Tolerance
|
| 10 |
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
|
| 11 |
WM_PM_OCCURRENCES |
Number(2,0) |
SMALLINT NOT NULL |
PM Linking Occurrences per Cycle
|
| 12 |
WM_PM_CUR_OCCUR |
Number(2,0) |
SMALLINT NOT NULL |
PM Linking Current Occurrence
|
| 13 |
WM_PM_CURR_CYCLE |
Number(3,0) |
SMALLINT NOT NULL |
Current Cycle
|
| 14 |
WM_PM_INTERVAL_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
PM linking interval type
1=Day Interval
2=Meter Interval
|
| 15 |
INTERVAL_MTR |
Signed Number(21,4) |
DECIMAL(19,4) NOT NULL |
Meter Reading Interval
|
| 16 |
INTERVAL_MTR2 |
Signed Number(21,4) |
DECIMAL(19,4) NOT NULL |
Meter Reading Interval
|
| 17 |
INTERVAL_VAL |
Number(9,0) |
DECIMAL(9) NOT NULL |
Interval
|
| 18 |
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
|
| 19 |
INTERVAL_VAL2 |
Number(9,0) |
DECIMAL(9) NOT NULL |
Interval
|
| 20 |
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
|
| 21 |
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
|
| 22 |
WM_PM_SEC_DUE_DATE |
Date(10) |
DATE |
Secondary Schedule's Due Date
|
| 23 |
WM_PM_LINK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Linked
|
| 24 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 25 |
PM_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 26 |
PM_SEQ_NBR_PRIM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 27 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 28 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
Default Value: N
|