ASSET_IDBUSINESS_UNITCBM_ALERT_IDCBM_ALERT_DATETIMEDefault Value: %Datetime
ASSET_INCDT_DTL(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | AM_IOT_INCIDENT_ID | Character(50) | VARCHAR2(50) NOT NULL | Stores IoT Incident ID |
| 4 | AM_IOT_INCIDNT_STS | Character(20) | VARCHAR2(20) NOT NULL | Stores IoT Incident Status N - NEW O - OPEN WIP - WORK IN PROGRESS R - RESOLVED W - WITHDRAWN |
| 5 | AM_IOT_INCIDNT_TYP | Character(20) | VARCHAR2(20) NOT NULL | Stores IoT Incident Type O - Outage M - Maintenance R - Routine |
| 6 | AM_IOT_INCD_ATTRNM | Character(50) | VARCHAR2(50) NOT NULL | Stores IoT Incident attributeName |
| 7 | AM_IOT_INCD_OBSVAL | Character(50) | VARCHAR2(50) NOT NULL | Stores IoT Incident Observed Value |
| 8 | AM_IOT_INCD_THSVAL | Character(50) | VARCHAR2(50) NOT NULL | Stores IoT Incident Threshold Value |
| 9 | CBM_ALERT_ID |
Number(15,0) | DECIMAL(15) NOT NULL | CBM Alert ID |
| 10 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 11 | CBM_ALERT_DATETIME |
DateTime(26) | TIMESTAMP NOT NULL |
CBM Alert Datetime
Default Value: %Datetime |