EOAW_CONTPNL1MV

(SQL View)
 Index Back

Content Panel View level 1


SELECT OPRID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PSOPRDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
4 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes
5 EOAWERROR_MSG_TXT Long Character(256) VARCHAR2(256) Error Message
6 EOAW_APPKEY9 Long Character CLOB Application Key 9
7 EOAW_APPKEY8 Long Character CLOB Application Key 8
8 EOAW_APPKEY7 Long Character CLOB Application Key 7
9 EOAW_APPKEY6 Long Character CLOB Application Key 6
10 EOAW_APPKEY5 Long Character CLOB Application Key 5
11 EOAW_APPKEY4 Long Character CLOB Application Key 4
12 EOAW_APPKEY3 Long Character CLOB Application Key 3
13 EOAW_APPKEY2 Long Character CLOB Application Key 2
14 EOAW_APPKEY15 Long Character CLOB Application Key 15
15 EOAW_APPKEY14 Long Character CLOB Application Key 14
16 EOAW_APPKEY13 Long Character CLOB Application Key 13
17 EOAW_APPKEY12 Long Character CLOB Application Key 12
18 EOAW_APPKEY11 Long Character CLOB Application Key 1
19 EOAW_APPKEY10 Long Character CLOB Application Key 10
20 EOAW_APPKEY1 Long Character CLOB Application Key 1
21 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
22 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
23 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID
24 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
25 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
26 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
27 EOAWGROUPBOX Character(1) VARCHAR2(1) NOT NULL Discussion Groupbox