DEPLOYED_BUDEPLOYED_ASSET_IDAM_DEPLOY_ASSET(SQL View) |
Index Back |
|---|---|
View of Deployed BU & Assets. |
| SELECT BUSINESS_UNIT , ASSET_ID , TAG_NUMBER FROM %Table(ASSET) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DEPLOYED_BU |
Character(5) | VARCHAR2(5) NOT NULL | Deployed Business Unit |
| 2 | DEPLOYED_ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Deployed Asset ID |
| 3 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |