AM_ASSET_IOT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AM_IOT_ASSETYPE | Character(30) | VARCHAR2(30) NOT NULL |
IoT Asset Type
Prompt Table: IOT_ASSETYP_DVW |
| 2 | AM_IOT_PLACE_NAME | Character(100) | VARCHAR2(100) NOT NULL |
Stores IoT Place Name
Prompt Table: IOT_PLACES_DVW |
| 3 | AM_IOT_ORG_ID | Character(50) | VARCHAR2(50) NOT NULL |
Stores IoT Org ID
Prompt Table: AM_IOT_ORG |
| 4 | AM_IOT_ORG_NAME | Character(100) | VARCHAR2(100) NOT NULL |
Stores IoT Org Name
Prompt Table: AM_IOT_ORG_VW |
| 5 | AM_IOT_ASSET_NAME | Character(50) | VARCHAR2(50) NOT NULL | Store IoT Asset Name |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | IOT_ASSET | Character(1) | VARCHAR2(1) NOT NULL |
IoT Asset
N=No Y=YES Default Value: N |
| 9 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
| 10 | ASSET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Asset Status
A=Received (Not in Service) B=Budgeted C=Commitment D=Disposed I=In Service M=Suspended R=Requisitioned T=Transferred W=Work In Progress |
| 11 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 12 | AM_IOT_ASSET_URL | Long Character(2000) | VARCHAR2(2000) | Store IoT Asset URL Self-linking |