SETIDTREE_NODELOCATION_SETIDSHOP_IDWM_PROB_SHOP_VW(SQL View) |
Index Back |
|---|---|
Problem Shop Location ViewThis view contains the shop location by problem for a work order in FMS. |
| SELECT DISTINCT A.SETID , A.TREE_NODE , A.LOCATION_SETID , B.SHOP_ID , A.SRVC_GRP_ID , A.BUSINESS_UNIT_WO , %TrimSubstr(B.DESCR,1,37) %Concat ', ' %Concat %TrimSubstr(B.CITY,1,20) %Concat ', ' %Concat %TrimSubstr(B.COUNTRY,1,6) , B.DESCR , B.LOCATION , B.CITY , B.COUNTY , B.STATE , B.POSTAL , B.COUNTRY , B.BUILDING , B.FLOOR , B.SECTOR , A.AGENT_ROLE , A.TECHNICIAN_ROLE , A.WO_TYPE , A.PRIORITY_CD FROM PS_WM_PROBLEM_LOC A , PS_WM_SHOP_LOC_VW B WHERE A.SRVC_GRP_ID = B.SRVC_GRP_ID AND A.BUSINESS_UNIT_WO = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 3 | LOCATION_SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field contains the location setid for an asset in work management. |
| 4 | SHOP_ID |
Character(10) | VARCHAR2(10) NOT NULL | This field contains the Shop ID to identify the service location for a work order in FMS. |
| 5 | SRVC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | The field contains the service group id used to identify the service location for a work order in FMS. |
| 6 | BUSINESS_UNIT_WO | Character(5) | VARCHAR2(5) NOT NULL | This field contains the Work Order Business Unit from Work Order Management. |
| 7 | DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | This generic field stores the description and used used on various tables. |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
| 10 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 11 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 12 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 13 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 14 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 15 | BUILDING | Character(10) | VARCHAR2(10) NOT NULL | Building # |
| 16 | FLOOR | Character(10) | VARCHAR2(10) NOT NULL | Floor # |
| 17 | SECTOR | Character(10) | VARCHAR2(10) NOT NULL | Sector |
| 18 | AGENT_ROLE | Character(30) | VARCHAR2(30) NOT NULL | This field contains the role that the agent has. |
| 19 | TECHNICIAN_ROLE | Character(30) | VARCHAR2(30) NOT NULL | This field contains the technician role for a work order in Work Management. |
| 20 | WO_TYPE | Character(5) | VARCHAR2(5) NOT NULL | This field contains the Work Order type for a work order in FMS. |
| 21 | PRIORITY_CD | Character(3) | VARCHAR2(3) NOT NULL | This field contains the priority code for a work order in FMS. |