SCC_ENT_PRFL_VW

(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.SCC_ENT_PRFL_NAME FROM PS_SCC_ENT_VW_PRFL A , PS_SCC_ENTITY_PRFL B WHERE A.SCC_ENT_PRFL_ID=B.SCC_ENT_PRFL_ID

  • Related Language Record: SCC_ENT_P_VW_LN

    • # 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 SCC_ENT_PRFL_NAME Character(30) VARCHAR2(30) NOT NULL Entity Profile Name