PROFILEIU_LN_VW

(SQL View)
Index Back

Asset Profile InterUnit View


SELECT %Substring(b.setcntrlvalue,1,5) , a.profile_id , C.LANGUAGE_CD , C.descr FROM PS_PROFILE_TBL a , ps_set_cntrl_rec b , PS_PROFILE_LANG C WHERE a.setid = b.setid AND b.recname = 'PROFILE_TBL' AND a.setid = C.setid AND A.PROFILE_ID = C.PROFILE_ID

  • Related Language Record for PROFILE_IU_VW RE_PROFILE_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description