FORM_APPR_VW (SQL View)	Index Back
Form Approval View Form Approval View

FORM_APPR_VW

(SQL View)

Form Approval View

SELECT DISTINCT eoawdttm_modified , a.EOAWTHREAD_ID , a.EOAWSTEP_STATUS , a.oprid , b.seq_nbr , d.portal_label , c.form_type , c.form_subject , c.form_priority , c.form_due_date , B.EOAWREQUESTOR_ID , B.EOAWTHREAD_STATUS , %DatePart(b.eoawdttm_modified) , xref.EODC_DOC_KEY FROM PS_EOAW_STEP_VW a , PS_FORM_AW b , PS_FORM c LEFT OUTER JOIN ps_eodc_form_xref xref ON c.FORM_TYPE = xref.SD_RECNAME AND c.SEQ_NBR = xref.SEQ_NBR , PS_FORM_TYPE d WHERE a.eoawprcs_id = 'FormApproval' AND a.eoawthread_id = b.eoawthread_id AND b.seq_nbr = c.seq_nbr AND c.form_type = d.form_type

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified

2 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID

3 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

6 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label

7 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field
Prompt Table: FORM_TYPE

8 FORM_SUBJECT Character(100) VARCHAR2(100) NOT NULL Subject

9 FORM_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=1-Critical
2=2-Urgent
3=3-Standard
4=4-Low

10 FORM_DUE_DATE Date(10) DATE Due Date

11 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
Prompt Table: PSOPRDEFN_VW

12 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

13 EOAWMODIFIED_DT Date(10) DATE Date Last Modification

14 EODC_DOC_KEY Character(150) VARCHAR2(150) NOT NULL Document Key String

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOAWDTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
2	EOAWTHREAD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Approval Framework Thread ID
3	EOAWSTEP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Step Instance Status A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	PORTAL_LABEL	Character(30)	VARCHAR2(30) NOT NULL	Portal Label
7	FORM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Form and Builder Field Prompt Table: FORM_TYPE
8	FORM_SUBJECT	Character(100)	VARCHAR2(100) NOT NULL	Subject
9	FORM_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=1-Critical 2=2-Urgent 3=3-Standard 4=4-Low
10	FORM_DUE_DATE	Date(10)	DATE	Due Date
11	EOAWREQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id Prompt Table: PSOPRDEFN_VW
12	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
13	EOAWMODIFIED_DT	Date(10)	DATE	Date Last Modification
14	EODC_DOC_KEY	Character(150)	VARCHAR2(150) NOT NULL	Document Key String