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 NameField TypeColumn TypeDescription
    PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    CONTENTIDNumber(15,0)DECIMAL(15) NOT NULLReport ID
    FILENAMECharacter(80)VARCHAR2(80) NOT NULLFile Name
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    DESCR50Character(50)VARCHAR2(50) NOT NULLDescription of length 50
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19