WM_PM_SCHLP_DT

(SQL Table)
Index Back

PM Meter Based Schedule

# 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 START_DATE Date(10) DATE Start Date for Gen Standing PO
6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
7 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

Default Value: N

8 FIRST_CYCLE_FLG Character(1) VARCHAR2(1) NOT NULL First Maintenance Cycle

Default Value: Y