EOAW_SUMMARY

(SQL Table)
Index Back

Summary Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
2 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
3 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
4 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
5 EOAWTHREAD_STATUS Character(1) VARCHAR2(1) NOT NULL Thread Status
A=Approved
C=Complete
D=Denied
E=Pending Denial
H=Hard Deny
I=Initial
N=Not Active
P=Pending
S=Awaiting Further Approvals
T=Terminated
W=Canceled
X=Suspended/Pending Denial

Default Value: N

6 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID
7 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
8 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
10 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
11 EOAW_PUSHBACK Character(1) VARCHAR2(1) NOT NULL Pushback

Default Value: N

12 APPROVEOPRID Character(30) VARCHAR2(30) NOT NULL Approver's Oper ID
13 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
14 DESCRLONG Long Character CLOB Long Description