CDM_LIST_VW

index back

CDM - Cntnt List (for User)

This view lists all Content to be distributed and all these Content has grant access to one User.
SELECT A.PRCSINSTANCE , A.CONTENTID , A.PRCSTYPE , A.PRCSNAME , A.OUTDESTFORMAT , A.RQSTDTTM , A.OUTPUTDIR , A.ADMIN_FILENAME , B.OPRID , B.DISTID , B.DISTIDTYPE , A.DISTNODENAME , A.ENDDTTM , A.DISTSTATUS , A.CONTENT_DESCR , C.URL , A.EXPIRATION_DATE , A.PSRF_FOLDER_NAME , A.GENPRCSTYPE FROM PS_CDM_LIST A , PS_CDM_AUTH_U_VW B , PS_CDM_DIST_NODE C WHERE A.PRCSINSTANCE = B.PRCSINSTANCE AND A.CONTENTID = B.CONTENTID AND A.DISTNODENAME = C.DISTNODENAME AND A.DISTSTATUS <> '6' AND A.LOGFILEONLY_FLAG = '0'

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
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
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
OUTPUTDIR Character(100) VARCHAR2(100) NOT NULL Output Directory
ADMIN_FILENAME Character(100) VARCHAR2(100) NOT NULL Distribution File Name
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
DISTID Character(30) VARCHAR2(30) NOT NULL Distribution ID
DISTIDTYPE Character(3) VARCHAR2(3) NOT NULL Distribution ID Type
2=User ID
3=Role Name
DISTNODENAME Character(15) VARCHAR2(15) NOT NULL Report Distribution Node Name
ENDDTTM DateTime(26) TIMESTAMP End Date/Time
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
CONTENT_DESCR Character(254) VARCHAR2(254) NOT NULL Report Description
URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
EXPIRATION_DATE Date(10) DATE Expiration Date
PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's 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
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19