AM_HGRID_PARENT(SQL View) |
Index Back |
|---|---|
Hgrid Parent View |
| SELECT DISTINCT P.BUSINESS_UNIT , P.ASSET_ID , P.COMPONENT_OF_ID FROM PS_AM_HGRID P , PS_AM_HGRID C WHERE P.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.COMPONENT_OF_ID = P.ASSET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | COMPONENT_OF_ID | Character(12) | VARCHAR2(12) NOT NULL | Component of Asset |