GPFR_AF_ATPR_VW

(SQL View)
Index Back

Attribute Prompt View

Application Framework - View returns Key Attributes for a particular country, application and node

SELECT A.COUNTRY ,A.GPFR_AF_APPL ,A.GPFR_AF_KEY_NODE ,A.GPFR_AF_KEY_ATTR ,A.GPFR_AF_ATTR_NAME ,A.DESCR60 ,A.GPFR_AF_ATTR_SEQ FROM PS_GPFR_AF_ATTR A

  • Related Language Record: GPFR_AF_ATP_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_KEY_NODE Number(8,0) INTEGER NOT NULL Application Framework - Key Node
    4 GPFR_AF_KEY_ATTR Number(8,0) INTEGER NOT NULL Application Framework - Key Attribute
    5 GPFR_AF_ATTR_NAME Character(12) VARCHAR2(12) NOT NULL Application Framework - Attribute Name
    6 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    7 GPFR_AF_ATTR_SEQ Number(4,0) SMALLINT NOT NULL Application Framework - Attribute Sequence