TECHNICIAN_ROLEASSIGNED_TO_OPRIDWM_ASSIGN_TO_WR(SQL View) |
Index Back |
|---|---|
Assigned To ViewAssigned To View |
| SELECT DISTINCT C.TECHNICIAN_ROLE , A.OPRID , D.NAME 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 | TECHNICIAN_ROLE |
Character(30) | VARCHAR2(30) NOT NULL | Technician role name |
| 2 | ASSIGNED_TO_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | Assigned To |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |