ASSIGNED_TO_OPRIDWM_ASSIGN_TO_VW(SQL View) |
Index Back |
|---|---|
Assigned To ViewAssigned To View |
| SELECT DISTINCT A.OPRID , D.NAME , A.EMPLID FROM PSOPRDEFN A , PSROLEUSER B , PS_WM_PROBLEM_LOC C , PS_PERSONAL_DATA D WHERE B.ROLEUSER = A.OPRID AND B.ROLENAME = C.TECHNICIAN_ROLE AND D.EMPLID = A.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASSIGNED_TO_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |