PTPRTNSCHDL(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PTSCHDL_NAME | 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 |