| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 AM_IOT_ASSET_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Store IoT Asset ID
|
| 2 |
AM_IOT_ASSET_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Store IoT Asset Name
|
| 3 |
AM_IOT_ASSET_TYPE |
Character(100) |
VARCHAR2(100) NOT NULL |
Store IoT Asset Type
|
| 4 |
ASSET_DESCR |
Character(254) |
VARCHAR2(254) NOT NULL |
Asset Description
|
| 5 |
AM_IOT_ASSGN_PLACE |
Character(100) |
VARCHAR2(100) NOT NULL |
Store IoT Assigned Place
|
| 6 |
AM_IOT_ASSETGEOLOC |
Character(100) |
VARCHAR2(100) NOT NULL |
Store IoT Asset Geolocation (Lat, Long)
|
| 7 |
AM_IOT_EAMID |
Character(50) |
VARCHAR2(50) NOT NULL |
Store IoT EAM ID
External Asset ID
|
| 8 |
AM_IOT_ORG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Stores IoT Org ID
|
| 9 |
AM_IOT_ASSET_URL |
Long Character(2000) |
VARCHAR2(2000) |
Store IoT Asset URL
Self-linking
|
| 10 |
AM_LASTUPDT_DTTM |
DateTime(26) |
TIMESTAMP |
Last Updated On
|
| 11 |
AM_LASTUPDT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Updated By
|