WM_PROPERTY_LVW

(SQL View)
Index Back

Properties Related Language

Related language view for properties in the Asset Repository

SELECT PROPERTY_ID , LANGUAGE_CD , PROPERTY_NM , PROPERTY_DESCR FROM PS_ASSET_PROP_LG

  • Related Language Record for WM_PROPERTY_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Property ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 PROPERTY_NM Character(50) VARCHAR2(50) NOT NULL Used to store an Asset Property Name
    4 PROPERTY_DESCR Character(50) VARCHAR2(50) NOT NULL Property Description