ASSET_FLOOR_P (SQL View)	Index Back
View Parent Property of Floors PARENT_PROPERTY_ID field has a Dynamic prompt on the ASSET_PROPERTY page. This is a view of all Building Asset Properties. Buildings are parent assets of a Floor.

ASSET_FLOOR_P

(SQL View)

View Parent Property of Floors

PARENT_PROPERTY_ID field has a Dynamic prompt on the ASSET_PROPERTY page. This is a view of all Building Asset Properties. Buildings are parent assets of a Floor.

SELECT BUSINESS_UNIT , PROPERTY_ID , PROPERTY_DESCR , PROPERTY_NM FROM PS_ASSET_PROPERTY WHERE PROPERTY_CLASS = '20'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Property ID

3 PROPERTY_DESCR Character(50) VARCHAR2(50) NOT NULL Property Description

4 PROPERTY_NM Character(50) VARCHAR2(50) NOT NULL Used to store an Asset Property Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PROPERTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Property ID
3	PROPERTY_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Property Description
4	PROPERTY_NM	Character(50)	VARCHAR2(50) NOT NULL	Used to store an Asset Property Name