GPFR_AF_ATTR

(SQL Table)
 Index Back

Attribute Record

Application Framework - This is the base Attribute Record. This record Stores all the attributes along with their properties.

  • Related Language Record: GPFR_AF_ATR_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_KEY_NODE Number(8,0) INTEGER NOT NULL Application Framework - Key Node

    Prompt Table: GPFR_AF_NODE

    4 GPFR_AF_KEY_ATTR Number(8,0) INTEGER NOT NULL Application Framework - Key Attribute

    Default Value: 99999999

    5 GPFR_AF_ATTR_NAME Character(12) VARCHAR2(12) NOT NULL Application Framework - Attribute Name
    6 GPFR_AF_ATTR_STAT Character(1) VARCHAR2(1) NOT NULL Application Framework - Attribute Status
    A=Active
    I=Inactive

    Default Value: A

    7 GPFR_AF_ATTR_SEQ Number(4,0) SMALLINT NOT NULL Application Framework - Attribute Sequence
    8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    9 GPFR_AF_ATTR_TYPE Character(1) VARCHAR2(1) NOT NULL Application Framework - *Attribute Type
    D=Date
    M=Monetary
    N=Numeric
    T=Text
    10 GPFR_AF_ATR_LENGTH Number(3,0) SMALLINT NOT NULL Application Framework - *Attribute Length
    11 GPFR_AF_ATR_DECIML Number(2,0) SMALLINT NOT NULL Application Framework - Attribute Decimal
    12 GPFR_AF_MANDATORY Character(1) VARCHAR2(1) NOT NULL Application Framework - Mandatory

    Y/N Table Edit

    Default Value: N

    13 GPFR_AF_ATR_LBLSRC Character(4) VARCHAR2(4) NOT NULL Application Framework - Attribute Label Source
    CODE=Code ID
    DTYP=Data Type
    RECD=Record
    XLAT=Xlat Value
    14 GPFR_AF_CODE_ID Character(12) VARCHAR2(12) NOT NULL Application Framework - Code ID

    Prompt Table: GPFR_AF_CODE_VW

    15 GPFR_AF_PROMPT Character(15) VARCHAR2(15) NOT NULL Application Framework - Edit Table

    Prompt Table: RECDEFN_VW

    16 GPFR_DA_DATTYP Character(10) VARCHAR2(10) NOT NULL DADS related field

    Prompt Table: GPFR_DA_DATTYP

    17 GPFR_AF_PR_LBL_FLD Character(18) VARCHAR2(18) NOT NULL Application Framework - Prompt Label Field Name

    Prompt Table: GPFR_AF_FLD_DVW

    18 GPFR_AF_PR_KEY_FLD Character(18) VARCHAR2(18) NOT NULL Application Framework - Prompt Key Field Name

    Prompt Table: GPFR_AF_FLD_DVW

    19 GPFR_AF_ATTR_FIELD Character(18) VARCHAR2(18) NOT NULL Application Framework - Field Name

    Prompt Table: GPFR_AF_DBFLDVW

    20 GPFR_AF_PS_DON Character(16) VARCHAR2(16) NOT NULL Application Framework - Peoplesoft Data Object Name

    Prompt Table: GPFR_AF_PDON_VW

    21 GPFR_AF_CUST_DON Character(16) VARCHAR2(16) NOT NULL Application Framework - Customer Data Object Name

    Prompt Table: GPFR_AF_CDON_VW

    22 GPFR_AF_RPT_ONLY Character(1) VARCHAR2(1) NOT NULL Field for Report Only Attribute

    Y/N Table Edit

    Default Value: N

    23 COMMENTS Long Character CLOB Comment
    24 GPFR_AF_OWNER Character(1) VARCHAR2(1) NOT NULL Application Framework - Object Owner
    C=Customer Maintained
    P=Peoplesoft Maintained