EONC_AWE_UDCONV (SQL Table)	Index Back
Log Table for AWE to EONC Log Table for AWE to EONC Conversion Program.

EONC_AWE_UDCONV

(SQL Table)

Log Table for AWE to EONC

Log Table for AWE to EONC Conversion Program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

2 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 EOAWLEVEL Number(1,0) SMALLINT NOT NULL Level e.g. Header = 0, Line = 1.
0=Header
1=Line

5 EOAWEVENT Character(3) VARCHAR2(3) NOT NULL Approval Workflow Events for Notification
A=On Final Approval
AD=Ad Hoc Delete
AH=Ad Hoc Insert
B=Push Back
D=On Final Denial
E=On Error
ES=On Escalate
H=Hold Step
L=Locked Out
NAN=No Approver Necessary
PC=Processing Complete
PL=On Process Launch
R=On Reactivate
RA=Route for Approval
RI=Request Information
RIA=Request Information Added
RR=Route for Review
RS=On Reassign
SC=On Step Complete
T=On Terminate
W=On Cancel

6 EOAWPARTICIPANT Character(3) VARCHAR2(3) NOT NULL Approval Workflow Events for Notification
A=Approvers
D=Dynamic
DA=Delegate Approver
DR=Delegate Requester
E=External
PA=Proxy Approver
PR=Proxy Requester
R=Requester
S=Administrator
U=User List
V=Reviewers

7 EOAWUSER_LIST_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the approval process.
Prompt Table: EOAWUSER_LIST

8 EOAW_NOTIF_NAME Character(50) VARCHAR2(50) NOT NULL EOAW version of EONC_NOTIF_NAME
Prompt Table: %EDITTABLE

9 EONC_CONV_TYP Character(3) VARCHAR2(3) NOT NULL AWE to Conversion Type. SU - Flag for system data update. SI - Flag for system data insert. C - Flag for customer data, update or insert.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
2	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EOAWLEVEL	Number(1,0)	SMALLINT NOT NULL	Level e.g. Header = 0, Line = 1. 0=Header 1=Line
5	EOAWEVENT	Character(3)	VARCHAR2(3) NOT NULL	Approval Workflow Events for Notification A=On Final Approval AD=Ad Hoc Delete AH=Ad Hoc Insert B=Push Back D=On Final Denial E=On Error ES=On Escalate H=Hold Step L=Locked Out NAN=No Approver Necessary PC=Processing Complete PL=On Process Launch R=On Reactivate RA=Route for Approval RI=Request Information RIA=Request Information Added RR=Route for Review RS=On Reassign SC=On Step Complete T=On Terminate W=On Cancel
6	EOAWPARTICIPANT	Character(3)	VARCHAR2(3) NOT NULL	Approval Workflow Events for Notification A=Approvers D=Dynamic DA=Delegate Approver DR=Delegate Requester E=External PA=Proxy Approver PR=Proxy Requester R=Requester S=Administrator U=User List V=Reviewers
7	EOAWUSER_LIST_ID	Character(30)	VARCHAR2(30) NOT NULL	Identifies the user list to be used when creating the approval process. Prompt Table: EOAWUSER_LIST
8	EOAW_NOTIF_NAME	Character(50)	VARCHAR2(50) NOT NULL	EOAW version of EONC_NOTIF_NAME Prompt Table: %EDITTABLE
9	EONC_CONV_TYP	Character(3)	VARCHAR2(3) NOT NULL	AWE to Conversion Type. SU - Flag for system data update. SI - Flag for system data insert. C - Flag for customer data, update or insert.