WM_TSK_REPLY_VW(SQL View) |
Index Back |
|---|---|
Task Notes Reply |
| SELECT A.BUSINESS_UNIT ,A.WO_ID ,A.WO_TASK_ID ,A.SEQ_NBR_5 ,A.SEQ_NBR_5_LINK ,A.TITLE ,A.NOTES ,A.REPLY_STATUS ,A.NOTE_SOURCE ,A.VISIBLE_FLG ,A.CONTACT_EMPLID ,A.CREATED_BY_USER ,A.CREATED_DTTM ,B.BUSINESS_UNIT_WR ,B.WR_ID ,B.WO_SOURCE_CD ,C.SCHEDULER_CODE ,C.LEAD_PERSON ,C.EMPLID FROM PS_WM_TSK_NOTES A , PS_WM_WO_HDR B , PS_WM_WO_TSK C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WO_ID = B.WO_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.WO_ID = C.WO_ID AND A.WO_TASK_ID = C.WO_TASK_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 3 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL | Task Number |
| 4 | SEQ_NBR_5 |
Number(5,0) | INTEGER NOT NULL | Sequence number five digits long |
| 5 | SEQ_NBR_5_LINK | Number(5,0) | INTEGER NOT NULL | Sequence number link |
| 6 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |
| 7 | NOTES | Long Character | CLOB | Budget Notes |
| 8 | REPLY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Reply Status
0=None 1=Needs Reply 2=Replied 3=Reviewed 4=Canceled |
| 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 |
| 10 | VISIBLE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Yes/No Indicator |
| 11 | CONTACT_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Contact Employee ID |
| 12 | CREATED_BY_USER | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 13 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Date and time |
| 14 | BUSINESS_UNIT_WR | Character(5) | VARCHAR2(5) NOT NULL | Work Request Business Unit |
| 15 | WR_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Request ID |
| 16 | WO_SOURCE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Work order source code
1=Third Party 2=CRM Help Desk 3=Work Order 4=Service Request 5=Preventive Maintenance 6=Project Costing 7=Express Work Order 8=Condition-based Maintenance 9=WO Inspection |
| 17 | SCHEDULER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Scheduler Code |
| 18 | LEAD_PERSON | Character(30) | VARCHAR2(30) NOT NULL | Lead Person |
| 19 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |