TRANSACTION_NAMEPrompt Table: HCDL_SS_TXN_VW
A=Approve
I=Initiate
HCDL_DLGTED_TXN(SQL View) |
Index Back |
|---|---|
Used as prompt tableUsed as prompt table for HCDL_DLGT_WRK.Transaction_name |
| SELECT DISTINCT A.TRANSACTION_NAME , A.TRANS_ALLOWED , B.DESCR FROM PS_HCDL_DELEGATION A , PS_HCDL_CURR_TXNS B WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.TRANS_ALLOWED = B.TRANS_ALLOWED |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRANSACTION_NAME |
Character(25) | VARCHAR2(25) NOT NULL |
EDI Transaction Name
Prompt Table: HCDL_SS_TXN_VW |
| 2 | TRANS_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 |