PSRECDEFNP_LVW

index back

Record Definition(Alt Lang)


SELECT A.RECNAME ,B.LANGUAGE_CD ,B.RECDESCR ,B.DESCRLONG FROM PSRECDEFN A , PSRECDEFNLANG B WHERE A.RECNAME = B.RECNAME AND A.RECTYPE NOT IN (2,3,7)

  • Related language record for PSPTRECDEFNDVW PSRECDEFNPVW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    RECDESCRCharacter(30)VARCHAR2(30) NOT NULLRecord Description
    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19