| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TRANSACTION_NAME |
Character(25) |
VARCHAR2(25) NOT NULL |
EDI Transaction Name
Prompt Table:
EO_TRANSACTIONS
|
| 2 |
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
|
| 3 |
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
|
| 4 |
HR_WF_ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Workflow Action
APV=Approved
CAN=Cancelled by Originator
DNY=Denied
PND=Pending
PSH=Push back for rework
RAS=Reassign
SAV=Saved For Later-Not Submitted
SUB=Submitted
|
| 5 |
HR_NEXT_STATUS |
Character(30) |
VARCHAR2(30) NOT NULL |
Next Status
|
| 6 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table:
PSBUSPROCDEFN
|
| 7 |
ACTIVITYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table:
PSACTIVITYDEFN
|
| 8 |
HR_EMAIL_EVENT |
Character(30) |
VARCHAR2(30) NOT NULL |
Email Event
Prompt Table:
PSEVENTDEFN
|
| 9 |
HR_WL_EVENT |
Character(30) |
VARCHAR2(30) NOT NULL |
Worklist Event
Prompt Table:
PSEVENTDEFN
|
| 10 |
HR_ALL_PATHS |
Character(1) |
VARCHAR2(1) NOT NULL |
All Paths Complete
Y/N Table Edit
Default Value: N
|
| 11 |
SYSTEM_DATA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
|