HCDL_DLGT_MAPLN (SQL View)	Index Back
AdHoc Sal Chg - Pending Txn Vw This view is intended to select all rows that are in the approval process that have not yet reached final approval as well as the associated Approval Process Id

HCDL_DLGT_MAPLN

(SQL View)

AdHoc Sal Chg - Pending Txn Vw

This view is intended to select all rows that are in the approval process that have not yet reached final approval as well as the associated Approval Process Id

SELECT A.DELEGATOR_ID , A.DELEGATOR_RCD , X.TRANSACTION_NAME , X.TRANS_ALLOWED , A.FROM_DATE , C.LANGUAGE_CD , C.DESCR FROM PS_HCDL_APPR_XREF X , PS_HCDL_DELEGATION A , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PS_HCDL_TXN_LANG C WHERE X.DELEGATOR_ID = A.DELEGATOR_ID AND X.DELEGATOR_RCD = A.DELEGATOR_RCD AND X.TRANSACTION_NAME IN ( SELECT A1.TRANSACTION_NAME FROM PS_HCDL_DELEGATION A1 WHERE A1.DELEGATOR_ID = A.DELEGATOR_ID AND A1.DELEGATOR_RCD = A.DELEGATOR_RCD AND A1.FROM_DATE = A.FROM_DATE AND A1.Transaction_Nbr = A.Transaction_Nbr) AND X.FROM_DATE = A.FROM_DATE AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND A.TRANSACTION_NAME = C.TRANSACTION_NAME AND A.TRANS_ALLOWED = C.TRANS_ALLOWED

Related Language Record for HCDL_DLGT_MAP_V

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DELEGATOR_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.

2 DELEGATOR_RCD Number(3,0) SMALLINT NOT NULL Delegator Record Number

3 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name

4 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

5 FROM_DATE Date(10) DATE From Date

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DELEGATOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
2	DELEGATOR_RCD	Number(3,0)	SMALLINT NOT NULL	Delegator Record Number
3	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name
4	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
5	FROM_DATE	Date(10)	DATE	From Date
6	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description