BUSINESS_UNITPM_SCHD_IDBUSINESS_UNIT_AMASSET_IDMAINT_TYPENEXT_DUE_DTPrompt Table: WM_STATUS_HDR
ASSET_PM_VW(SQL View) |
Index Back |
|---|---|
AM Fluid grid data of PMs |
| SELECT DISTINCT A.BUSINESS_UNIT , A.PM_SCHD_ID , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.MAINT_TYPE , A.NEXT_DUE_DT , A.NEXT_RDG , A.WO_ID , B.STATUS_CD , B.SHOP_ID , ' ' , A.DESCR_LONG FROM PS_WM_PM A , PS_WM_WO_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WO_ID = B.WO_ID UNION SELECT DISTINCT C.BUSINESS_UNIT , C.PM_SCHD_ID , C.BUSINESS_UNIT_AM , C.ASSET_ID , C.MAINT_TYPE , C.NEXT_DUE_DT , C.NEXT_RDG , C.WO_ID , ' ' , ' ' , ' ' , C.DESCR_LONG FROM PS_WM_PM C WHERE C.WO_ID = ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PM_SCHD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Preventive Maintenance Schedule ID |
| 3 | BUSINESS_UNIT_AM |
Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 4 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 5 | MAINT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | This field is used for maintenance type |
| 6 | NEXT_DUE_DT |
Date(10) | DATE | Preventive Maintenance due date |
| 7 | NEXT_RDG | Signed Number(21,4) | DECIMAL(19,4) NOT NULL | Next preventive maintenance due reading |
| 8 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 9 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table: WM_STATUS_HDR |
| 10 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shop Identification |
| 11 | UPCOMING_SCHD_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Upcoming Schedule |
| 12 | DESCR_LONG | Character(254) | VARCHAR2(254) NOT NULL | Long Description |