WM_PROBLEM_LOC

(SQL Table)
 Index Back

Problem / Location Defaults

Contains Work Request and Work Order defaults by problem type and location

  • Parent record: WM_PROBLEM_TREE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
    3 LOCATION_SETID Character(5) VARCHAR2(5) NOT NULL Location Set ID

    Prompt Table: SP_SETID_NONVW

    4 WR_LOCATION Character(10) VARCHAR2(10) NOT NULL Service Location

    Prompt Table: WR_LOCATION_VW

    5 AGENT_ROLE Character(30) VARCHAR2(30) NOT NULL Agent role name

    Prompt Table: WM_ROLENAME_VW

    6 TECHNICIAN_ROLE Character(30) VARCHAR2(30) NOT NULL Technician role name

    Prompt Table: WM_ROLENAME_VW

    7 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

    Prompt Table: WM_PRBLM_BU_VW
    Set Control Field: SETID

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

    Prompt Table: WM_SRVC_GRP_WBU
    Set Control Field: BUSINESS_UNIT_WO

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

    Prompt Table: WM_WO_TYPE
    Set Control Field: BUSINESS_UNIT_WO

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

    Prompt Table: WM_PRIORITY
    Set Control Field: BUSINESS_UNIT_WO