TRANSACTION_NAMEPrompt Table: EO_TRAN_CAT
Y/N Table Edit
Default Value: N
Prompt Table: EOAW_TXN
Y/N Table Edit
Y/N Table Edit
JPM_EO_TRANS_I(SQL View) |
Index Back |
|---|---|
Approval Transactions |
| SELECT T.TRANSACTION_NAME , T.TRAN_CATEGORY , T.SYSTEM_DATA_FLG , T.DESCR , T.EOAWPRCS_ID , T.DELEGATION_APPR , T.DELEGATION_INIT FROM PS_HCM_EO_TXN_VW T , PS_EOAW_TXN A WHERE A.EOAWPRCS_ID = T.EOAWPRCS_ID AND A.OBJECTOWNERID = 'HJPM' |
| # | 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 | DELEGATION_APPR | Character(1) | VARCHAR2(1) NOT NULL |
Delegate Approvals
Y/N Table Edit |
| 7 | DELEGATION_INIT | Character(1) | VARCHAR2(1) NOT NULL |
Delegate Initiation
Y/N Table Edit |