| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 AM_IOT_INCIDENT_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Stores IoT Incident ID
|
| 2 |
AM_IOT_ASSET_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Store IoT Asset ID
|
| 3 |
AM_IOT_ASSET_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Store IoT Asset Name
|
| 4 |
AM_IOT_INCD_OCCTYP |
Character(30) |
VARCHAR2(30) NOT NULL |
Stores IoT Incident Occurrence Type
|
| 5 |
AM_IOT_INCD_OBSVAL |
Character(50) |
VARCHAR2(50) NOT NULL |
Stores IoT Incident Observed Value
|
| 6 |
AM_IOT_INCD_ATTRNM |
Character(50) |
VARCHAR2(50) NOT NULL |
Stores IoT Incident attributeName
|
| 7 |
AM_IOT_INCD_THSVAL |
Character(50) |
VARCHAR2(50) NOT NULL |
Stores IoT Incident Threshold Value
|
| 8 |
AM_IOT_INCIDN_OPER |
Character(50) |
VARCHAR2(50) NOT NULL |
Stores IoT Incident operator
|
| 9 |
AM_LASTUPDT_DTTM |
DateTime(26) |
TIMESTAMP |
Last Updated On
|
| 10 |
AM_LASTUPDT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Updated By
|