AM_IOT_ORG_IDAM_IOT_ORG(SQL Table) |
Index Back |
|---|---|
Store IoT OrganisationThis record stores all the Org related data defined in IoT CS AM App |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AM_IOT_ORG_ID |
Character(50) | VARCHAR2(50) NOT NULL | Stores IoT Org ID |
| 2 | AM_IOT_ORG_NAME | Character(100) | VARCHAR2(100) NOT NULL | Stores IoT Org Name |
| 3 | AM_IOT_ORG_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Stores IoT Org Description |
| 4 | AM_IOT_ORG_URL | Long Character(2000) | VARCHAR2(2000) | Stores IoT Org URL |
| 5 | AM_LASTUPDT_DTTM | DateTime(26) | TIMESTAMP | Last Updated On |
| 6 | AM_LASTUPDT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated By |