ASSET_AREA_P (SQL View)	Index Back
View Parent Property of Areas PARENT_PROPERTY_ID field has a Dynamic prompt on the ASSET_PROPERTY page. This is a view of all Asset Properties that are Floors. Prompt is used when Area Property Class is selected. Areas have Floors as its parent.

ASSET_AREA_P

(SQL View)

View Parent Property of Areas

PARENT_PROPERTY_ID field has a Dynamic prompt on the ASSET_PROPERTY page. This is a view of all Asset Properties that are Floors. Prompt is used when Area Property Class is selected. Areas have Floors as its parent.

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

# 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