WM_WO_IANOT_VW

(SQL View)
 Index Back

WO Insp Activity Notes View


SELECT BUSINESS_UNIT , WO_ID , WO_TASK_ID , INSPECTION_ID , INSP_ACTIVITY_NBR , SEQ_NBR_5 , TITLE , NOTES , NOTE_SOURCE , VISIBLE_FLG , CONTACT_EMPLID , REPLY_STATUS , CREATED_BY_USER , CREATED_DTTM FROM PS_WM_WO_INSPC_NOT

  • Parent record: WM_WO_INSPC_ACT

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

    Default Value: WM_WO_INSPC_ACT.BUSINESS_UNIT

    Prompt Table: SP_BU_WM_NONVW

    2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

    Default Value: WM_WO_INSPC_ACT.WO_ID

    Prompt Table: WM_FTRK_WOI_PVW

    3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

    Default Value: WM_WO_INSPC_ACT.WO_TASK_ID

    Prompt Table: WM_FTRK_TSK_PVW

    4 INSPECTION_ID Character(10) VARCHAR2(10) NOT NULL Inspection ID

    Default Value: WM_WO_INSPC_ACT.INSPECTION_ID

    5 INSP_ACTIVITY_NBR Number(5,0) INTEGER NOT NULL Activity Number

    Default Value: WM_WO_INSPC_ACT.INSP_ACTIVITY_NBR

    6 SEQ_NBR_5 Number(5,0) INTEGER NOT NULL Sequence number five digits long

    Default Value: 1

    7 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    8 NOTES Long Character CLOB NOT NULL Budget Notes
    9 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: 1

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

    Default Value: Y

    11 CONTACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact Employee ID
    12 REPLY_STATUS Character(1) VARCHAR2(1) NOT NULL Reply Status
    0=None
    1=Needs Reply
    2=Replied
    3=Reviewed
    4=Canceled
    13 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
    14 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time