| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 AM_IOT_GROUP_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Store IoT Asset Group ID
|
| 2 |
AM_IOT_GROUP_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Store IoT Asset Group Name
|
| 3 |
AM_IOT_GROUP_DESCR |
Character(254) |
VARCHAR2(254) NOT NULL |
Stores IoT Asset Group Description
|
| 4 |
AM_IOT_GROUP_ASCNT |
Number(6,0) |
INTEGER NOT NULL |
Stores IoT Asset Group Asset Count
|
| 5 |
AM_IOT_ORG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Stores IoT Org ID
|
| 6 |
AM_IOT_PARENT_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Stores IoT Parent ID
|
| 7 |
AM_IOT_GROUP_URL |
Long Character(2000) |
VARCHAR2(2000) |
Stores IoT Asset Group URL
|
| 8 |
AM_LASTUPDT_DTTM |
DateTime(26) |
TIMESTAMP |
Last Updated On
|
| 9 |
AM_LASTUPDT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Updated By
|