TRANSACTION_NAMEPrompt Table: EO_TRAN_CAT
Y/N Table Edit
Default Value: N
Prompt Table: EOAW_TXN
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Default Value: N
Default Value: N
EODL_EO_TXN_VW(SQL View) |
Index Back |
|---|---|
EODL TransactionsEODL Delegation and AWE Transactions |
| SELECT A.TRANSACTION_NAME , A.TRAN_CATEGORY , A.SYSTEM_DATA_FLG , A.DESCR , B.EOAWPRCS_ID , B.EODL_SERVICEID , B.DELEGATION_INIT , B.DELEGATION_APPR , B.EODL_COMBINE_PART , B.EODL_LIMIT_DRILLUP FROM PS_EO_TRANSACTIONS A , PS_EODL_EO_TXN B WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRANSACTION_NAME |
Character(25) | VARCHAR2(25) NOT NULL | EDI Transaction Name |
| 2 | TRAN_CATEGORY | Character(15) | VARCHAR2(15) NOT NULL |
Transaction Category
Prompt Table: EO_TRAN_CAT |
| 3 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit Default Value: N |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: EOAW_TXN |
| 6 | EODL_SERVICEID | Character(30) | VARCHAR2(30) NOT NULL | Services ID |
| 7 | DELEGATION_INIT | Character(1) | VARCHAR2(1) NOT NULL |
Delegate Initiation
Y/N Table Edit Default Value: N |
| 8 | DELEGATION_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Delegate Approvals
Y/N Table Edit Default Value: N |
| 9 | EODL_COMBINE_PART | Character(1) | VARCHAR2(1) NOT NULL |
Combine Partial
Default Value: N |
| 10 | EODL_LIMIT_DRILLUP | Character(1) | VARCHAR2(1) NOT NULL |
Limit Drill Up
Default Value: N |