WM_PROPERTY_VW

(SQL View)
 Index Back

Asset Properties

Properties in the Asset Repository. Used for edit prompting.

SELECT X.PROPERTY_ID , X.PROPERTY_NM , X.SITE_PROPERTY_ID , S.PROPERTY_DESCR , X.BLDG_PROPERTY_ID , B.PROPERTY_DESCR , X.FLOOR_PROPERTY_ID , F.PROPERTY_DESCR , W.LOCATION , W.COUNTRY , W.STATE , W.CITY , X.PROPERTY_DESCR FROM PS_ASSET_SITE S , PS_ASSET_BLDG B , PS_ASSET_FLOOR F , PS_RE_ACTIVE_PPTY X LEFT OUTER JOIN PS_RE_UNLEASE_LOC W ON X.BUSINESS_UNIT = W.BUSINESS_UNIT_AM AND X.ASSET_ID = W.ASSET_ID WHERE X.PROPERTY_CLASS = '50' AND S.BUSINESS_UNIT = X.BUSINESS_UNIT AND S.PROPERTY_ID = X.SITE_PROPERTY_ID AND B.BUSINESS_UNIT = X.BUSINESS_UNIT AND B.SITE_PROPERTY_ID = X.SITE_PROPERTY_ID AND B.PROPERTY_ID = X.BLDG_PROPERTY_ID AND F.BUSINESS_UNIT = X.BUSINESS_UNIT AND F.BLDG_PROPERTY_ID = X.BLDG_PROPERTY_ID AND F.PROPERTY_ID = X.FLOOR_PROPERTY_ID

  • Related Language Record: WM_PROPERTY_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Property ID
    2 PROPERTY_NM Character(50) VARCHAR2(50) NOT NULL Used to store an Asset Property Name
    3 SITE_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Site ID

    Prompt Table: ASSET_SITE

    4 SITE_DESCR Character(50) VARCHAR2(50) NOT NULL Site Description
    5 BLDG_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Building ID

    Prompt Table: ASSET_BLDG

    6 BLDG_DESCR Character(50) VARCHAR2(50) NOT NULL Building Description
    7 FLOOR_PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Floor ID

    Prompt Table: ASSET_FLOOR

    8 FLOOR_DESCR Character(50) VARCHAR2(50) NOT NULL Floor Description
    9 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    11 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    12 CITY Character(30) VARCHAR2(30) NOT NULL City
    13 PROPERTY_DESCR Character(50) VARCHAR2(50) NOT NULL Property Description