PROFILE_INT_VW

(SQL View)
 Index Back

Asset Profile Prompt View


SELECT %Substring(b.setcntrlvalue,1,5) , a.profile_id , a.descr , a.financial_asset_sw FROM ps_profile_tbl a , ps_set_cntrl_rec b WHERE a.setid = b.setid AND b.recname = 'PROFILE_TBL' AND(a.financial_asset_sw = 'N' OR (a.financial_asset_sw = 'Y' AND EXISTS( SELECT 'X' FROM PS_PROFILE_DET_TBL C WHERE A.PROFILE_ID = C.PROFILE_ID AND A.SETID = C.SETID AND C.EFFDT <= %CurrentDateIn ))) AND PROFILE_ACTIVE_SW <> 'N'

  • Related Language Record: PROFILE_IN_VWLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    2 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
    N=Non Cap
    Y=Capitalize

    Y/N Table Edit

    Default Value: Y