PRCSRQSTDLGLIST

Platform	View Text
Default	SELECT DISTINCT J.DESCR , J.PRCSJOBNAME , J.PRCSTYPE , '9' , 0 ,J.PRCSJOBNAME , P.PNLGRPNAME , ' ' , ' ' , ' ' , ' ' , ' ' , K.PRCSTYPEDESCR , '0' , ' ' FROM PS_PRCSJOBDEFN J , PS_PRCSJOBPNL P , PS_PRCSTYPEDEFN K WHERE J.PRCSJOBNAME = P.PRCSJOBNAME AND J.PRCSTYPE = K.PRCSTYPE

PeopleSoft Field Name	Description
DESCR	Description
PRCSNAME	Process Name
PRCSTYPE	Process Type
GENPRCSTYPE	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 (inactive)
PRCSJOBSEQ	Process Job Item
PRCSJOBNAME	Process Job Name
PNLGRPNAME	Component Name
OUTDESTSRC	Process Request output destination source 0=(None) 1=Process Type Definition (inactive) 2=Process Definition 3=User Specified
OUTDESTTYPE	Process Request output destination type. 0=Any 1=(None) 2=File 3=Printer 4=Window 5=Email 6=Web 7=Default
OUTDESTFORMAT	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) 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)
OUTDEST	Process Scheduler Output Destination
PSRF_FOLDER_NAME	Reporting Folder's Name
PRCSTYPEDESCR	Process Type Description
FILEDEPEND	File Dependency
PRCSFILENAME	FileName

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010