BUSINESS_UNITPrompt Table:
SP_BU_AM_NONVW
Set Control Field: BUSINESS_UNIT
ASSET_IDPrompt Table: AM_END_RSN_TBL
AM_MAINT_EXT_VW(SQL View) |
Index Back |
|---|---|
Maintenance Extended AttributeMaintenance Management Extended Attributes child table. |
| SELECT M.BUSINESS_UNIT , M.ASSET_ID , M.LIFE_EXP , M.LIFE_EXP_NOTE , M.END_SUP_DATE , M.END_SUP_NOTE , M.END_LIFE_DATE , M.END_LIFE_RSN , M.REPLACE_DATE , CASE WHEN (M.LIFE_EXP > 0 AND A.IN_SERVICE_DT IS NOT NULL) THEN (%DateDiff(A.IN_SERVICE_DT, %CurrentDateIn) / 365 / M.LIFE_EXP * 100 ) ELSE 0 END FROM PS_AM_MAINT_EXT M , PS_ASSET A WHERE M.BUSINESS_UNIT = A.BUSINESS_UNIT AND M.ASSET_ID = A.ASSET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_AM_NONVW
|
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | LIFE_EXP | Number(6,2) | DECIMAL(5,2) NOT NULL | Life Expectancy Yrs |
| 4 | LIFE_EXP_NOTE | Character(254) | VARCHAR2(254) NOT NULL | Life Expectancy Note |
| 5 | END_SUP_DATE | Date(10) | DATE | End of Support |
| 6 | END_SUP_NOTE | Character(254) | VARCHAR2(254) NOT NULL | End of Support Note |
| 7 | END_LIFE_DATE | Date(10) | DATE | End of Life |
| 8 | END_LIFE_RSN | Character(10) | VARCHAR2(10) NOT NULL |
End of Life Reason
Prompt Table: AM_END_RSN_TBL |
| 9 | REPLACE_DATE | Date(10) | DATE | Replacement |
| 10 | PCT_LIFE_EXP | Number(10,2) | DECIMAL(9,2) NOT NULL | Life Expectancy % |