GPFR_AF_SQLENTY

(SQL Table)
 Index Back

SQL Entity Definition

Application Framework - This record is used to define SQL entity for specific country and application

  • Related Language Record: GPFR_AF_SQL_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
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 GPFR_AF_SQL_TYPE Character(1) VARCHAR2(1) NOT NULL Application Framework - SQL Type
    1=Insert
    2=Update
    3=Delete
    6 GPFR_AF_OUPUT_REC Character(20) VARCHAR2(20) NOT NULL Application Framework - Output Record

    Prompt Table: GPFR_AF_OREC_VW

    7 GPFR_AF_INPUT_REC Character(20) VARCHAR2(20) NOT NULL Application Framework - Primary Input Rec

    Prompt Table: PSRECDEFN

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

    Prompt Table: PSRECDEFN

    9 GPFR_AF_TEMPLT_OVR Character(1) VARCHAR2(1) NOT NULL Application Framework - Override Template

    Y/N Table Edit

    Default Value: N

    10 GPFR_AF_SQL_TEMPLT Long Character CLOB Application Framework - SQL Template
    11 GPFR_AF_OWNER Character(1) VARCHAR2(1) NOT NULL Application Framework - Object Owner
    C=Customer Maintained
    P=Peoplesoft Maintained