PROFILE_IU_VW

(SQL View)
 Index Back

Asset Profile InterUnit View


SELECT %Substring(b.setcntrlvalue,1,5) , a.profile_id , a.descr FROM PS_PROFILE_TBL a , ps_set_cntrl_rec b WHERE a.setid = b.setid AND b.recname = 'PROFILE_TBL' AND a.PROFILE_ACTIVE_SW <> 'N'

  • Related Language Record: PROFILEIU_LN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 NEW_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL New Business Unit
    2 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description