ACAD_ORG_SR_LVW (SQL View)	Index Back
Academic Organization Search ACAD_ORG_SRCH is a view which uses academic organization security to grant access to the academic organizations themselves, or other records keyed by ACAD_ORG. Users will only see ACAD_ORGs which they have security clearance to access. It is used as a prompt table for ACAD_ORG in Course Offer and Class Table. Use this view as the search record for the Academic Organization Table to restrict access to the table by security clearance.

ACAD_ORG_SR_LVW

(SQL View)

Academic Organization Search

ACAD_ORG_SRCH is a view which uses academic organization security to grant access to the academic organizations themselves, or other records keyed by ACAD_ORG. Users will only see ACAD_ORGs which they have security clearance to access. It is used as a prompt table for ACAD_ORG in Course Offer and Class Table. Use this view as the search record for the Academic Organization Table to restrict access to the table by security clearance.

SELECT A.INSTITUTION ,A.ACAD_ORG ,C.OPRID ,A1.LANGUAGE_CD ,A.EFFDT ,A1.DESCR FROM PS_ACAD_ORG_TBL A ,PS_ACAD_ORG_LANG A1 ,PS_SCRTY_TBL_ACAD C WHERE A.ACAD_ORG = A1.ACAD_ORG AND A.EFFDT = A1.EFFDT AND C.ACCESS_CD='Y' AND EXISTS ( SELECT 'X' FROM PSTREENODE E WHERE E.SETID=' ' AND E.TREE_NAME='ACAD_ORGANIZATION' AND E.EFFDT=C.TREE_EFFDT AND E.TREE_NODE=A.ACAD_ORG AND E.TREE_NODE_NUM BETWEEN C.TREE_NODE_NUM AND C.TREE_NODE_NUM_END AND NOT EXISTS ( SELECT 'X' FROM PS_SCRTY_TBL_ACAD G WHERE C.OPRID=G.OPRID AND C.TREE_NODE_NUM<>G.TREE_NODE_NUM AND E.TREE_NODE_NUM BETWEEN G.TREE_NODE_NUM AND G.TREE_NODE_NUM_END AND G.TREE_NODE_NUM BETWEEN C.TREE_NODE_NUM AND C.TREE_NODE_NUM_END))

Related Language Record for ACAD_ORG_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INSTITUTION_TBL

2 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

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

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

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INSTITUTION_TBL
2	ACAD_ORG	Character(10)	VARCHAR2(10) NOT NULL	Academic Organization
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description