CFG_SCHEMA_LANV

(SQL View)
 Index Back

Configurator

This view is created for oracle configurator integration. I has a field CZ whihc uses the case statement from sql query.

SELECT A.CFG_SCHEMA_ID , B.LANGUAGE_CD , B.DESCR FROM PS_CFG_SCHEMA_TBL A , PS_CFG_SCHEMA_LANG B WHERE A.CZ = ( SELECT CASE WHEN CZ = 'Y' THEN 'Y' ELSE 'N' END FROM PS_INSTALLATION) AND A.CFG_SCHEMA_ID = B.CFG_SCHEMA_ID

  • Related Language Record for CFG_SCHEMA_VIEW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CFG_SCHEMA_ID Character(18) VARCHAR2(18) NOT NULL Schema ID displayed on several pages of Configurator
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description