| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BPW_TASK_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Task ID
|
| 2 |
BPW_DESCR |
Character(80) |
VARCHAR2(80) NOT NULL |
Description
|
| 3 |
BPW_TASK_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Task Type
APPC=App Class
JOB=Job
PROC=Process
Default Value: PROC
|
| 4 |
PRCSTYPE |
Character(30) |
VARCHAR2(30) NOT NULL |
Process Type
Prompt Table:
BPW_PRCSTYPE_VW
|
| 5 |
PRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
Prompt Table:
PRCSDEFN
|
| 6 |
PRCSJOBNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Process Job Name
Prompt Table:
PRCSJOBDEFN
|
| 7 |
MENUNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table:
PSMENUDEFN
|
| 8 |
BARNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Bar Name
Prompt Table:
PRCSBARNAME_VW
|
| 9 |
ITEMNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Item Name
Prompt Table:
PSMENUITEM_VW2
|
| 10 |
ITEMPANELNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Panel Name
Prompt Table:
BPW_MENUPNL_VW
|
| 11 |
MENU_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Menu Action
A=Add
C=Correction
E=Data Entry
L=Update/Display All
U=Update
Default Value: U
|
| 12 |
BPW_RC_PRMPT_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
Run Control Prompt Record
Prompt Table:
PSRECDEFN
|
| 13 |
BPW_RC_REQUIRE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Control Required
Y/N Table Edit
Default Value: Y
|
| 14 |
BPW_TASK_HDLR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Task Handler ID
Prompt Table:
BPW_AC_TASK_VW
|
| 15 |
BPW_TASK_HDLR_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Task Handler Parameter
|
| 16 |
BPW_EVNT_HDLR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Event Handler ID
Prompt Table:
BPW_AC_EVNT_VW
|
| 17 |
BPW_EVNT_HDLR_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Event Handler Parameter
|
| 18 |
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
|
| 19 |
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)
|
| 20 |
BPW_SYS_DEFN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
System Defined
Y/N Table Edit
|
| 21 |
BPW_OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Additional valid values are from OBJECTOWNERID
Prompt Table:
BPW_OBJOWNID_VW
|
| 22 |
BPW_TASK_ICON |
Character(250) |
VARCHAR2(250) NOT NULL |
Icon Name
Prompt Table:
PTPPB_IMGCAT_VW
|
| 23 |
BPW_DATA_CHECK_REC |
Character(15) |
VARCHAR2(15) NOT NULL |
Data Check Record
Prompt Table:
BPW_DTCKREC_VW
|