EODL_AVAIL_TXNS (SQL View)	Index Back
Delegation Framework Available transaction for Delegators to create delegation. Those transactions are active in delegation system settings, as of the system date. The system should compare the user profile with the enabled transactions to determine if the manager has access to enabled transactiions.

EODL_AVAIL_TXNS

(SQL View)

Delegation Framework

Available transaction for Delegators to create delegation. Those transactions are active in delegation system settings, as of the system date. The system should compare the user profile with the enabled transactions to determine if the manager has access to enabled transactiions.

SELECT DISTINCT A.TRANSACTION_NAME , A.EODL_TRAN_ALLOWED , A.EFFDT , A.DESCR , A.ROLENAME , A.PNLGRPNAME , A.PACKAGEROOT , A.APPCLASS_PATH , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.EODL_CASCADE_DLGT , A.EODL_INCL_DLGTOR , D.OPRID FROM PS_EODL_CURR_TXNS A , PSMENUITEM B , PSAUTHITEM C , PS_USERCLASS_VW D WHERE A.PNLGRPNAME = B.PNLGRPNAME AND B.MENUNAME = C.MENUNAME AND B.ITEMNAME = C.BARITEMNAME AND C.CLASSID = D.CLASSID

Related Language Record: EODL_CURR_TX_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
Prompt Table: EODL_SS_TXN_VW

2 EODL_TRAN_ALLOWED Character(1) VARCHAR2(1) NOT NULL Stores the Transaction Type for every HCM transaction registered in the Delegation Framework. The type can be either Approve or Initiate.
A=Approve
I=Initiate

3 EFFDT Date(10) DATE Effective Date

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

5 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN_VW

6 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
Prompt Table: PSPNLGROUP_VW

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

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

9 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

10 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

11 EODL_CASCADE_DLGT Character(1) VARCHAR2(1) NOT NULL Cascade Delegation indicator
Y/N Table Edit
Default Value: N

12 EODL_INCL_DLGTOR Character(1) VARCHAR2(1) NOT NULL Include Delegator indicator
Y/N Table Edit
Default Value: N

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name Prompt Table: EODL_SS_TXN_VW
2	EODL_TRAN_ALLOWED	Character(1)	VARCHAR2(1) NOT NULL	Stores the Transaction Type for every HCM transaction registered in the Delegation Framework. The type can be either Approve or Initiate. A=Approve I=Initiate
3	EFFDT	Date(10)	DATE	Effective Date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: PSROLEDEFN_VW
6	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name Prompt Table: PSPNLGROUP_VW
7	PACKAGEROOT	Character(30)	VARCHAR2(30) NOT NULL	Root Package ID
8	APPCLASS_PATH	Character(254)	VARCHAR2(254) NOT NULL	Application Class Full Path
9	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
11	EODL_CASCADE_DLGT	Character(1)	VARCHAR2(1) NOT NULL	Cascade Delegation indicator Y/N Table Edit Default Value: N
12	EODL_INCL_DLGTOR	Character(1)	VARCHAR2(1) NOT NULL	Include Delegator indicator Y/N Table Edit Default Value: N
13	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).