GPFR_AD_NDSN_VW

(SQL View)
 Index Back

ADS Entry - Data Set Nodes

Application Framework ADS Entry - This record is used to retrieve a list of Data Set Node rows when searching for rows to be included in an ADS package. It also enhance the search of rows providing prompt tables for the search fields.

SELECT NS.COUNTRY ,NS.GPFR_AF_APPL ,NS.GPFR_AF_NODE_SET ,NS.GPFR_AF_KEY_NODE ,NO.GPFR_AF_NODE_NAME ,NO.DESCR100 ,NS.GPFR_AF_VERSION ,NS.LAST_UPDT_DTTM ,NS.LAST_UPDT_OPRID FROM PS_GPFR_AF_NDSET_N NS , PS_GPFR_AF_NODE NO WHERE NS.COUNTRY = NO.COUNTRY AND NS.GPFR_AF_APPL = NO.GPFR_AF_APPL AND NS.GPFR_AF_KEY_NODE = NO.GPFR_AF_KEY_NODE

  • Related Language Record: GPFR_ADNDSN_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: GPFR_CNTRCT_VW

    2 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application

    Prompt Table: GPFR_AF_APPL_VW

    3 GPFR_AF_NODE_SET Character(16) VARCHAR2(16) NOT NULL Application Framework - Node Set

    Prompt Table: GPFR_AF_NODSET

    4 GPFR_AF_KEY_NODE Number(8,0) INTEGER NOT NULL Application Framework - Key Node

    Prompt Table: GPFR_AF_NODE

    5 GPFR_AF_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Application Framework - Node Name

    Prompt Table: GPFR_AF_NODE

    6 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    7 GPFR_AF_VERSION Character(18) VARCHAR2(18) NOT NULL Application Framework object version.

    Prompt Table: GPFR_AF_NSNV_VW

    8 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp
    9 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name