EODP_INTGRPLVW2

(SQL View)
 Index Back

Integration Group View

Data Privacy Framework: Integration Group Lang View

SELECT DISTINCT A.IB_INTGROUPNAME ,A.IB_SERVICENAME ,B.LANGUAGE_CD ,COALESCE(%TrimSubstr(B.DESCR,1,30) ,%Substring(%SQL(EODP_CONVERT_TO_STRING,B.DESCRLONG,30),1,30) ) FROM PS_EODP_INTGRPVW1 A ,PSIBGROUPLANG B WHERE A.IB_INTGROUPNAME=B.IB_INTGROUPNAME

  • Related Language Record for EODP_INTGRP_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_INTGROUPNAME Character(30) VARCHAR2(30) NOT NULL Integration Group Name (see PSIBGROUPDEFN).
    2 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).

    Prompt Table: PSSERVICE

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description