CDM_LIST

index back

Content Dist Mgr - Cntnt List

This record is used by Content Distribution Manager to store the content list that are sent to the content repository.

  • Parent record of PTRS_DEL_QRYVW PTRS_QRYLANGVW PTRS_SRCHQRYVW
  • 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
    PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
    PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
    PRCSOUTPUTDIR Character(254) VARCHAR2(254) NOT NULL Process Output Directory
    CONTENT_DESCR Character(254) VARCHAR2(254) NOT NULL Report Description
    OUTDESTFORMAT Character(3) VARCHAR2(3) NOT NULL Process Request output format
    0=Any
    1=(None)
    10=Postscript (*.lis)
    11=Crystal Report (*.rpt)
    12=Rich Text File (*.rtf)
    13=SQR Portable Format (*.spf)
    14=Text Files (*.txt)
    15=Other
    16=Default
    17=XML Format(*.xml)
    18=Data Mover Data File (*.dat)
    19=Crystal Report Explorer(*.rpt)
    2=Acrobat (*.pdf)
    20=XMLP
    21=Atom
    22=Transformation
    23=Printer Command Lang. (*.pcl)
    24=PostScript (*.ps)
    3=Comma delimited (*.csv)
    4=HP Format (*.lis)
    5=HTML Documents (*.htm)
    6=Line Printer Format (*.lis)
    7=Lotus 1-2-3 Files (*.wks)
    8=Microsoft Excel Files (*.xls)
    9=Microsoft Word (*.doc)
    RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
    ENDDTTM DateTime(26) TIMESTAMP End Date/Time
    EXPIRATION_DATE Date(10) DATE Expiration Date
    DISTSTATUS Character(2) VARCHAR2(2) NOT NULL Distribution Status
    0=None
    1=Scheduled
    2=Processing
    3=Generated
    4=Unable to Post
    5=Posted to Web
    6=Delete
    7=Posting
    9=Pending for Approval
    DISTNODENAME Character(15) VARCHAR2(15) NOT NULL Report Distribution Node Name
    OUTPUTDIR Character(100) VARCHAR2(100) NOT NULL Output Directory
    TRANSFERINSTANCE Number(15,0) DECIMAL(15) NOT NULL Transfer Instance
    ADMIN_FILENAME Character(100) VARCHAR2(100) NOT NULL Distribution File Name
    GENPRCSTYPE Character(2) VARCHAR2(2) NOT NULL Generic Process Type
    0=Other
    1=SQR
    2=PeopleSoft COBOL
    3=Crystal Report
    4=Winword Macro
    5=Application Engine
    6=Cube Builder
    7=nVision
    8=Data Mover
    9=PSJob
    LOGFILEONLY_FLAG Character(1) VARCHAR2(1) NOT NULL Log File Only Flag
    FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
    PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
    PRCSBURSTRPT Character(1) VARCHAR2(1) NOT NULL Flag to indicate this is a bursted report

    Default: 0

    MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    CDM_APPROVAL_FLAG Character(1) VARCHAR2(1) NOT NULL Approval Required

    Default: N

    QRYXFORMFILETYPE Character(10) VARCHAR2(10) NOT NULL Output File Type result from Transformation
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19