SCC_ENT_VW_SRCH

(SQL View)
 Index Back

Entity View Search

Entity View Search

SELECT A.SCC_ENT_VIEW_ID , A.SCC_ENT_VIEW_NAME , B.SCC_ENTITY_NAME FROM PS_SCC_ENTITY_VIEW A , PS_SCC_ENTITY_REG B WHERE A.SCC_ENTITY_ID=B.SCC_ENTITY_ID

  • Related Language Record: SCC_ENT_VWS_LNG

    • # 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_VIEW_NAME Character(40) VARCHAR2(40) NOT NULL Entity View Name
    3 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name