RE_PROP_BLDG_NM (SQL View)	Index Back
Building Names

RE_PROP_BLDG_NM

(SQL View)

Building Names

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

Related Language Record: RE_PROPERTY_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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