IT_BU_ASSET_VW (SQL View)	Index Back
IT - View of all Assets by BU Used in ITAM Common Search setup for multiple pages. Used as the Prompt view listing all distinct Business Units and Asset Ids.

IT_BU_ASSET_VW

(SQL View)

IT - View of all Assets by BU

Used in ITAM Common Search setup for multiple pages. Used as the Prompt view listing all distinct Business Units and Asset Ids.

SELECT DISTINCT BUSINESS_UNIT , ASSET_ID , TAG_NUMBER , DESCR FROM PS_ASSET

Related Language Record: IT_BU_ASSET_LNG

# 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 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	TAG_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Tag Number
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description