CDM_FILE_VW_LAN

index back

Rpt Dist - File list

This record is used by Rpt Mgr to store the content list that are viewed via PIA.
SELECT A.PRCSINSTANCE , A.CONTENTID , A.FILENAME , C.LANGUAGE_CD , C.DESCR50 FROM PS_CDM_FILE_LIST A , PS_CDM_FILE_EXT B , PS_CDM_FILEEXT_LAN C WHERE A.CDM_FILE_TYPE = B.CDM_FILE_TYPE AND B.DISPLAY_OPTION = '1' AND B.CDM_FILE_TYPE = C.CDM_FILE_TYPE

  • Related language record for CDM_FILELIST_VW
  • PeopleSoft Field Name Field Type Column Type Description
    PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID
    FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19