WM_PM_SCHD_DTL

(SQL Table)
Index Back

PM Schedule Detail

Preventive Maintenance Schedule Detail

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

    Prompt Table: BUS_UNIT_TBL_WM

    2 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID

    Prompt Table: %EDITTABLE
    Set Control Field: BUSINESS_UNIT

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

    Default Value: 100

    7 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

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

    Default Value: Y

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

    Default Value: N

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

    Default Value: 1

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

    Prompt Table: WM_SRVC_GRP_BU

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

    Prompt Table: WM_WO_TYPE

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

    Prompt Table: WM_PC_PRJ_DVW2

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

    Prompt Table: PROJ_ACT_FS

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

    Prompt Table: WM_SRVC_SHOP_VW

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

    Prompt Table: WM_PRIORITY

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

    Prompt Table: WM_STATUS_TSK_O
    Set Control Field: BUSINESS_UNIT

    25 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

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

    Prompt Table: WM_STATUS_HDR

    27 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

    28 WO_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Work Management Approval
    1=Pre-Approved
    3=Workflow Approval
    29 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    30 ANNUAL_OCCURANCE Character(1) VARCHAR2(1) NOT NULL Annual Occurance
    31 CBM_ALERT Character(1) VARCHAR2(1) NOT NULL Force WO. Disregard options.
    1=On
    2=Off

    Default Value: 2

    32 CBM_SOURCE Character(1) VARCHAR2(1) NOT NULL CBM Alert source
    1=AM Reading Tolerance
    2=MM Alert
    3=Alert set manually
    33 PM_LEAD_DAYS Number(3,0) SMALLINT NOT NULL LEAD DAYS
    34 WM_PM_LINK_FLAG Character(1) VARCHAR2(1) NOT NULL Linked

    Default Value: N

    35 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

    Default Value: I

    36 WM_PM_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Work Management Approval
    1=Pre-Approved
    3=Workflow Approval
    37 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.

    Prompt Table: BUS_CAL_HOL_DFN

    38 SUBMIT_DTTM DateTime(26) TIMESTAMP Report Submitted On - DateTime
    39 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_FS.OPRID

    40 WM_PARENTCHILD_FLG Character(1) VARCHAR2(1) NOT NULL Parent/Child

    Y/N Table Edit

    Default Value: N

    41 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: WM_ELGBL_WRKR

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

    Prompt Table: WM_PREFCREW2_VW

    43 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    44 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

    Default Value: N