RS_ASSETPROP_VW

(SQL View)

SELECT A.PROPERTY_ID ,A.PROPERTY_NM , A.SITE_PROPERTY_ID , A.BLDG_PROPERTY_ID , A.FLOOR_PROPERTY_ID , A.AREA_PROPERTY_ID , A.SPACE_PROPERTY_ID FROM %Table(ASSET_PROPERTY) A

# 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 SITE_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Site ID
Prompt Table: ASSET_SITE

4 BLDG_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Building ID
Prompt Table: ASSET_BLDG

5 FLOOR_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Floor ID
Prompt Table: ASSET_FLOOR

6 AREA_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Area ID
Prompt Table: ASSET_AREA

7 SPACE_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Space ID
Prompt Table: ASSET_SPACE

#	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	SITE_PROPERTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Site ID Prompt Table: ASSET_SITE
4	BLDG_PROPERTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Building ID Prompt Table: ASSET_BLDG
5	FLOOR_PROPERTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Floor ID Prompt Table: ASSET_FLOOR
6	AREA_PROPERTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Area ID Prompt Table: ASSET_AREA
7	SPACE_PROPERTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Space ID Prompt Table: ASSET_SPACE