EODP_INTGRP_VW2

(SQL View)
 Index Back

Integration Group View

Data Privacy Framework: Integration Group View

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

  • Related Language Record: EODP_INTGRPLVW2

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description