BUSINESS_UNIT_WRPrompt Table: SP_BU_WR_NONVW
WR_IDSEQ_NBR0=None
1=Needs Reply
2=Replied
3=Reviewed
4=Canceled
0=Service Request
1=Work Order Header
2=3rd Party
3=Other
4=Work Order Task
5=Inspection Activity
Default Value: 0
Y/N Table Edit
WM_WR_NOTHST_VW(SQL View) |
Index Back |
|---|---|
WR Notes History View |
| SELECT A.BUSINESS_UNIT , A.WR_ID , A.SEQ_NBR , A.TITLE , A.NOTES , A.REPLY_STATUS , A.NOTE_SOURCE , A.VISIBLE_FLG , A.CREATED_BY_USER , B.NAME_DISPLAY , A.CREATED_DTTM FROM PS_WM_WR_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_WR |
Character(5) | VARCHAR2(5) NOT NULL |
Work Request 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 |
| 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 | CREATED_BY_USER | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 10 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Created By |
| 11 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Date and time |