GPFR_AD_PRMT_VW

(SQL View)
 Index Back

ADS Entry - Parm. Template Def

Application Framework ADS Entry - This record is used to retrieve a list of Parameter Template Definition rows when searching for rows to be included in an ADS package. It also enhance the search of rows providing prompt tables for the search fields.

SELECT COUNTRY ,GPFR_AF_APPL ,GPFR_AF_PARM_SEQ ,GPFR_AF_APLPRM_SEQ ,GPFR_AF_FUNCT_NM ,GPFR_AF_PARM_NM ,GPFR_AF_PRM_LABEL ,GPFR_AF_VERSION ,LAST_UPDT_DTTM ,LAST_UPDT_OPRID FROM PS_GPFR_AF_PRMTMPT

  • Related Language Record: GPFR_ADPRMT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: GPFR_AF_CNTY_VW

    2 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application

    Prompt Table: GPFR_AF_APPL_VW

    3 GPFR_AF_PARM_SEQ Number(8,0) INTEGER NOT NULL Application Framework - PARM Sequence

    Prompt Table: GPFR_AF_PRMTMPT

    4 GPFR_AF_APLPRM_SEQ Number(4,0) SMALLINT NOT NULL Application Framework - Attribute Sequence

    Prompt Table: GPFR_AF_PRMTMPT

    5 GPFR_AF_FUNCT_NM Character(16) VARCHAR2(16) NOT NULL Application Framework - Function

    Prompt Table: GPFR_AF_PRMTMPT

    6 GPFR_AF_PARM_NM Character(20) VARCHAR2(20) NOT NULL Application Framework - Parameter

    Prompt Table: GPFR_AF_PRMTMPT

    7 GPFR_AF_PRM_LABEL Character(30) VARCHAR2(30) NOT NULL Application Framework - Parameter Label
    8 GPFR_AF_VERSION Character(18) VARCHAR2(18) NOT NULL Application Framework object version.

    Prompt Table: GPFR_AF_APTV_VW

    9 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp
    10 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name