CDM_LS_NDN_VW

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 NameField TypeColumn TypeDescription
PRCSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
CONTENTIDNumber(15,0)DECIMAL(15) NOT NULLReport ID
PRCSTYPECharacter(30)VARCHAR2(30) NOT NULLProcess Type
PRCSNAMECharacter(12)VARCHAR2(12) NOT NULLProcess Name
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
OUTPUTDIRCharacter(100)VARCHAR2(100) NOT NULLOutput Directory
ADMIN_FILENAMECharacter(100)VARCHAR2(100) NOT NULLDistribution File Name
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
DISTIDCharacter(30)VARCHAR2(30) NOT NULLDistribution ID
DISTIDTYPECharacter(3)VARCHAR2(3) NOT NULLDistribution ID Type
2=User ID
3=Role Name
DISTNODENAMECharacter(15)VARCHAR2(15) NOT NULLReport Distribution Node Name
ENDDTTMDateTime(26)TIMESTAMPEnd Date/Time
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
CONTENT_DESCRCharacter(254)VARCHAR2(254) NOT NULLReport Description
URLCharacter(254)VARCHAR2(254) NOT NULLInternet URL (Universal Resource Locator)
EXPIRATION_DATEDate(10)DATEExpiration Date
PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's 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
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19