RE_COMP_VW(SQL View) |
Index Back |
|---|---|
Component Of ViewMaintain Property Occupants |
| SELECT ASSET_ID ,COMPONENT_OF_ID ,TAG_NUMBER ,SERIAL_ID ,DESCR ,ASSET_TYPE ,ASSET_SUBTYPE ,ASSET_STATUS ,HAZARDOUS_SW ,IN_PHY_USE FROM PS_ASSET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 2 | COMPONENT_OF_ID | Character(12) | VARCHAR2(12) NOT NULL | Component of Asset |
| 3 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
| 4 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | ASSET_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Asset Type
010=IT Hardware 020=IT Software 040=Equipment 050=Property 060=Fleet 070=Machinery 080=Furniture 090=Facility 100=Intangible 200=Asset Retirement Obligations 999=Other |
| 7 | ASSET_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL | Asset Subtype |
| 8 | 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 |
| 9 | HAZARDOUS_SW | Character(1) | VARCHAR2(1) NOT NULL | Hazardous Asset |
| 10 | IN_PHY_USE | Character(1) | VARCHAR2(1) NOT NULL | Describes if entity is in physical use. |