WM_PM_SCH_UPD

(SQL Table)
 Index Back

PM Schedule Mass Update

PM Schedule Mass Update New Values

  • Related Language Record: WM_PM_SCH_UPD_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_WM

    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 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

    7 THRESHOLD_PCT Number(3,0) SMALLINT NOT NULL Confidence %
    8 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
    9 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
    10 SCHED_DATE Date(10) DATE Schedule Date
    11 INTERVAL_VAL Number(9,0) DECIMAL(9) NOT NULL Interval
    12 INTERVAL_START_FRM Character(1) VARCHAR2(1) NOT NULL From the last PM completion
    N=No
    Y=Yes
    13 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
    14 DATE_OF_MONTH Character(2) VARCHAR2(2) NOT NULL Date of the Month
    15 WEEK_OF_MONTH Character(1) VARCHAR2(1) NOT NULL Week of the month
    1=1st
    2=2nd
    3=3rd
    4=4th
    5=Last
    16 START_FR_END_MONTH Character(1) VARCHAR2(1) NOT NULL From the end of the month
    N=No
    Y=Yes
    17 DURATION_MLTP Number(6,2) DECIMAL(5,2) NOT NULL Duration Multiple
    18 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

    Prompt Table: WM_SRVC_GRP_BU

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

    Prompt Table: WM_WO_TYPE

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

    Prompt Table: WM_PC_PRJ_VW3

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

    Prompt Table: PROJ_ACT_FS

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

    Prompt Table: WM_SRVC_SHOP_VW

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

    Prompt Table: WM_PRIORITY

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

    Prompt Table: WM_STATUS_TSK_O
    Set Control Field: BUSINESS_UNIT

    26 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
    27 STATUS_CD_HDR Character(4) VARCHAR2(4) NOT NULL Header Status

    Prompt Table: WM_STATUS_HDR

    28 WO_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL work order approval status
    A=Approved
    C=Cancelled
    E=Denied
    I=Initial
    P=Pending Approval
    29 WO_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Work Management Approval
    1=Pre-Approved
    3=Workflow Approval
    30 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    31 ANNUAL_OCCURANCE Character(1) VARCHAR2(1) NOT NULL Annual Occurance
    32 CBM_ALERT Character(1) VARCHAR2(1) NOT NULL Force WO. Disregard options.
    1=On
    2=Off
    33 CBM_SOURCE Character(1) VARCHAR2(1) NOT NULL CBM Alert source
    1=AM Reading Tolerance
    2=MM Alert
    3=Alert set manually
    34 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    35 START_DATE Date(10) DATE Start Date for Gen Standing PO
    36 END_DATE Date(10) DATE End Date
    37 INTERVAL_MTR Signed Number(21,4) DECIMAL(19,4) NOT NULL Meter Reading Interval
    38 PROJ_MTR_USAGE Character(1) VARCHAR2(1) NOT NULL Project Meter Usage
    1=None
    2=Average from Asset
    3=Sampling
    39 SAMPLING_METHOD Character(4) VARCHAR2(4) NOT NULL Used in Preventive Maintenance to allow the system to project the meter usage based on historic data (the sample).
    CYCL=Cycles
    DAYS=Days
    READ=Readings
    40 SAMPLING_SIZE Number(5,0) INTEGER NOT NULL Used in Preventive Maintenance to allow the system to project the meter usage based on historic data (the sample).
    41 PROJECTED_FROM Character(4) VARCHAR2(4) NOT NULL Used in Preventive Maintenance to calculate PM's start date based on projection of meter usage.
    LAST=Last PM Completion Date
    THRU=Current System Date
    42 WM_PM_LINK_METHOD Character(1) VARCHAR2(1) NOT NULL PM Linking Method
    1=Linking by Cycle
    3=Days Tolerance
    43 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
    44 WM_PM_DAYS_TOLER Number(2,0) SMALLINT NOT NULL PM Linking Days Tolerance
    45 WM_PM_INTERVAL_TYP Character(1) VARCHAR2(1) NOT NULL PM linking interval type
    1=Day Interval
    2=Meter Interval
    46 METER_TYPE Character(30) VARCHAR2(30) NOT NULL Meter Type

    Prompt Table: AM_METER_TYPE

    47 PM_LEAD_DAYS Number(3,0) SMALLINT NOT NULL LEAD DAYS
    48 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type

    Prompt Table: MAINT_TYPE_TBL

    49 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    50 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: WM_ELGBL_WRKR

    51 CREW_ID Character(10) VARCHAR2(10) NOT NULL Crew Name

    Prompt Table: WM_PREFCREW2_VW