DEPT_SEC_LANG (SQL View)	Index Back
Search Vw-Security for Dept DEPARTMENT_SRCH is a search view which uses departmental security to grant access to the departments themselves, or other records keyed by department. Users will only see departments which they have security clearance to acccess. It is used as the search record on the budgeting portion of Position Management and for the Salary Planning setup screens which are accessed by department. If you wish to restrict access to the Department Table by security clearance, this record could be used as the search record for the table itself.

DEPT_SEC_LANG

(SQL View)

Search Vw-Security for Dept

DEPARTMENT_SRCH is a search view which uses departmental security to grant access to the departments themselves, or other records keyed by department. Users will only see departments which they have security clearance to acccess. It is used as the search record on the budgeting portion of Position Management and for the Salary Planning setup screens which are accessed by department. If you wish to restrict access to the Department Table by security clearance, this record could be used as the search record for the table itself.

SELECT %Sql(SCRTY_SEL_DEPTKEY, OPR, L) , L.LANGUAGE_CD , L.DESCR , L.DESCRSHORT FROM PS_DEPT_TBL_LANG L , PSOPRDEFN OPR WHERE EXISTS ( SELECT 'X' FROM PS_SJT_DEPT SEC , PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS SOC WHERE SEC.SETID = L.SETID AND SEC.DEPTID = L.DEPTID AND SEC.EFFDT_NOKEY = L.EFFDT AND CLS.SCRTY_SET_CD = 'PPLJOB' AND CLS.SCRTY_TYPE_CD = '001' AND CLS.TREE = 'Y' AND CLS.SCRTY_KEY1 = SEC.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = SEC.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = SEC.SCRTY_KEY3 AND SOC.OPRID = OPR.OPRID AND SOC.CLASSID = CLS.CLASSID AND SOC.CLASSID = OPR.ROWSECCLASS AND SOC.SEC_RSC_FLG <> '2') OR EXISTS ( SELECT 'X' FROM PS_SJT_DEPT SEC , PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS SOC WHERE SEC.SETID = L.SETID AND SEC.DEPTID = L.DEPTID AND SEC.EFFDT_NOKEY = L.EFFDT AND CLS.SCRTY_SET_CD = 'DEPT' AND CLS.SCRTY_TYPE_CD = SEC.SCRTY_TYPE_CD AND CLS.SCRTY_KEY1 = SEC.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = SEC.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = SEC.SCRTY_KEY3 AND CLS.TREE = 'Y' AND SOC.OPRID = OPR.OPRID AND SOC.CLASSID = CLS.CLASSID AND SOC.CLASSID = OPR.ROWSECCLASS AND SOC.SEC_RSC_FLG <> '2') OR EXISTS ( SELECT 'X' FROM PS_SJT_DEPT SEC , PS_SJT_CLASS_ALL CLS , PS_SJT_OPR_CLS SOC WHERE SEC.SETID = L.SETID AND SEC.DEPTID = L.DEPTID AND SEC.EFFDT_NOKEY = L.EFFDT AND CLS.SCRTY_SET_CD = 'DEPT' AND CLS.SCRTY_TYPE_CD = SEC.SCRTY_TYPE_CD AND CLS.SCRTY_KEY1 = SEC.SCRTY_KEY1 AND CLS.SCRTY_KEY2 = SEC.SCRTY_KEY2 AND CLS.SCRTY_KEY3 = SEC.SCRTY_KEY3 AND CLS.TREE = 'N' AND SOC.OPRID = OPR.OPRID AND SOC.CLASSID = CLS.CLASSID)

Related Language Record for DEPT_SEC_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SET_DEPT_VLD_VW

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL

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

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

6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SET_DEPT_VLD_VW
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description