BULK_ASSET_SRCH(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 2 | FROM_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | From Asset ID |
| 3 | TO_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | To Asset ID |
| 4 | RETRIEVE_PB | Character(1) | VARCHAR2(1) NOT NULL | Retrieve Items |
| 5 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Asset Category
Prompt Table: CATEGORY_TBL |
| 6 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table: PROFILE_TBL |
| 7 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 8 | AREA_ID | Character(10) | VARCHAR2(10) NOT NULL |
Area ID
Prompt Table: AM_AREA_TBL |
| 9 | 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 |
| 10 | 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 |
| 11 | ASSET_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL |
Asset Subtype
Prompt Table: AM_SUBTYPE |
| 12 | ASSET_SEARCH | Character(1) | VARCHAR2(1) NOT NULL | Asset Search Criteria |
| 13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |