RV_APP_PG_FLD

(SQL View)
 Index Back

Component Page Field

Component Page Field view returns the configuration information.

SELECT RV_TEMP_NAME , MARKET , PNLGRPNAME , PNLNAME , RECNAME , FIELDNAME , FIELDTYPE FROM PS_RV_APP_CPG_FLD WHERE FIELDTYPE <> 19

  • Parent record: RV_APP_CPG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RV_TEMP_NAME Character(70) VARCHAR2(70) NOT NULL Template Name

    Prompt Table: RV_LBL_TMPL

    2 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: RV_PNLGRPDFN_VW

    4 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

    Prompt Table: RV_PNLGROUP_VW

    5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: RV_PNLREC_VW

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

    Prompt Table: RV_PNLRECGRD_VW

    7 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)