WM_ALERT_STATS (SQL Table)	Index Back
CBM Alert Status History CBM Alert Status History

WM_ALERT_STATS

(SQL Table)

CBM Alert Status History

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_AM

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
Prompt Table: ASSET

3 CBM_ALERT_DATETIME DateTime(26) TIMESTAMP NOT NULL CBM Alert Datetime
Default Value: %Datetime

4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

5 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
Default Value: 1

6 STATUS_DTTM DateTime(26) TIMESTAMP 05/13/02 EGS (CN#PL900-1): Added

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_AM
2	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification Prompt Table: ASSET
3	CBM_ALERT_DATETIME	DateTime(26)	TIMESTAMP NOT NULL	CBM Alert Datetime Default Value: %Datetime
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	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 Default Value: 1
6	STATUS_DTTM	DateTime(26)	TIMESTAMP	05/13/02 EGS (CN#PL900-1): Added