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 NameField TypeColumn TypeDescription
    PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
    CONTENTIDNumber(15,0)DECIMAL(15) NOT NULLReport ID
    PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
    PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
    PRCSOUTPUTDIRCharacter(254)VARCHAR2(254) NOT NULLProcess Output Directory
    CONTENT_DESCRCharacter(254)VARCHAR2(254) NOT NULLReport Description
    OUTDESTFORMATCharacter(3)VARCHAR2(3) NOT NULLProcess 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)
    RQSTDTTMDateTime(26)TIMESTAMPRequest Date/Time
    ENDDTTMDateTime(26)TIMESTAMPEnd Date/Time
    EXPIRATION_DATEDate(10)DATEExpiration Date
    DISTSTATUSCharacter(2)VARCHAR2(2) NOT NULLDistribution 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
    DISTNODENAMECharacter(15)VARCHAR2(15) NOT NULLReport Distribution Node Name
    OUTPUTDIRCharacter(100)VARCHAR2(100) NOT NULLOutput Directory
    TRANSFERINSTANCENumber(15,0)DECIMAL(15) NOT NULLTransfer Instance
    ADMIN_FILENAMECharacter(100)VARCHAR2(100) NOT NULLDistribution File Name
    GENPRCSTYPECharacter(2)VARCHAR2(2) NOT NULLGeneric 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_FLAGCharacter(1)VARCHAR2(1) NOT NULLLog File Only Flag
    FILENAMECharacter(80)VARCHAR2(80) NOT NULLFile Name
    PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name
    PRCSBURSTRPTCharacter(1)VARCHAR2(1) NOT NULLFlag to indicate this is a bursted report

    Default: 0

    MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    CDM_APPROVAL_FLAGCharacter(1)VARCHAR2(1) NOT NULLApproval Required

    Default: N

    QRYXFORMFILETYPECharacter(10)VARCHAR2(10) NOT NULLOutput File Type result from Transformation
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19