WM_WR_NOTES

(SQL Table)
 Index Back

Work Requests Comments

  • Parent record: WM_WR_HDR

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

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_WR_NONVW

    2 WR_ID Character(15) VARCHAR2(15) NOT NULL Work Request ID
    3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

    Default Value: 1

    4 SEQ_NBR_LINK Number(15,0) DECIMAL(15) NOT NULL Sequence Number Link
    5 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    6 NOTES Long Character CLOB Budget Notes
    7 REPLY_STATUS Character(1) VARCHAR2(1) NOT NULL Reply Status
    0=None
    1=Needs Reply
    2=Replied
    3=Reviewed
    4=Canceled

    Default Value: 0

    8 NOTE_SOURCE Character(1) VARCHAR2(1) NOT NULL Note Source
    0=Service Request
    1=Work Order Header
    2=3rd Party
    3=Other
    4=Work Order Task
    5=Inspection Activity

    Default Value: 0

    9 VISIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Yes/No Indicator

    Y/N Table Edit

    Default Value: Y

    10 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
    11 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time

    Default Value: %DateTime