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 |