WM_WR_HDR

(SQL Table)
 Index Back

Work Request Header

Main work request record

  • Parent Record Of WM_WR_AUDIT WM_WR_NOTES WM_WR_NOTES_VW

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

    Prompt Table: SP_BU_WR_NONVW

    2 WR_ID Character(15) VARCHAR2(15) NOT NULL Work Request ID
    3 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

    Prompt Table: WM_PROBLEM_TREE

    4 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group
    5 PROBLEM_CD Character(15) VARCHAR2(15) NOT NULL Problem code
    6 WR_LOCATION Character(10) VARCHAR2(10) NOT NULL Service Location

    Prompt Table: WM_PRB_LOC_VW

    7 WR_PRIORITY Character(1) VARCHAR2(1) NOT NULL Service Request Priority
    1=1-Critical
    2=2-Urgent
    3=3-Standard
    4=4-Low

    Default Value: 3

    8 WR_SUBJECT Character(60) VARCHAR2(60) NOT NULL Subject
    9 DESCRLONG Long Character CLOB Long Description
    10 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    11 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    12 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: WM_ASSET_LOC_VW

    13 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location
    14 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

    Prompt Table: WM_AREA_LOC_VW

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

    Prompt Table: WM_STATUS_WR

    16 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
    17 STATUS_DTTM DateTime(26) TIMESTAMP 05/13/02 EGS (CN#PL900-1): Added
    18 AGENT_ROLE Character(30) VARCHAR2(30) NOT NULL Agent role name
    19 TECHNICIAN_ROLE Character(30) VARCHAR2(30) NOT NULL Technician role name
    20 ASSIGNED_TO_OPRID Character(30) VARCHAR2(30) NOT NULL Assigned To

    Prompt Table: WM_ASSIGN_TO_WR

    21 ASSIGNED_BY_OPRID Character(30) VARCHAR2(30) NOT NULL Assigned By

    Prompt Table: WM_ASSIGN_BY_VW

    22 CONTACT_USERID Character(30) VARCHAR2(30) NOT NULL Contact User ID
    23 CONTACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact Employee ID
    24 CONTACT_MTHD Character(1) VARCHAR2(1) NOT NULL Contact method
    1=E-mail
    2=Phone
    3=Do Not Contact
    25 CONTACT_DETAIL Character(70) VARCHAR2(70) NOT NULL Contact detail
    26 RQST_FOR_USERID Character(30) VARCHAR2(30) NOT NULL Request For User ID

    Prompt Table: WM_WR_FOR_VW

    27 RQST_FOR_EMPLID Character(11) VARCHAR2(11) NOT NULL Requested for employee ID

    Prompt Table: WM_WR_FOR_VW

    28 RQST_FOR_MTHD Character(1) VARCHAR2(1) NOT NULL Requested for contact method
    1=E-mail
    2=Phone
    3=Do Not Contact
    29 RQST_FOR_DETAIL Character(70) VARCHAR2(70) NOT NULL Requested for detail
    30 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
    31 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
    32 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group
    33 RELATED_WR_ID Character(15) VARCHAR2(15) NOT NULL Related work request ID

    Prompt Table: WM_RELATED_WR

    34 ALERT_INDICATOR Character(3) VARCHAR2(3) NOT NULL Note alert indicator
    000=None
    001=Outstanding Request
    002=Reply Received

    Default Value: 000

    35 REQUIRED_DATE Date(10) DATE NOT NULL Required By

    Default Value: %date

    36 ENTERED_DTTM DateTime(26) TIMESTAMP Entered Datetime
    37 COMPLTED_DT Date(10) DATE Completed Date
    38 CLOSED_DATE Date(10) DATE Service Order Closed Date
    39 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %datetime

    40 LAST_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL LastUpdatedUser
    41 FROM_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Move From Location

    Prompt Table: WM_PROPERTY_VW

    42 TO_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Move To Location

    Prompt Table: WM_PROPERTY2_VW

    43 MOVE_EMPLOYEE Character(1) VARCHAR2(1) NOT NULL Move Employee

    Y/N Table Edit

    44 MOVE_PHONE Character(1) VARCHAR2(1) NOT NULL Move Phone

    Y/N Table Edit

    45 MOVE_FURNITURE Character(1) VARCHAR2(1) NOT NULL Move Equipment and Furniture

    Y/N Table Edit

    46 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL
    Set Control Field: BUSINESS_UNIT_HR