PROPERTY_ID10=Site
20=Building
30=Floor
40=Area
50=Space
PROPERTY_PARENT(SQL View) |
Index Back |
|---|---|
AM - Property Asset ParentUsed as prompt table for ASSET_PROPERTY.Parent_Propertry |
| SELECT PROPERTY_ID , PROPERTY_CLASS , PROPERTY_DESCR , PROPERTY_NM FROM PS_ASSET_PROPERTY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROPERTY_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Property ID |
| 2 | PROPERTY_CLASS | Character(2) | VARCHAR2(2) NOT NULL |
Property Class
10=Site 20=Building 30=Floor 40=Area 50=Space |
| 3 | PROPERTY_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Property Description |
| 4 | PROPERTY_NM | Character(50) | VARCHAR2(50) NOT NULL | Used to store an Asset Property Name |