HCDL_CURR_TXNS

(SQL View)
 Index Back

Current Txn for Delegation

Current Txn for Delegation

SELECT A.TRANSACTION_NAME , A.TRANS_ALLOWED ,B.EFFDT , A.DESCR , B.ROLENAME , B.PNLGRPNAME , B.PACKAGEROOT , B.APPCLASS_PATH , B.MESSAGE_SET_NBR , B.MESSAGE_NBR , D.EOAWPRCS_ID FROM PS_HCDL_TXN_HDR A , PS_HCDL_TXN B , PS_HCM_EO_TXN_VW D WHERE A.TRANSACTION_NAME = D.TRANSACTION_NAME AND A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.TRANS_ALLOWED = B.TRANS_ALLOWED AND B.STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_HCDL_TXN C WHERE B.TRANSACTION_NAME = C.TRANSACTION_NAME AND B.TRANS_ALLOWED = C.TRANS_ALLOWED AND C.EFFDT <= %CurrentDateIn)

  • 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 NOT NULL Effective Date

    Default Value: %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 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID