WM_WR_HDR_VW

(SQL View)
 Index Back

Work Request Business Unit

Work Request Business Unit definition

SELECT R.BUSINESS_UNIT , R.WR_ID , R.TREE_NODE , R.WR_LOCATION , R.WR_PRIORITY , R.WR_SUBJECT , R.STATUS_CD , R.INTERNAL_STATUS , R.AGENT_ROLE , R.TECHNICIAN_ROLE , R.ASSIGNED_TO_OPRID , R.ASSIGNED_BY_OPRID , R.RQST_FOR_USERID , R.CONTACT_USERID , R.BUSINESS_UNIT_WO , R.WO_ID , R.RELATED_WR_ID , R.REQUIRED_DATE , R.ALERT_INDICATOR , R.BUSINESS_UNIT_AM , R.ASSET_ID , A.ASSET_DESCR30 , A.ASSET_DESCR , A.TAG_NUMBER , A.SERIAL_ID , A.ASSET_OPEN_WO_CNT , CASE WHEN R.ASSET_ID <> ' ' THEN CASE WHEN A.ASSET_OPEN_WO_CNT > 0 THEN 'Y' ELSE 'N' END END FROM PS_WM_WR_HDR R LEFT OUTER JOIN PS_WM_WR_ASSET_VW A ON A.BUSINESS_UNIT_AM = R.BUSINESS_UNIT_AM AND A.ASSET_ID = R.ASSET_ID

  • Related Language Record: WM_WR_HDR_LVW

  • Parent record: WM_WR_WRK

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 WR_ID Character(15) VARCHAR2(15) NOT NULL Work Request ID
    3 RQST_TYPE Character(20) VARCHAR2(20) NOT NULL Request type equivalent to tree node.
    4 WR_LOCATION Character(10) VARCHAR2(10) NOT NULL Service Location
    5 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

    6 WR_SUBJECT Character(60) VARCHAR2(60) NOT NULL Subject
    7 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
    8 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

    9 AGENT_ROLE Character(30) VARCHAR2(30) NOT NULL Agent role name
    10 TECHNICIAN_ROLE Character(30) VARCHAR2(30) NOT NULL Technician role name
    11 ASSIGNED_TO_OPRID Character(30) VARCHAR2(30) NOT NULL Assigned To
    12 ASSIGNED_BY_OPRID Character(30) VARCHAR2(30) NOT NULL Assigned By
    13 RQST_FOR_USERID Character(30) VARCHAR2(30) NOT NULL Request For User ID
    14 CONTACT_USERID Character(30) VARCHAR2(30) NOT NULL Contact User ID
    15 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
    16 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
    17 RELATED_WR_ID Character(15) VARCHAR2(15) NOT NULL Related work request ID
    18 REQUIRED_DATE Date(10) DATE Required By
    19 ALERT_INDICATOR Character(3) VARCHAR2(3) NOT NULL Note alert indicator
    000=None
    001=Outstanding Request
    002=Reply Received
    20 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    21 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    22 ASSET_DESCR30 Character(30) VARCHAR2(30) NOT NULL Asset Description
    23 ASSET_DESCR Character(254) VARCHAR2(254) NOT NULL Asset Description
    24 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    25 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    26 ASSET_OPEN_WO_CNT Number(5,0) INTEGER NOT NULL Asset Open WO Count
    27 WR_ASSET_OPEN_WOS Character(1) VARCHAR2(1) NOT NULL Assets with Open WOs
    N=No
    Y=Yes