GPFR_AFNA_TAO

(SQL Table)
 Index Back

Temp table used in SQR

Application Framework - Temporary table used in the create file processing of Application Framework

  • Related Language Record: GPFR_AF_TAO_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 GPFR_AF_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Application Framework - Node Name
    3 GPFR_AF_ATTR_NAME Character(12) VARCHAR2(12) NOT NULL Application Framework - Attribute Name
    4 GPFR_AF_MANDATORY Character(1) VARCHAR2(1) NOT NULL Application Framework - Mandatory
    5 GPFR_AF_ATTR_TYPE Character(1) VARCHAR2(1) NOT NULL Application Framework - *Attribute Type
    D=Date
    M=Monetary
    N=Numeric
    T=Text
    6 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
    7 GPFR_AF_ATR_LENGTH Number(3,0) SMALLINT NOT NULL Application Framework - *Attribute Length
    8 GPFR_AF_ATR_DECIML Number(2,0) SMALLINT NOT NULL Application Framework - Attribute Decimal
    9 GPFR_AF_CODE_ID Character(12) VARCHAR2(12) NOT NULL Application Framework - Code ID
    10 GPFR_AF_PROMPT Character(15) VARCHAR2(15) NOT NULL Application Framework - Edit Table
    11 GPFR_AF_PR_KEY_FLD Character(18) VARCHAR2(18) NOT NULL Application Framework - Prompt Key Field Name
    12 GPFR_AF_PR_LBL_FLD Character(18) VARCHAR2(18) NOT NULL Application Framework - Prompt Label Field Name
    13 GPFR_AF_ATTR_FIELD Character(18) VARCHAR2(18) NOT NULL Application Framework - Field Name
    14 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    15 GPFR_AF_KEY_NODE Number(8,0) INTEGER NOT NULL Application Framework - Key Node
    16 GPFR_AF_KEY_ATTR Number(8,0) INTEGER NOT NULL Application Framework - Key Attribute
    17 GPFR_AF_NUM_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Application Framework - Number