PeopleSoft 9
Asset Management

Table Name ASSET_PROPERTY

Table Description
ASSET_PROPERTY
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT char(5) Yes Yes
ASSET_ID char(12) Yes Yes
PROPERTY_ID decimal(10) No No
PROPERTY_DESCR char(50) No No
PROPERTY_NM char(50) No No
PROPERTY_CLASS char(2) No Yes
PROPERTY_SUBCLASS CHAR(20) No No
PARENT_PROPERTY_ID decimal(10) No No
SITE_PROPERTY_ID decimal(10) No No
BLDG_PROPERTY_ID decimal(10) No No
FLOOR_PROPERTY_ID decimal(10) No No
AREA_PROPERTY_ID decimal(10) No No
SPACE_PROPERTY_ID decimal(10) No No
PARCEL_NUMBER char(30) No No
LOT char(20) No No
BLOCK char(20) No No
TOTAL_AREA decimal(17,3) No No
SPACE_UOM char(1) No No
CURRENT_OCCUPANCY int No No
MAX_OCCUPANCY int No No
OCCUPANCY_STATUS char(2) No No
OWNERSHIP_STATUS char(2) No No
IS_LEASED smallint No No
LEGAL_DESCR TEXT No No
Index
Name Type Unique Member
PS_ASSET_PROPERTY PK Yes
PS0ASSET_PROPERTY IE1 No
PSAASSET_PROPERTY IE2 No
Member(s) of "PS_ASSET_PROPERTY" Index
BUSINESS_UNIT
ASSET_ID
Member(s) of "PS0ASSET_PROPERTY" Index
PROPERTY_ID
BUSINESS_UNIT
ASSET_ID
Member(s) of "PSAASSET_PROPERTY" Index
PARENT_PROPERTY_ID
BUSINESS_UNIT

Published December 16, 2006