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 NameField TypeColumn TypeDescription
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
    RECDESCRCharacter(30)VARCHAR2(30) NOT NULLRecord Description
    RECTYPE_CHARCharacter(1)VARCHAR2(1) NOT NULLRecord 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.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19