CDM_LS_NDN_VW

(SQL View)
 Index Back

Rpt Dist - Rpt List w/o node

This view lists all reports with no distribution node specified.

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 , %Substring(' ', 1, 1) , A.EXPIRATION_DATE , A.PSRF_FOLDER_NAME , A.GENPRCSTYPE FROM PS_CDM_LIST A , PS_CDM_AUTH_U_VW B WHERE A.PRCSINSTANCE = B.PRCSINSTANCE AND A.CONTENTID = B.CONTENTID AND A.DISTSTATUS <> '6' AND A.LOGFILEONLY_FLAG = '0' AND A.DISTNODENAME = ''

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID
3 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
5 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)
6 RQSTDTTM DateTime(26) TIMESTAMP Request Date/Time
7 OUTPUTDIR Character(100) VARCHAR2(100) NOT NULL Output Directory
8 ADMIN_FILENAME Character(100) VARCHAR2(100) NOT NULL Distribution File Name
9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
10 DISTID Character(30) VARCHAR2(30) NOT NULL Distribution ID
11 DISTIDTYPE Character(3) VARCHAR2(3) NOT NULL Distribution ID Type
2=User ID
3=Role Name
12 DISTNODENAME Character(15) VARCHAR2(15) NOT NULL Report Distribution Node Name
13 ENDDTTM DateTime(26) TIMESTAMP End Date/Time
14 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
15 CONTENT_DESCR Character(254) VARCHAR2(254) NOT NULL Report Description
16 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
17 EXPIRATION_DATE Date(10) DATE Expiration Date
18 PSRF_FOLDER_NAME Character(18) VARCHAR2(18) NOT NULL Reporting Folder's Name
19 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