PC_AM_DFNEXP_VW

(SQL View)
 Index Back

PC AM Asset Defns for Express

View of subset of Project Asset information. Includes Asset ID, Description and Profile ID. Specifically used for prompting in the express asset pages since Definitions with an AM_Distrib_Status of 'I' are not allowed in the express functionality.

SELECT A.BUSINESS_UNIT_AM , A.ASSET_ID , A.DESCR , A.PROFILE_ID , A.DESCRSHORT FROM PS_PC_AM_DEFN A WHERE A.AM_DISTRIB_STATUS <> 'I' AND A.BOOK_PROCESSING_SW <> 'Y'

  • Related Language Record: PC_AM_DEFN_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_AM_NONVW

    2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Default Value: NEXT

    Prompt Table: PC_ASSET_ID_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description