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 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
    CDM_FILE_TYPECharacter(10)VARCHAR2(10) NOT NULLFile types to be referenced by the Distribution Agent for report distribution.
    FILE_SIZENumber(10,0)DECIMAL(10) NOT NULLPhysical File Size
    DTTM_CREATEDDateTime(26)TIMESTAMPDatetime Created
    CDM_ADMINCharacter(1)VARCHAR2(1) NOT NULLAdministrator Only
    CDM_BINARY_FILECharacter(1)VARCHAR2(1) NOT NULLTransfer as Binary File
    DESCR50Character(50)VARCHAR2(50) NOT NULLDescription of length 50
    FLDNOTUSEDNumber(1,0)SMALLINT NOT NULLThis 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.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19