CDM_LIST_ARCH

(SQL Table)
 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.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ARCHIVE_DT Date(10) DATE Archive Date
2 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID
4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
5 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
6 CONTENT_DESCR Character(254) VARCHAR2(254) NOT NULL Report Description
7 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)
8 RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
9 ENDDTTM DateTime(26) TIMESTAMP End Date/Time
10 OUTPUTDIR Character(100) VARCHAR2(100) NOT NULL Output Directory
11 RPTDIR Character(150) VARCHAR2(150) NOT NULL Report Directory