BUSINESS_UNITMAINT_LOOP_ID010=IT Hardware
020=IT Software
040=Equipment
050=Property
060=Fleet
070=Machinery
080=Furniture
090=Facility
100=Intangible
200=Asset Retirement Obligations
999=Other
WM_BU_LOOP_VW(SQL View) |
Index Back |
|---|---|
Maintenance Loop ViewThis view is used to list all Maintenance Loops that are mapped to the same set of Maintenance Type as the WO Business Unit is mapped to. |
| SELECT A.BUSINESS_UNIT , B.MAINT_LOOP_ID , B.DESCR50 , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL FROM PS_BUS_UNIT_TBL_WM A , PS_WM_PM_LOOP_VW B , PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.REC_GROUP_ID = 'WM_01' AND C.RECNAME = 'WM_PM_LOOP_HDR' AND C.SETID = B.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | MAINT_LOOP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Maintenance Loop ID |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 4 | ASSET_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Asset Type
010=IT Hardware 020=IT Software 040=Equipment 050=Property 060=Fleet 070=Machinery 080=Furniture 090=Facility 100=Intangible 200=Asset Retirement Obligations 999=Other |
| 5 | ASSET_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL | Asset Subtype |
| 6 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 7 | MODEL | Character(30) | VARCHAR2(30) NOT NULL | Model |