GPFR_AF_ATR_IMP

(SQL Table)
 Index Back

Attribute Import Record

Application Framework - This record is a copy GPFR_AF_ATTR record. Used for data upgrading into the GPFR_AF_ATTR record.

  • Related Language Record: GPFR_AF_IMP_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

    Default Value: 99999999

    5 GPFR_AF_APPL_VER Number(8,0) INTEGER NOT NULL Application Framework - Application

    Prompt Table: GPFR_AF_AVER_V

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

    Default Value: A

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

    Y/N Table Edit

    Default Value: N

    14 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
    15 GPFR_AF_CODE_ID Character(12) VARCHAR2(12) NOT NULL Application Framework - Code ID
    16 GPFR_AF_PROMPT Character(15) VARCHAR2(15) NOT NULL Application Framework - Edit Table
    17 GPFR_DA_DATTYP Character(10) VARCHAR2(10) NOT NULL DADS related field
    18 GPFR_AF_PR_LBL_FLD Character(18) VARCHAR2(18) NOT NULL Application Framework - Prompt Label Field Name
    19 GPFR_AF_PR_KEY_FLD Character(18) VARCHAR2(18) NOT NULL Application Framework - Prompt Key Field Name
    20 GPFR_AF_ATTR_FIELD Character(18) VARCHAR2(18) NOT NULL Application Framework - Field Name
    21 GPFR_AF_PS_DON Character(16) VARCHAR2(16) NOT NULL Application Framework - Peoplesoft Data Object Name
    22 GPFR_AF_CUST_DON Character(16) VARCHAR2(16) NOT NULL Application Framework - Customer Data Object Name
    23 GPFR_AF_RPT_ONLY Character(1) VARCHAR2(1) NOT NULL Field for Report Only Attribute
    24 COMMENTS Long Character CLOB Comment
    25 GPFR_AF_OWNER Character(1) VARCHAR2(1) NOT NULL Application Framework - Object Owner
    C=Customer Maintained
    P=Peoplesoft Maintained
    26 GPFR_AF_VERSION Character(18) VARCHAR2(18) NOT NULL Application Framework object version.
    27 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp
    28 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name