GPFR_AF_NOD_IMP

(SQL Table)
 Index Back

Upgrade Node/attribute process

Application Framework - This record is used in upgradation of data related to node and attributes

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

    Default Value: 99999999

    4 GPFR_AF_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Application Framework - Node Name
    5 GPFR_AF_ORDER Number(6,0) INTEGER NOT NULL Application Framework - Order
    6 GPFR_AF_LEVEL Number(2,0) SMALLINT NOT NULL Application Framework - Level
    7 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    8 GPFR_AF_LVLREC_ALS Character(4) VARCHAR2(4) NOT NULL Field for Level Record Alias
    ENT=ENTITY
    PRM=Flexible
    SEC=SEC
    9 GPFR_AF_LVLKEY_REC Character(15) VARCHAR2(15) NOT NULL Field for Level Key Record Name

    Prompt Table: GPFR_AF_LREC_VW

    10 GPFR_AF_LVL_FLD_NM Character(18) VARCHAR2(18) NOT NULL Application Framework - Level Key Definition

    Prompt Table: GPFR_AF_LVLF_VW

    11 GPFR_AF_LVL_PARM Character(50) VARCHAR2(50) NOT NULL Field for Level Key Func.Parm
    12 GPFR_AF_PSAE_PRGM Character(12) VARCHAR2(12) NOT NULL Application Framework - PeopleSoft AE Program

    Prompt Table: PSAEAPPLDEFN

    13 GPFR_AF_PSAE_SEC Character(8) VARCHAR2(8) NOT NULL Application Framework - PeopleSoft AE Section

    Prompt Table: GPFR_AF_AESE_VW

    14 GPFR_AF_CUSTAE_PGM Character(12) VARCHAR2(12) NOT NULL Application Framework - Customer AE Program

    Prompt Table: PSAEAPPLDEFN

    15 GPFR_AF_CUSTAE_SEC Character(8) VARCHAR2(8) NOT NULL Application Framework - Customer AE Section

    Prompt Table: GPFR_AF_AESE_VW

    16 GPFR_AF_LVL_1_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 1
    17 GPFR_AF_LVL_1_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 1
    18 GPFR_AF_LVL_2_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 2
    19 GPFR_AF_LVL_2_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 2
    20 GPFR_AF_LVL_3_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 3
    21 GPFR_AF_LVL_3_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 3
    22 GPFR_AF_LVL_4_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 4
    23 GPFR_AF_LVL_4_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 4
    24 GPFR_AF_LVL_5_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 5
    25 GPFR_AF_LVL_5_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 5
    26 GPFR_AF_LVL_6_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 6
    27 GPFR_AF_LVL_6_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 6
    28 GPFR_AF_LVL_7_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 7
    29 GPFR_AF_LVL_7_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 7
    30 GPFR_AF_LVL_8_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 8
    31 GPFR_AF_LVL_8_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 8
    32 GPFR_AF_LVL_9_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 9
    33 GPFR_AF_LVL_9_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 9
    34 GPFR_AF_LVL_10_ORD Number(6,0) INTEGER NOT NULL Application Framework - Level 10
    35 GPFR_AF_LVL_10_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Key Value 10
    36 GPFR_AF_OVR_AT_RUN Character(1) VARCHAR2(1) NOT NULL Application Framework - Override Run Control Select
    F=Only for nodes type finalize
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    37 GPFR_AF_COMP_FILTR Character(1) VARCHAR2(1) NOT NULL Application Framework - Enable Company Based Filtering

    Y/N Table Edit

    Default Value: Y

    38 GPFR_AF_ESTB_FILTR Character(1) VARCHAR2(1) NOT NULL Application Framework - Enable Estab Based Filtering

    Y/N Table Edit

    Default Value: Y

    39 GPFR_AF_EMPL_FILTR Character(1) VARCHAR2(1) NOT NULL Application Framework - Enable Employe Based Filtering

    Y/N Table Edit

    Default Value: Y

    40 GPFR_AF_NODE_STAT Character(1) VARCHAR2(1) NOT NULL Application Framework - Node Status
    A=Active
    I=Inactive

    Default Value: A

    41 COMMENTS Long Character CLOB Comment
    42 GPFR_AF_OWNER Character(1) VARCHAR2(1) NOT NULL Application Framework - Object Owner
    C=Customer Maintained
    P=Peoplesoft Maintained
    43 GPFR_AF_VERSION Character(18) VARCHAR2(18) NOT NULL Application Framework object version.
    44 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp
    45 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name