ASSET_PROPERTY(SQL Table) |
Index Back |
|---|---|
Asset PropertiesProperties in the Asset Repository |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table: ASSET |
| 3 | PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL | Property ID |
| 4 | PROPERTY_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Property Description |
| 5 | PROPERTY_NM | Character(50) | VARCHAR2(50) NOT NULL | Used to store an Asset Property Name |
| 6 | PROPERTY_CLASS | Character(2) | VARCHAR2(2) NOT NULL |
Property Class
10=Site 20=Building 30=Floor 40=Area 50=Space |
| 7 | PROPERTY_SUBCLASS | Character(20) | VARCHAR2(20) NOT NULL |
Property Subclass
010=Warehouse Prompt Table: AM_PROP_SUBC |
| 8 | PARENT_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Parent Property ID
Prompt Table: %EDITTABLE |
| 9 | SITE_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Site ID
Prompt Table: ASSET_SITE |
| 10 | BLDG_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Building ID
Prompt Table: ASSET_BLDG |
| 11 | FLOOR_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Floor ID
Prompt Table: ASSET_FLOOR |
| 12 | AREA_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Area ID
Prompt Table: ASSET_AREA |
| 13 | SPACE_PROPERTY_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Space ID
Prompt Table: ASSET_SPACE |
| 14 | PARCEL_NUMBER | Character(30) | VARCHAR2(30) NOT NULL | Parcel Number |
| 15 | LOT | Character(20) | VARCHAR2(20) NOT NULL | Lot Number |
| 16 | BLOCK | Character(20) | VARCHAR2(20) NOT NULL | Block Number |
| 17 | TOTAL_AREA | Number(18,3) | DECIMAL(17,3) NOT NULL | Total Area |
| 18 | SPACE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Space Unit of measure (Sq Feet or Sq Meters)
Prompt Table:
UNITS_TBL
|
| 19 | CURRENT_OCCUPANCY | Number(7,0) | INTEGER NOT NULL | Current Occupancy |
| 20 | MAX_OCCUPANCY | Number(8,0) | INTEGER NOT NULL |
Maximum Occupancy
Default Value: 0 |
| 21 | OCCUPANCY_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Occupancy Status
10=Occupied 20=Vacant Default Value: 10 |
| 22 | OWNERSHIP_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Ownership Status
10=Owned 20=Leased Default Value: 10 |
| 23 | LEGAL_DESCR | Long Character | CLOB | Legal Description |
| 24 | IS_LEASED | Number(1,0) | SMALLINT NOT NULL |
Indicator that the property is on a lease in RE Lease Admin application.
Default Value: 0 |