HCDL_AVAIL_TXNS

(SQL View)
 Index Back

Delegation Framework

Available transaction for Delegators to create delegation. Those transactions are active in delegation system settings, as of the system date. The system should compare the user profile with the enabled transactions to determine if the manager has access to enabled transactiions.

SELECT DISTINCT A.TRANSACTION_NAME , A.TRANS_ALLOWED , A.EFFDT , A.DESCR , A.ROLENAME , A.PNLGRPNAME , A.PACKAGEROOT , A.APPCLASS_PATH , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , D.OPRID FROM PS_HCDL_CURR_TXNS A , PSMENUITEM B , PSAUTHITEM C , PS_USERCLASS_VW D WHERE A.PNLGRPNAME = B.PNLGRPNAME AND B.MENUNAME = C.MENUNAME AND B.ITEMNAME = C.BARITEMNAME AND C.CLASSID = D.CLASSID

  • Related Language Record: HCDL_CURR_TX_LN

    • # 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 EFFDT Date(10) DATE Effective Date
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: PSROLEDEFN_VW

    6 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: PSPNLGROUP_VW

    7 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
    8 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path
    9 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    10 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).