GPFR_AD_NODE_VW

(SQL View)
 Index Back

ADS Entry - Nodes

Application Framework ADS Entry - This record is used to retrieve a list of 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 COUNTRY ,GPFR_AF_APPL ,GPFR_AF_KEY_NODE ,GPFR_AF_NODE_NAME ,DESCR100 ,GPFR_AF_VERSION ,LAST_UPDT_DTTM ,LAST_UPDT_OPRID FROM PS_GPFR_AF_NODE

  • Related Language Record: GPFR_ADNODE_LVW

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

    Prompt Table: GPFR_AF_CNTY_VW

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

    Prompt Table: GPFR_AF_APPL_VW

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

    Prompt Table: GPFR_AF_NODE

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

    Prompt Table: GPFR_AF_NODE

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

    Prompt Table: GPFR_AF_NODV_VW

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