WM_PM_SCHDTL_VW

(SQL View)
 Index Back

PM Schedule Detail View

Preventive Maintenance Schedule Detail View

SELECT A.BUSINESS_UNIT , A.PM_SCHD_ID , B.EFFDT , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.MAINT_LOOP_ID , A.LOCATION , A.MAINT_TYPE , A.DESCR100 , A.START_DATE , A.FIRST_CYCLE_FLG , A.LAST_REVIEWED_DTTM , A.LAST_REVIEWED_BY , B.WO_TEMPLATE_ID , B.THRESHOLD_PCT , B.PM_SCHD_OPT , B.PM_TM_SCHD_TYPE , B.SCHED_DATE , B.INTERVAL_VAL , B.INTERVAL_START_FRM , B.DAY_OFWEEK , B.DATE_OF_MONTH , B.WEEK_OF_MONTH , B.START_FR_END_MONTH , B.DURATION_MLTP , B.SRVC_GRP_ID , B.WO_TYPE , B.BUSINESS_UNIT_PC , B.PROJECT_ID , B.ACTIVITY_ID , B.SHOP_ID , B.PRIORITY_CD , B.STATUS_CD , B.INTERNAL_STATUS , B.STATUS_CD_HDR , B.WO_APPROVAL_STATUS , B.WO_APPRVL_FLG , B.DESCR254 , B.ANNUAL_OCCURANCE , B.CBM_ALERT , B.CBM_SOURCE , B.PROCESS_INSTANCE , B.IN_PROCESS_FLG , B.PM_LEAD_DAYS , B.WM_PM_APPR_STATUS , B.WM_PM_APPRVL_FLG , B.EFF_STATUS , B.WM_PARENTCHILD_FLG FROM PS_WM_PM_SCHD A , PS_WM_PM_SCHD_DTL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PM_SCHD_ID = B.PM_SCHD_ID AND B.EFFDT = ( SELECT MAX( D.EFFDT ) FROM PS_WM_PM_SCHD_DTL D WHERE D.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.PM_SCHD_ID = B.PM_SCHD_ID AND D.EFFDT <= %CurrentDateIn ) AND (B.EFF_STATUS = 'A' OR (B.EFF_STATUS <> 'A' AND B.WM_PM_APPR_STATUS <> 'A'))

  • Related Language Record: WM_PMSCHDTLG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_WM_NONVW

    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 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Prompt Table: SP_BU_AM_NONVW

    5 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Prompt Table: WM_ASSET_VWA

    6 MAINT_LOOP_ID Character(15) VARCHAR2(15) NOT NULL Maintenance Loop ID
    7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    8 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type

    Prompt Table: MAINT_TYPE_TBL

    9 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    10 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
    11 FIRST_CYCLE_FLG Character(1) VARCHAR2(1) NOT NULL First Maintenance Cycle

    Default Value: Y

    12 LAST_REVIEWED_DTTM DateTime(26) TIMESTAMP Last Reviewed
    13 LAST_REVIEWED_BY Character(30) VARCHAR2(30) NOT NULL Last reviewed by
    14 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID

    Prompt Table: WM_WO_JTMPL_VW2
    Set Control Field: BUSINESS_UNIT

    15 THRESHOLD_PCT Number(3,0) SMALLINT NOT NULL Confidence %

    Default Value: 100

    16 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

    Default Value: 1

    17 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
    18 SCHED_DATE Date(10) DATE Schedule Date
    19 INTERVAL_VAL Number(9,0) DECIMAL(9) NOT NULL Interval
    20 INTERVAL_START_FRM Character(1) VARCHAR2(1) NOT NULL From the last PM completion
    N=No
    Y=Yes

    Default Value: Y

    21 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
    22 DATE_OF_MONTH Character(2) VARCHAR2(2) NOT NULL Date of the Month
    23 WEEK_OF_MONTH Character(1) VARCHAR2(1) NOT NULL Week of the month
    1=1st
    2=2nd
    3=3rd
    4=4th
    5=Last
    24 START_FR_END_MONTH Character(1) VARCHAR2(1) NOT NULL From the end of the month
    N=No
    Y=Yes

    Default Value: N

    25 DURATION_MLTP Number(6,2) DECIMAL(5,2) NOT NULL Duration Multiple

    Default Value: 1

    26 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

    Prompt Table: WM_SRVC_GRP_BU

    27 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

    Prompt Table: WM_WO_TYPE

    28 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    29 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: WM_PM_PC_PRJ_VW

    30 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: PROJ_ACT_FS

    31 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

    Prompt Table: WM_SRVC_SHOP_VW

    32 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code

    Prompt Table: WM_PRIORITY

    33 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code

    Prompt Table: WM_STATUS_TSK_O
    Set Control Field: BUSINESS_UNIT

    34 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

    Default Value: 01

    35 STATUS_CD_HDR Character(4) VARCHAR2(4) NOT NULL Header Status

    Prompt Table: WM_STATUS_HDR

    36 WO_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL work order approval status
    A=Approved
    C=Cancelled
    E=Denied
    I=Initial
    P=Pending Approval

    Default Value: A

    37 WO_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Work Management Approval
    1=Pre-Approved
    3=Workflow Approval
    38 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    39 ANNUAL_OCCURANCE Character(1) VARCHAR2(1) NOT NULL Annual Occurance
    40 CBM_ALERT Character(1) VARCHAR2(1) NOT NULL Force WO. Disregard options.
    1=On
    2=Off
    41 CBM_SOURCE Character(1) VARCHAR2(1) NOT NULL CBM Alert source
    1=AM Reading Tolerance
    2=MM Alert
    3=Alert set manually
    42 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    43 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

    Default Value: N

    44 PM_LEAD_DAYS Number(3,0) SMALLINT NOT NULL LEAD DAYS
    45 WM_PM_APPR_STATUS Character(1) VARCHAR2(1) NOT NULL work order approval status
    A=Approved
    C=Cancelled
    E=Denied
    I=Initial
    P=Pending Approval
    46 WM_PM_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Work Management Approval
    1=Pre-Approved
    3=Workflow Approval
    47 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    48 WM_PARENTCHILD_FLG Character(1) VARCHAR2(1) NOT NULL Parent/Child

    Y/N Table Edit

    Default Value: N