PRCSRQSTITEMS

Platform	View Text
Default	SELECT DISTINCT J.PRCSJOBNAME , J.PRCSTYPE , J.DESCR , ' ' , '9' , 0 ,J.PRCSJOBNAME , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , %Substring(' ', 1, 1) , %Substring(' ', 1, 1) , %Substring(' ', 1, 1) , ' ' , ' ' , ' ' ,'0' ,J.PRCSFILENAME FROM PS_PRCSJOBDEFN J

PeopleSoft Field Name	Description
PRCSNAME	Process Name
PRCSTYPE	Process Type
DESCR	Description
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)
RUN_CNTL_ID	Run Control ID
PRCSJOBSEQ	Process Job Item
PRCSJOBNAME	Process Job Name
PRCSITEMLEVEL	Process Item Level
OUTDEST	Process Scheduler Output Destination
OUTDESTTYPE	Process Request output destination type. 0=Any 1=(None) 2=File 3=Printer 4=Window 5=Email 6=Web 7=Default Prompt Table: %EDITTABLE17 Set Control Field: GENPRCSTYPE
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) Prompt Table: OUTDESTFORMAT Set Control Field: OUTDESTTYPE
OUTDESTSRC	Process Request output destination source 0=(None) 1=Process Type Definition (inactive) 2=Process Definition 3=User Specified
EMAIL_LOG_FLAG	Email With Log Default: 0
EMAIL_SUBJECTTEXT	Email Subject
EMAIL_TEXTLONG	Message Text
EMAIL_LIST	Email Address List
EMAIL_WEB_RPT	Email Web Report N=Display report in browser Y=Email report
SET_JOB_DFLT_FLAG	Set Default Job Distribution
PSRF_FOLDER_NAME	Reporting Folder's Name Prompt Table: PRCSDEFNFLDR_VW Set Control Field: PSRF_FOLDER_NAME
FILEDEPEND	File Dependency
PRCSFILENAME	FileName

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