| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PTAFPRCS_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Process ID
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
|
| 4 |
PTAFENTRY_COMP |
Character(18) |
VARCHAR2(18) NOT NULL |
Entry Component
Prompt Table:
PSPNLGRPDFN_VW1
|
| 5 |
MENUNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table:
PSMENUDEFN_VW
|
| 6 |
PTAFAPPR_COMPONENT |
Character(18) |
VARCHAR2(18) NOT NULL |
Approval Component
Prompt Table:
PTAFMENU_PNL_VW
|
| 7 |
PNLNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table:
PTAFPAGE_VW
|
| 8 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Root Package ID
Prompt Table:
PTAFPACKAGE_VW
|
| 9 |
APPCLASS_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Application Class Full Path
Prompt Table:
PTAFAPCLSPTH_VW
|
| 10 |
PTAFRECNAME_XREF |
Character(15) |
VARCHAR2(15) NOT NULL |
Cross Reference Table
Prompt Table:
PTAFAW_REC_VW
|
| 11 |
PTAF_MAP_REC_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Mapping Record Name
|
| 12 |
PTAFAW_PACKAGENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Adhoc Access Logic Package
Prompt Table:
PTAFADHC_PKG_VW
|
| 13 |
PTAFAW_CLASS_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Adhoc Logic Class Path
Prompt Table:
PTAFADHC_CLS_VW
|
| 14 |
PTAFDESCRPKGROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Thread Description Package
Prompt Table:
PTAFDSCR_PKG_VW
|
| 15 |
PTAFDESCRCLASSPATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Thread Description Class Path
Prompt Table:
PTAFDSCR_CLS_VW
|
| 16 |
PTAFENABLE_NOTIF |
Character(1) |
VARCHAR2(1) NOT NULL |
Enables notificction for Approvals.
A=Enable Email and Worklist
E=Email Notification Only
W=Worklist Notification Only
Z=Disable Email and Worklist
Default Value: A
|
| 17 |
PTAFNOTIFY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to schedule the sending of email.
G=Integration Broker Processing
I=Online Processing
P=Offline Processing
Default Value: I
|
| 18 |
PTAFMINIMIZE_EML |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to flag whether or not all emails should be sent or just the minimal amount necessary. I.E. if the approval has two lines for the same approver should he receive one email or two.
Y/N Table Edit
Default Value: Y
|
| 19 |
PTAFAW_EMC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Email Approvals
Y/N Table Edit
Default Value: N
|
| 20 |
PTAFAW_EMC_PKGROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Form Generator Package Root
Prompt Table:
PTAFEMC_PKG_VW
|
| 21 |
PTAFAW_EMC_CLSPATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Form Generator Class Path
Prompt Table:
PTAFEMC_CLS_VW
|