CDM_FILELIST_VW

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 ,A.CDM_FILE_TYPE , A.FILE_SIZE , A.DTTM_CREATED , B.CDM_ADMIN , B.CDM_BINARY_FILE , B.DESCR50 ,B.FLDNOTUSED FROM PS_CDM_FILE_LIST A , PS_CDM_FILE_EXT B WHERE A.CDM_FILE_TYPE = B.CDM_FILE_TYPE AND B.DISPLAY_OPTION = '1'

  • Related language record: CDM_FILE_VW_LAN
  • 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
    CDM_FILE_TYPE Character(10) VARCHAR2(10) NOT NULL File types to be referenced by the Distribution Agent for report distribution.
    FILE_SIZE Number(10,0) DECIMAL(10) NOT NULL Physical File Size
    DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
    CDM_ADMIN Character(1) VARCHAR2(1) NOT NULL Administrator Only
    CDM_BINARY_FILE Character(1) VARCHAR2(1) NOT NULL Transfer as Binary File
    DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    FLDNOTUSED Number(1,0) SMALLINT NOT NULL This field indicates whether a field is being actively used in a table or whether it is just there to avoid rebuilding the table and removing it. The default is 0, which means the field is used.
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19