| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
|
| 2 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 3 |
APPR_STEP |
Character(3) |
VARCHAR2(3) NOT NULL |
Approval Step
1=Approval Step 1
2=Approval Step 2
3=Approval Step 3
4=Approval Step 4
5=Approval Step 5
6=Approval Step 6
7=Approval Step 7
8=Approval Step 8
9=Approval Step 9
Default Value: 1
|
| 4 |
APPR_PATH |
Character(3) |
VARCHAR2(3) NOT NULL |
Approval Path
A=Approval Path A
B=Approval Path B
C=Approval Path C
D=Approval Path D
E=Approval Path E
Default Value: A
|
| 5 |
APPR_SKIP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Skip Switch
Y/N Table Edit
Default Value: N
|
| 6 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table:
ROLE_USRLST_VW
|
| 7 |
APPR_WF_ERR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Workflow/Error Switch
B=Both
E=Error Message
M=Message Only
W=Workflow
Default Value: W
|
| 8 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table:
PSMSGSETDEFN
|
| 9 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
PSMSGCATDEFN
|
| 10 |
SQLID |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)
|
| 11 |
EVENTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
Prompt Table:
WF_ACT_EVT_VW
|
| 12 |
DENY_EVENTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Deny Event
Prompt Table:
WF_ACT_EVT_VW2
|
| 13 |
RECYCLE_EVENTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Recyle Event Name
Prompt Table:
WF_ACT_EVT_VW3
|
| 14 |
ACTIVITYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table:
WF_BP_ACT_VW
|
| 15 |
DENY_ACTIVITYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Deny Activity Name
Prompt Table:
WF_BP_ACT_VW
|
| 16 |
RECYCLE_ACTIVITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Recycle Activity Name
Prompt Table:
WF_BP_ACT_VW
|