WM_WO_NOTSRC_VW(SQL View) |
Index Back |
|---|---|
WO Hdr Notes Source View |
| SELECT A.BUSINESS_UNIT , A.WO_ID , A.CREATED_DTTM , A.CREATED_BY_USER , A.NOTE_SOURCE , A.SEQ_NBR_5 AS SEQ_NBR , A.REPLY_STATUS , A.VISIBLE_FLG , A.CONTACT_EMPLID , A.NAME_DISPLAY , A.TITLE , A.NOTES FROM PS_WM_WO_NOTHST_VW A WHERE (A.NOTE_SOURCE = '1' AND A.VISIBLE_FLG = 'Y') OR (A.NOTE_SOURCE = '0' AND A.VISIBLE_FLG = ' ') UNION ALL SELECT B.BUSINESS_UNIT , B.WO_ID , C.CREATED_DTTM , C.CREATED_BY_USER , C.NOTE_SOURCE , C.SEQ_NBR , C.REPLY_STATUS , C.VISIBLE_FLG , ' ' AS CONTACT_EMPLID , C.NAME_DISPLAY , C.BUSINESS_UNIT_WR %Concat '-' %Concat C.WR_ID %Concat '-' %Concat %NumToChar(C.SEQ_NBR) AS TITLE , C.NOTES FROM PS_WM_WO_ASSCSR_VW B , PS_WM_WR_NOTHST_VW C WHERE C.BUSINESS_UNIT_WR = B.BUSINESS_UNIT_WR AND C.WR_ID = B.WR_ID AND C.NOTE_SOURCE = '0' |
| # | 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 | CREATED_DTTM |
DateTime(26) | TIMESTAMP | Created Date and time |
| 4 | CREATED_BY_USER |
Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 5 | 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 |
| 6 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 7 | REPLY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Reply Status
0=None 1=Needs Reply 2=Replied 3=Reviewed 4=Canceled |
| 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 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display |
| 11 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |
| 12 | NOTES | Long Character | CLOB | Note |