RE_LS_BU_PPTY

(SQL View)
 Index Back

Asset Properties

Properties in the Asset Repository

SELECT P.BUSINESS_UNIT , Z.LS_KEY , P.ASSET_ID , %subrec(AM_PROPERTY_SBR, P) FROM PS_ASSET_PROPERTY P , PS_ASSET A , PS_RE_LS_PPTY Z WHERE P.BUSINESS_UNIT = A.BUSINESS_UNIT AND P.ASSET_ID = A.ASSET_ID AND P.PROPERTY_ID = Z.PROPERTY_ID AND A.ASSET_STATUS = 'I'

  • Related Language Record: RE_LSBU_PTY_LNG

    • # 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 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
    3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Prompt Table: ASSET

    4 PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Property ID
    5 PROPERTY_DESCR Character(50) VARCHAR2(50) NOT NULL Property Description
    6 PROPERTY_NM Character(50) VARCHAR2(50) NOT NULL Used to store an Asset Property Name
    7 PROPERTY_CLASS Character(2) VARCHAR2(2) NOT NULL Property Class
    10=Site
    20=Building
    30=Floor
    40=Area
    50=Space
    8 PROPERTY_SUBCLASS Character(20) VARCHAR2(20) NOT NULL Property Subclass
    010=Warehouse

    Prompt Table: AM_PROP_SUBC

    9 PARENT_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Parent Property ID

    Prompt Table: %EDITTABLE

    10 SITE_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Site ID

    Prompt Table: ASSET_SITE

    11 BLDG_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Building ID

    Prompt Table: ASSET_BLDG

    12 FLOOR_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Floor ID

    Prompt Table: ASSET_FLOOR

    13 AREA_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Area ID

    Prompt Table: ASSET_AREA

    14 SPACE_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Space ID

    Prompt Table: ASSET_SPACE

    15 PARCEL_NUMBER Character(30) VARCHAR2(30) NOT NULL Parcel Number
    16 LOT Character(20) VARCHAR2(20) NOT NULL Lot Number
    17 BLOCK Character(20) VARCHAR2(20) NOT NULL Block Number
    18 TOTAL_AREA Number(18,3) DECIMAL(17,3) NOT NULL Total Area
    19 SPACE_UOM Character(3) VARCHAR2(3) NOT NULL Space Unit of measure (Sq Feet or Sq Meters)

    Prompt Table: UNITS_TBL
    Set Control Field: UNIT_OF_MEASURE

    20 CURRENT_OCCUPANCY Number(7,0) INTEGER NOT NULL Current Occupancy
    21 MAX_OCCUPANCY Number(8,0) INTEGER NOT NULL Maximum Occupancy

    Default Value: 0

    22 OCCUPANCY_STATUS Character(2) VARCHAR2(2) NOT NULL Occupancy Status
    10=Occupied
    20=Vacant

    Default Value: 10

    23 OWNERSHIP_STATUS Character(2) VARCHAR2(2) NOT NULL Ownership Status
    10=Owned
    20=Leased

    Default Value: 10

    24 LEGAL_DESCR Long Character CLOB Legal Description