PTADSREC_TOP_VW

index back

SELECT RECNAME , RECDESCR , %NumToChar(RECTYPE) FROM PSRECDEFN P WHERE P.RECTYPE IN (0,1,5,6) AND NOT EXISTS ( SELECT 'Is Related Language Record?' FROM PSRECDEFN L WHERE L.RELLANGRECNAME = P.RECNAME )

  • Related language record: PTADSREC_TOP_VL
  • 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_CHAR Character(1) VARCHAR2(1) NOT NULL Record Type denoted in character for translate purpose.
    0=SQL Table
    1=SQL View
    2=Derived/Work
    3=SubRecord
    5=Dynamic View
    6=Query View
    7=Temporary Table
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19