HCDL_DLGT_LANG (SQL View)	Index Back
My Delegator Language View My Delegator Language View.

HCDL_DLGT_LANG

(SQL View)

My Delegator Language View

My Delegator Language View.

SELECT A.PROXY_ID , A.DELEGATOR_ID , A.DELEGATOR_RCD , A.TRANSACTION_NAME , A.TRANS_ALLOWED , B.LANGUAGE_CD , %Coalesce(BL.DESCR, B.DESCR) , %Coalesce(DL.DESCR, E.DESCR) , %Coalesce(JL.DESCR, F.DESCR) FROM PS_HCDL_DELEGATION A , PS_HCDL_TXN_AL_VW B LEFT OUTER JOIN PS_HCDL_TXN_LANG BL ON B.TRANSACTION_NAME = BL.TRANSACTION_NAME AND B.TRANS_ALLOWED = BL.TRANS_ALLOWED AND B.LANGUAGE_CD = BL.LANGUAGE_CD , PS_HCDL_ALL_JOB_VW D , PS_HCDL_DEPT_AL_VW E LEFT OUTER JOIN PS_DEPT_TBL_EFF_LN DL ON DL.SETID = E.SETID AND DL.DEPTID = E.DEPTID AND DL.LANGUAGE_CD = E.LANGUAGE_CD , PS_HCDL_JOBCD_AL_V F LEFT OUTER JOIN PS_JOBCODE_EFF_LN JL ON JL.SETID = F.SETID AND JL.JOBCODE = F.JOBCODE AND JL.LANGUAGE_CD = F.LANGUAGE_CD WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.TRANS_ALLOWED = B.TRANS_ALLOWED AND A.DELEGATOR_ID = D.EMPLID AND A.DELEGATOR_RCD = D.EMPL_RCD AND D.SETID_DEPT = E.SETID AND D.DEPTID = E.DEPTID AND B.LANGUAGE_CD = E.LANGUAGE_CD AND D.SETID_JOBCODE = F.SETID AND D.JOBCODE = F.JOBCODE AND B.LANGUAGE_CD = F.LANGUAGE_CD

Related Language Record for HCDL_MYDLGTOR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

5 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

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

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

8 DEPTNAME Character(30) VARCHAR2(30) NOT NULL Department Name

9 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title

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