EODP_IBSVC_XLVW

(SQL View)
 Index Back

IB References download View

Data Privacy Framework: IB Reference download view

SELECT A.IB_SERVICENAME ,B.DESCR ,A.IB_OPERATIONNAME ,C.DESCR ,A.DEFAULTVER ,X.XLATLONGNAME ,D.RECNAME ,E.RECDESCR ,F.FIELDNAME ,G.LONGNAME ,CTG.EODP_CTGRY_DESC ,CLS.EODP_CFCN_NAME ,A.EODP_PERS_IDFR ,A.EODP_SNSTV ,H.EODP_OBJ_DESCR , D.MSGNAME ,D.IB_MSGVERSION ,D.PARAMETERNAME ,D.QUEUENAME ,IG.IB_INTGROUPNAME ,IG.DESCR FROM (PS_EODP_IBREFHDRVW A LEFT OUTER JOIN PS_EODP_INTGRP_VW2 IG ON A.IB_SERVICENAME=IG.IB_SERVICENAME) ,PSSERVICE B ,PSOPERATION C ,PS_EODP_IBMSG_REF D ,PSRECDEFN E ,PS_EODP_MSGRECFLD F ,PSDBFLDLABL G , PS_EODP_PROD_VW H ,PS_EODP_IBSVC_REF I , PS_EODP_CTGRY_CODE CTG , PS_EODP_CLSFCN CLS ,PSXLATITEM X WHERE A.IB_SERVICENAME=B.IB_SERVICENAME AND A.IB_OPERATIONNAME=C.IB_OPERATIONNAME AND D.IB_OPERATIONNAME=A.IB_OPERATIONNAME AND D.VERSIONNAME=A.DEFAULTVER AND D.IB_OPERATIONNAME=C.IB_OPERATIONNAME AND D.RECNAME=E.RECNAME AND D.FIELDNAME=F.FIELDNAME AND D.RECNAME=F.RECNAME AND F.MSGNAME=D.MSGNAME AND A.RECNAME=F.RECNAME AND A.FIELDNAME=F.FIELDNAME AND D.IB_MSGVERSION=F.APMSGVER AND G.FIELDNAME=F.FIELDNAME AND G.DEFAULT_LABEL=1 AND CTG.EODP_CTGRY_CD=A.EODP_CTGRY_CD AND CLS.EODP_CLFNCD=A.EODP_CLFNCD AND B.OBJECTOWNERID=H.EODP_PRODUCT_CD AND A.IB_OPERATIONNAME=I.IB_OPERATIONNAME AND A.DEFAULTVER=I.DEFAULTVER AND A.IB_SERVICENAME=I.IB_SERVICENAME AND X.FIELDNAME='RTNGTYPE' AND X.FIELDVALUE=I.RTNGTYPE AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn)

  • Related Language Record: EODP_IBSVCXLLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service Name (see PSSERVICE).
    2 IB_WSIL_SVC_DESCR Character(254) VARCHAR2(254) NOT NULL Service Description
    3 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
    4 EODP_SO_DESCR Character(30) VARCHAR2(30) NOT NULL Data Privacy Framework: Service Operation Description
    5 DEFAULTVER Character(30) VARCHAR2(30) NOT NULL Default Application Message Version
    6 EODP_RTNG_TYPE Character(30) VARCHAR2(30) NOT NULL Data Privacy Framework: Routing Type
    7 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    8 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    10 FIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label
    11 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category
    12 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification
    13 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
    A=All
    N=No
    Y=Yes
    14 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
    A=All
    N=No
    Y=Yes
    15 EODP_OBJ_DESCR Character(30) VARCHAR2(30) NOT NULL Product
    16 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
    17 IB_MSGVERSION Character(30) VARCHAR2(30) NOT NULL Message Version
    18 PARAMETERNAME Character(15) VARCHAR2(15) NOT NULL Parameter Name
    19 QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
    20 IB_INTGROUPNAME Character(30) VARCHAR2(30) NOT NULL Integration Group Name (see PSIBGROUPDEFN).
    21 EODP_INTGRP_DESCR Character(30) VARCHAR2(30) NOT NULL Data Privacy Framework: Service Operation Description