SCC_ENT_P_VW_LN

(SQL View)
 Index Back

Entity Profile-View

Shows the relationship between an entity view and a profile.

SELECT A.SCC_ENT_VIEW_ID , A.SCC_ENT_PRFL_ID , B.LANGUAGE_CD , B.SCC_ENT_PRFL_NAME FROM PS_SCC_ENT_VW_PRFL A , PS_SCC_ENT_PRFL_LN B WHERE A.SCC_ENT_PRFL_ID=B.SCC_ENT_PRFL_ID

  • Related Language Record for SCC_ENT_PRFL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_ENT_VIEW_ID Character(40) VARCHAR2(40) NOT NULL Entity View ID
    2 SCC_ENT_PRFL_ID Character(40) VARCHAR2(40) NOT NULL Entity Profile ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SCC_ENT_PRFL_NAME Character(30) VARCHAR2(30) NOT NULL Entity Profile Name