PSPTRECDEFNDVW

index back

Rec Defn Dynamic View

Record Definition Dynamic view - where criteria limits RecType to Dynamic Views
SELECT A.RECNAME ,A.RECDESCR ,A.RECTYPE ,A.DESCRLONG FROM %Table(PSRECDEFN) A WHERE A.RECTYPE = 5

  • 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