SCC_ENTITY_VW_L

(SQL View)
 Index Back

Entity View View

View Relating Entity View with the parent Entity ID for the Entity Registry Component.

SELECT A.SCC_ENTITY_ID , A.SCC_ENT_VIEW_ID , B.LANGUAGE_CD , A.SCC_ENT_VIEW_NAME , A.SCC_ENTITY_DESCR FROM PS_SCC_ENTITY_VIEW A , PS_SCC_ENT_VW_LNG B WHERE A.SCC_ENT_VIEW_ID=B.SCC_ENT_VIEW_ID

  • Related Language Record for SCC_ENTITY_VW_V

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID

    Prompt Table: SCC_ENTITY_PT

    2 SCC_ENT_VIEW_ID Character(40) VARCHAR2(40) NOT NULL Entity View ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SCC_ENT_VIEW_NAME Character(40) VARCHAR2(40) NOT NULL Entity View Name
    5 SCC_ENTITY_DESCR Character(254) VARCHAR2(254) NOT NULL Entitiy Description