RB_CRM_FEED_VW

(SQL View)
 Index Back

Feed List View

This view returns a list of RSS feeds for the administrator.

SELECT PTFP_DATATYPE_ID ,DESCR ,DESCRLONG FROM PSFP_DATATYPE WHERE NOT EXISTS ( SELECT 'X' FROM PSFP_FEED B WHERE B.PTFP_DATATYPE_ID = PSFP_DATATYPE.PTFP_DATATYPE_ID) AND ACTIVE_FLAG = 'A'

  • Related Language Record: RB_CRM_FEED_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTFP_DATATYPE_ID Character(30) VARCHAR2(30) NOT NULL Data Type (see PSFP_DATATYPE).
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRLONG Long Character CLOB Long Description