| PTPRTNSCHDL(SQL Table) | Index Back | 
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Partition Schedule | |
| 2 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL | Process Type Prompt Table: PMN_PRCSTYPE_VW | 
| 3 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name Prompt Table: PMN_PRCSNAME_VW | 
| 4 | OUTDESTTYPE | Character(3) | VARCHAR2(3) NOT NULL | Process Request output destination type. 0=Any 1=(None) 2=File 3=Printer 4=Window 5=Email 6=Web 7=Default 8=Feed 9=IB Node Prompt Table: PTASOUTTYPE_DVW | 
| 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) Prompt Table: PTASOUTTYPE_DVW | 
| 6 | OUTDEST | Character(127) | VARCHAR2(127) NOT NULL | Process Scheduler Output Destination | 
| 7 | BCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Component Name (see PSBCDEFN). | 
| 8 | SCHDL_APPCLASS | Character(1) | VARCHAR2(1) NOT NULL | Application Class A=Application Class F=Field Default Value: F |