BUSINESS_UNIT_WOPrompt Table: SP_BU_WM_NONVW
PM_SCHD_IDPrompt Table: SP_BU_AM_NONVW
Prompt Table: WM_ASSET_VWA
Prompt Table: MAINT_TYPE_TBL
WM_PM_SCHDT1_VW(SQL View) |
Index Back |
|---|---|
PM Schedule Detail ViewPreventive Maintenance Schedule Detail View |
| SELECT A.BUSINESS_UNIT , A.PM_SCHD_ID , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.MAINT_LOOP_ID , A.LOCATION , A.MAINT_TYPE , A.DESCR100 FROM PS_WM_PM_SCHD A , PS_WM_PM_SCHD_DTL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PM_SCHD_ID = B.PM_SCHD_ID AND B.EFFDT = ( SELECT MAX( D.EFFDT ) FROM PS_WM_PM_SCHD_DTL D WHERE D.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.PM_SCHD_ID = B.PM_SCHD_ID AND D.EFFDT <= %CurrentDateIn ) AND B.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_WO |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table: SP_BU_WM_NONVW |
| 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
Prompt Table: SP_BU_AM_NONVW |
| 4 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table: WM_ASSET_VWA |
| 5 | MAINT_LOOP_ID | Character(15) | VARCHAR2(15) NOT NULL | Maintenance Loop ID |
| 6 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 7 | MAINT_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
This field is used for maintenance type
Prompt Table: MAINT_TYPE_TBL |
| 8 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |