EMPLIDDESCRRS_ASSGN_WM_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID ,A.DESCR ,A.ASSIGNMENT_ID ,A.BUSINESS_UNIT_WO ,A.WO_ID ,A.WO_TASK_ID FROM PS_RS_ASSIGNMENT A , PS_WM_WO_SCHED_LBR B WHERE A.BUSINESS_UNIT_WO = B.BUSINESS_UNIT AND A.WO_ID = B.WO_ID AND A.WO_TASK_ID = B.WO_TASK_ID AND A.SYSTEM_SOURCE = 'WM' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 4 | BUSINESS_UNIT_WO | Character(5) | VARCHAR2(5) NOT NULL | Business Unit Work Order |
| 5 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 6 | WO_TASK_ID | Number(5,0) | INTEGER NOT NULL | Task Number |