SEC_DPTBU_PR_VW (SQL View)	Index Back
Sec view for Dept by BU Prompt view for Departments where SCRTY_KEY1 is the first key instead of BUSINESS_UNIT.

SEC_DPTBU_PR_VW

(SQL View)

Sec view for Dept by BU

Prompt view for Departments where SCRTY_KEY1 is the first key instead of BUSINESS_UNIT.

SELECT SETTBL.SETCNTRLVALUE , D.DEPTID , D.DESCR , D.SETID FROM PS_DEPT_TBL D , PS_SET_CNTRL_REC SETTBL WHERE %EffdtCheck(DEPT_TBL B, D, %CurrentDateIn) AND D.SETID = SETTBL.SETID AND SETTBL.RECNAME = 'DEPT_TBL' AND EXISTS ( SELECT 'x' FROM PS_BUS_UNIT_TBL_HR BUS WHERE BUS.BUSINESS_UNIT = SETTBL.SETCNTRLVALUE)

Related Language Record: SEC_DPTBU_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

4 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

#	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
4	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID