WM_PM_SCH_SRH

(SQL Table)
Index Back

PM Schedule Mass Update

PM Schedule Mass Update Search Criteria

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

    Prompt Table: SP_BU_WM_NONVW

    4 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type

    Prompt Table: MAINT_TYPE_TBL

    5 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Prompt Table: SP_BU_AM_NONVW

    6 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
    7 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE
    Set Control Field: BUSINESS_UNIT_AM

    8 PM_SCHD_SRCH_FLD Character(1) VARCHAR2(1) NOT NULL Search Field
    1=Asset ID
    2=Tag #
    3=Serial ID
    4=VIN
    5=Location
    6=Loop ID
    7=Schedule
    9 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID

    Prompt Table: WM_PM_SCHD

    10 PM_SCHD_ID_TO Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID

    Prompt Table: WM_PM_SCHD

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

    Prompt Table: WM_ASSET_VWA

    12 ASSET_ID_TO Character(12) VARCHAR2(12) NOT NULL Asset ID to

    Prompt Table: WM_ASSET_VWA

    13 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number

    Prompt Table: WM_ASSET_VW9T

    14 TAG_NUMBER_TO Character(12) VARCHAR2(12) NOT NULL Tag Number To

    Prompt Table: WM_ASSET_VW9T

    15 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

    Prompt Table: WM_ASSET_VW9S

    16 SERIAL_ID_TO Character(20) VARCHAR2(20) NOT NULL To Serial ID

    Prompt Table: WM_ASSET_VW9S

    17 VIN Character(18) VARCHAR2(18) NOT NULL VIN

    Prompt Table: WM_ASSET_VIN

    18 VIN_TO Character(18) VARCHAR2(18) NOT NULL VIN to

    Prompt Table: WM_ASSET_VIN

    19 MAINT_LOOP_ID Character(15) VARCHAR2(15) NOT NULL Maintenance Loop ID

    Prompt Table: WM_PM_LOOP_VW

    20 MAINT_LOOP_TO_15 Character(15) VARCHAR2(15) NOT NULL Loop To

    Prompt Table: WM_PM_LOOP_VW

    21 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_VW

    22 LOCATION_TO Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_VW

    23 EFFDT Date(10) DATE Effective Date
    24 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    25 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

    26 THRESHOLD_PCT Number(3,0) SMALLINT NOT NULL Confidence %
    27 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
    28 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
    29 SCHED_DATE Date(10) DATE Schedule Date
    30 INTERVAL_VAL Number(9,0) DECIMAL(9) NOT NULL Interval
    31 INTERVAL_START_FRM Character(1) VARCHAR2(1) NOT NULL From the last PM completion
    N=No
    Y=Yes
    32 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
    33 DATE_OF_MONTH Character(2) VARCHAR2(2) NOT NULL Date of the Month
    34 WEEK_OF_MONTH Character(1) VARCHAR2(1) NOT NULL Week of the month
    1=1st
    2=2nd
    3=3rd
    4=4th
    5=Last
    35 START_FR_END_MONTH Character(1) VARCHAR2(1) NOT NULL From the end of the month
    N=No
    Y=Yes
    36 DURATION_MLTP Number(6,2) DECIMAL(5,2) NOT NULL Duration Multiple
    37 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

    Prompt Table: WM_SRVC_GRP_BU

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

    Prompt Table: WM_WO_TYPE

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

    Prompt Table: WM_PC_PRJ_VW3

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

    Prompt Table: PROJ_ACT_FS

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

    Prompt Table: WM_SRVC_SHOP_VW

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

    Prompt Table: WM_PRIORITY

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

    Prompt Table: WM_STATUS_TSK_O
    Set Control Field: BUSINESS_UNIT

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

    Prompt Table: WM_STATUS_HDR

    47 WO_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL work order approval status
    A=Approved
    C=Cancelled
    E=Denied
    I=Initial
    P=Pending Approval
    48 WO_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Work Management Approval
    1=Pre-Approved
    3=Workflow Approval
    49 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    50 ANNUAL_OCCURANCE Character(1) VARCHAR2(1) NOT NULL Annual Occurance
    51 CBM_ALERT Character(1) VARCHAR2(1) NOT NULL Force WO. Disregard options.
    1=On
    2=Off
    52 CBM_SOURCE Character(1) VARCHAR2(1) NOT NULL CBM Alert source
    1=AM Reading Tolerance
    2=MM Alert
    3=Alert set manually
    53 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    54 START_DATE Date(10) DATE Start Date for Gen Standing PO
    55 END_DATE Date(10) DATE End Date
    56 METER_TYPE Character(30) VARCHAR2(30) NOT NULL Meter Type

    Prompt Table: AM_METER_TYPE

    57 INTERVAL_MTR Signed Number(21,4) DECIMAL(19,4) NOT NULL Meter Reading Interval
    58 PROJ_MTR_USAGE Character(1) VARCHAR2(1) NOT NULL Project Meter Usage
    1=None
    2=Average from Asset
    3=Sampling
    59 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
    60 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).
    61 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
    62 WM_PM_LINK_METHOD Character(1) VARCHAR2(1) NOT NULL PM Linking Method
    1=Linking by Cycle
    3=Days Tolerance
    63 MAINT_TYPE_LNK Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type

    Prompt Table: MAINT_TYPE_TBL

    64 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
    65 WM_PM_DAYS_TOLER Number(2,0) SMALLINT NOT NULL PM Linking Days Tolerance
    66 WM_PM_INTERVAL_TYP Character(1) VARCHAR2(1) NOT NULL PM linking interval type
    1=Day Interval
    2=Meter Interval
    67 METER_TYPE_LNK Character(30) VARCHAR2(30) NOT NULL Meter Type

    Prompt Table: AM_METER_TYPE

    68 PM_LEAD_DAYS Number(3,0) SMALLINT NOT NULL LEAD DAYS
    69 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    70 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: WM_ELGBL_WRKR

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

    Prompt Table: WM_PREFCREW2_VW