PSRECDEFNPVW

 index back

Rec Defn Prompt View

Record Definition Prompt view - where criteria limits RecType to Tables and Views
SELECT A.RECNAME ,A.RECDESCR ,A.RECTYPE ,A.DESCRLONG FROM PSRECDEFN A WHERE A.RECTYPE NOT IN (2,3,7)

  • Related language record: PSRECDEFNP_LVW

    • PeopleSoft Field Name Field Type Column Type Description
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    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
    DESCRLONG Long Character CLOB Long Description
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20