GPFR_AF_PRMTMPT

(SQL Table)
 Index Back

Parameters at appl level

Application Framework - This record is used to define parameters at application level. Each row in this record is identified by unique parameter sequence number

  • Related Language Record: GPFR_AF_PRM_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_PARM_SEQ Number(8,0) INTEGER NOT NULL Application Framework - PARM Sequence

    Default Value: 99999999

    4 GPFR_AF_FUNCT_NM Character(16) VARCHAR2(16) NOT NULL Application Framework - Function
    5 GPFR_AF_PARM_NM Character(20) VARCHAR2(20) NOT NULL Application Framework - Parameter
    6 GPFR_AF_PRM_LABEL Character(30) VARCHAR2(30) NOT NULL Application Framework - Parameter Label
    7 GPFR_AF_PRM_SCOPE Character(3) VARCHAR2(3) NOT NULL Application Framework - Parameter Scope
    AED=Application/Extraction ID
    APP=Application Only
    DUP=Duplicate Data
    EED=Employee Event Data
    EID=Extraction ID Only

    Default Value: APP

    8 GPFR_AF_PRM_CNTL Character(2) VARCHAR2(2) NOT NULL Application Framework - Parameter Control
    CB=Check Box
    DD=Drop Down List
    EC=Edit Box Char
    ED=Edit Box Date
    EN=Edit Box Num
    PM=Prompt View
    SL=SQL Value
    TL=Translate Values

    Default Value: EC

    9 GPFR_AF_CHAR_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Character
    10 GPFR_AF_DATE_VAL Date(10) DATE Application Framework - Date
    11 GPFR_AF_NUM_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Application Framework - Number
    12 GPFR_AF_SQL_VAL Long Character CLOB Application Framework - SQL Data Value
    13 GPFR_AF_PROMPT_REC Character(20) VARCHAR2(20) NOT NULL Application Framework - Source Prompt Record

    Prompt Table: PSRECDEFN

    14 GPFR_AF_INPUT_FLD Character(18) VARCHAR2(18) NOT NULL Application Framework - Input Field

    Prompt Table: GPFR_AF_ENT_DVW

    15 GPFR_AF_SRC_CODE Character(30) VARCHAR2(30) NOT NULL Application Framework - Source Code

    Prompt Table: GPFR_AF_PRM_DVW

    16 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    17 GPFR_AF_PRM_DEFL Character(20) VARCHAR2(20) NOT NULL Application Framework - Parameter Default Value
    18 GPFR_AF_APLPRM_SEQ Number(4,0) SMALLINT NOT NULL Application Framework - Attribute Sequence
    19 GPFR_AF_OWNER Character(1) VARCHAR2(1) NOT NULL Application Framework - Object Owner
    C=Customer Maintained
    P=Peoplesoft Maintained
    20 GPFR_AF_VERSION Character(18) VARCHAR2(18) NOT NULL Application Framework object version.
    21 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp
    22 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name