EODL_TXN_AL_VW(SQL View) | 
Index Back | 
|---|---|
Delegation Txn LanaguageDelegation Transaction descriptions for all languages | 
| SELECT H.TRANSACTION_NAME , H.EODL_TRAN_ALLOWED , L.LANGUAGE_CD , H.DESCR FROM PS_EODL_TXN_HDR H , PSLANGUAGES L WHERE L.INSTALLED = 1 | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(25) | VARCHAR2(25) NOT NULL | 
EDI Transaction Name
 Prompt Table: EODL_SS_TXN_VW  | 
|
| 2 | 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 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |