GP_PIN_RECS_VW

(SQL View)
 Index Back

Views that GP Prompt Tables

Currently these prompt table start with 'GP_PIN%' or 'GP_FLD'. Other views should be added with care.

SELECT RECNAME , RECDESCR , RECTYPE FROM PSRECDEFN WHERE RECTYPE IN (1, 5, 6) AND RECNAME LIKE 'GP_%' ESCAPE '/'

  • Related Language Record: GP_PIN_RECS_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    3 RECTYPE Number(1,0) SMALLINT NOT NULL Record Type
    0=SQL Table
    1=SQL View
    2=Derived Work/Record
    3=Subrecord
    5=Dynamic View
    6=Query View
    7=Temporary Table