SEC_DEPT_PR_VW (SQL View)	Index Back
SCRTY_DEPT_PRMPT_VW Prompt view for DEPTIDS where SCRTY_KEY1 is the first key instead of SETID.

SEC_DEPT_PR_VW

(SQL View)

SCRTY_DEPT_PRMPT_VW

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

SELECT SETID , DEPTID , DESCR FROM PS_DEPT_TBL D WHERE %EffdtCheck(DEPT_TBL B, D, %CurrentDateIn)

Related Language Record: SEC_DEPT_PR_LN

# 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 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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description