UT_EOAWTSTHDRVW

(SQL View)
 Index Back

SAC_AW Test Header


SELECT A.EOAWTHREAD_ID , A.EOAWPRCS_ID , A.EOAWDEFN_ID , A.ORIGINATORID , A.EOAWREQUESTOR_ID , A.RECNAME , A.EOAWTHREAD_STATUS , A.EOAWPARENT_THREAD , A.EOAWDTTM_MODIFIED , A.COMMENTS , B.EOAWBU , B.EOAWHEADERID , B.EOAW_HDR_ATTR1 , B.EOAW_HDR_ATTR2 , B.EOAW_TOTAL_AMOUNT , B.EOAWHDRDESC FROM PS_UT_EOAWTESTXREF A , PS_UT_EOAWTESTHDR B WHERE A.EOAWHEADERID = B.EOAWHEADERID AND A.EOAWBU = B.EOAWBU AND A.EOAWPARENT_THREAD = A.EOAWTHREAD_ID

# 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 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
4 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
5 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
7 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
X=Suspended/Pending Denial

Default Value: N

8 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID
9 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
10 COMMENTS Long Character CLOB Comment
11 EOAWBU Character(5) VARCHAR2(5) NOT NULL sac_aw test header rec Bus. unit.
12 EOAWHEADERID Character(10) VARCHAR2(10) NOT NULL SAC_AW test header record id
13 EOAW_HDR_ATTR1 Character(30) VARCHAR2(30) NOT NULL Attribute #1
14 EOAW_HDR_ATTR2 Character(30) VARCHAR2(30) NOT NULL Attribute #2
15 EOAW_TOTAL_AMOUNT Signed Number(15,3) DECIMAL(13,3) NOT NULL Total Amount
16 EOAWHDRDESC Character(55) VARCHAR2(55) NOT NULL sac_aw test header description