AM_IOT_ASSETYPE_IDAM_IOT_ASSETYPE(SQL Table) |
Index Back |
|---|---|
Store IoT Asset TypesThis record stores IoT Asset Types |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AM_IOT_ASSETYPE_ID |
Character(50) | VARCHAR2(50) NOT NULL | Stores IoT Asset Type ID |
| 2 | AM_IOT_ASSET_TYPE | Character(100) | VARCHAR2(100) NOT NULL | Store IoT Asset Type |
| 3 | AM_IOT_ASSETYP_DSC | Character(254) | VARCHAR2(254) NOT NULL | Stores IoT Asset Type Description |
| 4 | AM_IOT_ORG_ID | Character(50) | VARCHAR2(50) NOT NULL | Stores IoT Org ID |
| 5 | AM_IOT_ASSETYP_URL | Long Character(2000) | VARCHAR2(2000) | Stores IoT Asset Type Self Link |
| 6 | AM_LASTUPDT_DTTM | DateTime(26) | TIMESTAMP | Last Updated On |
| 7 | AM_LASTUPDT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated By |