EPO_DSRCH_LANG (SQL View)	Index Back
Search Vw-Security for Dept EPO_DEPART_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. For Objectives Management we are filtering out Inactive Departments.

EPO_DSRCH_LANG

(SQL View)

Search Vw-Security for Dept

EPO_DEPART_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. For Objectives Management we are filtering out Inactive Departments.

SELECT %Sql(SCRTY_SEL_DEPTKEY, OPR,DEPT) , L.LANGUAGE_CD , L.DESCR FROM %Sql(SCRTY_DEPT_FROM) , PS_DEPT_TBL_LANG L WHERE %Sql(SCRTY_WHERE_DEPT) AND DEPT.SETID = L.SETID AND DEPT.DEPTID =L.DEPTID AND DEPT.EFFDT = L.EFFDT AND DEPT.EFF_STATUS = 'A'

Related Language Record for EPO_DEPART_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

#	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