EX_AWE_PRCS_VW

(SQL View)
Index Back

Expense AWE prompt view

Expenses prompt view for AWE process ID.

SELECT A.EOAWDEFN_ID , B.OBJECTOWNERID , A.EOAWPRCS_ID , A.EFFDT , B.DESCR FROM PS_EOAW_PRCS A , PS_EOAW_TXN B WHERE A.EOAWPRCS_ID = B.EOAWPRCS_ID AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

2 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
3 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description