WM_WO_TTMPL_EFF

(SQL Table)
 Index Back

WO Task Template Eff Control

WO Task Template -- Effective Control Tbl

  • Related Language Record: WM_WO_TTEFF_LNG

  • Parent record: WM_WO_TMPLT_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: WM_WO_TMPLT_HDR.SETID

    Prompt Table: SP_SETID_NONVW

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

    Default Value: WM_WO_TMPLT_HDR.WO_TEMPLATE_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 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

    Prompt Table: WM_TT_ITMSET_VW

    6 CRAFT_SETID Character(5) VARCHAR2(5) NOT NULL Foreign key SetID to RS_CRAFT_DETAIL table

    Prompt Table: WM_TT_CRFSET_VW

    7 TASK_ACTION Character(1) VARCHAR2(1) NOT NULL The purpose of this field is to identify the kind of action that may be done for a task.
    1=No Change
    2=Install Component
    3=Repair
    4=Remove
    5=Retire
    6=Remove and Sell
    7=Replacement asset
    8=Ownership Change
    8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    9 WO_DURATION Number(8,2) DECIMAL(7,2) NOT NULL Estimated Work Order Duration
    10 RESOLUTION_CD Character(15) VARCHAR2(15) NOT NULL Resolution code

    Prompt Table: WM_RESOLUTION

    11 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group

    Prompt Table: WM_PCR_CLSF_DVW

    12 PROBLEM_CD Character(15) VARCHAR2(15) NOT NULL Problem code

    Prompt Table: WM_PCR_PRBAC_VW