EOAW_TXN_VW2

(SQL View)
 Index Back

Approval Transaction Reg View

This view excludes the depricated Ad Hoc Salary Change transaction (process id = AdhocSalaryChange

SELECT EOAWPRCS_ID , DESCR , OBJECTOWNERID , EOAWENTRY_COMP , MENUNAME , EOAWAPPR_COMPONENT , PNLNAME , PACKAGEROOT , APPCLASS_PATH , EOAWRECNAME_XREF , EOAW_MAP_REC_NAME , EOAW_PACKAGENAME , EOAW_CLASS_PATH , EOAWDESCRPKGROOT , EOAWDESCRCLASSPATH , EOAWENABLE_NOTIF , EOAWNOTIFY_TYPE , EOAWMINIMIZE_EML , EOAW_EMC_FLAG , EOAW_EMC_PKGROOT , EOAW_EMC_CLSPATH , EOAW_EXT_URL , EOAW_EXT_NODE , EOAW_EXT_PORTAL , EOAW_INT_URL , EOAW_INT_NODE , EOAW_INT_PORTAL , EOAW_WL_PREFIX , EOAW_EMAIL , EOAW_WORKLIST , EOAW_PUSH FROM PS_EOAW_TXN WHERE EOAWPRCS_ID <> 'AdhocSalaryChange'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
4 EOAWENTRY_COMP Character(18) VARCHAR2(18) NOT NULL Entry Component

Prompt Table: PSPNLGRPDFN_VW1

5 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN_VW

6 EOAWAPPR_COMPONENT Character(18) VARCHAR2(18) NOT NULL Approval Component

Prompt Table: EOAWMENU_PNL_VW

7 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

Prompt Table: EOAWPAGE_VW

8 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

Prompt Table: EOAWPACKAGE_VW

9 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

Prompt Table: EOAWAPCLSPTH_VW

10 EOAWRECNAME_XREF Character(15) VARCHAR2(15) NOT NULL Cross Reference Table

Prompt Table: EOAW_REC_VW

11 EOAW_MAP_REC_NAME Character(15) VARCHAR2(15) NOT NULL Mapping Record Name
12 EOAW_PACKAGENAME Character(30) VARCHAR2(30) NOT NULL Adhoc Access Logic Package

Prompt Table: EOAWADHC_PKG_VW

13 EOAW_CLASS_PATH Character(254) VARCHAR2(254) NOT NULL Adhoc Logic Class Path

Prompt Table: EOAWADHC_CLS_VW

14 EOAWDESCRPKGROOT Character(30) VARCHAR2(30) NOT NULL Thread Description Package

Prompt Table: EOAWDSCR_PKG_VW

15 EOAWDESCRCLASSPATH Character(254) VARCHAR2(254) NOT NULL Thread Description Class Path

Prompt Table: EOAWDSCR_CLS_VW

16 EOAWENABLE_NOTIF Character(1) VARCHAR2(1) NOT NULL Enables notificction for Approvals.
A=Enable Email and Worklist
E=Email Notification Only
W=Worklist Notification Only
Z=Disable Email and Worklist

Default Value: A

17 EOAWNOTIFY_TYPE Character(1) VARCHAR2(1) NOT NULL Used to schedule the sending of email.
G=Integration Broker Processing
I=Online Processing
P=Offline Processing

Default Value: I

18 EOAWMINIMIZE_EML Character(1) VARCHAR2(1) NOT NULL Used to flag whether or not all emails should be sent or just the minimal amount necessary. I.E. if the approval has two lines for the same approver should he receive one email or two.

Y/N Table Edit

Default Value: Y

19 EOAW_EMC_FLAG Character(1) VARCHAR2(1) NOT NULL Use Email Approvals

Y/N Table Edit

Default Value: N

20 EOAW_EMC_PKGROOT Character(30) VARCHAR2(30) NOT NULL Form Generator Package Root

Prompt Table: EOAWEMC_PKG_VW

21 EOAW_EMC_CLSPATH Character(254) VARCHAR2(254) NOT NULL Form Generator Class Path

Prompt Table: EOAWEMC_CLS_VW

22 EOAW_EXT_URL Character(30) VARCHAR2(30) NOT NULL External URL Base

Prompt Table: PSURLDEFN

23 EOAW_EXT_NODE Character(30) VARCHAR2(30) NOT NULL External Node Name

Prompt Table: PSNODEVW

24 EOAW_EXT_PORTAL Character(30) VARCHAR2(30) NOT NULL External Portal Name

Prompt Table: PTLT_PORTAL_VW

25 EOAW_INT_URL Character(30) VARCHAR2(30) NOT NULL Internal URL Base

Prompt Table: PSURLDEFN

26 EOAW_INT_NODE Character(30) VARCHAR2(30) NOT NULL Internal Node Name

Prompt Table: PSNODEVW

27 EOAW_INT_PORTAL Character(30) VARCHAR2(30) NOT NULL Internal Portal Name

Prompt Table: PTLT_PORTAL_VW

28 EOAW_WL_PREFIX Character(5) VARCHAR2(5) NOT NULL Worklist Prefix
29 EOAW_EMAIL Character(1) VARCHAR2(1) NOT NULL Email Notification flag

Y/N Table Edit

Default Value: N

30 EOAW_WORKLIST Character(1) VARCHAR2(1) NOT NULL Worklist notification flag

Y/N Table Edit

Default Value: N

31 EOAW_PUSH Character(1) VARCHAR2(1) NOT NULL Push notification flag

Y/N Table Edit

Default Value: N