SCC_ENT_PROPLVW

(SQL View)
Index Back

SELECT A.SCC_ENTITY_ID , A.SCC_PROP_NAME , L.LANGUAGE_CD , L.SCC_PROP_LABEL FROM PS_SCC_ENT_PROPS A , PS_SCC_ENT_PROP_LN L WHERE A.SCC_ENTITY_ID = L.SCC_ENTITY_ID AND A.SCC_PROP_NAME = L.SCC_PROP_NAME

  • Related Language Record for SCC_ENT_PROP_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
    2 SCC_PROP_NAME Character(50) VARCHAR2(50) NOT NULL Property Name
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SCC_PROP_LABEL Character(50) VARCHAR2(50) NOT NULL Label