WM_WO_NOTHST_VW

(SQL View)
 Index Back

WO Notes History View


SELECT A.BUSINESS_UNIT , A.WO_ID , A.SEQ_NBR_5 , A.TITLE , A.NOTES , A.REPLY_STATUS , A.NOTE_SOURCE , A.VISIBLE_FLG , A.CONTACT_EMPLID , A.CREATED_BY_USER , B.NAME_DISPLAY , A.CREATED_DTTM FROM PS_WM_WO_NOTES A , PS_WM_OPER_NAME_VW B WHERE B.OPRID = A.CREATED_BY_USER

# 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_WM_NONVW

2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 SEQ_NBR_5 Number(5,0) INTEGER NOT NULL Sequence number five digits long
4 TITLE Character(35) VARCHAR2(35) NOT NULL Title
5 NOTES Long Character CLOB Note
6 REPLY_STATUS Character(1) VARCHAR2(1) NOT NULL Reply Status
0=None
1=Needs Reply
2=Replied
3=Reviewed
4=Canceled
7 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

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

Y/N Table Edit

9 CONTACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact Employee ID
10 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By
11 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Created By
12 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time