WM_ALERT(SQL Table) |
Index Back |
|---|---|
CBM AlertCBM Alert |
| # | 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
Prompt Table: ASSET |
| 3 | CBM_ALERT_DATETIME |
DateTime(26) | TIMESTAMP NOT NULL |
CBM Alert Datetime
Default Value: %Datetime |
| 4 | CBM_ALERT_ID | Number(15,0) | DECIMAL(15) NOT NULL |
CBM Alert ID
Default Value: 0 |
| 5 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL |
Time Zone
Default Value: GMT Prompt Table: PSTIMEZONE |
| 6 | CBM_ALERT_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
CBM Alert Level
1=1 2=2 3=3 4=4 5=5 |
| 7 | CBM_MSMT_LOCATION | Character(100) | VARCHAR2(100) NOT NULL | CBM Alert Measurement Location |
| 8 | CBM_ALERT_REMARK | Character(254) | VARCHAR2(254) NOT NULL | CBM Alert Remarks |
| 9 | 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 |
| 10 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 11 | CBM_ALERT_ERROR | Number(3,0) | SMALLINT NOT NULL | Alert Error Number |
| 12 | BUSINESS_UNIT_WO | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table: BUS_UNIT_TBL_WM |
| 13 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table: WM_SHOP_BU3_VW |
| 14 | PM_SCHD_ID | Character(10) | VARCHAR2(10) NOT NULL | Preventive Maintenance Schedule ID |
| 15 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 16 | TIMEZONE_GMT | Character(9) | VARCHAR2(9) NOT NULL |
should be named as TIMEZONE_UTC, the value of the field is fixed to "UTC", which is not adjustable to day light saving.
Default Value: UTC |