GPFR_AF_ETDN_VW

(SQL View)
 Index Back

SQL and DON Relationship

Application Framework - This view is used in SQL and DON relationship component

SELECT A.COUNTRY , A.GPFR_AF_APPL , A.GPFR_AF_SQL_ENTITY , A.GPFR_AF_DON , A.GPFR_AF_SQL_SEQ , B.DESCR FROM PS_GPFR_AF_DON_SQL A , PS_GPFR_AF_DON_REC B WHERE A.COUNTRY = B.COUNTRY AND A.GPFR_AF_APPL = B.GPFR_AF_APPL AND A.GPFR_AF_DON = B.GPFR_AF_DON

  • Related Language Record: GPFR_AF_ETD_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application
    3 GPFR_AF_SQL_ENTITY Character(16) VARCHAR2(16) NOT NULL Application Framework - SQL Entity
    4 GPFR_AF_DON Character(16) VARCHAR2(16) NOT NULL Application Framework - Data Object Name
    5 GPFR_AF_SQL_SEQ Number(8,0) INTEGER NOT NULL Application Framework - SQL Sequence
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description