| # |
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_INCIDNT_TYP |
Character(20) |
VARCHAR2(20) NOT NULL |
Stores IoT Incident Type
O - Outage
M - Maintenance
R - Routine
|
| 3 |
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
|
| 4 |
AM_IOT_INCDNT_SUMM |
Character(254) |
VARCHAR2(254) NOT NULL |
Stores IoT Incident Summary
|
| 5 |
AM_IOT_INCDNT_DESC |
Character(254) |
VARCHAR2(254) NOT NULL |
Stores IoT Incident Description
|
| 6 |
AM_IOT_INCDNT_RULE |
Character(254) |
VARCHAR2(254) NOT NULL |
Stores IoT Incident Rule Descr
|
| 7 |
AM_IOT_INCDT_PRIOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Stores IoT Incident Priority
|
| 8 |
AM_IOT_ASSETGEOLOC |
Character(100) |
VARCHAR2(100) NOT NULL |
Store IoT Asset Geolocation (Lat, Long)
|
| 9 |
AM_IOT_INCDNT_TIME |
Character(30) |
VARCHAR2(30) NOT NULL |
Stores IoT Incident incidentTimeAsString
|
| 10 |
AM_IOT_ORG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Stores IoT Org ID
|
| 11 |
AM_IOT_INCIDNT_URL |
Long Character(2000) |
VARCHAR2(2000) |
Stores IoT Incident URL
|
| 12 |
AM_IOT_INCDN_CRTBY |
Character(30) |
VARCHAR2(30) NOT NULL |
Stores IoT Incident Created By
|
| 13 |
AM_IOT_INCD_CRTIME |
Character(30) |
VARCHAR2(30) NOT NULL |
Stores IoT Incident createdTimeAsString
|
| 14 |
AM_IOT_INCD_LMODBY |
Character(30) |
VARCHAR2(30) NOT NULL |
Stores IoT Incident Last Modified By
|
| 15 |
AM_IOT_INCD_LMTIME |
Character(30) |
VARCHAR2(30) NOT NULL |
Stores IoT Incident lastModifiedTimeAsString
|
| 16 |
AM_LASTUPDT_DTTM |
DateTime(26) |
TIMESTAMP |
Last Updated On
|
| 17 |
AM_LASTUPDT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Updated By
|