ASSET_SPACE_P (SQL View)	Index Back
View Property Parent of Spaces PARENT_PROPERTY_ID field has a Dynamic prompt on the ASSET_PROPERTY page. This is a view of all Asset Properties that could be a parent asset of a Space Property Class. This includes both Floors and Areas.

ASSET_SPACE_P

(SQL View)

View Property Parent of Spaces

PARENT_PROPERTY_ID field has a Dynamic prompt on the ASSET_PROPERTY page. This is a view of all Asset Properties that could be a parent asset of a Space Property Class. This includes both Floors and Areas.

SELECT BUSINESS_UNIT , PROPERTY_ID , PROPERTY_DESCR , PROPERTY_NM FROM PS_ASSET_PROPERTY WHERE PROPERTY_CLASS IN ('30', '40')

# 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