PC_ASSET_ID_VW

(SQL View)
 Index Back

Asset info from Asset Table

Subset of Asset information found in the Asset Management system. Used for prompting purposes in Projects.

SELECT BUSINESS_UNIT , ASSET_ID , DESCR FROM PS_ASSET WHERE GROUP_ASSET_FLAG <> 'G' AND ASSET_TYPE <> '200'

  • Related Language Record: PC_ASTID_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description