AM_IOT_ORG_NAMEAM_IOT_ORG_VW(SQL View) |
Index Back |
|---|---|
Store IoT OrganisationThis record stores all the Org related data defined in IoT CS AM App |
| SELECT AM_IOT_ORG_ID ,AM_IOT_ORG_NAME ,AM_IOT_ORG_DESCR ,AM_IOT_ORG_URL ,AM_LASTUPDT_DTTM ,AM_LASTUPDT_OPRID FROM PS_AM_IOT_ORG |
| # | 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 |