WM_PM_BTF_VW

(SQL View)
 Index Back

Preventive Maintenance Record


SELECT BUSINESS_UNIT , PM_SCHD_ID , BUSINESS_UNIT_AM , ASSET_ID , NEXT_DUE_DT , WO_ID , NEXT_RDG , MAINT_TYPE , PERCENT_DUE , SETID , MAINT_LOOP_ID , LOCATION , PROCESS_INSTANCE , CBM_SOURCE ,CBM_ALERT ,COMPLTED_DT , DATE_OF_MONTH ,THRESHOLD_PCT , PM_SCHD_OPT , PM_TM_SCHD_TYPE , INTERVAL_VAL ,INTERVAL_START_FRM , DAY_OFWEEK , WEEK_OF_MONTH ,HOLIDAY_LIST_ID ,LAST_WO_ID ,LAST_PJC_DT ,METER_TYPE ,PM_CALC_TYPE ,REQ_START_DT ,PM_PROC_OPT ,MTR_CALC_FLG ,BKP_CALC_FLG ,START_DATE ,LAST_WO_RDG , CBM_ALERT_DATETIME , CBM_ALERT_ID ,CBM_ALERT_LEVEL ,BUS_UNIT_AM , ASSET_ID2 , LAST_SCHD_DT , TAG_NUMBER , SERIAL_ID , DESCR ,DESCR_LONG ,VIN ,ASSET_TYPE , ASSET_SUBTYPE , MFG_ID ,MODEL , MANUFACTURER , SHOP_ID , DESCR100 , WM_PM_LINK_FLAG , WM_PM_EXCEPTION ,PM_LEAD_DAYS FROM PS_WM_PM

  • Parent record: WM_PM_SCHD

    • # 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 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
    7 NEXT_RDG Signed Number(21,4) DECIMAL(19,4) NOT NULL Next preventive maintenance due reading
    8 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type
    9 PERCENT_DUE Signed Number(16,0) DECIMAL(15) NOT NULL Preventive Maintenance percent due
    10 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    11 MAINT_LOOP_ID Character(15) VARCHAR2(15) NOT NULL Maintenance Loop ID
    12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    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
    53 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    54 WM_PM_LINK_FLAG Character(1) VARCHAR2(1) NOT NULL Linked
    55 WM_PM_EXCEPTION Character(1) VARCHAR2(1) NOT NULL Exception Flag
    56 PM_LEAD_DAYS Number(3,0) SMALLINT NOT NULL LEAD DAYS