EODL_DLGTED_TXN (SQL View)	Index Back
Used as prompt table Used as prompt table for EODL_DLGT_WRK.Transaction_name

EODL_DLGTED_TXN

(SQL View)

Used as prompt table

Used as prompt table for EODL_DLGT_WRK.Transaction_name

SELECT DISTINCT A.TRANSACTION_NAME , A.EODL_TRAN_ALLOWED , B.DESCR FROM PS_EODL_DELEGATION A , PS_EODL_CURR_TXNS B WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.EODL_TRAN_ALLOWED = B.EODL_TRAN_ALLOWED

Related Language Record: EODLDLGTEDTXN_L

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description