WM_ALERT_SRH_VW

(SQL View)
 Index Back

CBM Alert Search Record

CBM Alert Search Record

SELECT A.BUSINESS_UNIT , A.CBM_ALERT_ID , A.ASSET_ID , B.TAG_NUMBER , B.ASSET_TYPE , B.ASSET_SUBTYPE , C.LOCATION , C.AREA_ID , A.CBM_ALERT_DATETIME , A.CBM_ALERT_LEVEL , A.CBM_ALERT_STATUS , A.BUSINESS_UNIT_WO , A.SHOP_ID FROM PS_WM_ALERT A , PS_ASSET B , PS_ASSET_LOC_VW C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.ASSET_ID = C.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 CBM_ALERT_ID Number(15,0) DECIMAL(15) NOT NULL CBM Alert ID
3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: ASSET

4 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
5 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
6 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

Prompt Table: AM_SUBTYPE

7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL
Set Control Field: BUSINESS_UNIT

8 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

Prompt Table: AM_AREA_TBL

9 CBM_ALERT_DATETIME DateTime(26) TIMESTAMP CBM Alert Datetime
10 CBM_ALERT_LEVEL Character(1) VARCHAR2(1) NOT NULL CBM Alert Level
1=1
2=2
3=3
4=4
5=5
11 CBM_ALERT_STATUS Character(1) VARCHAR2(1) NOT NULL CBM Alert Status
1=New
2=Error
3=PM Schedule Updated
4=Work Order Created
5=Work Order Completed
6=Work Order Canceled
7=Closed
12 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order

Prompt Table: SP_BU_WM_NONVW

13 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Prompt Table: WM_SHOP_BU3_VW