SEC_DEPT_PR_LN (SQL View)	Index Back
Rel Lng for Sec_dept_pr_Vw Prompt view for DEPTIDS where SCRTY_KEY1 is the first key instead of SETID.

SEC_DEPT_PR_LN

(SQL View)

Rel Lng for Sec_dept_pr_Vw

Prompt view for DEPTIDS where SCRTY_KEY1 is the first key instead of SETID.

SELECT D.SETID , D.DEPTID , L.LANGUAGE_CD , D.DESCR FROM PS_DEPT_TBL D , PS_DEPT_TBL_LANG L WHERE %EffdtCheck(DEPT_TBL B, D, %CurrentDateIn) AND D.SETID = L.SETID AND D.DEPTID = L.DEPTID AND D.EFFDT = L.EFFDT

Related Language Record for SEC_DEPT_PR_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCRTY_KEY1 Character(20) VARCHAR2(20) NOT NULL Contains the value of the field used for row level security for Job access - setid.

2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCRTY_KEY1	Character(20)	VARCHAR2(20) NOT NULL	Contains the value of the field used for row level security for Job access - setid.
2	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description