PTRS_QRYLANGVW

(SQL View)
 Index Back

Report search related lang qry

This record provides related language fields for PTRS_SRCHQRYVW record.

SELECT A.PRCSINSTANCE , B.DTTM_CREATED , F.LANGUAGE_CD , F.psrf_report_descr 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 Name PeopleSoft Field Type Database Column Type Description
    1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 CONTENT_DESCR Character(254) VARCHAR2(254) NOT NULL Report Description