GPFR_AF_ENTSRCH

(SQL View)
 Index Back

Search record for SQL entity

Application Framework - This view is used as a search record for SQL entity component

SELECT COUNTRY , GPFR_AF_APPL , GPFR_AF_SQL_ENTITY , DESCR , GPFR_AF_INPUT_REC , GPFR_AF_SECIN_REC , GPFR_AF_OUPUT_REC FROM PS_GPFR_AF_SQLENTY

  • Related Language Record: GPFR_AF_ESR_LNG

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: GPFR_AF_APPL

    3 GPFR_AF_SQL_ENTITY Character(16) VARCHAR2(16) NOT NULL Application Framework - SQL Entity

    Prompt Table: GPFR_AF_SQLENTY

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 GPFR_AF_INPUT_REC Character(20) VARCHAR2(20) NOT NULL Application Framework - Primary Input Rec

    Prompt Table: PSRECDEFN

    6 GPFR_AF_SECIN_REC Character(20) VARCHAR2(20) NOT NULL Application Framework - Secondary Input Record

    Prompt Table: PSRECDEFN

    7 GPFR_AF_OUPUT_REC Character(20) VARCHAR2(20) NOT NULL Application Framework - Output Record

    Prompt Table: PSRECDEFN