AM_IOT_PLACE_IDAM_IOT_PLACES(SQL Table) |
Index Back |
|---|---|
Store IoT AM App PlacesThis record stores all the places defined in IoT CS AM App |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AM_IOT_PLACE_ID |
Character(50) | VARCHAR2(50) NOT NULL | Store IoT Place ID |
| 2 | AM_IOT_PLACE_NAME | Character(100) | VARCHAR2(100) NOT NULL | Stores IoT Place Name |
| 3 | AM_IOT_PLACE_TYPE | Character(50) | VARCHAR2(50) NOT NULL | Stores IoT Place Type |
| 4 | AM_IOT_PLACE_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Stores IoT Place Description |
| 5 | AM_IOT_ORG_ID | Character(50) | VARCHAR2(50) NOT NULL | Stores IoT Org ID |
| 6 | AM_IOT_PLACE_URL | Long Character(2000) | VARCHAR2(2000) | Stores IoT Place Self Link |
| 7 | AM_LASTUPDT_DTTM | DateTime(26) | TIMESTAMP | Last Updated On |
| 8 | AM_LASTUPDT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated By |