PTRS_QRYLANGVW

index back

Report search related lang qry

This record provides related language fields for PTRS_SRCHQRYVW record.
SELECT A.PRCSINSTANCE , A.ENDDTTM , F.psrf_report_descr , F.LANGUAGE_CD FROM PS_CDM_LIST A INNER JOIN PS_CDM_FILE_LIST B ON A.PRCSINSTANCE = B.PRCSINSTANCE INNER JOIN PSRF_RINFO_TBL C ON A.PRCSINSTANCE = C.PRCSINSTANCE INNER JOIN PSPRCSRQST D ON A.PRCSINSTANCE = D.PRCSINSTANCE INNER JOIN PS_CDM_AUTH E ON A.CONTENTID = E.CONTENTID INNER JOIN PSRF_RDESC_LANG F ON a.prcstype = f.prcstype AND a.prcsname = f.prcsname WHERE A.LOGFILEONLY_FLAG = '0' AND B.CDM_FILE_TYPE NOT IN ('STDOUT', 'TRC', 'LOG', 'OUT', 'AET') AND C.FILENAME IS NOT NULL

  • Related language record for PTRS_SRCHQRYVW
  • Parent record: CDM_LIST
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    ENDDTTMDateTime(26)TIMESTAMPEnd Date/Time
    CONTENT_DESCRCharacter(254)VARCHAR2(254) NOT NULLReport Description
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19